OraFAQ Forum: Backup & Recovery » Incomplete recovery

Home » RDBMS Server » Backup & Recovery » Incomplete recovery

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Incomplete recovery [message #493870]

Thu, 10 February 2011 04:59

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????/

Report message to a moderator

Re: Incomplete recovery [message #493873 is a reply to message #493870]

Thu, 10 February 2011 05:02

knight
Messages: 111
Registered: January 2009

Senior Member

resetlogs is required in case of incomplete media recovery

Report message to a moderator

Re: Incomplete recovery [message #493875 is a reply to message #493873]

Thu, 10 February 2011 05:08

Michel Cadot
Messages: 68641
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

Report message to a moderator

Re: Incomplete recovery [message #493876 is a reply to message #493873]

Thu, 10 February 2011 05:08

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????????

Report message to a moderator

Re: Incomplete recovery [message #493878 is a reply to message #493875]

Thu, 10 February 2011 05:10

sekar52
Messages: 141
Registered: May 2010
Location: Mumbai

Senior Member

@michel
So do you mean we can open this case in noresetlogs

Report message to a moderator

Re: Incomplete recovery [message #493879 is a reply to message #493878]

Thu, 10 February 2011 05:12

knight
Messages: 111
Registered: January 2009

Senior Member

http://www.orafaq.com/wiki/Incomplete_Media_Recovery

Report message to a moderator

Re: Incomplete recovery [message #493881 is a reply to message #493878]

Thu, 10 February 2011 05:14

Michel Cadot
Messages: 68641
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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Apr 20 01:40:48 CDT 2024