Check the alert log on the new database (auxiliary database) - any more descriptive errors in there ?
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
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 ?