Tuesday, June 3, 2008

Cold Backup with RMAN

Database Cold/offline Backup with RMAN





Database Require in mount mode when cold backup taken through RMAN.


C:\> set ORACLE_SID=sidname
C:\> rman TARGET=SYS

RMAN> run
{
#shutdown database and startup with mount mode for backup.
shutdown immediate;
startup mount;
#perform full database backup
backup database;
#open database for normal use
sql 'alter database open';
#backup current controlfile
backup current controlfile;
sql 'alter database backup controlfile to TRACE';
}

No comments: