image

Deleting the Archive log Using RMAN

Once you are connected, then you can use the following to delete archivelogs with one of the following commands. You can choose the commands depending on your situation. 1. To delete all Archivelogs withou backing them up: delete archivelog all; 2. To backup all archivelogs which are not already backed up atleast one time –And … continue reading

image

Instance recovery required cannot set archivelog

ERROR Description SQL> alter database archivelog; alter database archivelog * ERROR at line 1: ORA-00265: instance recovery required, cannot set ARCHIVELOG mode   Reason : During the last shutdown , the database was not properly shutdown . I used the command shutdown abort. Solution: Start database Normally . SQL> Startup Open; Then Shutdown normally SQl> … continue reading

image

Deleting the Archive Log in Using RMAN in oracle

run { allocate channel for delete type disk; change archivelog until time ‘SYSDATE-7′ delete; release channel; } OR BACKUP ARCHIVELOG UNTIL TIME ‘SYSDATE-7′; DELETE COPY OF ARCHIVELOG ALL COMPLETED BEFORE ‘SYSDATE-14′; OR allocate channel for delete type disk; change archivelog until time ‘SYSDATE-7′ delete; release channel;      

Visit Us On FacebookVisit Us On Google PlusVisit Us On Youtube