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 expired backups

Re: RMAN expired backups

From: Steve Howard <stevedhoward_at_gmail.com>
Date: Sat, 02 Jun 2007 14:30:34 -0000
Message-ID: <1180794634.847027.275890@w5g2000hsg.googlegroups.com>


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 Sat Jun 02 2007 - 09:30:34 CDT

Original text of this message

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