EXPERT RESPONSE
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.
|
