Saturday, September 18, 2010

How to do RMAN DB BACKUP restore?

rman target / nocatalog

configure controlfile autobackup on;

run
{
 sql 'alter system switch logfile';
 sql 'alter system switch logfile';
 allocate channel d1 type 'sbt_tape' format '<DB_NAME>_FULL_BACKUP_%d_%s_%p_%u.bak';
 backup database tag <DB_NAME>_RMAN_BACKUP;
 backup current controlfile;
 sql 'alter system switch logfile';
 sql 'alter system switch logfile';
 release channel d1;
}

exit

No comments:

Post a Comment