Database Backup and Recovery (MOSC)

MOSC Banner

RMAN delete incremental backups or recover copy of

edited Jul 5, 2017 10:33AM in Database Backup and Recovery (MOSC) 11 commentsAnswered

Hi,

I'm looking for a backup solution to accomplish multiple Level 0 incremental backups without the incremental level 1 backup in between.

Even better would be to be able to do a PITR during the last 2 weeks, have 4 weekly Lvl0 backups during the last month and have 2 monthly backups

Database version is 11.2.0.4

Current situation is:

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 30 DAYS;

Every Sunday

run {

backup incremental level 0 device type disk tag 'dbatst_full' database;

backup device type disk tag 'dbatst_full' archivelog all not backed up delete all input;

delete noprompt obsolete device type disk;

}

Every Weekday

run {

backup incremental level 1 device type disk tag 'dbatst_inc' database;

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