Ask the Expert

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

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; 
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

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
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
Sort by: OldestNewest

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: