Recovery ManagerおよびMedia Managerトラブルシューティング・ガイド

Size: px

Start display at page:

Download "Recovery ManagerおよびMedia Managerトラブルシューティング・ガイド"

きよあつながおか
5 years ago
Views:

1 Recovery Manager Media Manager

2 Recovery Manager Media Manager... 3 RMAN RMAN OS SBT SBT RMAN OS RMAN USER_DUMP_DEST USER_DUMP_DEST Sbtio.log SBT SBTINIT SBTINIT SBTOPEN SBTBACKUP SBTOPEN SBTRESTORE SBTWRITE SBTREAD Recovery Manager Media Manager 2

3 Recovery Manager Media Manager Recovery Manager RMAN Oracle RMAN System Backup to Tape SBT API API RMAN Oracle Backup Solutions Program RMAN RMAN RMAN Recovery Manager Media Manager 3

4 RMAN / RMAN Oracle Server Oracle Server SBT API RMAN API / / SBT API Device Agent Robot Agent Disk Agent RMAN Unix libobk.so Windows ORASBT.DLL Media Management Database Media ID Session Manager Recovery Manager Media Manager 4

5 RMAN RMAN SBT API Oracle Oracle RMAN Oracle Oracle OS Oracle Oracle9i 10g RMAN Oracle SBT RMAN RMAN SBT v2.0 SBT 1. RMAN Oracle 2. Oracle sbtinit() RMAN RMAN RMAN RMAN-08030: allocated channel: ORA_SBT_TAPE_1 RMAN-08500: channel ORA_SBT_TAPE_1: sid=8 devtype=sbt_tape RMAN-08526: channel ORA_SBT_TAPE_1: VERITAS NetBackup for Oracle8 - Release 3.4GA Sbtinit() SBT API RMAN RMAN RMAN-08503: piece handle=3mckj4i8_1_2 comment=api Version 2.0,MMS Version sbtinit() Oracle sbtinit2() Sbtinit2() sbtinit() RMAN ALLOCATE CHANNEL PARMS ENV Recovery Manager Media Manager 5

6 4. Oracle sbtbackup() 5. Oracle sbtwrite2()api 6. Oracle sbtclose2() sbtwrite2() sbtclose2() 7. Oracle sbtinfo2() sbtinfo2() ID 8. sbtinfo2() RMAN RMAN-08045: channel ORA_SBT_TAPE_1: finished piece 1 at MAR :48:12 RMAN-08503: piece handle=41ckj865_1_1 comment=api Version 2.0,MMS Version Oracle sbtend() sbtend() RMAN SBT v2.0 SBT 1. RMAN Oracle Server Recovery Manager Media Manager 6

7 2. Oracle Server sbtinit() 2 3. Oracle sbtrestore() Sbtrestore() 4. Oracle sbtread2() sbtread2() 5. Oracle sbtclose() Sbtclose() sbtend() sbtend() RMAN 1. RMAN Error Message Stack RMAN Oracle8/8i RMAN RMAN-08526: channel t1: VERITAS NetBackup for Oracle8 Release 3.4GA (030800) RMAN-08526: channel dev1: BMO v3.0 RMAN-08526: channel t1: Tivoli Data Protection for Oracle: version Oracle9i channel dev_0: HP Open View OmniBack II A.04.10/PHSS_28582/PHSS_ : RMAN Error Message Stack Recovery Manager Media Manager 7

8 Oracle Oracle8 ORA-19506: failed to create sequential file, name="x", parms="" ORA-27006: sbtremove returned error Additional information: 7086 Oracle8i ORA-19506: failed to create sequential file, name="x", parms="" ORA-27006: sbtremove returned error Additional information: 4110 Oracle9i ORA-19557: device error, device type: SBT_TAPE, device name: ORA-27211: Failed to load Media Management Library Additional information: 2 SBT sbtinit() sbtinit2() sbtopen() sbtbackup() RMAN ORA-19506: failed to create sequential file, ORA-27007: failed to open file Additional information: 7009 Additional information: 1 ORA-19511: SBT error = 7009, errno = 0, sbtopen: can't connect with media manager RMAN ORA occurred during call to DBMS_BACKUP_RESTORE.BACKUPPIECECREATE RMAN-08526: channel t1: WARNING: Oracle Test Disk API ORA-19511: SBT error= 4110, errno = 0, BACKUP_DIR environment variable is not set API SBT API Recovery Manager Media Manager 8

