Embedded Files
Check
Check
SELECT log_mode
FROM v$database;
Enable
Enable
Stop Client Applications
Stop Listener
sqlplus / as sysdba
SHUTDOWN IMMEDIATE
STARTUP MOUNT
ALTER DATABASE ARCHIVELOG;
ALTER DATABASE OPEN;
Start Listener
Start Client Application
Disable
Disable
Stop Client Applications
Stop Listener
sqlplus / as sysdba
SHUTDOWN IMMEDIATE
STARTUP MOUNT
ALTER DATABASE NOARCHIVELOG;
ALTER DATABASE OPEN;
Start Listener
Start Client Applications
Delete
Delete
rman target /
crosscheck archivelog all;
delete noprompt expired archivelog all;
delete archivelog all completed before 'SYSDATE-5';
delete archivelog until time 'SYSDATE-10';
Errors
Errors
RMAN-08120: warning: archived log not deleted, not yet applied by standby
If your standby is broken and you intend to rebuild it rather than recover it, then using 'force' might be useful...
delete force archivelog all completed before 'SYSDATE-5';
Bibliography
Bibliography
Page updated
Google Sites
Report abuse