Database Backup and Recovery (MOSC)

MOSC Banner

RMAN question regarding configuring OPTIMIZATION ON and "report need backup" command.

edited Dec 21, 2011 1:41PM in Database Backup and Recovery (MOSC) 6 commentsAnswered
hi,

I have serveral read-only tablespaces for holding old date range partions. Once a month I switch these tablespace to read write and move a new partition into the tablespace and then switch the tablespace back to read only. I wanted to avoid backing up these datafiles every night so I turned optimization on. My rman backups seem to be working as expected - I see the datafiles for these tablespaces are being skipped except after data is added or when the last backup has aged out of the system. Recently I ran the command report need backup:

RMAN> report need backup;

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