Home » RDBMS Server » Backup & Recovery » Recovery process (Oracle 9i and above)
Recovery process [message #561164] Thu, 19 July 2012 04:38 Go to next message
hemchander83@gmail.com
Messages: 10
Registered: July 2012
Location: US
Junior Member
Hi,

Just assume a scenario...

When we restore the database using old controlfile, it will not have the information about the newly added datafile. However when we try to restore the database using backup control file there is an error showing unnamed datafile enrty has been made in controlfile with the details of the datafile location. From where the datafile location information is pulled from ?

What actually is happening when we restore is performed using backup controlfile ?
Also whats the difference between creating controlfile using reset logs and without reset logs and how it varies from opening the database in resetlog option ?
Re: Recovery process [message #561170 is a reply to message #561164] Thu, 19 July 2012 04:50 Go to previous messageGo to next message
Michel Cadot
Messages: 60053
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
When we restore the database using old controlfile, it will not have the information about the newly added datafile. However when we try to restore the database using backup control file there is an error showing unnamed datafile enrty has been made in controlfile with the details of the datafile location. From where the datafile location information is pulled from ?


It is in Oracle dictionary which have been updated and you have recovered.

Quote:
What actually is happening when we restore is performed using backup controlfile ?


The same thing that with a current control file except it does not know the end of the recovery and you have to specify it cancelling the recovery and opening the database with reset logs.

Quote:
Also whats the difference between creating controlfile using reset logs and without reset logs and how it varies from opening the database in resetlog option ?


It clears the online redo logs and creates a new incarnation of the database resetting the log sequence to 1.

Regards
Michel
Re: Recovery process [message #561495 is a reply to message #561170] Mon, 23 July 2012 05:47 Go to previous messageGo to next message
hemchander83@gmail.com
Messages: 10
Registered: July 2012
Location: US
Junior Member
Hi Michel,

Thanks for your quick response.
Answer for my first question you said that it will return the location details from the dictionary but how..
We are in the mount state for only dynamic views and the database is not opened. Also the control file doesn't have this information.

lets recap the same example, say I have old controlfile and the new entry is not reflecting in the datafile.
Now I am in the mount state and trying to recover the database however the recovery process failed saying there is an unnamed datafile and the recovery process updated the control file location.
Re: Recovery process [message #561497 is a reply to message #561495] Mon, 23 July 2012 05:59 Go to previous messageGo to next message
Michel Cadot
Messages: 60053
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Sorry I misread the first part.
Oracle gets the file location from the control file, this is the reason you have some files named "unamed" when you recover from a backup control file when you query v$dbfile, for instance.

Regards
Michel
Re: Recovery process [message #561514 is a reply to message #561497] Mon, 23 July 2012 07:11 Go to previous message
hemchander83@gmail.com
Messages: 10
Registered: July 2012
Location: US
Junior Member
Hi Michel,

Thanks for your reply.

Just correct me if I am wrong.

Old controlfile will not have the newly added datafile information however the information will be updated from the Archive log file.
Previous Topic: user name to connect for archivelog after migration.
Next Topic: datapump error
Goto Forum:
  


Current Time: Thu Dec 25 10:31:09 CST 2014

Total time taken to generate the page: 0.12970 seconds