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

Home -> Community -> Usenet -> c.d.o.server -> Re: Crash Recoveries

Re: Crash Recoveries

From: Jonathan Bliss <bliss_jonathan_at_hotmail.com>
Date: 19 Apr 2002 01:04:12 -0700
Message-ID: <ae530df0.0204190004.397bf0be@posting.google.com>


norwoodthree_at_my-deja.com (NorwoodThree) wrote in message news:<ba03e2c.0204181016.44d1dde1_at_posting.google.com>...
> Thanks for the info...
>
> You've got a very interesting problem, that's for sure. I'm going to
> check the bug database for you...
>
> In the meantime, can you post the contents of your export log and/or
> more of your alert.log when this happens? Thanks.

Below is some log stuff

Export.log

Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
Export done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character set

About to export the entire database ...

. exporting tablespace definitions
. exporting profiles
. exporting user definitions
. exporting roles
. exporting resource costs

<snip>
. exporting default and system auditing options . exporting statistics
Export terminated successfully without warnings.

SELECT * FROM V$LOGFILE
/

    GROUP# STATUS MEMBER

---------- ------- --------------------------------------------------
         1 STALE   D:\ORANT817\ORADATA\ORCL\REDO01.LOG
         2         D:\ORANT817\ORADATA\ORCL\REDO02.LOG
         3         D:\ORANT817\ORADATA\ORCL\REDO03.LOG
         4 STALE   D:\ORANT817\ORADATA\ORCL\REDO04.LOG

And the alert.log file between second startup one night and first startup the second.

Crash recovery completed successfully
Tue Apr 16 23:05:43 2002
Thread 1 advanced to log sequence 1400
Thread 1 opened at log sequence 1400
  Current log# 4 seq# 1400 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO04.LOG Successful open of redo thread 1.
Tue Apr 16 23:05:43 2002
SMON: enabling cache recovery
SMON: enabling tx recovery
Tue Apr 16 23:05:48 2002
Completed: alter database open
Wed Apr 17 17:31:54 2002
Thread 1 advanced to log sequence 1401
  Current log# 1 seq# 1401 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG Wed Apr 17 17:32:13 2002
Thread 1 advanced to log sequence 1402
  Current log# 2 seq# 1402 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO02.LOG Wed Apr 17 17:32:37 2002
Thread 1 advanced to log sequence 1403
  Current log# 3 seq# 1403 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO03.LOG Wed Apr 17 17:33:00 2002
Thread 1 advanced to log sequence 1404
  Current log# 4 seq# 1404 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO04.LOG Dump file d:\ORACLE\admin\ORCL\bdump\ORCLALRT.LOG Thu Apr 18 00:46:07 2002
ORACLE V8.1.7.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows NT Version 4.0 Service Pack 4, CPU type 586 Starting up ORACLE RDBMS Version: 8.1.7.0.0. System parameters with non-default values:

  processes                = 200
  timed_statistics         = TRUE
  shared_pool_size         = 22000000
  large_pool_size          = 614400
  java_pool_size           = 32768
  nls_date_format          = DD-MON-RR
  control_files            = d:\ORACLE\oradata\ORCL\control01.ctl,
d:\ORACLE\oradata\ORCL\control02.ctl,
e:\ORACLE\oradata\ORCL\control03.ctl
  db_block_buffers         = 30000
  db_block_size            = 4096
  compatible               = 8.1.6.0.0
  log_buffer               = 32768
  log_checkpoint_interval  = 10000
  log_checkpoint_timeout   = 1800
  db_files                 = 1024
  db_file_multiblock_read_count= 16
  max_enabled_roles        = 96
  remote_login_passwordfile= SHARED
  db_domain                = WORLD
  global_names             = TRUE
  distributed_transactions = 500
  instance_name            = ORCL
  service_names            = ORCL.WORLD
  sort_area_size           = 1048576
  sort_area_retained_size  = 1048576
  db_name                  = ORCL
  open_cursors             = 400
  ifile                    = d:\ORACLE\admin\ORCL\pfile\initORCL.ora
  os_authent_prefix        = 
  optimizer_mode           = RULE
  text_enable              = TRUE
  parallel_max_servers     = 5
  background_dump_dest     = d:\ORACLE\admin\ORCL\bdump
  user_dump_dest           = d:\ORACLE\admin\ORCL\udump
  max_dump_file_size       = 10240

  oracle_trace_collection_name=
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7

Thu Apr 18 00:46:09 2002
alter database mount exclusive
Successful mount of redo thread 1, with mount id 2260812054. Thu Apr 18 00:46:14 2002
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive Thu Apr 18 00:46:14 2002
alter database open
Beginning crash recovery of 1 threads
Thu Apr 18 00:46:15 2002
Thread recovery: start rolling forward thread 1 Recovery of Online Redo Log: Thread 1 Group 4 Seq 1404 Reading mem 0   Mem# 0 errs 0: D:\ORANT817\ORADATA\ORCL\REDO04.LOG Thu Apr 18 00:46:16 2002
Thread recovery: finish rolling forward thread 1 Thread recovery: 0 data blocks read, 0 data blocks written, 0 redo blocks read
Crash recovery completed successfully

Jon Received on Fri Apr 19 2002 - 03:04:12 CDT

Original text of this message

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