missing archive redologs

All posts relating to Oracle database administration.

Moderator: Tim...

Senior Member
Posts: 143
Joined: Thu Dec 08, 2011 12:33 am

missing archive redologs

Postby adda.road@yahoo.com » Tue May 01, 2012 8:00 pm

Hi Tim,

I had only one set archive redologs .
In that one set some archive redologs are missing.

How can i recover the database?

my answer is only incomplete recovery until cancel .

Please correct me if i am wrong.


Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: missing archive redologs

Postby Tim... » Tue May 01, 2012 8:32 pm


If your datafile backups are newer than the missing archived redo logs, then a full recovery is possible.

If your datafile backups were taken before the missing archived redo logs, then you will only be able to recovery to the point in time before the first missing archived redo log. All data beyond that point will be lost. This is why archived redo logs are so important.

You can perform the recovery to a specific SCN, time or using the cancel option, but in all cases you must recovery to a point before the gap.


Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: https://oracle-base.com
My blog: https://oracle-base.com/blog

Return to “Oracle Database Administration”

Who is online

Users browsing this forum: No registered users and 2 guests