Q

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

PRO+

Content

Find more PRO+ content and other member only offers, here.

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.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close