RMAN : RMAN is an Oracle Database client and every DBA’s favorite tool for backup and recovery of the database. We have many RMAN related posts which can help you in all scenarios .

However, today we will see a basic RMAN commands that will show what RMAN offers you. This post is mainly for DBAs who want to explore RMAN from scratch

To connect RMAN for your particular database , you need to use target clause , let us see how

Just set your ORACLE_SID and give / for your target , your database will connected to your desired database

Every DBA’s second command will be show all where you will see list of configuration with your database .

Note : If your database is new then you will see default configurations for each configuration

Now, if your database has already have some backup taken previously we can check it using list backup command .

Crosscheck Backup : This command will check the list of backup available in metadata is physically available or not . If it is physically deleted than it will give an EXPIRED status to those backup

We can see in above output first backup piece is expired as it is physically deleted from file system.

REPORT OBSOLETE :
In RMAN backups which goes out of retention policy are considered as obsolete backup .

Delete backup or delete obsolete :

We can delete OBSOLETE backup using delete obsolete command :

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Telegram Channel: https://t.me/helporacle

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

About The Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.