OraFAQ Forum: Backup & Recovery » RMAN

Home » RDBMS Server » Backup & Recovery » RMAN - shutdown clone hanging

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

RMAN - shutdown clone hanging [message #272882]

Mon, 08 October 2007 02:13

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.

Attachment: duplicate.txt
(Size: 5.17KB, Downloaded 1242 times)

Report message to a moderator

Re: RMAN - shutdown clone hanging [message #272899 is a reply to message #272882]

Mon, 08 October 2007 02:32

Michel Cadot
Messages: 68653
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

What is in the alert.log file?

Regards
Michel

Report message to a moderator

Re: RMAN - shutdown clone hanging [message #272911 is a reply to message #272882]

Mon, 08 October 2007 02:50

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.

Report message to a moderator

Previous Topic:	RMAN error in oracle 10g
Next Topic:	urgent help

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 20 08:48:07 CDT 2024