image

why we use crosscheck, obsolete , restore validate in rman?

1. why we use crosscheck command in rman ? 2. why we use obsolete command in rman ? 3. why we go for restore database validate ? Solution : .1. To check whether backups are physically available2. To check whether backups are valid (redundant)3. To check the existing backup pieces are valid to restore  

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

DROP a Database using RMAN Oracle

How to Drop a Database using RMAN in ORACLE: Use the drop database command to drop a database from the RMAN prompt. Here are the steps to follow: 1. Start up the database in mount exclusive mode: SQL> startup mount exclusive; Database mounted. SQL> exit 2. From the RMAN interface, use the following command to … 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