Re: New to Oracle and have Backup Question..
Date: Tue, 3 Feb 2009 15:28:51 -0800 (PST)
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.
> Have fun...!
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