Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

RMAN duplicate from ACTIVE DATABASE

Aravind NJan 20 2011 — edited Jan 20 2011

Hi,

I am trying to create a new 11.2.0.1 database by duplicating an existing 11.2.0.1 database using Rman with 'from active database' option.

I have created a password file and listener is configured as well.
The aux database is started in nomount state.

rman
connect target sys/pwd123@SRCDB
connect auxiliary sys/pwd123@AUXDB
duplicate target database to AUXDB
FROM ACTIVE DATABASE;

This fails saying that "ORA-12528: TNS:listener: all appropriate instances are blocking new connections" which is quite normal given that the listener is havig a handle in BLOCKED state for this AUXDB as it is in NOMOUNT state.

Could you please help me on how to proceed?

One option can be to create the controlfile manually and mount the instance before doing the duplicate. I hope Rman can continue from there.
Another option is to go for backup based duplicate.

Is there any other way to go?

Regards,
Aravind

This post has been answered by Chinar on Jan 20 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 17 2011

Added on Jan 20 2011

#general-database-discussions

3 comments

887 views