RMAN cloning with "WARNING from target database"

  • From: "jayaraj rengarajan" <jayaraj.rengarajan@xxxxxxxxx>
  • To: oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 11 Sep 2006 15:17:52 -0400

List members:

We do cloning of a production database using RMAN regularly for application
team.

I noticed this process hung Today with the following message ..This log file
was recorded with this WARNING messages (generated huge file)
...
...
...

cataloged datafile copy
datafile copy filename=/ora/CMSP9RO2/data/cms_data01_f07.dbf recid=143
stamp=600869488

cataloged datafile copy
datafile copy filename=/ora/CMSP9RO2/data/cms_data02_f15.dbf recid=144
stamp=600869492

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 09/11/2006 12:11:35
RMAN-03015: error occurred in stored script Memory Script

RMAN>

Recovery Manager complete.
WARNING from target database:

WARNING from target database:

WARNING from target database:
....
...
...
WARNING from target database:


We are seeing two sessions to the target database executing the following queries one from each session.

select count(*) from sys.x$kcrmx

SELECT act
   FROM x$ksusex
   WHERE sid = :1
     AND serial = :2

Any of you encounterd this ? suggestions ?



Thanks

Jay

Other related posts: