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
|