Re: New to Oracle and have Backup Question..

From: BD <>
Date: Tue, 3 Feb 2009 15:16:31 -0800 (PST)
Message-ID: <>

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.

Have fun...!

BD Received on Tue Feb 03 2009 - 17:16:31 CST

Original text of this message