Re: New to Oracle and have Backup Question..

From: <>
Date: Tue, 3 Feb 2009 15:28:51 -0800 (PST)
Message-ID: <>

On Feb 3, 11:16 pm, 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.
> Have fun...!
> BD

Its not only the "backups" but to know how to recover from it in case they need it.
so my best advice would be - read and understand the backup & recovery thoroughly and then suggest.

Shweta Received on Tue Feb 03 2009 - 17:28:51 CST

Original text of this message