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_at_ingrambarge.com>
Date: Wed, 8 Aug 2012 10:17:57 -0500
Message-ID: <C5533BD628A9524496D63801704AE56D75B2FD2483_at_SPOBMEXC14.adprod.directory>

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_at_freelists.org' 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)

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Aug 08 2012 - 10:17:57 CDT