Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Recovery re: redo scan question
Below is out of my alert.log. We had two really hard crashes
yesterday.
Isn't there a V$ view I can look at during the redo scan and recovery
to
see redo blocks increasing or decreasing for status and progress?
V$recovery_file_status, V$recovery_progress, v$recovery_stats, v$instance_recovery, v$recovery_log, and V$recover_file all showed "no rows selected" or0.
TIA.
Dianna G.
4-DEC-2006 14:28:07.75:
Completed redo scan
490788 redo blocks read, 71025 data blocks need recovery
4-DEC-2006 14:38:01.32:
Started recovery at
Thread 1: logseq 100106, block 64, scn 0.0
Recovery of Online Redo Log: Thread 1 Group 2 Seq 100106 Reading mem 0
Mem# 0 errs 0: DATA49:[V500.DB_PROD]ORA1_LOG_2A.RDO
Mem# 1 errs 0: DATA50:[V500.DB_PROD]ORA1_LOG_2B.RDO
4-DEC-2006 14:38:15.41:
Recovery of Online Redo Log: Thread 1 Group 8 Seq 100107 Reading mem 0
Mem# 0 errs 0: DATA49:[V500.DB_PROD]ORA1_LOG_8A.RDO
Mem# 1 errs 0: DATA50:[V500.DB_PROD]ORA1_LOG_8B.RDO
4-DEC-2006 14:38:21.58:
Completed redo application
4-DEC-2006 14:43:52.01:
Ended recovery at
Thread 1: logseq 100107, block 144867, scn 2.779768274
71025 data blocks read, 71025 data blocks written, 490788 redo blocks
read
4-DEC-2006 14:44:24.66:
Crash recovery completed successfully
Picked broadcast on commit scheme to generate SCNs
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Dec 05 2006 - 10:44:00 CST
![]() |
![]() |