We help IT Professionals succeed at work.

Rman duplicate failed when doing the refresh

bhanu823
bhanu823 asked
on
Hello ,

I am doing the RMAN Refresh ( Refreshing UA with production copy) using duplicate command. but it is keep failing. please suggest how to solve this puzzle. I think it is restoring but not recovering. I am getting the following error
ontents of Memory Script:
{
   set until scn  154539389477;
   recover
   clone database
    delete archivelog
   ;
}
executing Memory Script

executing command: SET until clause

Starting recover at 08-15-2012:04:42:11

starting media recovery
media recovery failed
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00601: fatal error in recovery manager
RMAN-03004: fatal error during execution of command
RMAN-04006: error from auxiliary database: ORA-01092: ORACLE instance terminated. Disconnection forced
RMAN-03002: failure of Duplicate Db command at 08/15/2012 04:42:38
RMAN-03015: error occurred in stored script Memory Script
RMAN-11003: failure during parse/execution of SQL statement: alter database recover if needed
 start until change 154539389477 using backup controlfile
ORA-01041: internal error. hostdef extension doesn't exist
Comment
Watch Question

Senior Oracle DBA
CERTIFIED EXPERT
Commented:
Look at the alert log on the target system.  There should be more information in there as to why the database came down.