9 Oracle Oracle8/8i : RMAN $ORACLE_HOME/lib libobk.<suffix> suffix Oracle Solaris libdsbtsh8.so Oracle 32 a. : $ORACLE_HOME/lib libobk.<suffix> % mv libobk.<suffix> libobk.sav % ln -s <pathname to vendor s MML module> $ORACLE_HOME/lib/libobk.<suffix> b. Oracle8 Oracle : Solaris : cd $ORACLE_HOME/rdbms/lib make -f ins_rdbms.mk ioracle LLIBOBK=/usr/lib/libobk.so LIBMM= LLIBMM= HP : cd $ORACLE_HOME/rdbms/lib make -f ins_rdbms.mk ioracle "LLIBOBK=/usr/lib/libobk.sl -lc" LIBMM= LLIBMM= Digital Unix : cd $ORACLE_HOME/rdbms/lib make -f ins_rdbms.mk ioracle LLIBOBK="/usr/lib/libobk.so" LIBMM= LLIBMM= AIX : cd $ORACLE_HOME/rdbms/lib make -f ins_rdbms.mk ioracle LLIBOBK=/usr/lib/libobk.a LIBMM= LLIBMM= Recovery Manager Media Manager 9

10 Oracle9i : libobk.x SBT_TAPE libobk.x x $ORACLE_HOME/lib $ORACLE_HOME/lib LIBPATH LD_LIBRARY_PATH PARMS SBT_LIBRARY ALLOCATE CHANNEL PARMS allocate channel t1 type 'sbt_tape' PARMS 'ENV=(TDPO_OPTFILE=/tmp/tdopt.opt)'; ALLOCATE CHANNEL PARMS Tivoli Storage Manager TDP and RMAN Problem Resolution Tips IBM.com IBM Tivoli Note : Integration of RMAN and ADSM Connect Agent for Oracle Oracle MetaLink Legato Networker Note : Quick Start for Legato Storage Manager Configuration and Troubleshooting Oracle MetaLink HP Omniback Note : RMAN: Configuring HP Omniback with RMAN Oracle MetaLink VERITAS NetBackup Note : How to Install, Configure, Check and Troubleshoot VERITAS NetBackup 4.5 for Oracle Oracle MetaLink NetBackup linking instructions 2. OS Oracle Recovery Manager Media Manager 10

