• Please help support our sponsors by considering their products and services.
    Our sponsors enable us to serve you with this high-speed Internet connection and fast webservers you are currently using at ADSM.ORG.
    They support this free flow of information and knowledge exchange service at no cost to you.

    Please welcome our latest sponsor Tectrade . We can show our appreciation by learning more about Tectrade Solutions
  • Community Tip: Please Give Thanks to Those Sharing Their Knowledge.

    If you receive helpful answer on this forum, please show thanks to the poster by clicking "LIKE" link for the answer that you found helpful.

  • Community Tip: Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING)

    Click the link above to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This notice will disappear after you have made at least 3 posts.

RMAN archive logs stuck ?

vilius.m

ADSM.ORG Senior Member
Joined
Jul 23, 2008
Messages
75
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.
 

fidel

ADSM.ORG Member
Joined
Aug 23, 2011
Messages
40
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.
Hello,
what about "tdpoconf SHOWENVironment" ?
Did you check the tdpo logfile ?
 

vilius.m

ADSM.ORG Senior Member
Joined
Jul 23, 2008
Messages
75
Reaction score
4
Points
0
>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...
 

vilius.m

ADSM.ORG Senior Member
Joined
Jul 23, 2008
Messages
75
Reaction score
4
Points
0
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.
 

vilius.m

ADSM.ORG Senior Member
Joined
Jul 23, 2008
Messages
75
Reaction score
4
Points
0
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.
 

Advertise at ADSM.ORG

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

UpCloud high performance VPS at $5/month

Get started with $25 in credits on Cloud Servers. You must use link below to receive the credit. Use the promo to get upto 5 month of FREE Linux VPS.

The Spectrum Protect TLA (Three-Letter Acronym): ISP or something else?

  • Every product needs a TLA, Let's call it ISP (IBM Spectrum Protect).

    Votes: 19 19.0%
  • Keep using TSM for Spectrum Protect.

    Votes: 61 61.0%
  • Let's be formal and just say Spectrum Protect

    Votes: 12 12.0%
  • Other (please comement)

    Votes: 8 8.0%

Forum statistics

Threads
31,774
Messages
135,487
Members
21,762
Latest member
Rambug
Top