Backup and Recovery - how to recover control file without backup and without 'create control file' command?

GeekInterview.com > Interview Questions > Oracle > Backup and Recovery

Go To First | Previous Question | Next Question

Backup and Recovery | Question 24 of 42

how to recover control file without backup and without 'create control file' command?

Total Answers and Comments: 3

Last Update: March 19, 2009 Asked by: GAURAV

Sponsored Links

Best Rated Answer

—

Submitted by: sanjayoracle

if we don;t have any backup of Controlfile...then we have to use create controlfile command..

Above answer was rated as good by the following members:
abharoy

October 04, 2007 06:56:57

Mohammed Abdul Afroze

RE: how to recover control file without backup and wit...

If we lost the controlfile and there is no controlfile backup trace. The only soln is for that is recreate the controlfile script by own.

Is this answer useful? Yes | No

0 2

Overall Rating: -2

April 24, 2008 22:26:26

sanjayoracle

Member Since: April 2008 Contribution: 4

RE: how to recover control file without backup and without 'create control file' command?

if we don;t have any backup of Controlfile...then we have to use create controlfile command..

Is this answer useful? Yes | No

1 0

Overall Rating: +1

March 18, 2009 07:21:21

chetan.ind

Member Since: March 2009 Contribution: 1

RE: how to recover control file without backup and without 'create control file' command?

If this is the situation simple process is :

1. Take a trace of control file from clone do the changes in that like database name and datafile name and location.
2. Save it as < name >.ora
3. Run the file in nomount stage.

This will create your control file .

Note : Always make a habit of taking control file trace with the cold back.

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank