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

Retrieving anything from some empty database files after crash

I was running Oracle 7.3, and it crashed recently with the following files, out of which three files (sys1orcl.ora, tmp1orcl.ora and rbs1orcl.ora) are showing zero bytes.
 ctl2orcl.ora 156KB
 initorcl.ora 6KB
 log1orcl.ora 201KB
 log2orcl.ora 201KB
 rbs1orcl.ora 0KB<<
 sys1orcl.ora 0KB<<
 tm1orcl.ora 2050KB
 usr1orcl.ora 0KB<<
Now, would it be possible to retrieve anything from the above database files.
You'll have to go to your database backup to be able to recover anything. One of the files you lost (sys1orcl.ora) is your database's Data Dictionary. Without that file, the database will never know what other database objects exist in the database. Your should be able to restore the database files from your backup.
This was last published in June 2005

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.

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.