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
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs.
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command.
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming.
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.