Home » RDBMS Server » Backup & Recovery » Database recovery with missing one of the archivelog (Oracle 10g (10.2.0.1.0))
Database recovery with missing one of the archivelog [message #493872] Thu, 10 February 2011 05:02 Go to next message
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
Re: Database recovery with missing one of the archivelog [message #493874 is a reply to message #493872] Thu, 10 February 2011 05:06 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Then you cannot recover after the last archived log you have before the one you lost.

Regards
Michel
Re: Database recovery with missing one of the archivelog [message #493877 is a reply to message #493872] Thu, 10 February 2011 05:09 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Is this a homework question, or a real situation?
Re: Database recovery with missing one of the archivelog [message #493882 is a reply to message #493877] Thu, 10 February 2011 05:17 Go to previous messageGo to next message
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
Re: Database recovery with missing one of the archivelog [message #493889 is a reply to message #493882] Thu, 10 February 2011 05:40 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
He probably said "C'est magnifique, mais ce n'est pas possible"
Re: Database recovery with missing one of the archivelog [message #493898 is a reply to message #493893] Thu, 10 February 2011 06:12 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Database recovery with missing one of the archivelog [message #493901 is a reply to message #493893] Thu, 10 February 2011 06:22 Go to previous messageGo to next message
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
Re: Database recovery with missing one of the archivelog [message #493902 is a reply to message #493901] Thu, 10 February 2011 06:25 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
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
Re: Database recovery with missing one of the archivelog [message #493904 is a reply to message #493903] Thu, 10 February 2011 06:36 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Database recovery with missing one of the archivelog [message #493905 is a reply to message #493904] Thu, 10 February 2011 06:39 Go to previous messageGo to next message
dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA
Senior Member

THANKS A LOT SIR. YOU CLEARED MY DOUBT.

REGARDS
DEEPAK
Re: Database recovery with missing one of the archivelog [message #493906 is a reply to message #493905] Thu, 10 February 2011 06:40 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA
Senior Member

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


Thanks
Deepak
Re: Database recovery with missing one of the archivelog [message #493965 is a reply to message #493906] Thu, 10 February 2011 11:46 Go to previous messageGo to next message
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
Re: Database recovery with missing one of the archivelog [message #493966 is a reply to message #493965] Thu, 10 February 2011 11:48 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Database recovery with missing one of the archivelog [message #493985 is a reply to message #493966] Thu, 10 February 2011 13:05 Go to previous messageGo to next message
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
Re: Database recovery with missing one of the archivelog [message #494047 is a reply to message #493965] Fri, 11 February 2011 02:49 Go to previous message
John Watson
Messages: 8922
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.
Previous Topic: OracleXE Backup & Recovery
Next Topic: RMAN-00554: initialization of internal recovery manager package failed
Goto Forum:
  


Current Time: Thu Mar 28 17:55:14 CDT 2024