Check the dataguard status for two Node RAC If you have 3 Node RAC then you can add more union clause and copy paste the select query from union clause …
-
-
Error: ORA-00018 maximum number of sessions exceeded SQL> drop table test; drop table test * ERROR at line 1: ORA-00018: maximum number of sessions exceeded Cause: Maximum number of session …
-
<aside> 💡 Steps to move the Oracle Grid Home location in Oracle Environment </aside> Login with root user, Stop CRS services. cd /u01/app/12.2.0/grid/bin ./crsctl stop crs ./crsctl stop cluster Login with …
-
Error ORA-04031: unable to allocate nnn bytes of shared memory Solution Need to add more memory to the Shared pool area. Check the size of memory allocate to shared_pool_size, shared_pool_reserved_size …
-
DataguardOracle
Check Status of generated, Received & Applied Archive log in Oracle Dataguard
by tuanlpby tuanlpCheck the Generated archive log in Primary Database –Run on Primary Server: select thread#, max(sequence#) “Last Primary Seq Generated” from v$archived_log val, v$database vdb where val.resetlogs_change# = vdb.resetlogs_change# group by …
-
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 …
-
What is Active DataGuard DML Redirection? Active Dataguard DML Redirection feature present in Oracle 19c. In this feature DML(insert/update/delete) operation can performed on Standby Database which redirected to Primary Database …
-
OracleTroubleshoot
ORA-16397: statement redirection from Oracle Active Data Guard standby database to primary database failedWhat is Active DataGuard DML Redirection?
by tuanlpby tuanlpError: Following error occurred during insert/DML operation on the Standby side of Active Dataguard in Oracle. On Standby Database: [oracle@orcl19c ~]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 – Production …