OraFAQ Forum: Backup & Recovery » Database recovery with missing one of the archivelog

Home » RDBMS Server » Backup & Recovery » Database recovery with missing one of the archivelog (Oracle 10g (10.2.0.1.0))

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

Database recovery with missing one of the archivelog [message #493872]

Thu, 10 February 2011 05:02

dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA

Senior Member

Hi All,

I want to do the recovery of my database using the archive log files but one of the archive log in between is missing, If any one can help me out with the solution I'll be very thankful.

Regards
Deepak Smile

Report message to a moderator

Re: Database recovery with missing one of the archivelog [message #493874 is a reply to message #493872]

Thu, 10 February 2011 05:06

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Then you cannot recover after the last archived log you have before the one you lost.

Regards
Michel

Report message to a moderator

Re: Database recovery with missing one of the archivelog [message #493877 is a reply to message #493872]

Thu, 10 February 2011 05:09

John Watson
Messages: 8960
Registered: January 2010
Location: Global Village

Senior Member

Is this a homework question, or a real situation?

Report message to a moderator

Re: Database recovery with missing one of the archivelog [message #493882 is a reply to message #493877]

Thu, 10 February 2011 05:17

dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA

Senior Member

This is the real question as my TL asked me to try this and I have searched over the internet for the steps as well but it did not helped me out. Sir So I thought to seek help from you experts.

Thanks
Deepak

Report message to a moderator

Re: Database recovery with missing one of the archivelog [message #493889 is a reply to message #493882]

Thu, 10 February 2011 05:40

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

What is impossible is impossible (even for a French DBA whatever Napoleon said).

Regards
Michel

[Updated on: Thu, 10 February 2011 05:40]

Report message to a moderator

Re: Database recovery with missing one of the archivelog [message #493893 is a reply to message #493889]

Thu, 10 February 2011 05:49

John Watson
Messages: 8960
Registered: January 2010
Location: Global Village

Senior Member

He probably said "C'est magnifique, mais ce n'est pas possible"

Report message to a moderator

Re: Database recovery with missing one of the archivelog [message #493898 is a reply to message #493893]

Thu, 10 February 2011 06:12

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

He actually said "Ce n'est pas possible, m'écrivez-vous : cela n'est pas français" ("It is not possible, you write me: this is not French"). Wink

Regards
Michel

Report message to a moderator

Re: Database recovery with missing one of the archivelog [message #493901 is a reply to message #493893]

Thu, 10 February 2011 06:22

dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA

Senior Member

May I be woring Sir but I want to describe the scenario to both of you.

I took backup of my database when there were 50 archived log files which were backed up. Then I created some users and tables and did manual switching of the logfiles, SAY 20 more archived files were generated and I took the backup of the new 20 files as well.

So now I have total backup of 70 archived logfiles. Now If In case say file number 30 is lost or deleted by mistake, will I be able to recover all the database any how such that ORACLE skips file number 30 and my data is recovered till file 70.

I hope I have made myself clear.

Thanks
Deepak

Report message to a moderator

Re: Database recovery with missing one of the archivelog [message #493902 is a reply to message #493901]

Thu, 10 February 2011 06:25

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Explain how Oracle can skip hundred of modifications you (and it) made and keep a consistent database.

In your case, you have a backup of this archived log so nothing is lost and you have nothing to do RMAN will restore it in order to recover your database.

Regards
Michel

[Updated on: Thu, 10 February 2011 06:26]

Report message to a moderator

Re: Database recovery with missing one of the archivelog [message #493903 is a reply to message #493902]

Thu, 10 February 2011 06:32

dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA

Senior Member

I fully agree with your point SIR, but is it possible that ORACLE can skip the data of that particular archive which is delete and recover the remaining data, because I know that the file that is lost or deleted the data of that particular file can not be recovered.

Can we recover the remaining data which is present in other files?

Thanks
Deepak

Report message to a moderator

Re: Database recovery with missing one of the archivelog [message #493904 is a reply to message #493903]

Thu, 10 February 2011 06:36

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

NO (back to my first answer but you seem to not understand it, maybe this single word will be more efficient).

Regards
Michel

Report message to a moderator

Re: Database recovery with missing one of the archivelog [message #493905 is a reply to message #493904]

Thu, 10 February 2011 06:39

dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA

Senior Member

THANKS A LOT SIR. YOU CLEARED MY DOUBT.

REGARDS
DEEPAK

Report message to a moderator

Re: Database recovery with missing one of the archivelog [message #493906 is a reply to message #493905]

Thu, 10 February 2011 06:40

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Do NOT post in UPPER case, you have not to shout.

Regards
Michel

[Updated on: Thu, 10 February 2011 06:42]

Report message to a moderator

Re: Database recovery with missing one of the archivelog [message #493915 is a reply to message #493906]

Thu, 10 February 2011 07:14

dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA

Senior Member

I am sorry, I was not aware of this Sir.

Thanks
Deepak

Report message to a moderator

Re: Database recovery with missing one of the archivelog [message #493965 is a reply to message #493906]

Thu, 10 February 2011 11:46

dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA

Senior Member

Sir, I have doubt, will settng the value of the parameter _allow_resetlogs_corruption to TRUE will put any effect in the recovery which I want to do?

Thanks
Deepak

Report message to a moderator

Re: Database recovery with missing one of the archivelog [message #493966 is a reply to message #493965]

Thu, 10 February 2011 11:48

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I do not comment this kind of parameter but to say ask Oracle support to... support you in this.

Regards
Michel

Report message to a moderator

Re: Database recovery with missing one of the archivelog [message #493985 is a reply to message #493966]

Thu, 10 February 2011 13:05

dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA

Senior Member

Ok Sir ,thanks for your help. I'll try to implemet this at my local environment and then tell you what happened.

Regards
Deepak

Report message to a moderator

Re: Database recovery with missing one of the archivelog [message #494047 is a reply to message #493965]

Fri, 11 February 2011 02:49

John Watson
Messages: 8960
Registered: January 2010
Location: Global Village

Senior Member

Only a lunatic would set this parameter.
I would fire any of my DBAs who did it.

Report message to a moderator

Previous Topic:	OracleXE Backup & Recovery
Next Topic:	RMAN-00554: initialization of internal recovery manager package failed

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 21:09:28 CST 2024