DBA Hub

📋Steps in this guide1/4

Retention Policy in RMAN

RMAN> configure retention policy to redundancy 2;

oracle configurationintermediate
by OracleDba
14 views
1

Configuring Retention Policy to number of copies

When we issue this command RMAN will mark obsolete those backups which are older than 15 days.

Code/Command (click line numbers to comment):

1
RMAN> configure retention policy to recovery window of 15 days;
2

Viewing obsolete backups

To view backups which have become obsolete according to the current retention policy you can give the following command

Code/Command (click line numbers to comment):

1
RMAN> report obsolete;
3

Deleting Obsolete Backups

Code/Command (click line numbers to comment):

1
RMAN> delete obsolete;
4

Checking the status of Retention Policy

Type the following command to know the currently configured RETENTION POLICY Resetting RETENTION POLICY to default You can reset the RETENTION POLICY to default value by giving the following command

Code/Command (click line numbers to comment):

1
2
3
RMAN> show retention policy;

RMAN> configure retention policy clear;

Comments (0)

Please to add comments

No comments yet. Be the first to comment!