Re: New to Oracle and have Backup Question..
From: Palooka <nobody_at_nowhere.com>
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 <ndit..._at_yahoo.com> wrote:
>
> 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_Overview.htm
> http://www.oracle.com/technology/deploy/availability/htdocs/RMAN_Overview.htm
>
>
Sigh Received on Tue Feb 03 2009 - 18:55:39 CST
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 <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_Overview.htm
> http://www.oracle.com/technology/deploy/availability/htdocs/RMAN_Overview.htm
>
>
Sigh Received on Tue Feb 03 2009 - 18:55:39 CST