Unusually long time to finish recovery

From: <Rhojel_Echano_at_sgs.com>
Date: Wed, 19 May 2004 15:12:41 +0800
Message-ID: <OFA02AB6A2.91C58A6F-ON48256E99.0025BBD1-48256E99.002788D6@sgs.com>

Hi everyone,
My problem: Our site SA restarted our production DB host (Win2000 Advanced Server)

                          to fix some Windows related-problem, according 
to him. After the server
                  restarted, the alert log showed ORA-1113. I issued a 
recovery command
                  and was surprised that recovery needed an archived redo 
log that was 24 hours
                          old! Why is this so?

Background: EE ver 8.1.7.4. This DB is a recent clone of our activated standby database.

                           Please don't make me explain why, damagement's 
Business reovery procedure 
                           testing byproduct!

Instance recovery parameters:

log_checkpoint_interval              10000
log_checkpoint_timeout                1800
fast_start_io_target                     638976

V$INSTANCE_RECOVERY :

RECOVERY_ESTIMATED_IOS                  : 2496
ACTUAL_REDO_BLKS                                : 10086
TARGET_REDO_BLKS                                : 9999
LOG_FILE_SIZE_REDO_BLKS                 : 117965
LOG_CHKPT_TIMEOUT_REDO_BLKS     : 71579

LOG_CHKPT_INTERVAL_REDO_BLKS : 10000
FAST_START_IO_TARGET_REDO_BLKS : 161802 Thanks for any help!

Best regards,
Rhojel Echano

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Received on Wed May 19 2004 - 02:10:30 CDT