RE: RMAN strange behavior - cannot figure it out - missing datafile in backup but it says it is in the backup
Date: Wed, 8 Aug 2012 10:16:34 -0500
Message-ID: <C5533BD628A9524496D63801704AE56D75B2FD247B_at_SPOBMEXC14.adprod.directory>
Geez, what a mess...
RMAN Cannot Backup Foreign (transportable tablespace, plugged-in) Datafiles [ID 357383.1]
So, for me the following took place to fix it: (note this db was created using the 11g provided starter database with example schemas - so apparently the EXAMPLE tablespace gets created as a PLUGGED_IN tablespace)
1.) Switch EXAMPLE tablespace to READ ONLY; 2.) Switch logfile 3.) Switch EXAMPLE tablespace to READ WRITE; 4.) Switch logfile
5.) Attempt to backup database again - HOWEVER RMAN now *FAILS* due to RMAN-03009: failure of resync command on default channel at 08/08/2012 10:09:42 RMAN-20052: invalid datafile create SCN
6.) So, UNREGISTER database 7.) Reregister database 8.) Sync database 9.) backup database
10.) Verify that yes, now all datafiles are being backed up correctly and file IDs now match everywhere
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.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Taylor, Chris David
Sent: Wednesday, August 08, 2012 9:58 AM
To: 'oracle-l_at_freelists.org'
Subject: RMAN strange behavior - cannot figure it out - missing datafile in backup but it says it is in the backup
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:54RMAN-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 -- http://www.freelists.org/webpage/oracle-lReceived on Wed Aug 08 2012 - 10:16:34 CDT