Advertisement

08.23.2007 at 03:19AM PDT, ID: 22781800 | Points: 500
[x]
Attachment Details

RMAN giving ORA-00447: fatal error in background process

Zones: Oracle 9.x, Tivoli Storage Manager
Tags: Oracle , Oracle database & RMAN, 9.2.0.8, backup with Tivoli Storage Manager for Oracle v5.3.3
Six months ago TSM was setup and installed and RMAN setup to backup database by consultant. Recently been attempting to learn more about how it all works and to ensure that the backups were actually working. As of last week everything seemed fine and logs showed good backups.

This week I am now getting an error with the backup the only change I can think of is that on reading a book on RMAN it suggested that I should have the Oracle parameter BACKUP_TAPE_IO_SLAVE=TRUE set, and LARGE_POOL configured to approx 32MB, I have a single channel and single tape drive. I have no opportunity to run a test server and have yet to get another quiet time on database to restart with this parameter back at false although from what I read it should be set as true for performance.

---------------------------------------------------------------------------------------------------------
The error that RMAN gives is :
RMAN-03009: failure of backup command on c1 channel at 08/23/2007 01:25:31
ORA-00447: fatal error in background process

---------------------------------------------------------------------------------------------------------
The RMAN script was (NB on setting the oracle parameter BACKUP_TAPE_IO_SLAVES script insisted on the %c being added to format command) :
sql 'alter system archive log current';
run {
allocate channel c1 type sbt;
backup
      filesperset 16
      format '%d/LOGS/%t/%s/%p/%c'
      archivelog all
      tag 'archivelogs';
release channel c1;
}

---------------------------------------------------------------------------------------------------------
The alert log seems normal showing :
Thu Aug 23 10:43:34 2007
Thread 1 advanced to log sequence 4758
  Current log# 3 seq# 4758 mem# 0: F:\ORACLE\ORADATA\AHB\REDO03.LOG
Thu Aug 23 10:43:34 2007
ARCH: Evaluating archive   log 1 thread 1 sequence 4757
ARCH: Beginning to archive log 1 thread 1 sequence 4757
Creating archive destination LOG_ARCHIVE_DEST_1: 'H:\ORACLE\ORADATA\AHB\ARCHIVE\AHB04757.ARC'
Thu Aug 23 10:43:34 2007
ARC0: Evaluating archive   log 1 thread 1 sequence 4757
ARC0: Unable to archive log 1 thread 1 sequence 4757
      Log actively being archived by another process
Thu Aug 23 10:43:34 2007
ARCH: Completed archiving  log 1 thread 1 sequence 4757

---------------------------------------------------------------------------------------------------------
A couple of lines are added to a PMON trace file :
*** 2007-08-23 10:44:10.159
KSFVSDEL: PMON cleaning up IO slave: 4477f30c

---------------------------------------------------------------------------------------------------------
The header of the PMON Trace file is :
ORACLE V9.2.0.8.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Instance name: ahb

Redo thread mounted by this instance: 1

Oracle process number: 2

Windows thread id: 4140, image: ORACLE.EXE

---------------------------------------------------------------------------------------------------------
There is also a core dump created :
Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production
Process Id: 0x000005c4  Thread Id : 0x00001370    Time : Thu Aug 23 10:44:10
Excp. Code: 0xc0000005  Excp. Type: ACCESS_VIO    Flags: 0x00000000

