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

Recover database not running in archive log mode

Some of my system disks crashed. I have reinstalled the operating system and Oracle 9i. Now I want to create a database from existing datafiles and control files. My DB was not running in archive log mode.

I have run into a problem. I have Oracle 9i running on RedHat 3 ES. The problem is that system disks of my system crashed. The oradata was on a separate RAID controller. I have reinstalled the operating system and Oracle 9i. Now I want to create a database from existing datafiles and control files. My DB was not running in archive log mode. I have old healthy redo logs and multiplexed control files. In recovery I don't mind some bits of data loss even.
Copy your datafiles, control files and online redo logs to some backup destination. Next, precreate a database (with the DBCA) on your disk system with the same tablespaces, controlfiles, online redo logs, etc., all on the same exact disk units. Then copy the datafiles, control files and online redo logs to where you precreated the database. You should then be able to start the database. The system will be set up for this instance and the control files will know the database crashed. It will recover uncommitted transactions from the online redo logs.

Dig Deeper on Oracle database backup and recovery

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