Home » RDBMS Server » Backup & Recovery » RMAN and dynamic listener
icon3.gif  RMAN and dynamic listener [message #110921] Fri, 11 March 2005 02:08 Go to next message
Uwe
Messages: 260
Registered: February 2003
Location: Zürich, Switzerland
Senior Member
Hi all,

I found out the the RMAN in 9i is not workable if I use dynamic listener method in listener.ora.
Has anyone figured out if there is a way to use dynamic listener with RMAN at RESTORE?
Backup seems to be possible, but restore break if auxilliary database is not in static listening.

any hints welcome, I will post this the next days at metalink to clearify with oracle.

thanks
Uwe
Re: RMAN and dynamic listener [message #110922 is a reply to message #110921] Fri, 11 March 2005 02:33 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Hi,

Are you referring to a dynamic listener as a listener that uses Dynamic Service Registration (where PMON registers with the listener, no SID_LIST_listener_name in listener.ora)?

If so, try to start the instance and force registration before the restore:

SQL> ALTER SYSTEM REGISTER;

System altered.


Best regards.

Frank
Re: RMAN and dynamic listener [message #112138 is a reply to message #110922] Wed, 23 March 2005 04:03 Go to previous messageGo to next message
Uwe
Messages: 260
Registered: February 2003
Location: Zürich, Switzerland
Senior Member
Hello Frank,

I just tried your suggestion to register the database via sqlplus.
the listener shows :

Instance "AMRFREZ", status BLOCKED, has 1 handler(s) for this service...

But if I start RMAN I got the following problems. So RMAN is not workable with the dynamic listener and needs the static one.
The DB is blocked, because to restore/recover with RMAN the database needs to be nomount.

Recovery Manager: Release 9.2.0.4.0 - 64bit Production

Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.

RMAN>
connected to target database: AMRPROD (DBID=3497542973)

RMAN>
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-04006: error from auxiliary database: ORA-12519: TNS:no appropriate service
handler found

RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22
> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40> 41> 42
> 43> 44>
executing command: SET until clause
using target database controlfile instead of recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of allocate command at 03/23/2005 09:51:56
RMAN-06174: not connected to auxiliary database

RMAN>

Recovery Manager complete.
Restore done


I will open up a tar on Metalink to get this clarified. I think this two strategies are blocking technologies.

kind regs
Uwe
Re: RMAN and dynamic listener [message #112140 is a reply to message #112138] Wed, 23 March 2005 04:34 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Hi,

Can you connect to the Clone DB using SQL*Plus? If you cannot, then RMAN wouldn't have a chance either. To test, try:

sqlplus "sys/password@clonedb as sysdba"

If you cannot, try to define a static listener as well to see if it solves the problem. If a static listener solves the problem, you've proved that dynamic service registration indeed doesn't work and you can send a test case to Oracle Support so they can log it as a BUG.

Best regards.

Frank
Re: RMAN and dynamic listener [message #112142 is a reply to message #112140] Wed, 23 March 2005 04:40 Go to previous messageGo to next message
Uwe
Messages: 260
Registered: February 2003
Location: Zürich, Switzerland
Senior Member
I havn't tried this, but I will try in some hours. We do need the recovery now for testing our library. it will run aound 5 hrs.
After this i will test if I could connect via sqlplus - but i guess it will work. We've registerd the DB's via Oracle Names Services.

I have send the question parallel to Oracle via Metalink. Maybe they identify a problem with this.

regards
Uwe
Re: RMAN and dynamic listener [message #115389 is a reply to message #112142] Mon, 11 April 2005 02:57 Go to previous message
Uwe
Messages: 260
Registered: February 2003
Location: Zürich, Switzerland
Senior Member
Hi Frank,

I guess the oproblem is that the state of the listener is BLOCKED.
I tried with a new Database to clone, but if I try to connect I got ORA-12519
12519, 00000, "TNS:no appropriate service handler found"
// *Cause: The listener could not find any available service handlers that
// are appropriate for the client connection.
// *Action: Run "lsnrctl services" to ensure that the instance(s) have
// registered with the listener, and are accepting connections.

I will raise a call to determine that Oracle does not work that way. Maybe they're not realy aware of this feature *smile*

Uwe
Previous Topic: Recovering offline dropped datafile - Very Very Urgent
Next Topic: Can't find libobk.so
Goto Forum:
  


Current Time: Thu Mar 28 20:49:58 CDT 2024