Home » RDBMS Server » Backup & Recovery » rman recovery problem (oralce, 10.2.0.4.0, HPUX)
rman recovery problem [message #551435] Wed, 18 April 2012 04:49 Go to next message
nanigadu
Messages: 3
Registered: April 2012
Junior Member
when i try to do backup i have the following error. This has happened after the DB server has been rebooted.


RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-04004: error from recovery catalog database: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor.

Is this RMAN catalog issue.

I tried to check the listener status and below are the details.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=*******)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for HPUX: Version 10.2.0.4.0 - Production
Start Date 09-APR-2012 17:58:53
Uptime 9 days 1 hr. 3 min. 39 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oracle/db/10.2.0.4/network/admin/listener.ora
Listener Log File /oracle/db/10.2.0.4/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=*******)(PORT=1521)))
Services Summary...
Service "****" has 1 instance(s).
Instance "****", status READY, has 1 handler(s) for this service...
Service "****XDB" has 1 instance(s).
Instance "****", status READY, has 1 handler(s) for this service...
Service "****_XPT" has 1 instance(s).
Instance "****", status READY, has 1 handler(s) for this service...
The command completed successfully

Can some one help me if i am missing some where.

Thanks in advance.
Sruhi.

[Updated on: Wed, 18 April 2012 05:20]

Report message to a moderator

Re: rman recovery problem [message #551446 is a reply to message #551435] Wed, 18 April 2012 05:43 Go to previous messageGo to next message
Flyby
Messages: 188
Registered: March 2011
Location: Belgium
Senior Member
The full output of your rman would be welcome.
Do you connect to the database with connect target user/paswoord@servicename?
RMAN documentation
Re: rman recovery problem [message #551449 is a reply to message #551435] Wed, 18 April 2012 07:06 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
 *Cause:  The listener received a request to establish a connection to a
 database or other service. The connect descriptor received by the listener
 specified a service name for a service (usually a database service)
 that either has not yet dynamically registered with the listener or has
 not been statically configured for the listener.  This may be a temporary
 condition such as after the listener has started, but before the database
 instance has registered with the listener.
 *Action:
  - Wait a moment and try to connect a second time.
  - Check which services are currently known by the listener by executing:
    lsnrctl services <listener name>
  - Check that the SERVICE_NAME parameter in the connect descriptor of the
    net service name used specifies a service known by the listener.
  - If an easy connect naming connect identifier was used, check that
    the service name specified is a service known by the listener.
  - Check for an event in the listener.log file.

Regards
Michel
Re: rman recovery problem [message #551458 is a reply to message #551449] Wed, 18 April 2012 08:30 Go to previous messageGo to next message
jimmybhandari
Messages: 3
Registered: February 2012
Junior Member

The problem might be with listener for your catalog database. Check the connect descriptor for your catalog db in tnsnames.ora file. See if the SID / Service name ( For your RMAN Catalog db) is registered with the listener.
In case, you are not using a catalog db for RMAN and you are logged in to server as sys
1. Set env variables for your db ( oracle sid, home ) and then use 2. rman target=/ to login to rman.
Hope, it helps!!!
Re: rman recovery problem [message #551537 is a reply to message #551458] Thu, 19 April 2012 01:59 Go to previous messageGo to next message
nanigadu
Messages: 3
Registered: April 2012
Junior Member
How can i find the RMAN password. RMAN was previously created by some one else.

[Updated on: Thu, 19 April 2012 02:02]

Report message to a moderator

Re: rman recovery problem [message #551539 is a reply to message #551537] Thu, 19 April 2012 02:22 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Just change it as you want.

Regards
Michel
Re: rman recovery problem [message #551552 is a reply to message #551539] Thu, 19 April 2012 04:35 Go to previous messageGo to next message
nanigadu
Messages: 3
Registered: April 2012
Junior Member
How can i find if the RMAN DB was started or not. If not started. how can i start RMAN DB.

I think the RMAN DB was residing in the same DB server.

Thanks
Re: rman recovery problem [message #551556 is a reply to message #551552] Thu, 19 April 2012 05:24 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
OK you have to first read:
Administrator's Guide
Database Backup and Recovery Basics

Regards
Michel
Previous Topic: Making backups with Oracle VSS writer
Next Topic: Effect of insert on export (expdp)
Goto Forum:
  


Current Time: Fri Mar 29 03:22:07 CDT 2024