dbTalk Databases Forums  

RMAN DUPLICATE DATABASE

comp.databases.oracle.server comp.databases.oracle.server


Discuss RMAN DUPLICATE DATABASE in the comp.databases.oracle.server forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
chris b
 
Posts: n/a

Default RMAN DUPLICATE DATABASE - 05-24-2007 , 10:16 AM






I am trying to work towards duplicating a database ( production )
& loading into a standby / both oracle 10.2.0.3 enterprise

The documentation suggests

a) starting standy database is nomount mode

b) connecting to production target via rman
c) connecting to catalog via rman

d) connecting to standby using

RMAN> CONNECT AUXILIARY SYS/STANDBY@STANDBY;

RMAN-00571:
================================================== =========
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS
===============
RMAN-00571:
================================================== =========
RMAN-04006: error from auxiliary database: ORA-12528: TNS:listener:
all appropri
ate instances are blocking new connections

RMAN>


Any ideas/suggestions , should I be in nomount mode before trying to
duplicate a database?? I seem to be in catch22 in that I can't
connect to the database that I need to re-populate by duplication


Reply With Quote
  #2  
Old   
Valentin Minzatu
 
Posts: n/a

Default Re: RMAN DUPLICATE DATABASE - 05-24-2007 , 10:34 AM






On May 24, 11:16 am, chris b <chris.br... (AT) providenthims (DOT) co.uk> wrote:
Quote:
I am trying to work towards duplicating a database ( production )
& loading into a standby / both oracle 10.2.0.3 enterprise

The documentation suggests

a) starting standy database is nomount mode

b) connecting to production target via rman
c) connecting to catalog via rman

d) connecting to standby using

RMAN> CONNECT AUXILIARY SYS/STANDBY@STANDBY;

RMAN-00571:
================================================== =========
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS
===============
RMAN-00571:
================================================== =========
RMAN-04006: error from auxiliary database: ORA-12528: TNS:listener:
all appropri
ate instances are blocking new connections

RMAN

Any ideas/suggestions , should I be in nomount mode before trying to
duplicate a database?? I seem to be in catch22 in that I can't
connect to the database that I need to re-populate by duplication
You need a static entry in the listener configuration file for the
standby - automatic instance registration does not happen in nomount
mode.



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.