There is a command that TSM has which does all this for you. Look in the admin
or reference guide for the define dbbackuptrigger, that should do what you're
after.
Gordon Woodward
Wintel Server Support
Shukrie.Hashim@SH
ELL.COM To: ADSM-L AT VM.MARIST
DOT EDU
Sent by: cc:
[email protected]. Subject: Re: Emergency .. HELP
EDU
16/07/2004 11:01
AM
Please respond to
ADSM-L
do you know how I can write a script, I have never scripted before ..
I want to have a script that checks the recovery log if it's 75% full or not
... and then ... it pauses all processes and then ... it does an incremental db
backup ... how can I do this .. ?
Shukrie
-----Original Message-----
From: Steve Harris [mailto:Steve_Harris AT HEALTH.QLD.GOV DOT AU]
Sent: 16 July 2004 08:45
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Emergency .. HELP
looks like you have a bad DB backup tape.
Clean the heads and try it again. If it fails, go back to the previous backup
tape.
>>> Shukrie.Hashim AT SHELL DOT COM 16/07/2004 10:29:07 >>>
Steve
I did a restore db ... then ... some weird message came out .. what is it ?
should I do an audit ? what is the command for an audit ?
ANR9999D ssrecons.c(2398): ThreadId<67> Actual: Magic=40EB4B01,
SrvId=610717121,
SegGroupId=2931634798798438565, SeqNum=12592898, converted=T.
ANR9999D ssrecons.c(2412): ThreadId<67> Expected: Magic=53454652, SrvId=0,
SegGroupId=296636929.
SeqNum=1.ANR9999D ssrecons.c(2398): ThreadId<67> Actual: Magic=4F474943,
SrvId=12717578,
SegGroupId=4187893577790063616, SeqNum=135201039, converted=T.
ANR9999D ssrecons.c(2412): ThreadId<67> Expected: Magic=53454652, SrvId=0,
SegGroupId=296677584.
SeqNum=1.
ANR9999D ssrecons.c(2398): ThreadId<67> Actual: Magic=4C630400,
SrvId=828322399,
SegGroupId=6009320758017282134, SeqNum=234901590, converted=T.
ANR9999D ssrecons.c(2412): ThreadId<67> Expected: Magic=53454652, SrvId=0,
SegGroupId=296677701.
SeqNum=1.
ANR8302E I/O error on drive DRIVE2 (/dev/rmt1) (OP=LOCATE, Error Number=5,
CC=0, KEY=08, ASC=00,
ASCQ=05,
SENSE=70.00.08.00.00.00.00.58.00.00.00.00.00.05.FF.0A.3A.60.40.01.00.09.01.91.00.D5.50.14.00.00.2B.00.-
Description=An undetermined error has occurred). Refer to Appendix D in the
'Messages' manual for
recommended action.
<< Message number 8944 not available for language EN_US >>
ANR8359E Media fault detected on 3590 volume 002322 in drive DRIVE2 (/dev/rmt1)
of library 3494LIB.
am I suppose to do an audit ?
-----Original Message-----
From: Steve Harris [mailto:Steve_Harris AT HEALTH.QLD.GOV DOT AU]
Sent: 14 July 2004 12:09
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Emergency .. HELP
Shukie,
You probably don't want to hear this, but this is why you should always have
that 500MB log file ready to be allocated, and immediatly deallocate it when
the condition has beed cleared.
I believe that you are stuck with a database restore to point of time of your
last DB backup. This is an issue, but in most cases it is not too bad. Once
you get back up and running, just run your backups again, and in general they
will pick up whatever they are missing.
Once you are back on level ground, have a look at the facilty to trigger DB
backups automatically when the log gets above a given percentage full.
Regards and commisserations
Steve
Steve Harris
Queensland Health
Brisbane Australia
>>> Shukrie.Hashim AT SHELL DOT COM 14/07/2004 11:01:09 >>>
Hi there
I have reached my maximum extention of recovery log of 13 gb ... now I can't
even extend it so I can't log in and do a database back up ... can someone tell
me how to delete some of the recovery log ... is there any other way ?
Shukrie
***********************************************************************************
This email, including any attachments sent with it, is confidential and for the
sole use of the intended recipient(s). This confidentiality is not waived or
lost, if you receive it and you are not the intended recipient(s), or if it is
transmitted/received in error.
Any unauthorised use, alteration, disclosure, distribution or review of this
email is prohibited. It may be subject to a statutory duty of confidentiality
if it relates to health service matters.
If you are not the intended recipient(s), or if you have received this email in
error, you are asked to immediately notify the sender by telephone or by return
email. You should also delete this email and destroy any hard copies produced.
***********************************************************************************
***********************************************************************************
This email, including any attachments sent with it, is confidential and for the
sole use of the intended recipient(s). This confidentiality is not waived or
lost, if you receive it and you are not the intended recipient(s), or if it is
transmitted/received in error.
Any unauthorised use, alteration, disclosure, distribution or review of this
email is prohibited. It may be subject to a statutory duty of confidentiality
if it relates to health service matters.
If you are not the intended recipient(s), or if you have received this email in
error, you are asked to immediately notify the sender by telephone or by return
email. You should also delete this email and destroy any hard copies produced.
***********************************************************************************
--
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.
|