RMAN archive logs stuck ?

V

vilius.m

ADSM.ORG Senior Member
Joined
Jul 23, 2008
Messages
76
Reaction score
4
Points
0
Hello,

Server OS: Windows 2012 R2
TSM server: 7.1.7
Client OS: Windows 2012 R2
BA client: 7.1.4 (tried 7.1.6)
TDPO client: 7.1.3

RMAN archive logs just freezes (no errors at all):
Code: 
RMAN> run {
2>   sql 'alter system archive log current';
3>   allocate channel t1 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=C:\progra~1\Tivoli\TSM\AgentOBA64\tdpo.opt)';
4>   backup not backed up as backupset archivelog all format 'bckarch-%s-%T-%U' delete input;
5>   release channel t1;
6> }

using target database control file instead of recovery catalog
sql statement: alter system archive log current

allocated channel: t1
channel t1: SID=16 device type=SBT_TAPE
channel t1: Data Protection for Oracle: version 7.1.3.0

Starting backup at 2016.10.25
current log archived
channel t1: starting archived log backup set
channel t1: specifying archived log(s) in backup set
input archived log thread=1 sequence=15319 RECID=4 STAMP=925757938
..............
input archived log thread=1 sequence=15378 RECID=63 STAMP=925948935
input archived log thread=1 sequence=15379 RECID=64 STAMP=925969509
channel t1: starting piece 1 at 2016.10.25
Full also freezes but my guess is that it freezes by trying to archive needed logs. It's not a network issue - filespaces gets created on tsm side(I checked that), tsm sessions just hangs there. Also if I remember corectlty I was able to do first full backup, and as soon as logs were archived - stop.
TSM config files:
Code: 
>type "C:\Program Files\Tivoli\TSM\baclient\dsm.opt"
COMMMethod              tcpip
TCPPort                 1500
TCPServeraddress        x.x.x.x
NODename                node1
PASSWORDAccess          generate
ERRORLOGRetention       30
SCHEDLOGRetention       30

>type "C:\Program Files\Tivoli\TSM\AgentOBA64\tdpo.opt"
DSMI_ORC_CONFIG  c:\Program Files\tivoli\tsm\agentoba64\dsm.opt
DSMI_LOG  c:\Program Files\tivoli\tsm\agentoba64

>type "C:\Program Files\Tivoli\TSM\AgentOBA64\dsm.opt"
COMMMethod  tcpip
TCPPort  1500
TCPServeraddress  x.x.x.x
NODename  nodetdp1
PASSWORDAccess  generate
Errorlogname  "C:\Program Files\Tivoli\TSM\AgentOBA64\dsmerror.log"
Schedlogname  "C:\Program Files\Tivoli\TSM\AgentOBA64\dsmsched.log"
ERRORLOGRetention  30
SCHEDLOGRetention  30
Oracle archive config:
Code: 
SQL> archive log list;
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            E:\oracle\archivelog
Oldest online log sequence     15409
Next log sequence to archive   15411
Current log sequence           15411

I used the same config for other hosts with no problems before.
Any ideas ?

Thanks,
Vilius M.
 
vilius.m said:
Hello,

Server OS: Windows 2012 R2
TSM server: 7.1.7
Client OS: Windows 2012 R2
BA client: 7.1.4 (tried 7.1.6)
TDPO client: 7.1.3

RMAN archive logs just freezes (no errors at all):
Code: 
RMAN> run {
2>   sql 'alter system archive log current';
3>   allocate channel t1 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=C:\progra~1\Tivoli\TSM\AgentOBA64\tdpo.opt)';
4>   backup not backed up as backupset archivelog all format 'bckarch-%s-%T-%U' delete input;
5>   release channel t1;
6> }

using target database control file instead of recovery catalog
sql statement: alter system archive log current

allocated channel: t1
channel t1: SID=16 device type=SBT_TAPE
channel t1: Data Protection for Oracle: version 7.1.3.0

Starting backup at 2016.10.25
current log archived
channel t1: starting archived log backup set
channel t1: specifying archived log(s) in backup set
input archived log thread=1 sequence=15319 RECID=4 STAMP=925757938
..............
input archived log thread=1 sequence=15378 RECID=63 STAMP=925948935
input archived log thread=1 sequence=15379 RECID=64 STAMP=925969509
channel t1: starting piece 1 at 2016.10.25
Full also freezes but my guess is that it freezes by trying to archive needed logs. It's not a network issue - filespaces gets created on tsm side(I checked that), tsm sessions just hangs there. Also if I remember corectlty I was able to do first full backup, and as soon as logs were archived - stop.
TSM config files:
Code: 
>type "C:\Program Files\Tivoli\TSM\baclient\dsm.opt"
COMMMethod              tcpip
TCPPort                 1500
TCPServeraddress        x.x.x.x
NODename                node1
PASSWORDAccess          generate
ERRORLOGRetention       30
SCHEDLOGRetention       30

