| |
GeekInterview.com > Interview Questions > Oracle > Backup and Recovery
| Print | |
Question: how to recover control file without backup and without 'create control file' command?
|
| March 03, 2009 07:21:21 |
#3 |
| chetan.ind |
Member Since: March 2009 Total Comments: 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. |
| |
Back To Question | |
