Home » RDBMS Server » Backup & Recovery » RMAN - shutdown clone hanging
icon9.gif  RMAN - shutdown clone hanging [message #272882] Mon, 08 October 2007 02:13 Go to next message
stevenfoo
Messages: 10
Registered: October 2007
Junior Member
Dear All,

I am testing the RMAN DUPLICATE function on my test box.
I am running oracle 10.2 on Windows 2003 platform.

rman target sys/dba@Demo1 auxiliary sys/dba@BOX

RMAN> DUPLICATE TARGET DATABASE TO BOX
2> pfile=c:\oradata\BOX\initbox.ora;

The Duplicate process start and restore the datafiles and then perform the recover. However when it comes to the stage below it take a very long time and the clone still does not shutdown.

contents of Memory Script:
{
shutdown clone;
startup clone nomount pfile= 'c:\oradata\BOX\initbox.ora';
}
executing Memory Script


Anyone has any idea? Appreciate if anyone could help.

Re: RMAN - shutdown clone hanging [message #272899 is a reply to message #272882] Mon, 08 October 2007 02:32 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What is in the alert.log file?

Regards
Michel
Re: RMAN - shutdown clone hanging [message #272911 is a reply to message #272882] Mon, 08 October 2007 02:50 Go to previous message
stevenfoo
Messages: 10
Registered: October 2007
Junior Member
Hi All,

I managed to solve the issue.

There was another session of sql opening somewhere. I kill it and RMAN completed the duplicate.

Thanks again.
Previous Topic: RMAN error in oracle 10g
Next Topic: urgent help
Goto Forum:
  


Current Time: Wed Dec 07 20:23:38 CST 2016

Total time taken to generate the page: 0.21703 seconds