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 first published in May 2004

Dig deeper on Oracle database backup and recovery

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

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.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close