Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Crash Recoveries
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
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,
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
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
Jon Received on Fri Apr 19 2002 - 03:04:12 CDT