An Oracle 11.2.0.4.7 4-nodes RAC on linux env, the fourth instance has this problem just, When the monitoring tool queries the usage of ASM DISKGroup, the query of V$asm_disk and v$asm_diskgroup has not been completed. from ASM INSTANCE found that waiting for ‘enq: DD – contention’...
alter database datafile 'undofile' resize BIGGER_SIZE; the first step avoid undo extent reused by system 2. we will provide procedure better_flashback_table_query , check how many rows can be recovered 3. we will provide procedure better_flashback_table_save , which will recover data and s...
export PATH=${ORACLE_HOME}/bin:${PATH} DG=`sqlplus -s ‘/as sysasm’ < /ora00/grid/Mani/dg.log export ORACLE_HOME=/ora01/app/oracle/product/11.2.0/db_1 export ORACLE_SID=nwe5o export PATH=${ORACLE_HOME}/bin:${PATH} FROM DBA_REGISTERED_ARCHIVED_LOG R, DBA_CAPTURE C, V$ASM_...