11 3. SBT RMAN run { allocate channel d1 type disk format '/dev/null'; backup datafile <datafile #, etc>; } SBT API PARMS BACKUP_DIR Oracle8/8i : a. $ORACLE_HOME Oracle b. % cd $ORACLE_HOME/lib % mv libobk.<suffix> libobk.<suffix>.save % ln -s libdsbtsh8.<suffix> libobk.<suffix> Oracle8 Oracle c. run { allocate channel t1 type sbt format '%U'; parms='env=(backup_dir=/<backup_directory>)'; backup datafile <datafile #, etc>; } Oracle9i : SBT run { allocate channel t1 type sbt format '%U'; parms='sbt_library=oracle.disksbt, ENV=(BACKUP_DIR=/<backup_directory)'; backup datafile <datafile #, etc>; } RMAN API Recovery Manager Media Manager 11

12 4. SBT Oracle Oracle Oracle Oracle MML SBT BACKUP_TAPE_IO_SLAVES TRUE 2 5. RMAN ORA ORA-19506: sbtinit sbtinit2 sbtopen sbtread sbtwrite sbtclose sbtinfo sbtend SBT SBT RMAN-00571: ======================================= RMAN-00569: ======= ERROR MESSAGE STACK FOLLOWS======= RMAN-00571: ======================================= RMAN-03015: error occurred in stored script bkfist(1) RMAN-03006: non-retryable error occurred during execution of command: backup (2) RMAN-07004: unhandled exception during command execution on channel ch1 (3) RMAN-10035: exception raised in RPC: ORA-27015: skgfcls: failed to close the file ORA-19511: SBT error = 7023, errno = 29, sbtclose: system error (4) RMAN-10031: ORA occurred during call to DBMS_BACKUP_RESTORE.BACKUPPIECECREATE(5) 1. RMAN bkfist Recovery Manager Media Manager 12

13 2. RMAN : backup 3. : ch1 4. : ORA SBT : 7023 OS OS : 29 : sbtclose 5. RMAN RPC: DBMS_BACKUP_RESTORE.BACKUPPIECECREATE : sbtclose OS 29 SBT API 2.0 sbtbackup() ORA-19506: failed to create sequential file, name="4fckrhkv_1_1", parms="" ORA-27028: skgfqcre: sbtbackup returned error ORA-19511: Error received from media manager layer, error text: sbtbackup: Failed to open for backup. # SBT API 2.0 textual error message SBT API ORA SBT API SBT ORA OS RMAN sbtio.log 8 SBT Note : Main Index of Common Causes for ORA Oracle MetaLink 6. OS Note : Unix Error Codes Oracle MetaLink /usr/include/sys/errno.h Recovery Manager Media Manager 13

14 7. RMAN USER_DUMP_DEST Oracle SBT Oracle SBT API ALLOCATE CHANNEL TRACE=1 RUN { ALLOCATE CHANNEL tst TYPE DISK TRACE=1 FORMAT '/dev/null'; BACKUP DATAFILE <datafile #, etc>; } *** SESSION ID:(9.17) :50: skgfalo(se=0x815ff8c8, ctx=0x262bf98, dev=0x264861c, devparms=, flags= ) skgfidev(se=0x815ff8c8 ctx=0x262bf98, dev=0x264861c) entering sbtinit on line 2203 return from sbtinit on line 2213 skgfqsbi(ctx=0x262bf98, vtapi=api Version 1.1, id=mms Version ) skgfqcre(se=0x815ff8c8, ctx=0x262bf98, dev=0x264861c, file=0x2647f08, fparms=, flags=0x0) entering sbtopen on line 683 return from sbtopen on line 704 skgfwrt(ctx=0x262bf98, file=0x2647f08, iosb=0x2647cf4, buf=0x815b0000, numblks=1) skgfwrt(data= A1B ) entering sbtwrite on line Oracle Server PARMS= ENV=(NB_ORA_CLASS=class1) skgfidev(): processing: ENV=(NB_ORA_CLASS=fdfa) skgfidev(): setting environment variable: NB_ORA_CLASS=fdfa Recovery Manager Media Manager 14

15 skgfwrt(ctx=0x262bf98, file=0x2647f08, iosb=0x2647cf4, buf=0x815b0000, numblks=1) skgfwrt(data= A1B ) entering sbtwrite on line 903 sbtwrite() 1 TRACE=5 Recovery Manager Media Manager 15

16 2 KRB_TRACE_THREAD krbbpc 3 KRB_TRACE_IO I/O 4 KRB_TRACE_INCR 5 KRB_TRACE_PERF 6 KRB_TRACE_KRBBPC_OUTPUT : 0 SBT -1 SBT_ERROR_EOF SBT_ERROR_NOTFOUND 2 SBT / USER_DUMP_DEST Sbtio.log Legato Storage Manager sbtio.log (24677) LSM : 03/19/02 10:26:27 Sbtopen: unable to start save session with server dlsun1556: There is no pool named 'fdfa'. NetBackup Legato Networker /nsr/log /nsr Daemon.log Note: Omniback /var/opt/omni/log oracle8.log debug.log media.log Note: NetBackup <install_path>/netb ackup/logs bphdp dbclient bpdbsbora Note: Tivoli Logdirectory (in dsm.opt or tdpo.opt) Note: parameter: tracefile Recovery Manager Media Manager 16

17 8. SBT SBTINIT SBTINIT2 sbtinit() sbtinit2() sbtinit() sbtinit2() NetBackup Legato OmniBack II sbtinit() sbtinit2() sbtinit() sbtinit2() SBTOPEN SBTBACKUP 2 RMAN sbtopen() sbtbackup() PARMS Legato Networker Oracle NetBackup NB_ORA_CLASS "Class" Oracle Legato Networker NSR_DATA_VOLUME_POOL Oracle UNIX NT OmniBack II Oracle OmniBack II UserList SBTOPEN SBTRESTORE sbtopen() sbtrestore() sbtopen() sbtrestore() Recovery Manager Media Manager 17

18 2 Oracle Real Application Cluster 2 2 SBTWRITE SBTREAD sbtwrite() sbtread() Oracle sbtwrite() sbtread() sbtwrite() sbtwrite2() sbtread() I/O Recovery Manager Media Manager 18

19 Recovery Manager Media Manager : Timothy Chien Senad Dizdar : Matt Arrocha Oracle Corporation World Headquarters 500 Oracle Parkway Redwood Shores, CA U.S.A. : : : Copyright 2005, Oracle. All rights reserved. Oracle Oracle Corporation

BIG_RM_BAS_OPEN

BIG_RM_BAS_OPEN Oracle8 & 1998 1 21 1 1 1998 1 21 2 2 1998 1 21 3 3 1998 1 21 4 4 1998 1 21 5 5 1998 1 21 6 6 7 1998 1 21 7 Oracle Oracle Enterprise Enterprise Manager Manager Recovery Recovery Manager Manager GUI Oracle8