Sunday , September 24 2023

How To Change Backup Retention AND Delete Obsolete Backup On RMAN


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.


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.


We change the backup retention with the following command.


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.


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


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


About dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *