Re: Backup of Oracle on Solaris 2.6

If it's a production system that you don't want to loose, I'd use a "grandfather" backup scheme. It's a good scheme that protects you pretty well... It also keeps the wear on your tapes to an acceptable level so you dont wind up using old tapes more than you need to by using a rotation schedule. I have a simple version of this that I can send you if you want.

As for the database itself, put it in archive mode, and direct the archive redo logs to a nice cozy directory. Back them up daily and you can rebuild back to the point in time of your last set of logs. If you mirror them (Oracle can do this I think) on another system,(NFS drive, etc) you can essentially rebuild the database back to the exact point of failure.

I'm no expert but I hope this helps -
Reply vs email

On 2 Mar 1998 00:53:01 GMT, panceri_at_charlie.cns.iit.edu (Eric D Pancer) wrote:

>
> Hello.
>
>Hoping there are some suggestions for a backup solution that I am
>currently writing a spec for. We are in need of backing up everythingj
>that is changed in Oracle each day, as well as a full backup of the
>database each week. If needed , I can provide more info on request (by
>then I should have it!!)
>
>I would just like to know what those that have gone thru this before
>suggest, in regards to saving what to disk each night, and what to tape.
>
>Thanks in advance...
>
>CC mail appreciated.
>
>Eric
>eric_at_REMOVETHISWORD.outlook.net
Received on Thu Mar 05 1998 - 00:00:00 CST