Backup error [message #507783] |
Tue, 17 May 2011 22:57 |
mzainal
Messages: 54 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 #507785 is a reply to message #507783] |
Tue, 17 May 2011 23:29 |
mzainal
Messages: 54 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.
|
|
|
|
|