How To Change Backup Retention AND Delete Obsolete Backup On RMAN

dbtut

6 years ago

First, we connect to the node where the database is located with ssh.

After loading the database’s profile, we connect to RMAN with the command below.

rman target /

1	rman target /

You can read the following articles to load profiles and connect to RMAN.

“How To Connect To Oracle With sqlplus“,

“How To Create .profile File To Connect The Oracle“

The following command displays all rman configurations.

show all;

show all;

We change the backup retention with the following command.

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;

1	CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;

Then, with the following command, we do the necessary checks to delete metadata information in the control file that has metadata information but has not a backup file in RMAN.

crosscheck backup;

1	crosscheck backup;

The following command also deletes metadata information detected by crosscheck from the control file.

delete expired backupset;

1	delete expired backupset;

Then we delete all backups that can be deleted with the following command.

delete obsolete device type disk;

1	delete obsolete device type disk;