Re: Backup Strategy - Multiple schema database

EscVector wrote:
> On Dec 15, 8:44 am, "hpuxrac" <johnbhur..._at_sbcglobal.net> wrote:
> > Noghri64 wrote:
> > > At a high level, what is the recommended backup strategy for a
> > > multi-schema (100s) 24/7 database?
> > > Database has a high volume of DML activity.
> > > Point-in-time recovery is required on occasions for specific schemas.
> >
> > > Thanks.You probably want a daily backup with perhaps some extra runs to pickup
> > archive logs.
> >
> > Do you have a service level agreement? If not maybe you want to think
> > about that area.
> >
> > Depending on size of the database you might want to look at incremental
> > backups.
> >
> > You didn't say what version of oracle you are running. If you are
> > running from 9i up rman is recommended. It had some issues prior to 9i
> > and at least in my opinion wasn't fully useable.
> >
> > Test out your backup and recovery strategy periodically. Have it all
> > documented so you don't have to remember how to do things in the middle
> > of the night.
>
> Counter point: Used RMAN to backup multiple 8.1.7.4 database on Solaris
> 8. Never had any issues with backup or restore other than "crosscheck"
> because the unaware sometimes gzip archivelogs. Backup of 300-500gbo
> took approx 45 min to tape LT700 using 6 channels using libobk for
> netbackup media management. Tapes were dedicated during the backup
> window. Backups were called using rman, not the netbackup interface.
> Everyone was happy.

Ok then if you got all the way up to 8.1.7.4 then maybe it was ok sometimes.

Did you not understand the "at least in my opinion part"? Received on Fri Dec 15 2006 - 10:55:16 CST