RE: 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@xxxxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 8 Aug 2012 10:17:57 -0500
Additionally, I CLONED this starter database to a production instance after
some development - the issue is in the CLONED copy - not the original (hence
the problem).
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.
_____________________________________________
From: Taylor, Chris David
Sent: Wednesday, August 08, 2012 10:17 AM
To: Taylor, Chris David; 'oracle-l@xxxxxxxxxxxxx'
Subject: RE: RMAN strange behavior - cannot figure it out - missing datafile in
backup but it says it is in the backup
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)
--
//www.freelists.org/webpage/oracle-l
Other related posts:
