OraFAQ Forum: Backup & Recovery » RMAN cannot find datafiles during duplicate

Home » RDBMS Server » Backup & Recovery » RMAN cannot find datafiles during duplicate

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

RMAN cannot find datafiles during duplicate [message #212911]

Mon, 08 January 2007 16:08

clintonf
Messages: 82
Registered: May 2006

Member

Hi all,

I have been unable to duplicate my database due to the following error:

RMAN-00571: ================================================
RMAN-00569: ==== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===============================================
RMAN-03002: failure of Duplicate Db command at 01/05/2007 10:25:02
RMAN-03015: error occurred in stored script Memory Script
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20201: datafile not found in the recovery catalog
RMAN-06010: error while looking up datafile: 12

Here is what I have done to duplicate the database. I have been gone for a while so I suspect there is something missing that I am not seeing:

1) Flushed current log to archive log
2) BACKUP database PLUS archivelog;
3) Copied backup pieces, archivelog files and .dbf's to auxiliary machine (same directory structure as target DB)
4) Wait a day
5) Flush current logs to archivelog
6) BACKUP archivelog ALL;
7) Copied the archivelog files to auxiliary machine
8 ) Duplicate DB with TSPITR to a point before step 6 but AFTER step 3

I believe that this is the process that I have used successfully in the past. Hopefully some extra pairs of eyes can find what is missing or suggest what I may be doing incorrectly.

Thanks!

[Updated on: Mon, 08 January 2007 16:09]

Report message to a moderator

Re: RMAN cannot find datafiles during duplicate [message #212919 is a reply to message #212911]

Mon, 08 January 2007 17:32

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Did you check for the existence of backupsets for the concerned datafile (inside the catalog and physically)?.
Did you rescync the catalog?
>> Copied the archivelog files
Did you also copy the backupsets?
Seems your 'set until' is looking for some more information.
>>RMAN-06010: error while looking up datafile: 12
how Are you renaming the datafiles?
Based on file no?

[Updated on: Mon, 08 January 2007 18:06]

Report message to a moderator

Re: RMAN cannot find datafiles during duplicate [message #213201 is a reply to message #212919]

Tue, 09 January 2007 15:50

clintonf
Messages: 82
Registered: May 2006

Member

Hi Mahesh,

I have executed a `LIST backup` command to verify that the datafiles are in the catalog. I have also verified their physical existence on the target and auxiliary machines.

I resync'd the catalog.

I have copied all the backup sets (I had missed some). Then I backed up the archive log, copied the backupsets and archivelogs over to the auxiliary machine.

For renaming the datafiles I have used `CONFIGURE AUXNAME` for all the files. I verified that those configurations were still in place.

After doing all that I tried another TSPITR duplication but received the same error as before (still with datafile 12).

What can you make of that?

Thanks again.

Report message to a moderator

Re: RMAN cannot find datafiles during duplicate [message #213608 is a reply to message #213201]

Thu, 11 January 2007 07:31

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>> 6) BACKUP archivelog ALL;
I would backup the database and archived logs.
For duplication, RMAN expects everything in its vicinity.

Report message to a moderator

Re: RMAN cannot find datafiles during duplicate [message #213655 is a reply to message #213608]

Thu, 11 January 2007 13:29

clintonf
Messages: 82
Registered: May 2006

Member

Things seem to be working fine now... Question

Yesterday I noticed the following entries which occur every 5-6 minutes for a while now (but started after I went away) in my Windows Event Viewer:

Application Log: Info: Initializing PGA for process QMN0 in instance catdb.
~1 minute later: Warning: Instance catdb has been terminated.
4-5 minutes later: Info: Initializing PGA for process QMN0 in instance catdb.
~1 minute later: Warning: Instance catdb has been terminated.
4-5 minutes later: Info: Initializing PGA for process QMN0 in instance catdb.
~1 minute later: Warning: Instance catdb has been terminated.

catdb is my recovery catalog. Apparently the DB server also spontaneously re-booted at times too. The catalog DB service was thus disabled. I subsequently re-enabled it to try some thoughts that I had.

After this I was able to duplicate my database as before (without differing from my above process). The messages are still happening though.

Everything seems OK now ( Smile

), but I am curious as to what the above messages are indicating.

Does anyone have suggestions as to what may have caused them, what affect they had and why restarting the service allowed duplication?

Thanks!

Report message to a moderator

Previous Topic:	rman error - RMAN-03009
Next Topic:	How to Back Up RAW Secondary Volume

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Apr 28 18:05:44 CDT 2024