How Can I Get the Retention Policy for Archive Logs Maintained by Oracle RMAN?

Question

How can I find the retention policy for archive logs maintained by Oracle Recovery Manager (RMAN)?

Environment

• Connector: Oracle
• Connector: Oracle E-Business Suite
• Connector: Oracle RAC
• Connector: Amazon RDS for Oracle

Answer

Execute the following query to get the retention policy for archive logs maintained by Oracle RMAN:

SELECT VALUE FROM "V$RMAN_CONFIGURATION" WHERE NAME = 'RETENTION POLICY';