Q
Problem solve Get help with specific problems with your technologies, process and projects.

Performing a hot backup with RMAN

How can I do a hot backup using RMAN?

How can I do a hot backup using RMAN?
There are no special techniques required to perform a hot backup with RMAN. To perform a hot backup, simply do the following with your database up and running:

rman
connect target user/pswd@tnsalias
connect catalog user/pswd@tnsalias
run {
   allocate channel .....
   backup database;
   }

Starting in Oracle 9i, you can configure default channels so the ALLOCATE CHANNEL command is unnecessary. Additionally, in 9i and higher, the RUN brackets are optional. This means that you can get by with a simple BACKUP DATABASE command to perform your hot backup.

I have some RMAN notes on my Web site in the White Papers section. These notes are somewhat dated, so after you've gone through the document, please read the Oracle documentation on RMAN.

This was last published in September 2005

Dig Deeper on Oracle database backup and recovery

PRO+

Content

Find more PRO+ content and other member only offers, here.

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.

Start the conversation

Send me notifications when other members comment.

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

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close