RMAN 2005-04-18 - By jungwolf
On 4/17/05, Justis Durkee <justisd@(protected)> wrote:
> I ran into this very same problem just the other day.
>
> In order to connect to the nomount aux db, you have to set up a static
> service for the listener in listener.ora.
>
> SID_LIST_LISTENER > (SID_DESC> (global_dbname=...)
> (sid_name=standy_sid)
> (oracle_home=...)
> )
> )
>
> Then reload the listener configuration, lsnrctl reload.
Maurice, please let us know if this fixes the problem. It should
because, if I remember correctly, dynamic registration with the
listener doesn't happen until the database is mounted. That's
probably not the right terminology. The effect is, the listener
doesn't pass connections to an instance using dynamic registration
until the instance is in mount state.
So, since duplicating a database with rman requires the auxiliary to
be nomount, you're stuck with either running rman from the auxiliary
server (and using a local connection) or putting a static entry in
listener.ora as Justis suggests.
As you said:
>rman target / catalog rman/rman@(protected) auxiliary sys/PASSWORD@(protected)
>makes the problem. Setting the ORACLE_SID to STANDBY( alias in the
>tnsnames) and using
>rman target / catalog rman/rman@(protected) auxiliary sys/password
>works for the connection ! RMAN says:
The first doesn't work because rman is trying to go through the
listener, and the second does work because it is bypassing the
listener with a local connection.
HTH,
Steven
--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting
|
|
