Search This Blog

Saturday, September 22, 2007

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';
}

5 comments:

Babu said...

Hi,

Rman cold backup it's working well taj.

Babu

Anonymous said...

Don't stop posting such articles. I love to read stories like this. Just add some pics :)

Md. Tanweer Qasim Mohnavi said...

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.

Md. Tanweer Qasim Mohnavi said...

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.

Md. Tanweer Qasim Mohnavi said...

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.