Home » RDBMS Server » Backup & Recovery » Backup error (HP-UX 11i Db10.2.0.4)
Backup error [message #507783] Tue, 17 May 2011 22:57 Go to next message
mzainal
Messages: 50
Registered: March 2010
Location: Malaysia
Member
Hi,

I backup database using Tape backup. So i got a few error. Tape i already replace. Here the error:
[Normal] From: BSM@mohrops.example.com "KSMAPP2-JCS-ARCHIVELOG"  Time: 5/18/11 11:46:13 AM
    OB2BAR application on "ksmapp2.example.com" successfully started.

[Normal] From: ob2rman@ksmapp2.example.com "jcsdb2"  Time: 05/18/11 11:38:35
    Starting backup of target database.

    Net service name: jcsdb2.example.com.
    Instance status: OPEN.
    Instance name: jcsdb2.
    Database DBID = 723853876.
    Database control file type: CURRENT.
    Database log mode: ARCHIVELOG.


[Normal] From: ob2rman@ksmapp2.example.com "jcsdb2"  Time: 05/18/11 11:38:41
    Starting Oracle Recovery Manager.


Recovery Manager: Release 10.2.0.4.0 - Production on Wed May 18 11:38:41 2011

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

RMAN> CONNECT TARGET *
2> CONNECT CATALOG *
3> run {
4> allocate channel 'dev_0' type 'sbt_tape'
5>  parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=jcsdb2,OB2BARLIST=KSMAPP2-JCS-ARCHIVELOG,OB2BARHOSTNAME=ksmapp2.example.com)';
6> backup
7>  format 'KSMAPP2-JCS-ARCHIVELOG<jcsdb2_%s:%t:%p>.dbf'
8>  archivelog all
9>  delete input;
10> backup
11>  format 'KSMAPP2-JCS-ARCHIVELOG<jcsdb2_%s:%t:%p>.dbf'
12>  current controlfile;
13> }
14> EXIT
connected to target database: JCSDB2 (DBID=723853876)

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

Recovery Manager complete.
[Major] From: ob2rman@ksmapp2.example.com "jcsdb2"  Time: 05/18/11 11:38:43
    The database reported error while performing requested operation.

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
 
 Recovery Manager complete.

[Major] From: ob2rman@ksmapp2.example.com "jcsdb2"  Time: 05/18/11 11:38:44
    Oracle Recovery Manager completed with errors.

[Major] From: ob2rman@ksmapp2.example.com "jcsdb2"  Time: 05/18/11 11:38:44
    Backup of target database failed.

[Normal] From: BSM@mohrops.example.com "KSMAPP2-JCS-ARCHIVELOG"  Time: 5/18/11 11:46:24 AM
    OB2BAR application on "ksmapp2.example.com" disconnected.

[Normal] From: BSM@mohrops.example.com "KSMAPP2-JCS-ARCHIVELOG"  Time: 5/18/11 11:46:55 AM

    Backup Statistics:
          
        Session Queuing Time (hours)         0.00        
        -------------------------------------------      
        Completed Disk Agents ........          0          
        Failed Disk Agents ...........          0          
        Aborted Disk Agents ..........          0          
        -------------------------------------------      
        Disk Agents Total  ...........          0          
        ===========================================      
        Completed Media Agents .......          0          
        Failed Media Agents ..........          0          
        Aborted Media Agents .........          0          
        -------------------------------------------      
        Media Agents Total  ..........          0          
        ===========================================      
        Mbytes Total .................       0 MB        
        Used Media Total .............          0          
        Disk Agent Errors Total ......          0    


============================================================================
                      Session completed with errors!
============================================================================


oracle;ksmapp2;/home/oracle>lsnrctl status

LSNRCTL for HPUX: Version 10.2.0.4.0 - Production on 18-MAY-2011 11:37:52

Copyright (c) 1991, 2007, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for HPUX: Version 10.2.0.4.0 - Production
Start Date                18-MAY-2011 08:40:15
Uptime                    0 days 2 hr. 57 min. 36 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/10.2.0/network/admin/listener.ora
Listener Log File         /u01/app/oracle/product/10.2.0/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ksmapp2.example.com)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "jcsdb1.example.com" has 1 instance(s).
  Instance "jcssby", status READY, has 1 handler(s) for this service...
Service "jcsdb1_XPT.example.com" has 1 instance(s).
  Instance "jcssby", status READY, has 1 handler(s) for this service...
Service "jcsdb2.example.com" has 1 instance(s).
  Instance "jcsdb2", status READY, has 1 handler(s) for this service...
Service "jcsdb2XDB.example.com" has 1 instance(s).
  Instance "jcsdb2", status READY, has 1 handler(s) for this service...
Service "jcsdb2_XPT.example.com" has 1 instance(s).
  Instance "jcsdb2", status READY, has 1 handler(s) for this service...
Service "jcssby.example.com" has 1 instance(s).
  Instance "jcssby", status READY, has 1 handler(s) for this service...
Service "jcssbyXDB.example.com" has 1 instance(s).
  Instance "jcssby", status READY, has 1 handler(s) for this service...
The command completed successfully

Please assist me.
Re: Backup error [message #507784 is a reply to message #507783] Tue, 17 May 2011 23:02 Go to previous messageGo to next message
BlackSwan
Messages: 22691
Registered: January 2009
Senior Member
Since Networking is involved, the basic assumption is that two distinct systems are involved.

For System1 post hostname, IP#, Operating System name & version & Oracle s/w version to 4 decimal places.
For System2 post hostname, IP#, Operating System name & version & Oracle s/w version to 4 decimal places.
Clarify which hostname is associated with DataBase (DB) Server system & which hostname with SQL Client.

From DB Server post content of listener.ora & sqlnet.ora (if either exist)
From DB Server post results from following commands
lsnrtcl status
lsnrctl service
sqlplus scott/tiger

From SQL Client post content of tnsnames.ora & sqlnet.ora (if either exist)
From SQL Client post results from following commands
tnsping <DB_alias>
ping <DBhostname>
sqlplus scott/tiger@<DB_alias>

ORA-12514 ALWAYS only occurs due to a problem on DB Server system.
One cause of this problem is when the Oracle database is down & needs to be started.
A remote client send a request to the Listener asking to be connected to a specific service.
If/when the listener does not know anything about that service, the listener responds with ORA-12514
Since every connection request to the listener gets logged, listener.log file will contain a line with 12514 as status code.
This line contains valuable debugging details. So post this line & surrounding lines.
Re: Backup error [message #507785 is a reply to message #507783] Tue, 17 May 2011 23:29 Go to previous messageGo to next message
mzainal
Messages: 50
Registered: March 2010
Location: Malaysia
Member
When i check, out catalog not up. So i start catalog and all run smooth. Actually, last DB admin has quit. So took his job and learn from below.

Quiet difficult because they not document what they do on that DB. So, i start do document for my own.
Re: Backup error [message #507786 is a reply to message #507785] Tue, 17 May 2011 23:32 Go to previous messageGo to next message
BlackSwan
Messages: 22691
Registered: January 2009
Senior Member
>So i start catalog and all run smooth.
Is problem solved now?
Re: Backup error [message #507787 is a reply to message #507786] Tue, 17 May 2011 23:39 Go to previous message
mzainal
Messages: 50
Registered: March 2010
Location: Malaysia
Member
Solve my problem.
Previous Topic: weird error
Next Topic: how much recovery area should I temporary allocate in this DG configuration
Goto Forum:
  


Current Time: Sat Aug 23 08:36:56 CDT 2014

Total time taken to generate the page: 0.12560 seconds