Has anyone seen the following behviour with their sbtio.log under Solaris and TDP for
Oracle V2.2. I cant find anything on Tivoli's Knowledge base..
Any hints/tip are welcome....
Tel: +44(0) 207 547 4917
Fax +44(0)207 541-4705
Mobile +44(0) 7768 361-885
email: [EMAIL PROTECTED]
Group mail [EMAIL PROTECTED]
---------------------- Forwarded by Bruce Mitchell on 16/11/2001 11:09
---------------------------
From: Martin-db Baker on 16/11/2001 11:06
To: Bruce Mitchell
cc:
Subject: Re: TDPO 2.2 some undesirable behaviour. (Document link: Database 'Bruce
Mitchell', View '($Inbox)')
Bruce,
the sbtio.log is according to the RMAN documentation the 3rd Party media
management log file, and contains " information on the functioning of the media
management device. " and is owned/populated by the media manager.
Given that debug=49 is superceded by TPDO_TRACE and I don't have this in the
dsm.optora_alt file, and even when I do put it in the TDPOconfig file it doesn;t have
any effect on the sbtio.log. But seems to have the effect of forking the log and
duplicates much of the output.
tdpo.opt specifies nothing beyond the minimum.
This is the contents of the tdpo TDPO_OPTFILE
TDPO_NODE vss1fxp1ora2
DSMI_ORC_CONFIG /opt/tivoli/tsm/client/api/bin/dsm.optora_alt
TDPO_PSWDPATH /opt/tivoli/tsm/client/oracle/bin
TDPO_OWNER oracle
TDPO_FS RMSPRDorc
DSMI_LOG /u003/RMS/admin/scripts/dsmi_RMSDEV1.log
TDPO_NUM_BUFFERS 8
TDPO_TRACE_FLAGS orclevel0
TDPO_TRACE_FILE /u003/RMS/admin/scripts/tdpo_RMSDEV1.log
I have a sneeking suspicion that Tivoli have shipped the agent with the debugger
defaulted ON.... Can you PMR this or check their knowledge base?
Martin Baker
Oracle Database Administrator
FX/IT
020 754(5 6039)
---------------------------------------- Message History
----------------------------------------
From: Bruce Mitchell on 16/11/2001 08:59
To: Martin-db Baker/DMGIT/DMG UK/DeuBa@DMG UK
cc:
Subject: Re: TDPO 2.2 some undesirable behaviour. (Document link: Database
'Martin-db Baker', View '($Inbox)')
Martin,
According to the documentation , RMAN controls the logging to sbtio.log. I asked
Paul to comment out the TDPO_TRACE(s) he had
set in the dsm.opt file..
Is there anything withim RMAN thats 'tracing'..
Tel: +44(0) 207 547 4917
Fax +44(0)207 541-4705
Mobile +44(0) 7768 361-885
email: [EMAIL PROTECTED]
Group mail [EMAIL PROTECTED]
---------------------------------------- Message History
----------------------------------------
From: Martin-db Baker on 15/11/2001 17:38
To: Bruce Mitchell/DMGIT/DMG UK/DeuBa@DMG UK
cc: Paul Cornish/DMGIT/DMG UK/DeuBa@DMG UK
Subject: TDPO 2.2 some undesirable behaviour.
Bruce,
James has installed for me the TDPO 2.2 on srmsd1, and initial testing looks
promising.
as always there is a "However", there is an undesirable effect of tracing via
sbtio.log (previously controlled by debug=49)............
It produces logs running into the 10's or even 100Mb for 1 restore.... this is no
good, as the trace info goes to the database instance trace directories, and these are
kept puposefully small on Development machines.
I've tried the
TDPO_TRACE_FLAGS orclevel0 orclevel1 orclevel2
TDPO_TRACE_FILE /u003/RMS/admin/scripts/tdpo_RRATED.log
varying the levels, but makes no difference to sbtio.log.
trace level 0 =OFF is set at the TNS (Oracle networking substrate) level, and
has no effect on the quantity of sbtio logging.
I have discussed with Paul Cornish, and he advises similar experience... said
something about settings in dsm.sys or opt, can you throw any light on this?
Martin Baker
Oracle Database Administrator
FX/IT
020 754(5 6039)
--
This e-mail may contain confidential and/or privileged information. If you are not the
intended recipient (or have received this e-mail in error) please notify the sender
immediately and destroy this e-mail. Any unauthorized copying, disclosure or
distribution of the material in this e-mail is strictly forbidden.