Re: New to Oracle and have Backup Question..

From: <shweta.kaparwan_at_googlemail.com>
Date: Tue, 3 Feb 2009 15:28:51 -0800 (PST)
Message-ID: <f9f439c0-780b-4a81-931a-6de446a29262_at_k36g2000pri.googlegroups.com>



On Feb 3, 11:16 pm, BD <robert.d..._at_gmail.com> wrote:
> On Feb 3, 2:39 pm, newsqlman <ndit..._at_yahoo.com> 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.
>
> http://www.oracle.com/technology/deploy/availability/htdocs/BR_Overvi...http://www.oracle.com/technology/deploy/availability/htdocs/RMAN_Over...
>
> Have fun...!
>
> BD

Hi
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.

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

Original text of this message