Database Backup and Recovery (MOSC)

MOSC Banner

RMAN incremental merge

edited May 18, 2009 8:52PM in Database Backup and Recovery (MOSC) 1 commentAnswered
Hi,
I am running Level 0 on Sunday and Level 1 on all week days.

LEVEL 0:

run {
backup archivelog all delete input;
BACKUP INCREMENTAL LEVEL 0 TAG=LEVEL_0 DATABASE;
}

LEVEL 1:

run {
backup archivelog all delete input;
BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG LEVEL_0 DATABASE;
RECOVER COPY OF DATABASE WITH TAG LEVEL_0;
}

Questions: Here my Level 0  will create "backup set" instead of image copies of the db files.
When it's time to run LEVEL 1 with the incremental merge "FOR RECOVER OF COPY WITH TAG LEVEL_0", it will need image copies. Since they are not created, RMAN will create all image copies of LEVEL 0. The previously created "backup set" by my LEVEL 0 is useless for the use of "incremental merge" purpose.

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