Enable DDL Auditing in Oracle
Enable DDL logging in Oracle can be done in several ways. Enable the parameter ENABLE_DDL_LOGGING in Oracle 12c Enable the audit of the database and enable DDL auditing on objects…
Enable DDL logging in Oracle can be done in several ways. Enable the parameter ENABLE_DDL_LOGGING in Oracle 12c Enable the audit of the database and enable DDL auditing on objects…
Check the Size and free space in ASM Disks set pagesize 200 set lines 200 set long 1000 col path for a50 col name for a10 col header_Status for a12…
ORA-31650: timeout waiting for master process response Error During execution of EXPDP or IMPDP, we are getting the following error: Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0…
Check the Size of Oracle Database and PDB databases Following Queries for NON-CDB database: Check the database size physical consume on disk.select sum(bytes)/1024/1024 size_in_mb from dba_data_files; Check the total…
Trace logon failure in Oracle In Oracle we are going to trace the logon session which is not successfully for some reasons. Trace with Auditing 1. Check the auditing…
Check physical Standby is in sync Dataguard The following command will help to check the Standby is synced with Primary Database in Oracle Dataguard Environment. On Primary Server: Check…
Undo tablespace is used for the rollback of the transaction when commit or rollback occurs during the transaction. The system will give preference to the DML operations against the undo…
ORA-19527: physical standby redo log must be renamed Error:ORA-19527: physical standby redo log must be renamedORA-00312: online log 7 thread 0: ‘G:ORACLEORADATASTANDBY05.LOG’ At DR site, we got the error…
Steps verify for Switchover Dataguard to physical standby Before Switchover the Dataguard in production Server. You need to check the value of switch over column in v$database.If it having…
Step to resize standby redolog files In Data-guard, if we recreate or add the standby redolog files due to thread number issue or Size mentioned wrong then in that…