ADSM-L

TDP for ORACLE on SUN SOLARIS

2000-05-31 17:46:09
Subject: TDP for ORACLE on SUN SOLARIS
From: Gerardo Zapata <gzapata AT AVANTEL DOT NET>
Date: Wed, 31 May 2000 14:46:09 -0700
I'm trying to use the TDP For ORACLE on SUN SOLARIS and I have encountered the 
following problems.
I ran a an oracle backup to disk and it completed OK.
Then I tried to send it to the tape device and I found problems.
The environmental variables set appear at the bottom of the document.
I consulted the ORACLE datasbase to look for a similar problem and I found the 
report at the end of this note. We repeated the linking process with the  'make 
-f ins_rdbms.mk ioracle LLIBMM=/usr/lib/libobk.so' but still no success.

Thanks in advance
Regards




********* rman_ok_log *********

Recovery Manager: Release 8.0.4.0.0 - Production

RMAN-06008: connected to recovery catalog database

RMAN> connect target
2> run {
3> # allocate channel adsm type 'sbt_tape';
4>   allocate channel canal1 type disk;
5>  backup
6>    full
7>    tag whole_opera_backup
8>    filesperset 2
9>    format '/dbases/oracledb1/CAT8/scripts/dat/whole_%d_%s'
10>    (database);
11> }
12>
13>
RMAN-06005: connected to target database: OPERA

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: canal1
RMAN-08500: channel canal1: sid=11 devtype=DISK

RMAN-03022: compiling command: backup
RMAN-03023: executing command: backup
RMAN-08008: channel canal1: starting datafile backupset
RMAN-08502: set_count=23 set_stamp=399040839
RMAN-08010: channel canal1: including datafile 1 in backupset
RMAN-08011: channel canal1: including current controlfile in backupset
RMAN-08013: channel canal1: piece 1 created
RMAN-08503: piece handle=/dbases/oracledb1/CAT8/scripts/dat/whole_OPERA_23 
comment=NONE
RMAN-08008: channel canal1: starting datafile backupset
RMAN-08502: set_count=24 set_stamp=399040850
RMAN-08010: channel canal1: including datafile 3 in backupset
RMAN-08010: channel canal1: including datafile 2 in backupset
RMAN-08013: channel canal1: piece 1 created
RMAN-08503: piece handle=/dbases/oracledb1/CAT8/scripts/dat/whole_OPERA_24 
comment=NONE
RMAN-08008: channel canal1: starting datafile backupset
RMAN-08502: set_count=25 set_stamp=399040866
RMAN-08010: channel canal1: including datafile 4 in backupset
RMAN-08013: channel canal1: piece 1 created
RMAN-08503: piece handle=/dbases/oracledb1/CAT8/scripts/dat/whole_OPERA_25 
comment=NONE
RMAN-03023: executing command: partial resync
RMAN-08003: starting partial resync of recovery catalog
RMAN-08005: partial resync complete
RMAN-08031: released channel: canal1

Recovery Manager complete.

********* rman_failed_log *********

Recovery Manager: Release 8.0.4.0.0 - Production

RMAN-06008: connected to recovery catalog database

RMAN> connect target
2> run {
3>   allocate channel adsm type 'sbt_tape';
4> # allocate channel canal1 type disk;
5>  backup
6>    full
7>    tag whole_opera_backup
8>    filesperset 2
9>    format 'whole_%d_%s'
10>    (database);
11> }
12>
13>
RMAN-06005: connected to target database: OPERA

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: adsm
RMAN-08500: channel adsm: sid=11 devtype=SBT_TAPE

RMAN-03022: compiling command: backup
RMAN-03023: executing command: backup
RMAN-08008: channel adsm: starting datafile backupset
RMAN-08502: set_count=22 set_stamp=399040781
RMAN-08010: channel adsm: including datafile 1 in backupset
RMAN-08011: channel adsm: including current controlfile in backupset
RMAN-00569: ================error message stack follows================
RMAN-03007: retryable error occurred during execution of command: backup
RMAN-07004: unhandled exception during command execution on channel adsm
RMAN-10032: unhandled exception during execution of job step 1: ORA-06512: at 
line 122
RMAN-10035: exception raised in RPC: ORA-19624: operation failed, retry possible
ORA-19506: failed to create sequential file, name="whole_OPERA_22", parms=""
ORA-27006: sbtremove returned error
SVR4 Error: 17347964: Unknown system error
Additional information: 4110
Additional information: 1
ORA-06512: at "SYS.DBMS_BACKUP_RESTORE", line 408
RMAN-10031: ORA-19624 occurred during call to 
DBMS_BACKUP_RESTORE.BACKUPPIECECREATE

