Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

RMAN expired backups

20 views
Skip to first unread message

cptkirkh

unread,
Jun 1, 2007, 5:25:32 PM6/1/07
to
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.

EdStevens

unread,
Jun 1, 2007, 6:15:36 PM6/1/07
to

see MetaLink note Note:120282.1. Do a search on "RMAN-06023: no
backup or copy of datafile". Offhand, it looks like you deleted your
backups.

Steve Howard

unread,
Jun 2, 2007, 10:30:34 AM6/2/07
to

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

bohana

unread,
Jun 3, 2007, 3:58:24 PM6/3/07
to
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.

0 new messages