We run 9i.
I've just been doing some reading about 10g and the Flashback
technology. Sounds like this could do the trick. Anybody have
experience with Flashback?
On Dec 15, 11:55 am, "hpuxrac" <johnbhur..._at_sbcglobal.net> wrote:
> 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 - 13:49:24 CST