------------------- Memory Map of process ----------------
Start Addr-End Addr   Type     Size        ModuleName
0x00400000-0x02806fff Image    0037777408  E:\ORACLE\ORA92\BIN\ORACLE.EXE
0x77f80000-0x77ffcfff Image    0000512000  C:\WINNT\SYSTEM32\NTDLL.DLL
0x60600000-0x6078ffff Image    0001638400  E:\ORACLE\ORA92\BIN\ORACLIENT9.DLL
0x610a0000-0x6113ffff Image    0000655360  E:\ORACLE\ORA92\BIN\ORACORE9.DLL
0x612a0000-0x61319fff Image    0000499712  E:\ORACLE\ORA92\BIN\ORANLS9.DLL
0x613a0000-0x613b0fff Image    0000069632  E:\ORACLE\ORA92\BIN\ORAUNLS9.DLL
0x78000000-0x78044fff Image    0000282624  C:\WINNT\SYSTEM32\MSVCRT.DLL
0x7c570000-0x7c623fff Image    0000737280  C:\WINNT\SYSTEM32\KERNEL32.DLL
0x75050000-0x75057fff Image    0000032768  C:\WINNT\SYSTEM32\WSOCK32.DLL
0x75030000-0x75043fff Image    0000081920  C:\WINNT\SYSTEM32\WS2_32.DLL
0x7c2d0000-0x7c331fff Image    0000401408  C:\WINNT\SYSTEM32\ADVAPI32.DLL
0x77d30000-0x77d9efff Image    0000454656  C:\WINNT\SYSTEM32\RPCRT4.DLL
0x75020000-0x75027fff Image    0000032768  C:\WINNT\SYSTEM32\WS2HELP.DLL
0x7ce20000-0x7cf0efff Image    0000978944  C:\WINNT\SYSTEM32\OLE32.DLL
0x77f40000-0x77f7bfff Image    0000245760  C:\WINNT\SYSTEM32\GDI32.DLL
0x77e10000-0x77e6efff Image    0000389120  C:\WINNT\SYSTEM32\USER32.DLL
0x77570000-0x7759ffff Image    0000196608  C:\WINNT\SYSTEM32\WINMM.DLL
0x60800000-0x60805fff Image    0000024576  E:\ORACLE\ORA92\BIN\ORAVSN9.DLL
0x60500000-0x60592fff Image    0000602112  E:\ORACLE\ORA92\BIN\ORACOMMON9.DLL
0x02810000-0x02aa2fff Image    0002699264  E:\ORACLE\ORA92\BIN\ORAGENERIC9.DLL
0x62fc0000-0x6303efff Image    0000520192  E:\ORACLE\ORA92\BIN\ORAXML9.DLL
0x780a0000-0x780b1fff Image    0000073728  C:\WINNT\SYSTEM32\MSVCIRT.DLL
0x630f0000-0x63119fff Image    0000172032  E:\ORACLE\ORA92\BIN\ORAXSD9.DLL
0x61480000-0x61535fff Image    0000745472  E:\ORACLE\ORA92\BIN\ORAN9.DLL
0x61400000-0x6142bfff Image    0000180224  E:\ORACLE\ORA92\BIN\ORANL9.DLL
0x61960000-0x61972fff Image    0000077824  E:\ORACLE\ORA92\BIN\ORANLDAP9.DLL
0x615a0000-0x6162ffff Image    0000589824  E:\ORACLE\ORA92\BIN\ORANNZSBB9.DLL
0x62000000-0x62025fff Image    0000155648  E:\ORACLE\ORA92\BIN\ORALDAPCLNT9.DLL
0x616b0000-0x616c5fff Image    0000090112  E:\ORACLE\ORA92\BIN\ORANCRYPT9.DLL
0x779b0000-0x77a4afff Image    0000634880  C:\WINNT\SYSTEM32\OLEAUT32.DLL
0x62300000-0x6233dfff Image    0000253952  E:\ORACLE\ORA92\BIN\ORATRACE9.DLL
0x61730000-0x61766fff Image    0000225280  E:\ORACLE\ORA92\BIN\ORANRO9.DLL
0x617c0000-0x617c5fff Image    0000024576  E:\ORACLE\ORA92\BIN\ORANHOST9.DLL
0x617d0000-0x617d5fff Image    0000024576  E:\ORACLE\ORA92\BIN\ORANONAME9.DLL
0x616a0000-0x616a5fff Image    0000024576  E:\ORACLE\ORA92\BIN\ORANCDS9.DLL
0x61820000-0x61826fff Image    0000028672  E:\ORACLE\ORA92\BIN\ORANTNS9.DLL
0x64000000-0x64006fff Image    0000028672  E:\ORACLE\ORA92\BIN\ORANMS.DLL
0x64020000-0x64030fff Image    0000069632  E:\ORACLE\ORA92\BIN\ORANMSP.DLL
0x60a00000-0x60d21fff Image    0003284992  E:\ORACLE\ORA92\BIN\ORAPLS9.DLL
0x62500000-0x62506fff Image    0000028672  E:\ORACLE\ORA92\BIN\ORASLAX9.DLL
0x61350000-0x61360fff Image    0000069632  E:\ORACLE\ORA92\BIN\ORASNLS9.DLL
0x60810000-0x60815fff Image    0000024576  E:\ORACLE\ORA92\BIN\ORAWTC9.DLL
0x62600000-0x62676fff Image    0000487424  E:\ORACLE\ORA92\BIN\ORASQL9.DLL
0x60820000-0x60825fff Image    0000024576  E:\ORACLE\ORA92\BIN\ORAODM9.DLL
0x60e00000-0x60eddfff Image    0000909312  E:\ORACLE\ORA92\BIN\ORAPLP9.DLL
0x10000000-0x102e2fff Image    0003026944  E:\ORACLE\ORA92\BIN\ORAJOX9.DLL
0x61af0000-0x61af9fff Image    0000040960  E:\ORACLE\ORA92\BIN\ORANSGR9.DLL
0x77920000-0x77942fff Image    0000143360  C:\WINNT\SYSTEM32\IMAGEHLP.DLL
0x60000000-0x60031fff Image    0000204800  E:\ORACLE\ORA92\BIN\ORAWWG9.DLL
0x7cdc0000-0x7ce0ffff Image    0000327680  C:\WINNT\SYSTEM32\NETAPI32.DLL
0x7c340000-0x7c34efff Image    0000061440  C:\WINNT\SYSTEM32\SECUR32.DLL
0x77bf0000-0x77c00fff Image    0000069632  C:\WINNT\SYSTEM32\NTDSAPI.DLL
0x77980000-0x779a3fff Image    0000147456  C:\WINNT\SYSTEM32\DNSAPI.DLL
0x77950000-0x77979fff Image    0000172032  C:\WINNT\SYSTEM32\WLDAP32.DLL
0x751c0000-0x751c5fff Image    0000024576  C:\WINNT\SYSTEM32\NETRAP.DLL
0x75150000-0x7515efff Image    0000061440  C:\WINNT\SYSTEM32\SAMLIB.DLL
0x62f00000-0x62f0efff Image    0000061440  E:\ORACLE\ORA92\BIN\OCIJDBC9.DLL
0x00230000-0x00235fff Image    0000024576  E:\ORACLE\ORA92\BIN\ORAIMR9.DLL
0x61850000-0x61857fff Image    0000032768  E:\ORACLE\ORA92\BIN\ORANBEQ9.DLL
0x61890000-0x6189cfff Image    0000053248  E:\ORACLE\ORA92\BIN\ORANNTS9.DLL
0x75500000-0x75503fff Image    0000016384  C:\WINNT\SYSTEM32\SECURITY.DLL
0x773b0000-0x773defff Image    0000192512  C:\WINNT\SYSTEM32\ACTIVEDS.DLL
0x77380000-0x773a2fff Image    0000143360  C:\WINNT\SYSTEM32\ADSLDPC.DLL
0x78280000-0x782b4fff Image    0000217088  C:\WINNT\SYSTEM32\KERBEROS.DLL
0x76670000-0x7667dfff Image    0000057344  C:\WINNT\SYSTEM32\CRYPTDLL.DLL
0x77430000-0x7743ffff Image    0000065536  C:\WINNT\SYSTEM32\MSASN1.DLL
0x782d0000-0x782f0fff Image    0000135168  C:\WINNT\SYSTEM32\MSV1_0.DLL
0x7c740000-0x7c7c6fff Image    0000552960  C:\WINNT\SYSTEM32\CRYPT32.DLL
0x77340000-0x77352fff Image    0000077824  C:\WINNT\SYSTEM32\IPHLPAPI.DLL
0x77520000-0x77524fff Image    0000020480  C:\WINNT\SYSTEM32\ICMP.DLL
0x77320000-0x77336fff Image    0000094208  C:\WINNT\SYSTEM32\MPRAPI.DLL
0x77830000-0x7783dfff Image    0000057344  C:\WINNT\SYSTEM32\RTUTILS.DLL
0x77880000-0x7790dfff Image    0000581632  C:\WINNT\SYSTEM32\SETUPAPI.DLL
0x7c0f0000-0x7c150fff Image    0000397312  C:\WINNT\SYSTEM32\USERENV.DLL
0x774e0000-0x77512fff Image    0000208896  C:\WINNT\SYSTEM32\RASAPI32.DLL
0x774c0000-0x774d0fff Image    0000069632  C:\WINNT\SYSTEM32\RASMAN.DLL
0x77530000-0x77551fff Image    0000139264  C:\WINNT\SYSTEM32\TAPI32.DLL
0x71710000-0x71793fff Image    0000540672  C:\WINNT\SYSTEM32\COMCTL32.DLL
0x70a70000-0x70ad5fff Image    0000417792  C:\WINNT\SYSTEM32\SHLWAPI.DLL
0x77360000-0x77378fff Image    0000102400  C:\WINNT\SYSTEM32\DHCPCSVC.DLL
0x61910000-0x6191bfff Image    0000049152  E:\ORACLE\ORA92\BIN\ORANTCP9.DLL
0x782c0000-0x782cbfff Image    0000049152  C:\WINNT\SYSTEM32\RNR20.DLL
0x777e0000-0x777e7fff Image    0000032768  C:\WINNT\SYSTEM32\WINRNR.DLL
0x66210000-0x66218fff Image    0000036864  C:\WINNT\SYSTEM32\NETWARE\NWWS2NDS.DLL
0x00380000-0x003c7fff Image    0000294912  C:\WINNT\SYSTEM32\NETWIN32.DLL
0x003d0000-0x003e4fff Image    0000086016  C:\WINNT\SYSTEM32\CLNWIN32.DLL
0x035f0000-0x0360ffff Image    0000131072  C:\WINNT\SYSTEM32\LOCWIN32.DLL
0x03610000-0x0363bfff Image    0000180224  C:\WINNT\SYSTEM32\NCPWIN32.DLL
0x66220000-0x6622bfff Image    0000049152  C:\WINNT\SYSTEM32\NETWARE\NWWS2SLP.DLL
0x66250000-0x66256fff Image    0000028672  C:\WINNT\SYSTEM32\NWSRVLOC.DLL
0x777f0000-0x777f4fff Image    0000020480  C:\WINNT\SYSTEM32\RASADHLP.DLL
0x74fd0000-0x74fedfff Image    0000122880  C:\WINNT\SYSTEM32\MSAFD.DLL
0x75010000-0x75016fff Image    0000028672  C:\WINNT\SYSTEM32\WSHTCPIP.DLL
0x03680000-0x036bbfff Image    0000245760  C:\WINNT\SYSTEM32\ORASBT.DLL
0x036c0000-0x03715fff Image    0000352256  C:\WINNT\SYSTEM32\MSVCR71.DLL
0x03730000-0x0389cfff Image    0001495040  C:\WINNT\SYSTEM32\TSMAPI.DLL
0x039f0000-0x03a16fff Image    0000159744  C:\WINNT\SYSTEM32\TSMUTIL1.DLL
0x76620000-0x76630fff Image    0000069632  C:\WINNT\SYSTEM32\MPR.DLL
0x06200000-0x062cdfff Image    0000843776  C:\WINNT\SYSTEM32\DSMNTAPI.DLL
0x7c3a0000-0x7c41afff Image    0000503808  C:\WINNT\SYSTEM32\MSVCP71.DLL
0x69be0000-0x69beffff Image    0000065536  C:\WINNT\SYSTEM32\NTMSAPI.DLL
0x76fb0000-0x770aafff Image    0001028096  C:\WINNT\SYSTEM32\MFC42U.DLL
0x773e0000-0x773f4fff Image    0000086016  C:\WINNT\SYSTEM32\ATL.DLL
0x75400000-0x75409fff Image    0000040960  C:\WINNT\SYSTEM32\NTDSBCLI.DLL
0x68d10000-0x68da8fff Image    0000626688  C:\WINNT\SYSTEM32\CATSRVUT.DLL
0x6c1b0000-0x6c1b9fff Image    0000040960  C:\WINNT\SYSTEM32\MFCSUBS.DLL
0x78b20000-0x78dddfff Image    0002875392  C:\WINNT\SYSTEM32\MSI.DLL
0x7cf30000-0x7d175fff Image    0002383872  C:\WINNT\SYSTEM32\SHELL32.DLL
0x75a00000-0x75a12fff Image    0000077824  C:\WINNT\SYSTEM32\CABINET.DLL
0x064b0000-0x0652cfff Image    0000512000  C:\WINNT\SYSTEM32\URLMON.DLL
0x77820000-0x77826fff Image    0000028672  C:\WINNT\SYSTEM32\VERSION.DLL
0x759b0000-0x759b5fff Image    0000024576  C:\WINNT\SYSTEM32\LZ32.DLL
0x7c950000-0x7c9defff Image    0000585728  C:\WINNT\SYSTEM32\CLBCATQ.DLL
0x7c660000-0x7c68efff Image    0000192512  C:\WINNT\SYSTEM32\CATSRV.DLL
0x78740000-0x788affff Image    0001507328  C:\WINNT\SYSTEM32\COMSVCS.DLL
0x6de80000-0x6dee3fff Image    0000409600  C:\WINNT\SYSTEM32\TXFAUX.DLL
0x6df80000-0x6e03afff Image    0000765952  C:\WINNT\SYSTEM32\MSDTCPRX.DLL
0x6a7a0000-0x6a7affff Image    0000065536  C:\WINNT\SYSTEM32\MTXCLU.DLL
0x73930000-0x7393ffff Image    0000065536  C:\WINNT\SYSTEM32\CLUSAPI.DLL
0x689d0000-0x689dcfff Image    0000053248  C:\WINNT\SYSTEM32\RESUTILS.DLL
0x69c40000-0x69c4ffff Image    0000065536  C:\WINNT\SYSTEM32\NTFRSAPI.DLL
0x76980000-0x7699afff Image    0000110592  C:\WINNT\SYSTEM32\SFC.DLL
0x68010000-0x680fffff Image    0000983040  C:\WINNT\SYSTEM32\SFCFILES.DLL
0x73df0000-0x73e00fff Image    0000069632  C:\WINNT\SYSTEM32\CERTADM.DLL
0x75570000-0x75593fff Image    0000147456  C:\WINNT\SYSTEM32\CERTCLI.DLL
0x0a7d0000-0x0a864fff Image    0000610304  C:\WINNT\SYSTEM32\WININET.DLL
0x75ab0000-0x75ab4fff Image    0000020480  C:\WINNT\SYSTEM32\SENSAPI.DLL
0x72a00000-0x72a2cfff Image    0000184320  C:\WINNT\SYSTEM32\DBGHELP.DLL
------------------- End of memory map --------------------