Recovery Manager complete.


********* env variables *******

DSMO_NODE=oracle
DSMO_AVG_SIZE=50
DSMI_CONFIG=/opt/tivoli/tsm/client/ba/bin/oracle.opt
DSMI_LOG=/opt/tivoli/tsm/client/ba/bin
DSMO_PSWDPATH=/opt/tivoli/tsm/client/oracle/bin
DSMI_DIR=/opt/tivoli/tsm/client/ba/bin


********* files list & links *********

$ ls -l oracle
-rwsr-s--x   1 oracle   dba      21128872 May 31 12:22 oracle
$ pwd
$ pwd
/dbases/oracle/oracle/app/oracle/product/8.0.4/bin
$ echo $ORACLE_HOME
/dbases/oracle/oracle/app/oracle/product/8.0.4

$ pvs oracle
        libnsl.so.1 (SUNWprivate_1.1, SISCD_2.3);
        libsocket.so.1 (SISCD_2.3);
        libdl.so.1 (SUNW_0.7, SISCD_2.3);
        libc.so.1 (SUNW_1.1);
        libaio.so.1 (SUNW_1.0);

********* oracle_reported_problem *********

  Bookmark Fixed font  Go to End

Doc ID:  Note:1035643.6
Subject:  RMAN-10035, ORA-19506, ORA-27006 RUNNING RMAN TO BACKUP ARCHIVE LOGS
Type:  PROBLEM
Status:  PUBLISHED
 Content Type:  TEXT/PLAIN
Creation Date:  10-SEP-1997
Last Revision Date:  28-FEB-2000
Language:  USAENG



Problem Description:
====================

You are attempting to use Recovery Manager (RMAN) to back up your archive log
files to tape and you get the following errors:

RMAN-03026: error recovery releasing channel resources
RMAN-08031: released channel: t1
RMAN-00569: =============error message stack follows================
RMAN-03015: error occurred in stored script backup_al_all
RMAN-03007: retryable error occurred during execution of command: backup
RMAN-07004: unhandled exception during command execution on channel t1
RMAN-10032: unhandled exception during execution of job step 1:
ORA-06512: at line 305
RMAN-10035: exception raised in RPC: ORA-19624: operation failed, retry
possible
ORA-19506: failed to create sequential file, name="al_t310146906_s1_p1",
parms=""
ORA-27006: sbtremove returned error
SVR4 Error: 16914400: Unknown system error
Additional information: 4110
Additional information: 1
ORA-06512: at "SYS.DBMS_BACKUP_RESTORE", line 399
RMAN-10031: ORA-19624 occurred during call to
DBMS_BACKUP_RESTORE.BACKUPPIECECREATE


Problem Explanation:
====================

The problem is that RMAN was not linked with the appropriate media manager
library for tape backups.


Search Words:
=============

Bug 520403, LIBMM, LLIBMM

Solution: LINK RMAN WITH APPROPRIATE MEDIA MANAGER LIBRARY FOR OS


Solution Description:
=====================

To verify that RMAN was not linked with the appropriate media manager, you can
try to back up to disk.


Solution Explanation:
=====================

If this succeeds, then you will need to link RMAN with the appropriate media
manager library for your Operating System.

References:
===========

BUG# 520403 describes how to link the oracle executable with the media manager:

The examples for linking oracle with a media manager in the 8.0.3
production readme (section 16.1) are incorrect.  The make lines include the
text LIBMM - this should be LLIBMM

e.g.

  make -f ins_rdbms.mk ioracle LIBMM=/usr/lib/libobk.so

  should be:

  make -f ins_rdbms.mk ioracle LLIBMM=/usr/lib/libobk.so
.


--------------------------------------------------------------------------------
 Copyright (c) 1995,1999 Oracle Corporation. All Rights Reserved. Legal Notices 
and Terms of Use.
 Copyright (c) 1995,1999 Oracle Corporation. All Rights Reserved. Legal Notices 
and Terms of Use.


********* relinking output *********

make

 - Linking Oracle
