Re: Backup Strategy - Multiple schema database

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.

EVERY Oracle database is multi-schema. As soon as you shake it out of the box you have schemas for SYS, SYSTEM, DBSNMP, and several others based on the installation options you chose. The schemas you build yourself are just more of the same.

Backup strategy remains the same. Run in archivelog mode and take regular on-line backups of the db and the archivelog files. For a little extra flexibility, add a daily export with consistent=y.

I'm not aware of the ability to do a point-in-time recovery of an individual schema, but I've never explored it. Given the need for complete database consistency, I don't see how that would be possible, but am open for further education. Here's my reasoning: given tables in the schema FRED and the schema DAVE; given a transaction that updates a table in both FRED and DAVE. Now, how do you achive a PIT recovery of just FRED and yet maintain consistency across the database? Received on Fri Dec 15 2006 - 07:52:27 CST