Database Backup and Recovery (MOSC)

MOSC Banner

Best option for excluding read-only tablespaces.

edited Oct 25, 2011 5:06PM in Database Backup and Recovery (MOSC) 4 commentsAnswered ✓
Hello, I think I have found 3 ways to exclude read-only tablespaces from backups:

1. configure exclude for tablespace xxxx;

2. configure optimization on;

Or while doing the backup:

3. backup database .... skip read only;

Any thoughts on preference to one over the others?

This is my particular situation. I have 2 read only tablespaces. Once a month I have a job that alters tablespaces to read-write and moves a partition into the tablespace and then switch it back to read-only. I have daily incremental and weekly full backups for the whole databases running. My goal is to only backup the read-only tablespaces when necessary (initially, after the read-write/read-only switch, if the backup gets removed from disk).

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center