Test the Unified Audit Policy

-

 

Test the Unified Audit Policy

SELECT DBUSERNAME, SQL_TEXT, EVENT_TIMESTAMP

FROM UNIFIED_AUDIT_TRAIL WHERE DBUSERNAME = 'SYS' and event_timestamp like '12-JAN%' and sql_text like 'ALTER%';

Comments

Post a Comment

Popular posts from this blog

Enabling Transparent Data Encryption (TDE) in Oracle RAC on ODA with Data Guard – The Correct and Secure Approach

-
Image
Transparent Data Encryption (TDE) is a critical security feature in Oracle Database that protects sensitive data at rest by encrypting datafiles, tablespaces, or specific columns. In modern enterprise environments especially Oracle RAC deployments on Oracle Database Appliance (ODA) with Data Guard TDE implementation must be done carefully to avoid service disruption, Data Guard lag, or wallet inconsistencies. This article walks through the correct, production-safe method to enable TDE with Auto-Login Wallet while ensuring: ·                No exposure of sensitive credentials ·                Consistency across RAC nodes ·                Seamless synchronization with the physical standby   ⚠️ Important: This guide assumes Oracle Database 19c on ODA, RAC Primary, ...
Read more

Resolving ORA-10635 and ORA-39171 Errors During BLOB Tablespace Maintenance

-
Recently, I came across an interesting situation while performing a space management task on one of our databases. The challenge involved a table that contained BLOB data distributed across multiple tablespaces . What seemed like a simple shrink operation ended up turning into a deeper learning experience that I’d like to share. 🧩 Background In this environment, the main table BINARY_ARCHIVE was stored in the MAIN_DATA tablespace. Its BLOB segment was placed separately in the ATTACHMENTS_DATA tablespace to improve performance and manage large object storage efficiently. Additionally, another table called BINARY_OBJECT_LINK maintained a foreign key reference to the BLOB data and resided in the LINK_DATA tablespace. When I attempted to reclaim space from the BLOB segment using the SHRINK SPACE command, Oracle returned the following error. ⚠️ The Error ORA -10635 : Invalid segment or tablespace type 10635. 00000 - " Invalid segment or tablespace type " *Ca...
Read more

How I Use RMAN’s Auxiliary Destination to Recover Tables Safely

-
Image
If you’ve ever had to recover a single table in Oracle without touching the rest of your database, you know it can feel like performing surgery on a live patient. That’s where RMAN ’s auxiliary destination comes to the rescue. What Is the Auxiliary Destination? In simple terms, it’s a temporary workspace where Oracle can safely restore and recover a table before it goes back into the main database. Think of it as a sandbox: everything happens there first, away from the production environment, so nothing breaks if something goes wrong. When I first started using it, I was worried about messing up live data. But once I understood the concept, it made table-level recovery so much smoother. Why You Need It You can’t just yank a table out of a backup and drop it into a running database—especially if users are working on it. RMAN needs a safe place to do its magic : It restores the table from backups. It applies redo logs to bring the table to the exact point-in-time you nee...
Read more