Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Recovery re: redo scan question

Recovery re: redo scan question

From: DIANNA GIBBS <DIANNA.GIBBS_at_childrens.com>
Date: Tue, 05 Dec 2006 10:44:00 -0600
Message-Id: <45754D70020000AF00001528@CNET3.CHILDRENS.COM>

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" or
0.

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-l
Received on Tue Dec 05 2006 - 10:44:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US