Re: Question about data protection for Oracle

If you are intent on shutting down your database first, you don't need the
TDP, and in fact the TDP needs to run with the DB up.  You will do offline
full backups.

The TDP uses RMAN, which is included with Oracle 8.  RMAN implements
incremental backups, among many other things.  The TDP allows RMAN to send
the output data directly to tape.  You could instead send the output data
to a disk file, and use the regular TSM client to back the disk file up to
tape, but you will not be able to use the full capability of RMAN
versioning



_____________________________
William Mansfield
Senior Consultant
Solution Technology, Inc
630 718 4238



                      William SO Ng
                      <ngwso AT HK1.IBM DOT CO        To:       ADSM-L AT 
VM.MARIST DOT EDU
                      M>                       cc:
                      Sent by: "ADSM:          Subject:  Question about data 
protection for Oracle
                      Dist Stor
                      Manager"
                      <[email protected]
                      .EDU>


                      01/29/2002 09:08
                      PM
                      Please respond to
                      "ADSM: Dist Stor
                      Manager"






Hello there,

I have a question about backup on Oracle and would like to get a
confirmation.  I understand TSM data protection provide ONLINE backup and
restore of database, i.e. database is still up and running during backup
and restore.  My questions are:

1.   Every time I do a backup on Oracle, I'll shutdown Oracle first.  Do I
still need TSM data protection ?  From what I understand, once I shutdown
Oracle, database is just a "file" to system and no process will lock these
file, so TSM should be able to backup these files safely without TSM data
protection, am I correct ?

2.   I heard that Oracle 8 provide tools to perform incremental backup on
database.  Do I still need TSM data protection ?

Thanks for your advice.

Regards
William

Tivoli Software, IBM Software Group, IBM China/Hong Kong Limited
11/F, PCCW Tower, Taikoo Place, 979 King's Road, Hong Kong
Internet : ngwso AT hk1.ibm DOT com
Tel: 2825-7613                    Fax: 2825-0022