On May 24, 11:16 am, chris b <chris.br..._at_providenthims.co.uk> wrote:
> 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_at_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.
Received on Thu May 24 2007 - 10:34:04 CDT
