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

Recovering a 9i database

How do I recover an entire Oracle9i database including controlfile and logfiles?

How do I recover an entire Oracle9i database including controlfile and logfiles?
The method of recovery really depends on your method of backing up your database. If you use RMAN, then let RMAN figure out exactly what needs to be recovered. If you have a cold backup, and no archived redo logs, then just restore all of the datafiles, controlfiles, and online redo logs and start up the database. If you perform a cold backup or hot backup, and you have your archived redo logs, then restore the missing datafiles and control files, but do not restore the online redo logs if you have them! They will be needed in the rolling-forward phase of your recovery.

With this type of question, I often conclude that backup and recovery, especially recovery, is a new concept as far as the Oracle database is concerned. I highly recommend that you read the Oracle Backup & Recovery Guide. You can find a copy on Technet and click the Documentation tab at the top of the Web page. Access to Technet is free, but you will need to sign up for an account.

Dig Deeper on Oracle database design and architecture

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.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close