Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Duplicate by RMAN in 10g

happy10319Aug 4 2007 — edited Jul 19 2009
Hi,
to duplicate a databse to an auxiliary DB, auxiliary should be in nomount.
please See 374069.1 note on metalink or Oracle® Data Guard
Concepts and Administration 10g Release 2 (10.2) B14239-04 page F-7.
But,
RMAN can not connect to an auxiliary oracle database when it is in nomount state. I created another
data base named orcl3. Impossible to conect to by RMAN as auxiliary for orcl2
and orcl3 :
orcl2 is in noumount :
C:\Documents and Settings\a.user>rman target sys/pwd@orcl auxiliary sys/pwd@orcl2
connectÚ Ó la base de donnÚes cible : ORCL (DBID=1155329895)
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: Úchec de l'initialisation du gestionnaire de rÚcupÚration interne
RMAN-04006: Error not connected to auxiliaire :ORA-12528: TNS:listener: all appropriate instances are blocking new connections
I did :
SQL>alter database mount
and now :
C:\Documents and Settings\ >rman target sys/pwd@orcl auxiliary sys/pwd@orcl2
Regards.

Recovery Manager: Release 10.2.0.1.0 - Production on Sam. Ao¹t 4 08:02:21 2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.

connected to target : ORCL (DBID=1155329895)
connected to auxiliaire : ORCL2 (DBID=608821149, non ouverte)

RMAN> exit

orcl3 is nomounted :


C:\Documents and Settings\a.user>rman target sys/pwd@orcl auxiliary
sys/pwd@orcl3

Recovery Manager: Release 10.2.0.1.0 - Production on Sam. Ao¹t 4 08:31:55 2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.

connectÚ Ó la base de donnÚes cible : ORCL (DBID=1155329895)
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: Úchec de l'initialisation du gestionnaire de rÚcupÚration interne
RMAN-04006: Error not connected to auxiliaire :ORA-12528: TNS:listener: all appropriate instances are blocking new connections

Many thanks.

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 16 2009
Added on Aug 4 2007
#general-database-discussions
24 comments
10,535 views