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 …
-
OracleRac
Change network interface and subnet address by OIFCFG command in RAC Environment
by tuanlpby tuanlpOracle Clusterware requires that each node is connected through a private network. You can also called cluster interconnect. It used for established communication between all the nodes present in the …