Database Backup and Recovery (MOSC)

MOSC Banner

Question on RMAN backup - FULL Database plus Archive Logs

edited May 21, 2010 9:18PM in Database Backup and Recovery (MOSC) 5 commentsAnswered
  Hi

Let us suppose that we have a database with following data files

1. users.dbf  =  1000 MB
2. undo.dbf   =  1000 MB
3. system.dbf =  1000 MB
4. sysaux.dbf =  1000 MB

REDO LOGS are sized at 100MB each and every day the database generates 10 LOG SWITCHES, i,e, 1000 MB per day

We have configured the retention windows to 3 days
we have configured RMAN to make backup sets
we have configured the Rman FULL Database plus archive log backup to run every night at midnight


At the end of Day 1, the Rman backup is triggered at midnight

So, the backup of DAY 1 will include all the 4 datafiles plus 10 archive logs (1 thru 10). So far so good

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