------------------- Registers ----------------------------
eip = 77f8206b esp = 55fecc20 ebp = 55fecc60 edi = 03722569 esi = 00000000
eax = 00000020 ebx = 0372256d ecx = 7ffed000 edx = 00000020
ecs = 0000001b eds = 00000023 ees = 00000023 ess = 00000023
egs = 00000000 efs = 00000038
eflags = 00010202
------------------- End of Registers ---------------------

------------------- Instruction Disassembly --------------
------------------- End of Disassembly -------------------

------------------- Call Stack Trace ---------------------
Frameptr   RetAddr  Param#1  Param#2  Param#3  Param#4  Function Name      
0x55fecc60 0369041e 00000000 55fedc94 03722468 036a5b20 0x77f8206b          
0x55fef1a4 029dc7fc 560a0030 00000000 56086f24 56087d24 0x0369041e          
0x55fef1e4 00c3fd77 45384100 dc4d3fd7 56087640 00000002 _skgfqcre+636      
0x55fef210 00c3cb84 45384100 56087628 450ad771 0000000b _ksfq_cre+359      
0x55fef250 00cb565d 45384120 453840e8 00000068 00000001 _ksfqsubmit+228    
0x55fef41c 00e14012 0bdf6898 0bdf0430 0bdf0694 000003c8 _ksfvrdp+2413      
0x55fefcf4 00707f63 00000032 00000000 00000000 01ac802c _opirip+818        
0x55fefd80 00439f0e 00000032 00000000 00000000 00000000 _opidrv+659        
0x55fefd98 00430155 55fefe1c 00000032 00000000 00000000 _sou2o+30          
0x55fefe34 004304c9 00000003 55feff78 00000000 00000000 _opimai+341        
0x55feffb4 7c57b3bc 084b4f88 00000000 00000000 084b4f88 _BackgroundThreadSta
0x55feffec 00000000 00430360 084b4f88 00000000 00000000 0x7c57b3bc          
---------------- End of Call Stack Trace -----------------
------------------- Raw Stack Dump -----------------------
Address    Dump of bytes
0x55fecc20 39 f6 6c 03 20 00 00 00 - 5c f7 6c 03 00 00 00 00 9.l. ...\.l.....
0x55fecc30 69 25 72 03 48 24 72 03 - 6d 25 72 03 e8 b5 70 03 i%r.H$r.m%r...p.
0x55fecc40 00 00 00 00 48 24 72 03 - 30 cc fe 55 6c c8 fe 55 ....H$r.0..Ul..U
0x55fecc50 0c f4 fe 55 0d 24 6c 03 - 28 09 70 03 ff ff ff ff ...U.$l.(.p.....
0x55fecc60 a4 f1 fe 55 1e 04 69 03 - 00 00 00 00 94 dc fe 55 ...U..i........U
0x55fecc70 68 24 72 03 20 5b 6a 03 - 69 25 72 03 94 dc fe 55 h$r. [j.i%r....U
0x55fecc80 94 cc fe 55 6a 2f 0a 56 - 6b 33 0a 56 30 00 0a 56 ...Uj/.Vk3.V0..V
0x55fecc90 70 13 00 00 20 73 62 74 - 62 61 63 6b 75 70 28 29 p... sbtbackup()
0x55fecca0 3a 20 45 78 69 74 20 2d - 20 74 64 70 6f 50 72 65 : Exit - tdpoPre
0x55feccb0 70 53 65 6e 64 28 29 2e - 64 73 6d 48 61 6e 64 6c pSend().dsmHandl
0x55feccc0 65 20 3d 20 33 33 2c 20 - 72 63 20 3d 20 2d 31 2c e = 33, rc = -1,
0x55feccd0 20 4f 62 6a 65 63 74 20 - 4e 61 6d 65 20 3d 20 5c  Object Name = \
0x55fecce0 61 64 73 6d 6f 72 63 5c - 6f 72 63 6e 74 5c 37 75 adsmorc\orcnt\7u
0x55feccf0 69 71 33 6c 71 73 5f 31 - 5f 33 0a 00 00 00 00 00 iq3lqs_1_3......
0x55fecd00 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x55fecd10 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x55fecd20 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x55fecd30 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x55fecd40 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x55fecd50 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x55fecd60 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x55fecd70 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x55fecd80 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x55fecd90 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x55fecda0 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x55fecdb0 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x55fecdc0 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x55fecdd0 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x55fecde0 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x55fecdf0 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x55fece00 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x55fece10 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x55fece20 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x55fece30 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x55fece40 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x55fece50 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x55fece60 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x55fece70 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x55fece80 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x55fece90 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x55fecea0 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x55feceb0 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x55fecec0 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x55feced0 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x55fecee0 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x55fecef0 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x55fecf00 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x55fecf10 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x55fecf20 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x55fecf30 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x55fecf40 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x55fecf50 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x55fecf60 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x55fecf70 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x55fecf80 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x55fecf90 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x55fecfa0 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x55fecfb0 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x55fecfc0 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x55fecfd0 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x55fecfe0 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x55fecff0 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x55fed000 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x55fed010 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x55fed020 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x55fed030 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x55fed040 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x55fed050 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x55fed060 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x55fed070 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x55fed080 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x55fed090 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x55fed0a0 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x55fed0b0 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x55fed0c0 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x55fed0d0 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x55fed0e0 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x55fed0f0 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x55fed100 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x55fed110 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
------------------- End of Raw Stack Dump ----------------


Hopefully that is all the info you need I think I've remembered everything. Has anyone any ideas as to why changing the BACKUP_IO_TAPE_SLAVE parameter has caused a problem. I did a full shutdown and restart after applying the change, and there was a windows update applied at same time so machine was rebooted.

This is our production database so I am keen to get the backup fixed.
Start your free trial to view this solution
Question Stats
Zone: Storage
Question Asked By: ambisset
Question Asked On: 08.23.2007
Participating Experts: 2
Points: 500
Views: 0
Translate:
Loading Advertisement...
08.24.2007 at 01:12PM PDT, ID: 19765121
StephenJD:

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
08.27.2007 at 03:33AM PDT, ID: 19774560
ambisset:

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
04.02.2008 at 02:49AM PDT, ID: 21261384
bhanukir7:

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
 
Loading Advertisement...
Microsoft
  • Internet Protocols
  • Applications
  • Development
  • OS
  • Hardware
  • Windows Security
Apple
  • Operating Systems
  • Hardware
  • Programming
  • Networking
  • Software
Internet
  • Search Engines
  • File Sharing
  • WebTrends / Stats
  • Spy / Ad Blockers
  • Web Browsers
  • New Net Users
  • Web Development
  • Chat / IM
  • Anti Spam
  • Web Servers
  • Anti-Virus
  • Email Clients
Gamers
  • Tips
  • Online / MMORPG
  • Puzzle
  • Emulators
  • Action / Adventure
  • Role Playing
  • Consoles
  • Game Programming
  • Strategy
  • Sports
  • Misc
  • Computer Games
Digital Living
  • Hardware
  • New Net Users
  • New Users
  • Software
  • Digital Music
  • Gaming World
  • Home Security
  • Apple
  • Networking Hardware
Virus & Spyware
  • Vulnerabilities
  • IDS
  • Encryption
  • Anti-Virus
  • Operating Systems Security
  • Software Firewalls
  • WebApplications
  • Cell Phones
  • Operating Systems
  • Internet
  • Hardware Firewalls
Hardware
  • Handhelds / PDAs
  • Displays / Monitors
  • Components
  • Networking Hardware
  • Peripherals
  • Laptops/Notebooks
  • Storage
  • Servers
  • Desktops
  • New Users
  • Misc
  • Apple
Software
  • System Utilities
  • Industry Specific
  • Network Management
  • Photos / Graphics
  • Page Layout
  • VMWare
  • Misc
  • Web Development
  • OS
  • CYGWIN
  • Voice Recognition
  • Message Queue
  • Quality Assurance
  • Security
  • Firewalls
  • MultiMedia Applications
  • Development
  • Database
  • Office / Productivity
  • Business Management
  • OS/2 Apps
  • Server Software
  • Internet / Email
ITPro
  • OS
  • Storage
  • Encryption
  • Operating Systems Security
  • Apple Hardware
  • Laptops & Notebooks
  • Servers
  • Networking Hardware
  • Peripherals
  • Devices
  • Displays / Monitors
  • WebTrends / Stats
  • Search Engines
  • Firewalls
  • WebApplications
  • IDS
  • Vulnerabilities
  • Email Clients
  • File Sharing
  • Spy / Ad Blockers
  • Web Browsers
  • Web Servers
  • Networking
  • Anti-Virus
  • Chat / IM
  • Anti Spam
Developer
  • Web Servers
  • Web Browsers
  • Game Programming
  • Dev Tools
  • Industry Specific
  • Office / Productivity
  • Database
  • CYGWIN
  • Web Development
  • Search Engines
  • File Sharing
  • WebTrends / Stats
  • Programming
  • Content Management
  • Application Servers
  • Protocols
Storage
  • Removable Backup Media
  • Storage Technology
  • Servers
  • Grid
  • Remote Access
  • Backup / Restore
  • Misc
  • Hard Drives
OS
  • Miscellaneous
  • Security
  • Development
  • Linux
  • VMWare
  • MainFrame OS
  • Unix
  • Apple
  • OS / 2
  • AS / 400
  • BeOS
  • Microsoft
  • VMS / OpenVMS
Database
  • Oracle
  • Miscellaneous
  • MySQL
  • Software
  • Sybase
  • Contact Management
  • PostgreSQL
  • Data Manipulation
  • Clarion
  • InterSystems Cache
  • Siebel
  • MUMPS
  • OLAP
  • SQLBase
  • SAS
  • GIS & GPS
  • 4GL
  • Berkeley DB
  • DB2
  • Informix
  • Interbase / Firebird
  • FoxPro
  • Reporting
  • LDAP
  • Filemaker Pro
  • MS SQL Server
  • dBase
  • MS Access
Security
  • Misc
  • Web Browsers
  • Software Firewalls
  • Operating Systems Security
  • File Sharing
  • Spy / Ad Blockers
  • Vulnerabilities
  • WebApplications
  • IDS
  • Anti-Virus
  • Encryption
  • Anti Spam
  • Email Clients
  • VPN
  • Chat / IM
Programming
  • Editors IDEs
  • Installation
  • Handhelds / PDAs
  • Multimedia Programming
  • System / Kernel
  • Algorithms
  • Game
  • Signal Processing
  • Project Management
  • Open Source
  • Database
  • Misc
  • Languages
  • Processor Platforms
  • Theory
Web Development
  • Scripting
  • Blogs
  • Web Servers
  • Software
  • Search Engines
  • Web Graphics
  • Images
  • Internet Marketing
  • Images and Photos
  • Components
  • Document Imaging
  • Web Languages/Standards
  • Illustration
  • WebApplications
  • Fonts
  • WebTrends / Stats
  • Authoring
  • Digital Camera Software
  • Miscellaneous
Networking
  • Protocols
  • Apple Networking
  • Network Management
  • Message Queue
  • Application Servers
  • Content Management
  • File Servers
  • Email Servers
  • Misc
  • Java Editors & IDEs
  • Wireless
  • Networking Hardware
  • Backup / Restore
  • System Utilities
  • ISPs & Hosting
  • Web Servers
  • Storage Technology
  • Removable Backup Media
  • Servers
  • Broadband
  • Grid
  • OS / 2
  • Novell Netware
  • Unix Networking
  • Windows Networking
  • Security
  • Telecommunications
  • Operating Systems
  • Linux Networking
Other
  • Community Advisor
  • Lounge
  • Community Support
  • New Net Users
  • Philosophy / Religion
  • Math / Science
  • Miscellaneous
  • URLs
  • Expert Lounge
  • Politics
  • Puzzles / Riddles
Community Support
  • Suggestions
  • New to EE
  • New Topics
  • Community Advisor
  • CleanUp
  • Announcements
  • General
  • Feedback
  • Input
  • EE Bugs
 
08.24.2007 at 01:12PM PDT, ID: 19765121
StephenJD:
Does your tape drive have any physical means of selecting whether it is a slave or a master drive? e.g. - a jumper that needs reset?
 
08.27.2007 at 03:33AM PDT, ID: 19774560
ambisset:
I can guarantee it is nothing to do with the tape drive as normal backups work just fine and tsm backups of the actual physical files on the database server are working well too. So unfortunately it is not a physical problem.

It must be some form of configuration setup within Oracle parameters or TSM parameters or some interaction between the too or software bug with a windows update. As these are the only changes I can think of happening between it working and it not working.

Thanks for the attempt though.
 
04.02.2008 at 02:49AM PDT, ID: 21261384
bhanukir7:
Hi,

The changes you made were recomended to set the backup to tapes in asynchronous mode. And use the large pool "The Large Pool is an area in the memory used to relieve the burden placed on the Shared Pool".

The parameter for the BACKup_TAPE_IO_SLAVE=TRUE sets the backup to tape in asynchrounous mode.

Please reset that to normal and this would require a restart of the DB instance.

Do that and run the backups.

The likely reason why this parameter changes have not worked is because your tape drive/library does not have the ability to perform asynchronous operations.

bhanu
 
 
20080236-EE-VQP-29 / EE_QW_2_20070628