Re: Which backup system ? newbie

From: Paul Drake <paledHOWMUCHSPAMCANYOUEAT_at_home.com>
Date: Fri, 21 Sep 2001 03:18:35 GMT
Message-ID: <3BAAB1A5.7040000@home.com>

 > backup database; is all it takes.

its that easy?
I guess that I can no longer dismiss RMAN.

I would have said:

• nightly groom archived redo logs (& compress, write to tape)
• nightly hot backup to disk (& compress, write to tape)
• weekly export to disk (& compress, write to tape)
• weekly cold backup to disk (& compress, write to tape)
• and no RMAN

but that's cuz I have a killer set of backup scripts in the nt shell (sql plus, mostly) that even handle archlog propagation for standby database (once a day, nothing too fancy). and small databases.

yeah, I downloaded 9.0.1.1 for win32 this week, but haven't installed it yet.

<opinion>
9.0.1.1 - It was shipped for the stockholders, not for the DBAs. 8.1.7.2.1 is where your production db should be (on win32) </opinion>

Paul

Howard J. Rogers wrote:

> Genuinely 9i??
> 
> On NT???
> 
> That's fast work -it was only released two days ago.
> 
> But if it really *is* 9i, then you really can't go past RMAN.  Supplied with
> Oracle for free, it is now genuinely a one-line backup tool, and there's no
> need for a separate Catalog database as there used to be.
> 
> backup database;  is all it takes.
> 
> Sounds like you want to read up on backup and recovery theory, though.  I
> don't know what "logical locks" are (though they sound like redo logs), but
> Oracle isn't Informix.
> 
> Regards
> HJR
> 
> 
> "Wolfgang Blümlhuber" <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.
>>
>>
>>
>>
>>

>
> Received on Thu Sep 20 2001 - 22:18:35 CDT