From: "Taylor, Chris David" <ChrisDavid.Taylor@ingrambarge.com>
To: "'oracle-l@freelists.org'" <oracle-l@freelists.org>
Date: Wed, 8 Aug 2012 09:58:16 -0500
Subject: RMAN strange behavior - cannot figure it out - missing datafile in
 backup but it says it is in the backup
Thread-Topic: RMAN strange behavior - cannot figure it out - missing
 datafile in backup but it says it is in the backup
Message-ID: <C5533BD628A9524496D63801704AE56D75B2FD2458@SPOBMEXC14.adprod.directory>
Accept-Language: en-US
Content-Language: en-US
acceptlanguage: en-US
Content-type: text/plain
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-To: ChrisDavid.Taylor@ingrambarge.com

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