Re: Q: Which backup system ? newbie

"Wolfgang Bl?lhuber" <wolfgang.bluemlhuber_at_rz.fh-regensburg.de> wrote in message news:<9oc40g$qjm$1_at_news.uni-paderborn.de>...
> Hi,
>
> I need to configure a new server for our Oracle 9i. running on NT4
> The Server will be a DELL 4400 with 4x 18GB SCSI
> Our database has a size of about 4 GB now but will increase twice
> the next few years.
>
>
> The question is: how to backup this system?
> I don't think that it is necessary to backup all the disks every day ?!?
> Is there anything in oracle like writing logical locks directly to tape
> (like
> in informix)?
> I thought to backup a full database export on friday and write logical locks
> to tape until the next export will be saved.
>
> What do you recomend for a save backup management ??
> Which software can you recomend ??
>
> Any help will be appreciate.
>
> Thanks in advance.
>
> Wolfgang.

You are just providing too little clues to give any sensible advice. Is this a 7x24 system? OLTP? Datawarehouse? Transaction volume? From your suggestions it looks like you plan to implement a minimal solution. You will soon regret this.
I can only recommand you to
a) read the Oracle concepts manual
b) read the chapters on backup and recovery in the Oracle Servers administrators manual
c) buy the Oracle Backup and Recovery handbook by Rama Velpuri and develop a solution based on RMAN (comes with Oracle and can backup modified blocks only)
or read this book and ask for suggestions after reading it.

The other alternative would definitely be hire a consultant (I am one myself) as this is definitely a too broad subject for free advice.

Regards,

Sybrand Bakker, Senior Oracle DBA Received on Thu Sep 20 2001 - 04:31:32 CDT