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';
}
5 comments:
Hi,
Rman cold backup it's working well taj.
Babu
Don't stop posting such articles. I love to read stories like this. Just add some pics :)
Assalamo Alaikum
Very nice explanation. Thanks for it.
Can you provide me the script how schedule the RMAN hot backup in Linux.
Thank you very much.
Assalamo Alaikum
Very nice explanation. Thanks for it.
Can you provide me the script how schedule the RMAN hot backup in Linux.
Thank you very much.
Assalamo Alaikum
Very nice explanation. Thanks for it.
Can you provide me the script how schedule the RMAN hot backup in Linux.
Thank you very much.
Post a Comment