Can I use RMAN to back up a database not running in archive log mode?

Can RMAN be used to back up a database that is not running in archive log mode? I need to back up the test database but we don't run it in archive log mode. I understand that it wouldn't be a hot backup.

    Requires Free Membership to View

    Login

Yes, you can use RMAN to perform backups for databases not running in archive log mode. Here is an old RMAN script I used to perform a cold backup of my database: 
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; }
Feel free to modify this to suit your needs. My RMAN script was from an early 9i version of RMAN as well, so you can also look to update for 10g.

This was first published in November 2005

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