Re: RMAN expired backups

Hi,

There should be a file named E:\BACKUPS\G3IJ5B67_1_1 on your server? This is the file name for the backup piece holding your datafiles.

RMAN could not find them for some reason... perhaps your restoring into a different server and the RMAN files are on a different path?

Cheers,

Bruno.

On Jun 2, 3:30 pm, Steve Howard <stevedhow..._at_gmail.com> wrote:
> On Jun 1, 5:25 pm, cptkirkh <k..._at_scic.com> wrote:
>
>
>
> > I am attempting a test restore on oracle 10g. I have made it all the
> > way to the restore database command. When I run it this is what i
> > get:
>
> > Starting restore at 01-JUN-07
> > using channel ORA_DISK_1
>
> > RMAN-00571:
> > ===========================================================
> > RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS
> > ===============
> > RMAN-00571:
> > ===========================================================
> > RMAN-03002: failure of restore command at 06/01/2007 16:18:40
> > RMAN-06026: some targets not found - aborting restore
> > RMAN-06023: no backup or copy of datafile 4 found to restore
> > RMAN-06023: no backup or copy of datafile 3 found to restore
> > RMAN-06023: no backup or copy of datafile 2 found to restore
> > RMAN-06023: no backup or copy of datafile 1 found to restore
>
> > Then when i run the list backup command this is what I get.
>
> > BS Key Type LV Size Device Type Elapsed Time Completion Time
> > ------- ---- -- ---------- ----------- ------------ ---------------
> > 2557 Full 17M DISK 00:00:05 31-MAY-07
> > BP Key: 4600 Status: EXPIRED Compressed: NO Tag:
> > TAG20070531T031741
> > Piece Name: E:\BACKUPS\C-890890261-20070531-02
> > Controlfile Included: Ckp SCN: 1070883382 Ckp time: 31-MAY-07
> > SPFILE Included: Modification time: 22-APR-07
>
> > BS Key Type LV Size Device Type Elapsed Time Completion Time
> > ------- ---- -- ---------- ----------- ------------ ---------------
> > 2558 Incr 1 7G DISK 00:14:37 01-JUN-07
> > BP Key: 4601 Status: EXPIRED Compressed: YES Tag: LEVEL 1
> > INCREMENTA_060107030007
> > Piece Name: E:\BACKUPS\G3IJ5B67_1_1
> > List of Datafiles in backup set 2558
> > File LV Type Ckp SCN Ckp Time Name
> > ---- -- ---- ---------- --------- ----
> > 1 1 Incr 1071348205 01-JUN-07 F:\ORACLE\PRODUCT\10.1.0\ORADATA
> > \PORKY\SYSTEM01.DBF
> > 2 1 Incr 1071348205 01-JUN-07 F:\ORACLE\PRODUCT\10.1.0\ORADATA
> > \PORKY\UNDOTBS01.DBF
> > 3 1 Incr 1071348205 01-JUN-07 F:\ORACLE\PRODUCT\10.1.0\ORADATA
> > \PORKY\SYSAUX01.DBF
> > 4 1 Incr 1071348205 01-JUN-07 F:\ORACLE\PRODUCT\10.1.0\ORADATA
> > \PORKY\USERS01.DBF
> > 5 1 Incr 1071348205 01-JUN-07 F:\ORACLE\PRODUCT\10.1.0\ORADATA
> > \PORKY\USERS02.DBF
>
> > BS Key Type LV Size Device Type Elapsed Time Completion Time
> > ------- ---- -- ---------- ----------- ------------ ---------------
> > 2559 Full 17M DISK 00:00:10 01-JUN-07
> > BP Key: 4602 Status: EXPIRED Compressed: NO Tag:
> > TAG20070601T031516
> > Piece Name: E:\BACKUPS\C-890890261-20070601-00
> > Controlfile Included: Ckp SCN: 1071350977 Ckp time: 01-JUN-07
> > SPFILE Included: Modification time: 22-APR-07
>
> > BS Key Type LV Size Device Type Elapsed Time Completion Time
> > ------- ---- -- ---------- ----------- ------------ ---------------
> > 2560 Full 17M DISK 00:00:09 01-JUN-07
> > BP Key: 4603 Status: EXPIRED Compressed: NO Tag:
> > TAG20070601T031704
> > Piece Name: E:\BACKUPS\C-890890261-20070601-01
> > Controlfile Included: Ckp SCN: 1071352586 Ckp time: 01-JUN-07
> > SPFILE Included: Modification time: 22-APR-07
>
> > BS Key Size Device Type Elapsed Time Completion Time
> > ------- ---------- ----------- ------------ ---------------
> > 2561 2G DISK 00:03:04 01-JUN-07
> > BP Key: 4604 Status: AVAILABLE Compressed: YES Tag: LEVEL
> > 1 INCREMENTA_060107030007
> > Piece Name: E:\BACKUPS\G6IJ5C6H_1_1
>
> > List of Archived Logs in backup set 2561
> > Thrd Seq Low SCN Low Time Next SCN Next Time
> > ---- ------- ---------- --------- ---------- ---------
> > 1 104478 1070882118 31-MAY-07 1070892573 31-MAY-07
> > 1 104479 1070892573 31-MAY-07 1070893724 31-MAY-07
> > 1 104480 1070893724 31-MAY-07 1070918086 31-MAY-07
> > 1 104481 1070918086 31-MAY-07 1070923353 31-MAY-07
> > 1 104482 1070923353 31-MAY-07 1070932961 31-MAY-07
> > 1 104483 1070932961 31-MAY-07 1070994146 31-MAY-07
> > 1 104484 1070994146 31-MAY-07 1071095465 31-MAY-07
> > 1 104485 1071095465 31-MAY-07 1071136004 31-MAY-07
> > 1 104486 1071136004 31-MAY-07 1071186964 31-MAY-07
> > 1 104487 1071186964 31-MAY-07 1071212676 31-MAY-07
> > 1 104488 1071212676 31-MAY-07 1071225386 01-JUN-07
> > 1 104489 1071225386 01-JUN-07 1071226717 01-JUN-07
> > 1 104490 1071226717 01-JUN-07 1071238259 01-JUN-07
> > 1 104491 1071238259 01-JUN-07 1071324603 01-JUN-07
> > 1 104492 1071324603 01-JUN-07 1071341803 01-JUN-07
> > 1 104493 1071341803 01-JUN-07 1071342368 01-JUN-07
> > 1 104494 1071342368 01-JUN-07 1071342768 01-JUN-07
> > 1 104495 1071342768 01-JUN-07 1071343226 01-JUN-07
> > 1 104496 1071343226 01-JUN-07 1071343605 01-JUN-07
> > 1 104497 1071343605 01-JUN-07 1071344227 01-JUN-07
> > 1 104498 1071344227 01-JUN-07 1071344933 01-JUN-07
> > 1 104499 1071344933 01-JUN-07 1071351458 01-JUN-07
> > 1 104500 1071351458 01-JUN-07 1071352316 01-JUN-07
> > 1 104501 1071352316 01-JUN-07 1071352866 01-JUN-07
>
> > The only availible backup is the backup i ran last night. Everyone
> > before that is expired. What could i have set wrong? Thnaks in
> > advance.
>
> Regardless of whether it is there or not (EXPIRED), your full backup
> is only 17M, and took five seconds to complete?? That sounds like
> just the controlfile, and the level 1 (that shows as EXPIRED, anyway)
> would need a level 0 to be usable in recovery.
>
> BS Key Type LV Size Device Type Elapsed Time Completion Time
> ------- ---- -- ---------- ----------- ------------ ---------------
> 2557 Full 17M DISK 00:00:05 31-MAY-07
> BP Key: 4600 Status: EXPIRED Compressed: NO Tag:
> TAG20070531T031741
> Piece Name: E:\BACKUPS\C-890890261-20070531-02
> Controlfile Included: Ckp SCN: 1070883382 Ckp time: 31-MAY-07
>
> HTH,
>
> Steve
Received on Sun Jun 03 2007 - 14:58:24 CDT