This is an example based on Oracle 12c 12.1.0.2 with PSU July 2015 Single PDB configuration. I found last week some objects in my PDBs related to the auditing that were not compiled and in INVALID state. OBJECT_TYPE OWNER OBJECT_NAME ————– ——- ———– VIEW SYS DBA_FGA_AUDIT_TRAIL VIEW SYS DBA_COMMON_AUDIT_TRAIL VIEW SYS FGA_LOG$FOR_EXPORT PUBLIC SYNONYM DBA_FGA_AUDIT_TRAIL […]
Oracle rman backups cleanup – database decommissioning
This simple step by step instruction shows how to get rid of the old database’s rman backups and unregister that db from RMAN. This is useful especially when you are decommissioning the databases. Remember – leaving out deleting the backups from both the rman catalog and media library catalog, may lead to orphaned backups on your backup […]