Re: alter system dump logfile

[Manoj Kumar Jha]

Title: alter system dump logfile

Please check : oradebug DUMPLIST as given below... SQL>   oradebug    dumplist EVENTS TRACE_BUFFER_ON TRACE_BUFFER_OFF HANGANALYZE LATCHES PROCESSSTATE SYSTEMSTATE INSTANTIATIONSTATE REFRESH_OS_STATS CROSSIC CONTEXTAREA HEAPDUMP HEAPDUMP_ADDR POKE_ADDRESS POKE_LENGTH POKE_VALUE POKE_VALUE0 GLOBAL_AREA MEMORY_LOG REALFREEDUMP ERRORSTACK HANGANALYZE_PROC TEST_STACK_DUMP BG_MESSAGES ENQUEUES SIMULATE_EOV KSFQP_LIMIT KSKDUMPTRACE DBSCHEDULER GRANULELIST GRANULELISTCHK SCOREBOARD GES_STATE ADJUST_SCN NEXT_SCN_WRAP CONTROLF FULL_DUMPS BUFFERS RECOVERY SET_TSN_P1 BUFFER PIN_BLOCKS BC_SANITY_CHECK FLUSH_CACHE LOGHIST ARCHIVE_ERROR REDOHDR LOGERROR OPEN_FILES DATA_ERR_ON DATA_ERR_OFF BLK0_FMTCHG TR_SET_BLOCK TR_SET_ALL_BLOCKS TR_SET_SIDE TR_CRASH_AFTER_WRITE TR_READ_ONE_SIDE TR_CORRUPT_ONE_SIDE TR_RESET_NORMAL TEST_DB_ROBUSTNESS LOCKS GC_ELEMENTS FILE_HDRS KRB_CORRUPT_INTERVAL KRB_CORRUPT_SIZE KRB_PIECE_FAIL KRB_OPTIONS KRB_SIMULATE_NODE_AFFINITY KRB_TRACE KRB_BSET_DAYS DROP_SEGMENTS TREEDUMP LONGF_CREATE ROW_CACHE LIBRARY_CACHE SHARED_SERVER_STATE KXFPCLEARSTATS KXFPDUMPTRACE KXFPBLATCHTEST KXFXSLAVESTATE KXFXCURSORSTATE WORKAREATAB_DUMP OBJECT_CACHE SAVEPOINTS OLAP_DUMP ----- Original Message ----- From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Sent: Thursday, August 28, 2003 9:09 PM Subject: alter system dump logfile Hi all, as mentioned in Metalink article, one can use "ALTER SYSTEM DUMP LOGFILE ... LAYER 11 OPCODE 3" to dump deleted rows from archived logs. does anyone know 1. what others layers are and what they correspond to? 2. what other opcodes are and what they relate to? TIA Raj -------------------------------------------------------------------------------- Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !