Q
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.

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