Q

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.

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.
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
This Content Component encountered an error

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