ADSM-L

Re: Backing Up Oracle DB with TSM 4.2.1

2002-06-25 21:08:09
Subject: Re: Backing Up Oracle DB with TSM 4.2.1
From: Steve Harris <Steve_Harris AT HEALTH.QLD.GOV DOT AU>
Date: Wed, 26 Jun 2002 11:01:45 +1000
There are several ways.

1. Configure RMAN to do backups to a disk directory.  Exclude the oracle 
database directories from backup. run your normal node incremental after the 
RMAN job has finished.  RMAN disk backups have unique names, so you will need 
an include on the backup directory and a dedicated management class for Oracle 
backup data.

2. Shutdown the database with a preschedule command, backup the node, then 
start it up with a postschedule command.

3. exclude the database directories from backup.  set up a script to set the 
oracle tablespaces to hot backup mode (alter tablespace begin backup) one at a 
time, then run an *archive* on each, then take them out of hot backup mode. 
Note that this way you back up lots of gas,as you back up blank pages too.  The 
RMAN solution only backs up used pages.

HTH

Steve Harris
AIX and TSM Admin
Queensland Health, Brisbane Australia

>>> Anthony.Rivera AT MAIL.IHS DOT GOV 26/06/2002 2:50:16 >>>
I have a client that is running a small (~10GB) Oracle (9.0) DB on Win2K. I
have never backed up an Oracle DB before, especially on Win2K. (TSM Server
is AIX).

If someone could point me to a step-by-step explanation of how to do this, I
would greatly appreciate it. Thank you.

Tony



**********************************************************************
This e-mail, 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 e-mail 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 
e-mail in error, you are asked to immediately notify the sender by 
telephone or by return e-mail.  You should also delete this e-mail 
message and destroy any hard copies produced.
**********************************************************************
<Prev in Thread] Current Thread [Next in Thread>