Re: Backup Strategy - Multiple schema database

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: 15 Dec 2006 05:44:48 -0800
Message-ID: <1166190288.812848.76160@16g2000cwy.googlegroups.com>

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. Received on Fri Dec 15 2006 - 07:44:48 CST