Recovery re: redo scan question

From: "DIANNA GIBBS" <DIANNA.GIBBS@xxxxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>, "cerner_dbarchitecture" <cerner_dbarchitecture@xxxxxxxxxxxxxxxxxxx>, "IOUG Cerner SIG" <ioug-cerner@xxxxxxxxxxxx>
Date: Tue, 05 Dec 2006 10:44:00 -0600

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

--
//www.freelists.org/webpage/oracle-l

Recovery re: redo scan question

Other related posts: