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 …

 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 …