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…