Thursday, December 22, 2011

How to resolve Error ORA-01079

International Bibliography of Periodical Liter...Image via Wikipedia
I was about to mount system database but suddenly I got an error message on PC screen this stuck my mind for a minute. The error message was look like it:

 
ORA-01079 Oracle database was not properly created, operation aborted

 
Then I have decided to read about the error on Oracle official site & oracle database related forums. This is the information which I found through oracle official site & forums:


ORA-01079:
ORACLE database was not properly created, operation aborted
Cause: There was an error when the database or control file was created.
Action: recreate the database or a new control file.


Now it was clear that the error is related to database or controlfile creation. As the solution mention, I have to recreate controlfile or database. The query for recreating controlfile is as follows:

 
create controlfile database name-of-database

 
When you recreated controlfile then you can not open database only way You have to create new database. But you can not recover your old database.

 
There is an alternative way to the CREATE CONTROLFILE statement is ALTER DATABASE BACKUP CONTROLFILE TO TRACE. It generates a SQL script in the trace file to re-create controlfile. If the database contains read-only or temporary tablespaces, then that SQL script will also contain all the necessary SQL statements to add those files back into the oracle database. So this helps you to recreating controlfile, also helps to restore old database information.

 
But this command also has a some shortcomings like it can recover only read-only or temporary tablespaces. It is not able to add large files back into the database. So if your data is important for you & you want to recover it in any cost, you should use Oracle Recovery Software.

 
This software resolves most of the oracle database corruption errors & recover your data in few clicks. This software recovers most of components of oracle database.



Enhanced by Zemanta

No comments:

Post a Comment