Database Backup and Recovery (MOSC)

MOSC Banner

Backup incremental level 0; VS RECOVER COPY OF DATABASE

edited Sep 10, 2015 10:00AM in Database Backup and Recovery (MOSC) 7 commentsAnswered

Hi guys,

as it written in Documentation, best practice is to schedule a daily incremental backup, and a weekly full backup.

RECOVER COPY OF DATABASE WITH TAG 'OSS';

BACKUP DEVICE TYPE DISK INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG 'OSS' DATABASE;

BACKUP DEVICE TYPE SBT ARCHIVELOG ALL;

BACKUP BACKUPSET ALL;

DELETE ARCHIVELOG ALL;

---------------------

the question is:

why do we need to do a weekly full backup, when we do "RECOVER COPY OF DATABASE WITH TAG 'OSS';" before each "INCREMENTAL LEVEL 1", is that doesn't mean .. that the old backup will be rolled forward to the last SCN, which means .. the old backup will be just like 'full backup' ? right ...

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