Q
Problem solve Get help with specific problems with your technologies, process and projects.

Cold backup using RMAN

Use this script to perform a cold backup with RMAN.

Can one do a cold backup using RMAN?
RMAN can perform a cold backup. My RMAN script to perform a cold backup looks similar to the following:
run {
# Shutdown database for backups and put into MOUNT mode
shutdown immediate
startup mount
# Allocate channel. Important: This must be done after
# database has been mounted!!!
allocate channel t1;
# Perform full database backup
backup full format "%d_FULL_%U" (database) ;
# Open database after backup complete
sql 'alter database open'; 
backup current controlfile;
sql 'ALTER DATABASE BACKUP CONTROLFILE TO TRACE';
release channel t1;
}

In the script, I have RMAN perform the SHUTDOWN IMMEDIATE. RMAN does require that the database be in at least MOUNT...

mode for the backup to occur, but this is still a cold backup. After the database is backed up, RMAN opens the database for business.

This was last published in May 2004

Dig Deeper on Oracle database backup and recovery

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close