RMAN strange behavior - cannot figure it out - missing datafile in backup but it says it is in the backup

From: Taylor, Chris David <ChrisDavid.Taylor_at_ingrambarge.com>
Date: Wed, 8 Aug 2012 09:58:16 -0500
Message-ID: <C5533BD628A9524496D63801704AE56D75B2FD2458_at_SPOBMEXC14.adprod.directory>

RMAN 11.2.0.2 with catalog on newly created database RMAN is telling me it cannot find a backup of datafile #5 yet the list backup shows it - It appears I have something misconfigured somewhere but I can't figure out where.

RMAN> restore database validate;

Starting restore at 08-AUG-12
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID87 device type=DISK allocated channel: ORA_DISK_2
channel ORA_DISK_2: SIDW8 device type=DISK

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 08/08/2012 09:41:54

RMAN-06026: some targets not found - aborting restore RMAN-06023: no backup or copy of datafile 5 found to restore

RMAN> list backup of datafile 5;

specification does not match any backup in the repository

RMAN> list backup;

List of Backup Sets

---

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------

5165651 Full    374.43M    DISK        00:01:21     08-AUG-12
        BP Key: 5165653   Status: AVAILABLE  Compressed: YES  Tag: %TAG
        Piece Name: Z:\DBABACKUP\CURRENT\VESMETP\0MNI479K_1_1

  List of Datafiles in backup set 5165651   File LV Type Ckp SCN Ckp Time Name

• -- ---- ---------- --------- ---- 1 Full 17817091143 08-AUG-12 G:\ORACLE\ORADATA\VESMETP\DATAFILES\SYSTEM01.DBF 2 Full 17817091143 08-AUG-12 G:\ORACLE\ORADATA\VESMETP\DATAFILES\SYSAUX01.DBF 3 Full 17817091143 08-AUG-12 G:\ORACLE\ORADATA\VESMETP\DATAFILES\UNDOTBS01.DBF 4 Full 17817091143 08-AUG-12 G:\ORACLE\ORADATA\VESMETP\DATAFILES\USERS01.DBF 5 Full 17817091143 08-AUG-12 G:\ORACLE\ORADATA\VESMETP\DATAFILES\EXAMPLE01.DBF 6 Full 17817091143 08-AUG-12 G:\ORACLE\ORADATA\VESMETP\DATAFILES\VESSEL_DATA01.DBF 7 Full 17817091143 08-AUG-12 G:\ORACLE\ORADATA\VESMETP\DATAFILES\VESSEL_INDEX01.DBF 8 Full 17817091143 08-AUG-12 G:\ORACLE\ORADATA\VESMETP\DATAFILES\REPORT_OBJECTS01.DBF

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------

5165652 Full    1.05M      DISK        00:00:02     08-AUG-12
        BP Key: 5165654   Status: AVAILABLE  Compressed: YES  Tag: %TAG
        Piece Name: Z:\DBABACKUP\CURRENT\VESMETP\0NNI47C9_1_1

  Control File Included: Ckp SCN: 17817091181 Ckp time: 08-AUG-12

BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------

5165706 29.13M     DISK        00:00:06     08-AUG-12
        BP Key: 5165708   Status: AVAILABLE  Compressed: YES  Tag: %TAG
        Piece Name: Z:\DBABACKUP\CURRENT\VESMETP\0ONI47CJ_1_1

  List of Archived Logs in backup set 5165706
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    1       17797789318 07-AUG-12 17817049779 07-AUG-12
  1    2       17817049779 07-AUG-12 17817059758 07-AUG-12
  1    3       17817059758 07-AUG-12 17817088111 08-AUG-12
  1    4       17817088111 08-AUG-12 17817088390 08-AUG-12
  1    5       17817088390 08-AUG-12 17817088510 08-AUG-12
  1    6       17817088510 08-AUG-12 17817088715 08-AUG-12
  1    7       17817088715 08-AUG-12 17817088840 08-AUG-12
  1    8       17817088840 08-AUG-12 17817090496 08-AUG-12
  1    9       17817090496 08-AUG-12 17817090696 08-AUG-12
  1    10      17817090696 08-AUG-12 17817091091 08-AUG-12
  1    11      17817091091 08-AUG-12 17817091208 08-AUG-12

BS Key  Type LV Size       Device Type Elapsed Time Completion Time


------- ---- -- ---------- ----------- ------------ ---------------

5165740 Full    9.67M      DISK        00:00:01     08-AUG-12
        BP Key: 5165752   Status: AVAILABLE  Compressed: NO  Tag: TAG20120808T085555
        Piece Name: Z:\DBABACKUP\CURRENT\VESMETP\C-1404776366-20120808-04

  SPFILE Included: Modification time: 08-AUG-12   SPFILE db_unique_name: VESMETP
  Control File Included: Ckp SCN: 17817091243 Ckp time: 08-AUG-12

RMAN> Chris Taylor

"Quality is never an accident; it is always the result of intelligent effort."
-- John Ruskin (English Writer 1819-1900)

Any views and/or opinions expressed herein are my own and do not necessarily reflect the views of Ingram Industries, its affiliates, its subsidiaries or its employees.

--

http://www.freelists.org/webpage/oracle-l Received on Wed Aug 08 2012 - 09:58:16 CDT