>type "C:\Program Files\Tivoli\TSM\AgentOBA64\tdpo.opt"
DSMI_ORC_CONFIG  c:\Program Files\tivoli\tsm\agentoba64\dsm.opt
DSMI_LOG  c:\Program Files\tivoli\tsm\agentoba64

>type "C:\Program Files\Tivoli\TSM\AgentOBA64\dsm.opt"
COMMMethod  tcpip
TCPPort  1500
TCPServeraddress  x.x.x.x
NODename  nodetdp1
PASSWORDAccess  generate
Errorlogname  "C:\Program Files\Tivoli\TSM\AgentOBA64\dsmerror.log"
Schedlogname  "C:\Program Files\Tivoli\TSM\AgentOBA64\dsmsched.log"
ERRORLOGRetention  30
SCHEDLOGRetention  30
Oracle archive config:
Code: 
SQL> archive log list;
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            E:\oracle\archivelog
Oldest online log sequence     15409
Next log sequence to archive   15411
Current log sequence           15411

I used the same config for other hosts with no problems before.
Any ideas ?

Thanks,
Vilius M.
Click to expand...

Hello,
what about "tdpoconf SHOWENVironment" ?
Did you check the tdpo logfile ?
 
>tdpoconf SHOWENVironment
Code: 
IBM Tivoli Storage Manager for Databases:
Data Protection for Oracle
Version 7, Release 1, Level 3.0
(C) Copyright IBM Corporation 1997, 2015. All rights reserved.


Data Protection for Oracle Information
Version:              7
Release:              1
Level:                3
Sublevel:             0
Platform:             64bit DP Oracle Win64

Tivoli Storage Manager Server Information
Server Name:          DSMSERV
Server Address:       x.x.x.x
Server Type:          Windows
Server Port:          1500
Communication Method: TCP/IP

Session Information
Node Name:            nodetdp1
Node Type:            DP Oracle Win64
DSMI_DIR:             C:\Program Files\Common Files\Tivoli\TSM\api64
DSMI_ORC_CONFIG:      c:\Program Files\tivoli\tsm\agentoba64\dsm.opt
TDPO_OPTFILE:         C:\Program Files\Tivoli\TSM\AgentOBA64\tdpo.opt
Compression:          FALSE
License Information:  License file exists and contains valid license data.

tdpoerror.log log contains no errors - I terminate backup process by Ctrl+C because it just waits...
 
I figured out the cause - after running rman archivelog command sqlplus.exe process is started:
oracle.exe
--cmd.exe
----sqlplus.exe
as "NT AUTHORITY\SYSTEM" and while it is running rman log archiving is blocked(waiting forever). As soon as I kill that process log archiving moves and finishes successfully. sqlplus.exe gets restarted immediately after being killed.

Any ideas what oracle configuration causes oracle.exe to spawn sqlplus.exe ?
(I know very little about oracle)

Thanks,
Vilius M.
 
I figured this out.
Fist of all this problem only happens if we use tdpo 7.1.3 - if we use tdpo 7.1.0 sqlpus.exe(child of oracle.exe) process will not be created so this problem won't happen in this case.
If we use tdpo 7.1.3 during rman archivelog command execution sqlpus.exe process gets created(child of oracle.exe process) - it performs some task and terminates. Lets say we have 2 oracle bin paths like:
C:\oracle\path1\bin
C:\oracle\path2\bin
and we use C:\oracle\path1\bin for our rman operation - if sqlpus.exe is executed from C:\oracle\path2\bin problem described above happens. This could happen if path C:\oracle\path2\bin comes first in our PATH environment variable.
So obvious fix is to ensure that oracle path we use for rman comes first in PATH variable, unfortunately I observed system where switching those paths resulted that application was unable to start - in that case I just downgraded tdpo to 7.1.0 and that solved the problem.

Vilius M.
 
You must log in or register to reply here.

Data Privacy Impact Assessment

Compliance Assurance in Every Byte: Discover the Impact of Our DPIA Services.

Sponsor ADSM.ORG

If you are reading this, so are your potential customer. Advertise at ADSM.ORG right now.

Navigation Menu

Forums
   IBM TSM
   EMC Backup and Recovery
   Symantec NetBackup  
   SAN  
   NAS
   Platforms / OS
Mailing List Archives
   ADSM-L
User Groups

NordVPN 3 Months FREE

Help Support ADSM.ORG and Get NordVPN with 64% Off and 3 Months FREE.

NordVPN with 64% off + 3 months FREE

Forum statistics

Threads
31,974
Messages
135,446
Members
21,952
Latest member
gatherpc
Back
Top