ld -dy /dbases/oracle/oracle/app/oracle/product/8.0.4/lib/SC4.2/crti.o 
/dbases/oracle/oracle/app/oracle/product/8.0.4/lib/SC4.2/crt1.o 
/dbases/oracle/oracle/app/oracle/product/8.0.4/lib/SC4.2/crtn.o 
-L/opt/SUNWcluster/lib -R/opt/SUNWcluster/lib 
-L/dbases/oracle/oracle/app/oracle/product/8.0.4/lib/ 
-L/dbases/oracle/oracle/app/oracle/product/8.0.4/rdbms/lib -o 
/dbases/oracle/oracle/app/oracle/product/8.0.4/rdbms/lib/oracle 
/dbases/oracle/oracle/app/oracle/product/8.0.4/rdbms/lib/opimai.o 
/dbases/oracle/oracle/app/oracle/product/8.0.4/rdbms/lib/ssoraed.o 
/dbases/oracle/oracle/app/oracle/product/8.0.4/rdbms/lib/ttcsoi.o 
/dbases/oracle/oracle/app/oracle/product/8.0.4/rdbms/lib/config.o -lserver 
-lclient -lvsn -lcommon -lgeneric -lobk 
/dbases/oracle/oracle/app/oracle/product/8.0.4/rdbms/lib/defopt.o 
/dbases/oracle/oracle/app/oracle/product/8.0.4/lib/ncrstab.o -lknlopt -lslax 
-lplsf -lplsb -lextp -lserver -lclient -lvsn -lcommon -lgeneric -lknlopt -lslax 
-lplsf -lplsb -lextp -licx -
 lndw1 /dbases/oracle/oracle/app/or
acle/product/8.0.4/lib/nautab.o 
/dbases/oracle/oracle/app/oracle/product/8.0.4/lib/naeet.o 
/dbases/oracle/oracle/app/oracle/product/8.0.4/lib/naect.o 
/dbases/oracle/oracle/app/oracle/product/8.0.4/lib/naedhs.o -lnetv2 -lnttcp 
-lnetwork -lncr -lnetv2 -lnttcp -lnetwork -lclient -lvsn -lcommon -lgeneric 
/usr/lib/libobk.so -lnlsrtl3 -lcore4 -lnlsrtl3 -lcore4 -lnlsrtl3 -lnetv2 
-lnttcp -lnetwork -lncr -lnetv2 -lnttcp -lnetwork -lclient -lvsn -lcommon 
-lgeneric -lepc -lnlsrtl3 -lcore4 -lnlsrtl3 -lcore4 -lnlsrtl3 -lclient -lvsn 
-lcommon -lgeneric -lnlsrtl3 -lcore4 -lnlsrtl3 -lcore4 -lnlsrtl3 -lnsl -lsocket 
-lgen -ldl -R 
/opt/SUNWcluster/lib:/dbases/oracle/oracle/app/oracle/product/8.0.4/lib -Y 
P,/dbases/oracle/oracle/app/oracle/product/8.0.4/lib:/usr/dt/lib:/usr/lib:/dbases/oracle/oracle/app/oracle/product/8.0.4/lib:/usr/dt/lib:/usr/lib::/opt/SUNWcluster/lib:/usr/ccs/lib:/usr/lib
 -Qy -lc -laio -lm 
/dbases/oracle/oracle/app/oracle/product/8.0.4/rdbms/lib/skgxns.o -lkidt 
-lnlsrtl3 -lco
 re4 -lnlsrtl3 -lcore4 -lnlsrtl3 -l
nsl -lsocket -lgen -ldl -R 
/opt/SUNWcluster/lib:/dbases/oracle/oracle/app/oracle/product/8.0.4/lib -Y 
P,/dbases/oracle/oracle/app/oracle/product/8.0.4/lib:/usr/dt/lib:/usr/lib:/dbases/oracle/oracle/app/oracle/product/8.0.4/lib:/usr/dt/lib:/usr/lib::/opt/SUNWcluster/lib:/usr/ccs/lib:/usr/lib
 -Qy -lc -laio -lm
mv -f /dbases/oracle/oracle/app/oracle/product/8.0.4/bin/oracle 
/dbases/oracle/oracle/app/oracle/product/8.0.4/bin/oracleO
mv oracle /dbases/oracle/oracle/app/oracle/product/8.0.4/bin/oracle
chmod 6751 /dbases/oracle/oracle/app/oracle/product/8.0.4/bin/oracle

ld: warning: option -YP appears more than once, first setting taken
ld: warning: option -Q appears more than once, first setting taken
<Prev in Thread] Current Thread [Next in Thread>
  • TDP for ORACLE on SUN SOLARIS, Gerardo Zapata <=