Hi all ,
On one RS/6000 Box , i am not using Tivoli`s scheduler., Instead I use
maestro scheduler .
It executes script which shut downs the oracle database.. Performs backups --and
brings oracle up..
for some reason the database does not come up from last week , and has to
start manually
.. While doing so it gives some problems.
Here is the log of backup at the end of it you will see some errors. I don't
know where to look
for these errors in TSM, Oracle or AIX?
Thanks
Shekhar ..
medrs2:more O46854.0115
===============================================================
= JOB : MEDRS2#WKLYRS2.RS2BKUP
= USER : root
= JCLFILE : /usr/tivoli/tsm/client/ba/bin/rs2script
= Job Number: 46854
= Mon Mar 12 01:15:17 EST 2001
===============================================================
MAESTRO for UNIX/JOBMANRC 6.1 (C) Tivoli Systems Inc. 1998
Starting /maestro/jobmanrc /usr/tivoli/tsm/client/ba/bin/rs2script
MAESTRO for UNIX (AIX)/JOBINFO 6.1 (9.3) (C) Tivoli Systems Inc. 1998
Installed for group 'DEFAULT'.
Oracle Server Manager Release 3.1.5.0.0 - Production
(c) Copyright 1997, Oracle Corporation. All Rights Reserved.
Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production
With the Partitioning and Java options
PL/SQL Release 8.1.5.0.0 - Production
SVRMGR> Connected.
SVRMGR> Database closed.
Database dismounted.
ORACLE instance shut down.
SVRMGR> 115 (1%)
Server Manager complete.
Database "ACWQ" shut down.
O46854.0115 (2%)
Oracle Server Manager Release 3.1.5.0.0 - Production
(c) Copyright 1997, Oracle Corporation. All Rights Reserved.
Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production
With the Partitioning and Java options
PL/SQL Release 8.1.5.0.0 - Production
SVRMGR> Connected.
SVRMGR> Database closed.
Database dismounted.
ORACLE instance shut down.
SVRMGR>
Server Manager complete.
Database "ACWT" shut down.
Oracle Server Manager Release 3.1.5.0.0 - Production
(c) Copyright 1997, Oracle Corporation. All Rights Reserved.
Node Name: MEDRS2
Session established with server TSM: AIX-RS/6000
Server Version 3, Release 7, Level 4.0
Server date/time: 03/12/01 01:17:35 Last access: 03/11/01 03:51:51
Incremental backup of volume '/'
Incremental backup of volume '/usr'
Incremental backup of volume '/var'
Incremental backup of volume '/home'
Incremental backup of volume '/ora01'
Incremental backup of volume '/ora02'
Incremental backup of volume '/ora03'
O46854.0115 (10%)
Incremental backup of volume '/ora04'
Incremental backup of volume '/ora05'
Incremental backup of volume '/ora06'
Incremental backup of volume '/maestro'
Incremental backup of volume '/tsm'
Incremental backup of volume '/tsmpool'
Incremental backup of volume '/tsmdb'
Incremental backup of volume '/tsmdb1'
Incremental backup of volume '/tsmdata'
ANS1898I ***** Processed 1,000 files *****
Directory--> 1,536 / [Sent]
Normal File--> 712 /bosinst.data [Sent]
Normal File--> 20,552 /dsmerror.log [Sent]
Normal File--> 6,380 /image.data [Sent]
Special File--> 0 /dev/fd0 [Sent]
Special File--> 0 /dev/mt0 [Sent]
Special File--> 0 /dev/mt1 [Sent]
Retry # 1 Normal File--> 1,390 /maestro/stdlist/2001.03.11/NETMAN [
Sent]
Retry # 1 Normal File--> 1,281 /maestro/stdlist/2001.03.11/O40184.0
425 [Sent]
Retry # 1 Normal File--> 42,722 /maestro/stdlist/2001.03.11/O45034.0
115 [Sent]
Retry # 1 Normal File--> 32,735 /maestro/stdlist/2001.03.12/O46854.0
115 [Sent]
Successful incremental backup of '/maestro'
Successful incremental backup of '/tsm'
Successful incremental backup of '/tsmpool'
Successful incremental backup of '/tsmdb'
Successful incremental backup of '/tsmdb1'
O46854.0115 (82%)
Successful incremental backup of '/tsmdata'
Total number of objects inspected: 64,270
Total number of objects backed up: 297
Total number of objects updated: 0
Total number of objects rebound: 0
Total number of objects deleted: 0
Total number of objects expired: 20
Total number of objects failed: 0
Total number of bytes transferred: 26.07 GB
Data transfer time: 5,628.10 sec
Network data transfer rate: 4,858.98 KB/sec
Aggregate data transfer rate: 3,370.30 KB/sec
Objects compressed by: 0%
Elapsed processing time: 02:15:14
SQL*Plus: Release 8.1.5.0.0 - Production on Mon Mar 12 03:32:53 2001
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Total System Global Area 193621124 bytes
Fixed Size 64644 bytes
Variable Size 126275584 bytes
Database Buffers 67108864 bytes
Redo Buffers 172032 bytes
Database mounted.
Database opened.
SQL> Disconnected from Oracle8i Enterprise Edition Release 8.1.5.0.0 - Productio
n46854.0115 (91%)
With the Partitioning and Java options
PL/SQL Release 8.1.5.0.0 - Production
Database "TDMSX" warm started.
SQL*Plus: Release 8.1.5.0.0 - Production on Mon Mar 12 03:33:39 2001
(c) Copyright 1999 Oracle Corporation. All rights reserved.
SQL> Connected to an idle instance.
SQL> ORACLE instance started.
Total System Global Area 193621124 bytes
Fixed Size 64644 bytes
Variable Size 126275584 bytes
Database Buffers 67108864 bytes
Redo Buffers 172032 bytes
Database mounted.
Database opened.
SQL> Disconnected from Oracle8i Enterprise Edition Release 8.1.5.0.0 - Productio
n
With the Partitioning and Java options
PL/SQL Release 8.1.5.0.0 - Production
Database "TDMS2D" warm started.
LSNRCTL for IBM/AIX RISC System/6000: Version 8.1.5.0.0 - Production on 12-MAR-0
1 03:33:46
(c) Copyright 1998 Oracle Corporation. All rights reserved.
Starting /ora01/app/oracle/product/8.1.5/bin/tnslsnr: please wait...
TNSLSNR for IBM/AIX RISC System/6000: Version 8.1.5.0.0 - Production
System parameter file is /ora01/app/oracle/product/8.1.5/network/admin/listener.
ora
Log messages written to /ora01/app/oracle/product/8.1.5/network/log/listener.log
Listening on: (DESCRIPTION=(PROTOCOL_STACK=(PRESENTATION=TTC)(SESSION=NS))(ADDRE
SS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
Listening on: (DESCRIPTION=(PROTOCOL_STACK=(PRESENTATION=TTC)(SESSION=NS))(ADDRE
SS=(PROTOCOL=TCP)(HOST=medrs2)(PORT=1521)))
Connecting to (DESCRIPTION=(PROTOCOL_STACK=(PRESENTATION=TTC)(SESSION=NS))(ADDRE
SS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Alias LISTENER
Version TNSLSNR for IBM/AIX RISC System/6000: Version 8.1.5.0.
0 - Production
Start Date 12-MAR-01 03:33:47
Uptime 0 days 0 hr. 0 min. 2 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File /ora01/app/oracle/product/8.1.5/network/admin/listener
.ora
Listener Log File /ora01/app/oracle/product/8.1.5/network/log/listener.l
og
Services Summary...
ACWQ has 1 service handler(s)
ACWT has 1 service handler(s)
CCDWD has 1 service handler(s)
OEM has 1 service handler(s)
PLSExtProc has 1 service handler(s)
TDMS2D has 1 service handler(s)
TDMS2T has 1 service handler(s)
TDMSD has 1 service handler(s)
TDMST has 1 service handler(s)
TDMSTBU has 1 service handler(s)
TDMSX has 1 service handler(s)
test has 1 service handler(s)
The command completed successfully
Oracle Names Control for IBM/AIX RISC System/6000: Version 8.1.5.0.0 - Productio
n on 12-MAR-01 03:33:50
(c) Copyright 1997 Oracle Corporation. All rights reserved.
Currently managing name server "NS1.medf.bayer.com"
Version banner is "Oracle Names for IBM/AIX RISC System/6000: Version 8.1.5.0.0
Production"
Starting "/ora01/app/oracle/product/8.1.5/bin/names"...server not started, error
s follow
NNC-00002: error listening on stream (ADDRESS=(PROTOCOL=TCP)(HOST=medrs2.medf.ba
yer.com)(PORT=1575))
TNS-12542: TNS:address already in use
TNS-12560: TNS:protocol adapter error
TNS-00512: Address already in use
IBM/AIX RISC System/6000 Error: 6
===============================================================
= Exit Status : 0
= System Time (Seconds) : 862 Elapsed Time (Minutes) : 138
= User Time (Seconds) : 120
= Mon Mar 12 03:33:51 EST 2001
===============================================================
medrs2: rpcinfo -p | grep 1575
|