Backup planning experience

From: <alexberi_at_my-deja.com>
Date: Thu, 08 Feb 2001 11:02:44 GMT
Message-ID: <95tuch$df3$1@nnrp1.deja.com>

Hello,

I'm in a little of trouble having to make a backup plan for my Oracle 8.0.5 database. The problem is I have one table OPERBIG which will become very large, around 200Gb, I created two separated tablespaces one for the table and one for the indexes on it, and I'm not sure how to deal with this.
I'm planning to use RMAN(or it's interface from Enterprise Mgr), to partition the table by date and to make the backup daily.

-Is it a good idea to backup the whole database incrementaly or to
treat the table separatelly?
-What about the partitions?
-If the database can be shutdown during the night do I need to backup
archive logs?
-the output device is a tape, do I need a different tape for each daily
backup?

I don't have any experience with this and someone from the client side must have the instructions from me to change the tapes and do all the work there.

Thanks alot,
Alex.

Sent via Deja.com
http://www.deja.com/ Received on Thu Feb 08 2001 - 05:02:44 CST