-
Are you sure you are recovering a database? You have deleted the control file but that was all you did, you have not lose a single datafile. So basically this is:
Have not backed up the control file using the TO TRACE option, but used the TO filename option of ALTER DATABASE BACKUP CONTROLFILE
you do
Use the control file copy to obtain SQL output. Copy the backup control file and execute STARTUP MOUNT before ALTER DATABASE BACKUP CONTROLFILE TO TRACE NORESETLOGS. If the control file copy predated a recent structural change, edit the TO TRACE output to reflect the structural change
This is cut & pasted from Oracle Docs
-
Thank you very much!
You said: "This is cut & pasted from Oracle Docs"
Could you please tell me which chapter? I would like to read the details!
Thanks a lot! So, the conclusion is that you cannot use the binary backup of the controlfile directly to recover the db. You have to use it to create a trace file and then use that trace file to build a new control file, then continue the recovery. (In my scenario, there is no recovery required. It simply is a scenario of lossing all current control files.)
Could you please tell me which chapter? I would like to read the details!
-
Hi abonga can you do this...
......
startup mount
select * from v$recover_file; (note down the file name and #)
alter database recover datafile file#
(will ask for archive files/redofiles)
auto
alter database open;(if you get error user alter database open using backup controlfile)
.....
Hope this work.
can you post the result.
Thanks.
Thanigaivasan.
-
Sorry, I typed your name wrongly Abongwa.
Thanigaivasan
-
Here is the doc that explain ALL:
http://otn.oracle.com/docs/products/...scen.htm#11872
See the topic of Table 6-1 Options for Creating the Control File
I think that's the ONLY right way to use a binary backup of controlfile. All other use is useless. :>
-
Ur right Narayanan. Get the current logfile from v$log, and then apply that logfile with the exact path.
First , give this command,
Recover database using backup controlfile. It asks for the recovery of the database with a particular file. Just supply the file name which is a current one. Then u get a message like
'Media Recovery Complete'
Now open database with resetlogs.
best of luck
tia
PNRDBA
-
I felt like sharing this....site..
http://metalink.oracle.com/metalink/...1&p_showHelp=1
Thanks.
Thanigaivasan
-
Hi Abongwa,
When you are trying to recover the database with 'ALTER DATABASE RECOVER UNTIL CANCEL USING BACKUP CONTROLFILE' ... this is an incomplete recovery.
To do this, you should copy all the datafiles from sufficiently recent backup (the files should correspond to the structure of your database when you backed up your control file).
Then perform the recovery with the above command.
When you are prompted for the current log sequence number, then cancel the recovery.
Then use the command 'ALTER DATABASE OPEN RESETLOGS' to open the database.
Hope you'll succeed with this
-
I dont understand why you peeps are insisting on applying logs when there is nothing to recover heh
-
Hi,
I totally agree with Pando.
He has only deleted the Controlfile. Which means that all the datafiles and the logfiles are intact.
Just recreate the controlfile and open the database normally.
Vijay.
Say No To Plastics
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|