Home » RDBMS Server » Backup & Recovery » Incomplete recovery
Incomplete recovery [message #493870] Thu, 10 February 2011 04:59 Go to next message
sekar52
Messages: 141
Registered: May 2010
Location: Mumbai
Senior Member
Hi consider a situation in which I take hot backup of database at 10:00 am.After taking the hot backup 50 archived logs are created.Out of 50 i have backed up first 25 of them and at 5:00pm i lose complete database including control,data and the last 25 archived log files that were not backed up.So I am using latest hot backup to recover..
I restore the control file backup and datafile backup taken during ho tbackup(10 am) and i issue the command
.......startup mount
>>>>>>>Recover database until cancel
!!!!!!! Apply the available 25 archive logs
then i give "cancel" since I dont have the next redo log .
Now in which mode will the database open(Reset logs or no reset logs)
Why????/
Re: Incomplete recovery [message #493873 is a reply to message #493870] Thu, 10 February 2011 05:02 Go to previous messageGo to next message
knight
Messages: 111
Registered: January 2009
Senior Member
resetlogs is required in case of incomplete media recovery
Re: Incomplete recovery [message #493875 is a reply to message #493873] Thu, 10 February 2011 05:08 Go to previous messageGo to next message
Michel Cadot
Messages: 60017
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In addition.Why? Because what's inside the current log is irrelevant regarding what you recover as you stop the recovery before them.

Regards
Michel
Re: Incomplete recovery [message #493876 is a reply to message #493873] Thu, 10 February 2011 05:08 Go to previous messageGo to next message
sekar52
Messages: 141
Registered: May 2010
Location: Mumbai
Senior Member
Do you categorize this as incomplete recovery even if I use the control which was taken during hot backup(10 am) for recovery and didnt specify "using backup control file" during recovery????????
Re: Incomplete recovery [message #493878 is a reply to message #493875] Thu, 10 February 2011 05:10 Go to previous messageGo to next message
sekar52
Messages: 141
Registered: May 2010
Location: Mumbai
Senior Member
@michel
So do you mean we can open this case in noresetlogs
Re: Incomplete recovery [message #493879 is a reply to message #493878] Thu, 10 February 2011 05:12 Go to previous messageGo to next message
knight
Messages: 111
Registered: January 2009
Senior Member
http://www.orafaq.com/wiki/Incomplete_Media_Recovery
Re: Incomplete recovery [message #493881 is a reply to message #493878] Thu, 10 February 2011 05:14 Go to previous message
Michel Cadot
Messages: 60017
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No, I only add to knight's answer; my answer includes his.

Incomplete recovery means you don't completly recover the database, that is you don't apply all archived and current logs which is the meaning of "cancel".

Regards
Michel
Previous Topic: Seeking info on rman restore and recovery process
Next Topic: Backup until....in RMAN
Goto Forum:
  


Current Time: Mon Dec 22 10:27:51 CST 2014

Total time taken to generate the page: 0.14795 seconds