We help IT Professionals succeed at work.

Rman duplicate failed when doing the refresh

bhanu823 asked
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;
   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
Watch Question

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