Evaluate
Weigh the pros and cons of technologies, products and projects you are considering.
Recovering system datafile without backup
How can I recover my system datafile without any backup? I was converting locally to dictionary-managed tablespaces by executing the query exec dbms_space_admin.tablespace_migrate_to_dictionary('ts1'); after some time when I started my db I got the following errors.
How can I recover my system datafile without any backup? I was converting locally to dictionary-managed tablespaces by executing the querry exec dbms_space_admin.tablespace_migrate_to_dictionary('ts1'); after some time when I started my db I got the following error: "ORA-04045: errors during recompilation/revalidation of LBACSYS.LBAC$LOGON ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at line 2 ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at line 2." Please help me to recover my db. The problem is I don't have any sort of backup.
You cannot recover the SYSTEM tablespace's datafile without a backup. This is why a good backup and recovery strategy needs to be implemented. Your only option at this point is to re-create the entire database, which means you will lose your valuable data.
This was last published in October 2006
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.
Meet all of our Oracle Database / Applications experts
View all Oracle Database / Applications questions and answers
Start the conversation
0 comments