Wednesday , April 24 2024

How To List RMAN Jobs


It is often time consuming job to gather detailed information about the backups of Oracle databases with RMAN. You need to collect information from many different environments. However, it is easier to access RMAN backup information with queries.

You can reach detailed information about the backups taken in the last x days with the following query.

Using the session_recid and session_stamp information obtained from the above query, you can access the backupset details created in the corresponding RMAN session by the following query.

By using session_recid and session_stamp information, it is possible to access the outputs of the operations performed in the corresponding RMAN session with the following query.

You can also find detailed information about the running RMAN jobs.


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 *