Oracle Recovery without a good control file

5 pts.
Tags:
Oracle
Oracle 10.2.0.4
Oracle control file
Oracle Recovery Manager
How do I recover without a good Controlfile

Software/Hardware used:
Oracle 10.2.0.4, Windows platform
ASKED: November 4, 2010  7:24 PM
UPDATED: November 8, 2010  4:55 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.

Startup the database with the initialization file….
SQL> startup nomount
SQL> show parameter control (to check the path of control file)

Now create a control file

SQL> CREATE CONTROLFILE REUSE DATABASE “ORCL10G” RESETLOGS NOARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 ‘L:\ORCL10G\LOG\REDO01.LOG’ SIZE 50M,
GROUP 2 ‘L:\ORCL10G\LOG\REDO02.LOG’ SIZE 50M,
GROUP 3 ‘L:\ORCL10G\LOG\REDO03.LOG’ SIZE 50M
DATAFILE
‘L:\ORCL10G\DATA\SYSTEM01.DBF’,
‘L:\ORCL10G\DATA\UNDOTBS01.DBF’,
‘L:\ORCL10G\DATA\SYSAUX01.DBF’,
‘L:\ORCL10G\DATA\USERS01.DBF’,
‘L:\ORCL10G\DATA\EXAMPLE01.DBF’,
‘L:\ORCL10G\DATA\UNDOTBS02.DBF’
CHARACTER SET WE8MSWIN1252;
NOTE: change as per your drive letter (For eg, if it shows K:, then change as K:\ and then write the same !)
Now try to mount ….
SQL> alter database mount;
SQL> alter database open resetlogs;

CAUTION:
a) Always multiplex the Control files and Redo log files.
b) Take a backup of the database.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
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

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
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

Thanks! We'll email you when relevant content is added and updated.

Following