Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: RMAN log sequence not found.

Re: RMAN log sequence not found.

From: <Kenneth>
Date: Fri, 12 Aug 2005 12:44:48 GMT
Message-ID: <42fc938e.155578@news.inet.tele.dk>


On 12 Aug 2005 02:29:51 -0700, "kechup" <kechupko_at_azet.sk> wrote:

>Hello,
>
>We switched to RMAN managed backups. Prior to this we deleted
>archivelogs by means of OS. Now I made database backup, and then
>archivelog backup. I tested if I can restore archivelog from backup and
>I have got thes message:
>RMAN-00571: ===========================================================
>RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
>RMAN-00571: ===========================================================
>RMAN-03002: failure of restore command at 08/12/2005 11:09:33
>RMAN-06026: some targets not found - aborting restore
>RMAN-06025: no backup of log thread 1 seq 33 scn 37770144 found to
>restore
>RMAN-06025: no backup of log thread 1 seq 32 scn 37770142 found to
>restore
>RMAN-06025: no backup of log thread 1 seq 31 scn 37763529 found to
>restore
>RMAN-06025: no backup of log thread 1 seq 30 scn 37763527 found to
>restore
>RMAN-06025: no backup of log thread 1 seq 29 scn 37763522 found to
>restore
>RMAN-06025: no backup of log thread 1 seq 28 scn 37763446 found to
>restore
>
>All the reported log sequences were deleted before the RMAN`s database
>backup and are not needed for database recovery. I tried crosscheck and
>then DELETE EXPIRED but without success.
>
>So now I have database backup, all archivelogs in backup needed for
>recovery but can`t restore them because were deleted by means of OS and
>they are not needed for reco.
>
>Any idea?

Funny...you have given several lines of output from your restore command, but you haven't posted the command itself.....

You haven't given version and platform either. Is it that hard to figure out that such info is essential ? I will assume 9.2 or above.

My guess is that you issued "restore archivelog all", which will unconditionally search for *all* archivelogs generated since last RESETLOGS. Instead, do an

"restore archivelog from sequence=34;"

Or better : If you just want to ensure your backups of archivelogs are really in place, do a validate instead and avoid heavy I/O-consumption and disks being filled with old archivelogs :

"restore archivelog from sequence=34 validate;"

There is almost never reason to restore archivelogs explicitly. In a typical recovery situation, RMAN will automatically restore the archivelogs needed for the recovery,. e.g.

run {
restore database;
recover database;
}

The first command will restore the latest full backup.

The second will apply incremental backups since then (if any are present), then figure out which archivelogs are needed for further recovery, restore these and finally apply them.

Received on Fri Aug 12 2005 - 07:44:48 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US