Re: New to Oracle and have Backup Question..

From: Palooka <>
Date: Wed, 04 Feb 2009 00:55:39 +0000
Message-ID: <fI5il.421$CH4.315_at_newsfe18.ams2>

BD wrote:
> On Feb 3, 2:39 pm, newsqlman <> wrote:
>> I'm new to Oracle and have a question for someone that I started
>> trying to help out.  They are using Oracle for a DB server and
>> currently don't backup anything nightly or weekly.  I'm sure there is
>> a way to set Oracle up to Backup nightly to a file on the hard drive
>> somewhere so that the backup software can back those database files up
>> to tape.  I would prefer not loading a backup agent like Symantec
>> Veritas has because of the expense and usually running the DB backup
>> utility and maintenance procedures tend to work quite well in a small
>> environment.  I currently have several SQL setups doing that without
>> any DB Backup agent and am hoping to help him with the same type
>> setup.
>> Any thoughts?
>> Thanks.

> One option is a Cold backup
> -Shut down your db instance for a time each night; the tape backup
> software will back up all the database files in a consistent state
> A cold backup once a week, combined with backing up archive logs each
> night, is also a pretty reasonable strategy, and not all that
> complicated to implement. Just make sure someone's educated themselves
> on (and clearly documented) disaster recovery procedures involving
> cold backups and archive logs.
> You'll also want to read about RMAN. No need for backup outages when
> you're using RMAN.
> I won't bother saying anything specific about it; you should likely
> just go straight to the Oracle Docs and start reading. But RMAN is
> pretty much the de facto backup and recovery tool for Oracle dbs.
> Here's a couple of links.

Sigh Received on Tue Feb 03 2009 - 18:55:39 CST

Original text of this message