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 …

  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 …

  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 …

 LOG_ARCHIVE_DEST_n: this parameter is used to transfer the archived redo from the primary database to standby database. Standby to primary in case of switchover. Note: LOG_ARCHIVE_DEST_n destination must have either …

 1. Identify your SQL ID of SQL Query which need to trace. SELECT sql_id, plan_hash_value, substr(sql_text,1,40) sql_textFROM v$sqlWHERE sql_text like ‘SQL QUERY%’;2. Enable the trace of SQL with using SQLID …

 Error in Alert Log Sun Nov 25 02:14:17 2018Unable to allocate memory for new incident error in file E:ORACLE12Cdiagrdbmsicictraceic_m001_6448.trc:ORA-04030: out of process memory when trying to allocate 20520 bytes (pga …

  Configure the Shared Single Client Access Name (SCAN) Single Client Access NameIn release 11g, SCAN is introduced, In SCAN act as cluster alias,you does not need to change the …

 1. Stop all the services running on the Node srvctl stop service -db database_name -service “service_name_list” -node node_name–Examplesrvctl stop service -db grid -service “sales,oltp” -node NODE1 2. Check the VIP …