Showing posts with label RMAN DB backup. Show all posts
Showing posts with label RMAN DB backup. Show all posts

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