Rman duplicate failed when doing the refresh

Posted on 2012-08-15
Last Modified: 2012-10-15
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
Question by:bhanu823
    1 Comment
    LVL 34

    Accepted Solution

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

    Featured Post

    Gigs: Get Your Project Delivered by an Expert

    Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

    Join & Write a Comment

    Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
    Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
    This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
    This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now