Can one do a cold backup using RMAN?

    Requires Free Membership to View

    Login

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

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top