RMAN plays an important role n Oracle RDBMS. Let’s have look on the steps are used by Oracle during the “RMAN Backup With Archivelog”
RMAN> run
{
allocate channel c1 type disk;
backup database;
backup(archivelog all);
}
RMAN> backup archivelog all delete input;
Note: This will backup all archivelog file and delete those from target location. If we physically delete some archivelog file before backup then we have to execute following command before backup-
RMAN> change archivelog all crosscheck;
RMAN> backup archivelog all delete input;
Some other Options:
RMAN> BACKUP ARCHIVELOG FROM TIME 'SYSDATE-2' UNTIL TIME 'SYSDATE';
C:\>set nls_date_format=YYYY-MM-DD hh24:mi:ss
RMAN> run
{
allocate channel c1 type disk;
set until time='2009-05-21 13:08:11';
backup(archivelog all);
}
Today’s thought
“Success comes when opportunity meets preparation.” Zig Ziglar
Thank you for giving your valuable time to read the above information.
If you want to be updated with all our articles send us the Invitation or Follow us:
Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/
Joel Perez’s LinkedIn: Joel Perez’s Profile
LinkedIn Group: Oracle Cloud DBAAS
Facebook Page: OracleHelp
