Re: Oracle 7 Crash on NT4 !

Check with your NT Admins and see if they are running any type of backups during the night using any type of "open file manager" to backup open files. If they are and the backup is hitting the Oracle datafiles while the database is up and running, you can get some nasty corruption.

Merlin Team wrote:
>
> Hello there.
>
> I hope someone can point me in the right direction with a problem on Oracle
> 7.3.2.3.1. on NT4.
>
> It would appear that something goes wrong at approx 23:09 every Tuesday !
> There is a scheduled hot backup done at 20:30 every night which lasts about
> 1 hour at most but
> the database appears to have started up ok after that.It then dies and shuts
> down the instance.
> The other 3 databases on the same server continue ok. The only way I have
> found to recover the
> situation is to restore from the Tues backup.
>
> I have included parts of various log/trace files below.
>
> TIA
>
> Eric Penninton
> eric_merlin_at_hotmail.com
>
> S002SNP.TRC
>
> ----- Dump of the Fixed UGA -----
> arg arg [170A914, 170A918) = 0000ABAB
> arg arg [170A918, 170A91C) = 0170A91C
> arg arg [170A91C, 170A9D8) = 006B27A8 0000108C 078D92F8 01712394 01710230
> ...
> Dump of memory from 170A930 to 170A9D8
> 170A920 00000000 00000000 020A0200
> 00000000
> 170A940 0000108C 73736573 206E6F69 70616568 00000000 7FFF7FFF 00207FFF
> 00000000
> 170A960 0000004C 0171324C 0171324C 0000008C 0170A970 0170A970 0000010C
> 0170A97C
> 170A980 0170A97C 0000020C 0170A988 0170A988 0000040C 017123A4 017123A4
> 0000080C
> 170A9A0 0170A9A0 0170A9A0 0000100C 0170A9AC 0170A9AC 0000200C 0170A9B8
> 0170A9B8
> 170A9C0 0000400C 0170A9C4 0170A9C4 0000800C 0170A9D0 0170A9D0
> arg arg [170A9D8, 170A9DC) = 00000000
> arg arg [170A9DC, 170AAB4) = 0170A91C 00000000 017107B8 00000000 00000000
> ...
> Dump of memory from 170A9F0 to 170AAB4
> 170A9E0 00000000 00000000 00000000
> 00000000
> 170AA00 00000000 00000000 00000000 00000000 00000000 00000000 00000000
> 00000000
> Repeat 3 times
> 170AA80 00000000 00000000 00000000 0170AA8C 0170AA8C 00000032 00000000
> 00000001
> 170AAA0 00000000 00000000 00000000 00000000 00000000
> arg arg [170AAB4, 170AAC4) = 00000000 00000000 0170A4F8 0170A91C
> arg arg [170AAC4, 170AB44) = 00000000 00000000 00000000 00000000 00000000
> ...
> Dump of memory from 170AAD8 to 170AB44
> 170AAC0 00000000
> 00000000
> 170AAE0 00000000 00000000 00000000 00000000 00000000 00000000 00000000
> 00000000
> Repeat 2 times
> 170AB40 00000000
> arg arg [170AB44, 170AB48) = 07874700
> arg arg [170AB48, 170AB4C) = 00000000
> arg arg [170AB4C, 170AB74) = 00000000 00000000 00000000 00000000 00000000
> ...
> Dump of memory from 170AB60 to 170AB74
> 170AB60 00000000 00000000 00000000 00000000 00000000
> arg arg [170AB74, 170ABB4) = 00000000 00000000 00000000 00000000 00000000
> ...
> Dump of memory from 170AB88 to 170ABB4
> 170AB80 00000000 00000000 00000000 00000000 00000000
> 00000000
> 170ABA0 00000000 00000000 00000000 00000000 00000000
> arg arg [170ABB4, 170ABB8) = 00000000
> arg arg [170ABB8, 170ABBC) = 00000000
> arg arg [170ABBC, 170AC00) = 0170A510 0170A62C 0170A754 52454D41 4E414349
> ...
> Dump of memory from 170ABD0 to 170AC00
> 170ABC0 00000000 00000000 00000000
> 00000000
> 170ABE0 00000000 00000000 00000000 00000000 00000000 00000000 00000000
> 00407C00
> arg arg [170AC00, 170AC08) = 00058BC4 00000000
> arg arg [170AC08, 170AC0C) = 00000000
> arg arg [170AC0C, 170AC10) = 00000000
> arg arg [170AC10, 170AC14) = 7FFFFFFF
> arg arg [170AC14, 170AC18) = 00000000
> arg arg [170AC18, 170AC1C) = 00000000
> arg arg [170AC1C, 170AC20) = 00000000
> arg arg [170AC20, 170AC24) = 00000000
> arg arg [170AC24, 170AC34) = 0170AC24 0170AC24 0170AC2C 0170AC2C
> arg arg [170AC34, 170AC38) = 00000000
> arg arg [170AC38, 170AC3C) = 00000000
> arg arg [170AC3C, 170AC44) = 00000000 00000000
> arg arg [170AC44, 170AC50) = 00000002 00000000 00000000
> arg arg [170AC50, 170AC54) = 00000000
> arg arg [170AC54, 170ACAC) = 00000000 00000000 00000000 00000000 FFFFFFFF
> ...
> Dump of memory from 170AC68 to 170ACAC
> 170AC60 FFFFFFFF FFFFFFFF 00000000 00000000 00000000
> 00000000
> 170AC80 00000000 00000000 00000000 00000000 00000000 00000001 00000000
> 00000002
> 170ACA0 00000000 00000000 00000000
> arg arg [170ACAC, 170ACB0) = 00000000
> arg arg [170ACB0, 170ACB4) = 00000000
> arg arg [170ACB4, 170ACB8) = 00000000
> arg arg [170ACB8, 170ACD8) = 00000000 00000000 00000000 00000000 00000000
> ...
> Dump of memory from 170ACCC to 170ACD8
> 170ACC0 00000000 00000000 02000000
> arg arg [170ACD8, 170ACE4) = 00000000 00000000 00000000
> arg arg [170ACE4, 170ACE8) = 00000000
> arg arg [170ACE4, 170ACE8) = 00000000
> arg arg [170ACE8, 170ACEC) = 00000000
> arg arg [170ACEC, 170ACF0) = 0171081C
> arg arg [170ACF0, 170AD1C) = 00000000 00000000 00000000 00000000 00000000
> ...
> Dump of memory from 170AD04 to 170AD1C
> 170AD00 00000000 00000000 00000000 00000000 00000000 00000000
> arg arg [170AD1C, 170AD20) = 00000000
> arg arg [170AD20, 170AD24) = 00000000
> arg arg [170AD24, 170AD28) = 00000000
> arg arg [170AD28, 170AD68) = 00000000 00000000 00000000 00000000 00000000
> ...
> Dump of memory from 170AD3C to 170AD68
> 170AD20
> 00000000
> 170AD40 00000000 00000000 00000000 00000000 00000000 00000000 00000000
> 00000000
> 170AD60 00000000 00000000
> arg arg [170AD68, 170AD6C) = 00000000
> arg arg [170AD6C, 170AD70) = 00000000
> arg arg [170AD70, 170AD74) = 00000000
> arg arg [170AD70, 170AD74) = 00000000
> arg arg [170AD74, 170AD78) = 00000000
> arg arg [170AD78, 170AD7C) = 00000000
> arg arg [170AD7C, 170AD80) = 00000000
> arg arg [170AD80, 170AD84) = 0000CDCD
> kgefec: fatal error 0
> Tue Mar 16 23:29:39 1999
> ksedmp: internal or fatal error
> ORA-00603: ORACLE server session terminated by fatal error
> ORA-00376: file 8 cannot be read at this time
> ORA-01110: data file 8: 'D:\ORANT\DATABASE\CONTAUTH\ROLLBACK\ROLLBACK02.DBF'
> ORA-00376: file 8 cannot be read at this time
> ORA-01110: data file 8: 'D:\ORANT\DATABASE\CONTAUTH\ROLLBACK\ROLLBACK02.DBF'
> Current SQL information unavailable - no session.
>
> ****************************************************************************
> ****************
>
> S002SNP.TRC
>
> ----- Dump of the Fixed UGA -----
> arg arg [171A91C, 171A920) = 0000ABAB
> arg arg [171A920, 171A924) = 0171A924
> arg arg [171A924, 171A9E0) = 006A0CE8 0000108C 078D7A08 0172239C 01720238
> ...
> Dump of memory from 171A938 to 171A9E0
> 171A920 00000000
> 00000000
> 171A940 020A0200 00000000 0000108C 73736573 206E6F69 70616568 00000000
> 7FFF7FFF
> 171A960 00207FFF 00000000 0000004C 01723254 01723254 0000008C 0171A978
> 0171A978
> 171A980 0000010C 0171A984 0171A984 0000020C 0171A990 0171A990 0000040C
> 017223AC
> 171A9A0 017223AC 0000080C 0171A9A8 0171A9A8 0000100C 0171A9B4 0171A9B4
> 0000200C
> 171A9C0 0171A9C0 0171A9C0 0000400C 0171A9CC 0171A9CC 0000800C 0171A9D8
> 0171A9D8
> arg arg [171A9E0, 171A9E4) = 00000000
> arg arg [171A9E4, 171AABC) = 0171A924 00000000 017207C0 00000000 00000000
> ...
> Dump of memory from 171A9F8 to 171AABC
> 171A9E0 00000000
> 00000000
> 171AA00 00000000 00000000 00000000 00000000 00000000 00000000 00000000
> 00000000
> Repeat 3 times
> 171AA80 00000000 00000000 00000000 00000000 00000000 0171AA94 0171AA94
> 00000032
> 171AAA0 00000000 00000001 00000000 00000000 00000000 00000000 00000000
> arg arg [171AABC, 171AACC) = 00000000 00000000 0171A500 0171A924
> arg arg [171AACC, 171AB4C) = 00000000 00000000 00000000 00000000 00000000
> ...
> Dump of memory from 171AAE0 to 171AB4C
> 171AAE0 00000000 00000000 00000000 00000000 00000000 00000000 00000000
> 00000000
> Repeat 2 times
> 171AB40 00000000 00000000 00000000
> arg arg [171AB4C, 171AB50) = 07873410
> arg arg [171AB50, 171AB54) = 00000000
> arg arg [171AB54, 171AB7C) = 00000000 00000000 00000000 00000000 00000000
> ...
> Dump of memory from 171AB68 to 171AB7C
> 171AB60 00000000 00000000 00000000 00000000 00000000
> arg arg [171AB7C, 171ABBC) = 00000000 00000000 00000000 00000000 00000000
> ...
> Dump of memory from 171AB90 to 171ABBC
> 171AB80 00000000 00000000 00000000
> 00000000
> 171ABA0 00000000 00000000 00000000 00000000 00000000 00000000 00000000
> arg arg [171ABBC, 171ABC0) = 00000000
> arg arg [171ABC0, 171ABC4) = 00000000
> arg arg [171ABC4, 171AC08) = 0171A518 0171A634 0171A75C 52454D41 4E414349
> ...
> Dump of memory from 171ABD8 to 171AC08
> 171ABC0 00000000
> 00000000
> 171ABE0 00000000 00000000 00000000 00000000 00000000 00000000 00000000
> 00000000
> 171AC00 00000000 00407C00
> arg arg [171AC08, 171AC10) = 00058BC4 00000000
> arg arg [171AC10, 171AC14) = 00000000
> arg arg [171AC14, 171AC18) = 00000000
> arg arg [171AC18, 171AC1C) = 7FFFFFFF
> arg arg [171AC1C, 171AC20) = 00000000
> arg arg [171AC20, 171AC24) = 00000000
> arg arg [171AC24, 171AC28) = 00000000
> arg arg [171AC28, 171AC2C) = 00000000
> arg arg [171AC2C, 171AC3C) = 0171AC2C 0171AC2C 0171AC34 0171AC34
> arg arg [171AC3C, 171AC40) = 00000000
> arg arg [171AC40, 171AC44) = 00000000
> arg arg [171AC44, 171AC4C) = 00000000 00000000
> arg arg [171AC4C, 171AC58) = 00000002 00000000 00000000
> arg arg [171AC58, 171AC5C) = 00000000
> arg arg [171AC5C, 171ACB4) = 00000000 00000000 00000000 00000000 FFFFFFFF
> ...
> Dump of memory from 171AC70 to 171ACB4
> 171AC60 FFFFFFFF FFFFFFFF 00000000
> 00000000
> 171AC80 00000000 00000000 00000000 00000000 00000000 00000000 00000000
> 00000001
> 171ACA0 00000000 00000002 00000000 00000000 00000000
> arg arg [171ACB4, 171ACB8) = 00000000
> arg arg [171ACB8, 171ACBC) = 00000000
> arg arg [171ACBC, 171ACC0) = 00000000
> arg arg [171ACC0, 171ACE0) = 00000000 00000000 00000000 00000000 00000000
> ...
> Dump of memory from 171ACD4 to 171ACE0
> 171ACC0 00000000 00000000
> 02000000
> arg arg [171ACE0, 171ACEC) = 00000000 00000000 00000000
> arg arg [171ACEC, 171ACF0) = 00000000
> arg arg [171ACEC, 171ACF0) = 00000000
> arg arg [171ACF0, 171ACF4) = 00000000
> arg arg [171ACF4, 171ACF8) = 01720824
> arg arg [171ACF8, 171AD24) = 00000000 00000000 00000000 00000000 00000000
> ...
> Dump of memory from 171AD0C to 171AD24
> 171AD00 00000000 00000000 00000000 00000000
> 00000000
> 171AD20 00000000
> arg arg [171AD24, 171AD28) = 00000000
> arg arg [171AD28, 171AD2C) = 00000000
> arg arg [171AD2C, 171AD30) = 00000000
> arg arg [171AD30, 171AD70) = 00000000 00000000 00000000 00000000 00000000
> ...
> Dump of memory from 171AD44 to 171AD70
> 171AD40 00000000 00000000 00000000 00000000 00000000 00000000
> 00000000
> 171AD60 00000000 00000000 00000000 00000000
> arg arg [171AD70, 171AD74) = 00000000
> arg arg [171AD74, 171AD78) = 00000000
> arg arg [171AD78, 171AD7C) = 00000000
> arg arg [171AD78, 171AD7C) = 00000000
> arg arg [171AD7C, 171AD80) = 00000000
> arg arg [171AD80, 171AD84) = 00000000
> arg arg [171AD84, 171AD88) = 00000000
> arg arg [171AD88, 171AD8C) = 0000CDCD
> kgefec: fatal error 0
> Tue Mar 16 23:29:37 1999
> ksedmp: internal or fatal error
> ORA-00603: ORACLE server session terminated by fatal error
> ORA-00376: file 8 cannot be read at this time
> ORA-01110: data file 8: 'D:\ORANT\DATABASE\CONTAUTH\ROLLBACK\ROLLBACK02.DBF'
> ORA-00376: file 8 cannot be read at this time
> ORA-01110: data file 8: 'D:\ORANT\DATABASE\CONTAUTH\ROLLBACK\ROLLBACK02.DBF'
> Current SQL information unavailable - no session.
>
> ****************************************************************************
> **************
>
> S002LGWR.TRC
>
> Tue Mar 16 20:30:08 1999
> ORACLE V7.3.2.3.1 - Production Release vsnsta=0
> vsnsql=b vsnxtr=3
> Windows NT V4.0, OS V5.101, CPU type 586
> Dump file D:\ORANT\RDBMS73\trace\s002LGWR.TRC
> Tue Mar 16 20:34:07 1999
> ORACLE V7.3.2.3.1 - Production Release vsnsta=0
> vsnsql=b vsnxtr=3
> Windows NT V4.0, OS V5.101, CPU type 586
> Dump file D:\ORANT\RDBMS73\trace\s002LGWR.TRC
> Thu Mar 18 09:56:49 1999
> ORACLE V7.3.2.3.1 - Production Release vsnsta=0
> vsnsql=b vsnxtr=3
> Windows NT V4.0, OS V5.101, CPU type 586
>
> ****************************************************************************
> *************
>
> S002RECO.TRC
>
> Tue Mar 16 20:30:08 1999
> ORACLE V7.3.2.3.1 - Production Release vsnsta=0
> vsnsql=b vsnxtr=3
> Windows NT V4.0, OS V5.101, CPU type 586
> Dump file D:\ORANT\RDBMS73\trace\s002RECO.TRC
> Tue Mar 16 20:34:07 1999
> ORACLE V7.3.2.3.1 - Production Release vsnsta=0
> vsnsql=b vsnxtr=3
> Windows NT V4.0, OS V5.101, CPU type 586
> Dump file D:\ORANT\RDBMS73\trace\s002RECO.TRC
> Thu Mar 18 09:56:49 1999
> ORACLE V7.3.2.3.1 - Production Release vsnsta=0
> vsnsql=b vsnxtr=3
> Windows NT V4.0, OS V5.101, CPU type 586
>
> ****************************************************************************
> *************
>
> S002DBWR.TRC
>
> Tue Mar 16 20:30:07 1999
> ORACLE V7.3.2.3.1 - Production Release vsnsta=0
> vsnsql=b vsnxtr=3
> Windows NT V4.0, OS V5.101, CPU type 586
> Dump file D:\ORANT\RDBMS73\trace\s002DBWR.TRC
> Tue Mar 16 20:34:07 1999
> ORACLE V7.3.2.3.1 - Production Release vsnsta=0
> vsnsql=b vsnxtr=3
> Windows NT V4.0, OS V5.101, CPU type 586
> Oracle7 Server Release 7.3.2.3.1 - Production Release
> With the distributed, replication and parallel query options
> PL/SQL Release 2.3.2.3.0 - Production
> Windows NT V4.0, OS V5.101, CPU type 586
> Instance name: s002
>
> Redo thread mounted by this instance: 1
>
> Oracle process number: 3
>
> pid: 18df
>
> Tue Mar 16 23:09:28 1999
>
> *** SESSION ID:(2.1) 1999.03.16.23.09.28.406
> KCF: write/open error dba=0x8000ff1 block=0xff1 online=1
> file=8 D:\ORANT\DATABASE\CONTAUTH\ROLLBACK\ROLLBACK02.DBF
> error=9205 txt: 'OSD-04016: Error queuing an asynchronous I/O request.
> (OS 33)'
> Automatic datafile offline due to write error on
> file 8: D:\ORANT\DATABASE\CONTAUTH\ROLLBACK\ROLLBACK02.DBF
> KCF: write/open error dba=0x80008e4 block=0x8e4 online=0
> file=8 D:\ORANT\DATABASE\CONTAUTH\ROLLBACK\ROLLBACK02.DBF
> error=9205 txt: 'OSD-04016: Error queuing an asynchronous I/O request.
> (OS 33)'
> Dump file D:\ORANT\RDBMS73\trace\s002DBWR.TRC
> Thu Mar 18 09:56:49 1999
> ORACLE V7.3.2.3.1 - Production Release vsnsta=0
> vsnsql=b vsnxtr=3
> Windows NT V4.0, OS V5.101, CPU type 586
>
> ****************************************************************************
> **********
>
> S002ARCH.TRC
>
> Tue Mar 16 20:30:07 1999
> ORACLE V7.3.2.3.1 - Production Release vsnsta=0
> vsnsql=b vsnxtr=3
> Windows NT V4.0, OS V5.101, CPU type 586
> Dump file D:\ORANT\RDBMS73\trace\s002ARCH.TRC
> Tue Mar 16 20:34:07 1999
> ORACLE V7.3.2.3.1 - Production Release vsnsta=0
> vsnsql=b vsnxtr=3
> Windows NT V4.0, OS V5.101, CPU type 586
> Dump file D:\ORANT\RDBMS73\trace\s002ARCH.TRC
> Thu Mar 18 09:56:49 1999
> ORACLE V7.3.2.3.1 - Production Release vsnsta=0
> vsnsql=b vsnxtr=3
> Windows NT V4.0, OS V5.101, CPU type 586
>
> ****************************************************************************
> ************
>
> S002ALRT.LOG
>
> Mon Mar 15 00:53:18 1999
> Beginning database checkpoint by background
> Completed database checkpoint by background
> Mon Mar 15 01:53:19 1999
> Beginning database checkpoint by background
> Completed database checkpoint by background
> Mon Mar 15 02:53:20 1999
> Beginning database checkpoint by background
> Completed database checkpoint by background
> Mon Mar 15 03:53:20 1999
> Beginning database checkpoint by background
> Completed database checkpoint by background
> Mon Mar 15 04:53:20 1999
> Beginning database checkpoint by background
> Completed database checkpoint by background
> Mon Mar 15 05:53:21 1999
> Beginning database checkpoint by background
> Completed database checkpoint by background
> Mon Mar 15 06:53:22 1999
> Beginning database checkpoint by background
> Completed database checkpoint by background
> Mon Mar 15 07:53:22 1999
> Beginning database checkpoint by background
> Completed database checkpoint by background
> Mon Mar 15 08:53:23 1999
> Beginning database checkpoint by background
> Completed database checkpoint by background
> Mon Mar 15 09:53:23 1999
> Beginning database checkpoint by background
> Completed database checkpoint by background
> Mon Mar 15 10:53:24 1999
> Beginning database checkpoint by background
> Completed database checkpoint by background
> Mon Mar 15 11:53:24 1999
> Beginning database checkpoint by background
> Completed database checkpoint by background
> Mon Mar 15 12:53:25 1999
> Beginning database checkpoint by background
> Completed database checkpoint by background
> Mon Mar 15 13:53:25 1999
> Beginning database checkpoint by background
> Completed database checkpoint by background
> Mon Mar 15 13:57:21 1999
> Beginning database checkpoint by background
> Thread 1 advanced to log sequence 1198
> Current log# 3 seq# 1198 mem# 0:
> D:\ORANT\DATABASE\CONTAUTH\REDO\LOG3S002.ORA
> Completed database checkpoint by background
> Mon Mar 15 14:57:21 1999
> Beginning database checkpoint by background
> Completed database checkpoint by background
> Mon Mar 15 15:57:21 1999
> Beginning database checkpoint by background
> Completed database checkpoint by background
> Mon Mar 15 16:57:22 1999
> Beginning database checkpoint by background
> Completed database checkpoint by background
> Mon Mar 15 17:57:22 1999
> Beginning database checkpoint by background
> Completed database checkpoint by background
> Mon Mar 15 18:57:23 1999
> Beginning database checkpoint by background
> Completed database checkpoint by background
> Mon Mar 15 19:57:23 1999
> Beginning database checkpoint by background
> Completed database checkpoint by background
> Mon Mar 15 20:30:02 1999
> Shutting down instance (immediate)
> License high water mark = 8
> Mon Mar 15 20:30:02 1999
> ALTER DATABASE CLOSE NORMAL
> Mon Mar 15 20:30:03 1999
> SMON: disabling tx recovery
> SMON: disabling cache recovery
> Mon Mar 15 20:30:03 1999
> Thread 1 closed at log sequence 1198
> Current log# 3 seq# 1198 mem# 0:
> D:\ORANT\DATABASE\CONTAUTH\REDO\LOG3S002.ORA
> Mon Mar 15 20:30:03 1999
> Completed: ALTER DATABASE CLOSE NORMAL
> Mon Mar 15 20:30:03 1999
> ALTER DATABASE DISMOUNT
> Completed: ALTER DATABASE DISMOUNT
> Starting up ORACLE RDBMS Version: 7.3.2.3.1.
> System parameters with non-default values:
> processes = 200
> license_max_sessions = 20
> shared_pool_size = 9000000
> nls_date_format = DD-MON-RR
> control_files = D:\ORANT\DATABASE\ctl1s002.ora,
> D:\ORANT\DATABASE\ctl2s002.ora
> compatible = 7.3.2.0.0
> log_archive_start = TRUE
> log_archive_dest = d:\orant\database\contauth\archivelog
> log_archive_format = archca%S.arc
> log_buffer = 163840
> log_checkpoint_interval = 20000
> log_checkpoint_timeout = 3600
> log_checkpoints_to_alert = TRUE
> rollback_segments = Rca_rollback1, Rca_rollback2, Rca_rollback3,
> Rca_rollback4, Rca_rollback5, Rca_rollback6, Rca_rollback7, Rca_rollback8
> sequence_cache_entries = 100
> sequence_cache_hash_buckets= 89
> remote_login_passwordfile= EXCLUSIVE
> global_names = TRUE
> distributed_lock_timeout = 300
> mts_servers = 0
> mts_max_servers = 0
> mts_max_dispatchers = 0
> audit_trail = NONE
> sort_area_retained_size = 65536
> sort_direct_writes = AUTO
> db_name = contauth
> job_queue_processes = 2
> job_queue_interval = 10
> snapshot_refresh_processes= 1
> background_dump_dest = %RDBMS73%\trace
> user_dump_dest = %RDBMS73%\trace
> max_dump_file_size = 10240
>
> Mon Mar 15 20:30:07 1999
>
> PMON started
> Mon Mar 15 20:30:07 1999
>
> DBWR started
> Mon Mar 15 20:30:07 1999
>
> ARCH started
> Mon Mar 15 20:30:07 1999
>
> LGWR started
> Mon Mar 15 20:30:07 1999
>
> RECO started
> Mon Mar 15 20:30:07 1999
>
> SNP0 started
> Mon Mar 15 20:30:07 1999
>
> SNP1 started
> Mon Mar 15 20:30:07 1999
> alter database mount exclusive
> Mon Mar 15 20:30:07 1999
> Successful mount of redo thread 1.
> Mon Mar 15 20:30:07 1999
> Completed: alter database mount exclusive
> Mon Mar 15 20:30:07 1999
> alter database open
> Mon Mar 15 20:30:08 1999
> Thread 1 opened at log sequence 1198
> Current log# 3 seq# 1198 mem# 0:
> D:\ORANT\DATABASE\CONTAUTH\REDO\LOG3S002.ORA
> Successful open of redo thread 1.
> Mon Mar 15 20:30:08 1999
> SMON: enabling cache recovery
> SMON: enabling tx recovery
> Mon Mar 15 20:30:10 1999
> Completed: alter database open
> Mon Mar 15 20:30:13 1999
> alter tablespace SYSTEM begin backup
> Completed: alter tablespace SYSTEM begin backup
> Mon Mar 15 20:30:34 1999
> alter tablespace SYSTEM end backup
> Mon Mar 15 20:30:34 1999
> Completed: alter tablespace SYSTEM end backup
> Mon Mar 15 20:30:34 1999
> alter tablespace PCA_TEMP begin backup
> Completed: alter tablespace PCA_TEMP begin backup
> Mon Mar 15 20:31:09 1999
> alter tablespace PCA_TEMP end backup
> Mon Mar 15 20:31:09 1999
> Completed: alter tablespace PCA_TEMP end backup
> Mon Mar 15 20:31:09 1999
> alter tablespace TCA_AUDIT begin backup
> Completed: alter tablespace TCA_AUDIT begin backup
> Mon Mar 15 20:31:14 1999
> alter tablespace TCA_AUDIT end backup
> Completed: alter tablespace TCA_AUDIT end backup
> Mon Mar 15 20:31:14 1999
> alter tablespace TCA_AUTHORHELD begin backup
> Completed: alter tablespace TCA_AUTHORHELD begin backup
> Mon Mar 15 20:31:40 1999
> alter tablespace TCA_AUTHORHELD end backup
> Mon Mar 15 20:31:40 1999
> Completed: alter tablespace TCA_AUTHORHELD end backup
> Mon Mar 15 20:31:40 1999
> alter tablespace TCA_KEYSHELD begin backup
> Completed: alter tablespace TCA_KEYSHELD begin backup
> Mon Mar 15 20:31:52 1999
> alter tablespace TCA_KEYSHELD end backup
> Mon Mar 15 20:31:52 1999
> Completed: alter tablespace TCA_KEYSHELD end backup
> Mon Mar 15 20:31:52 1999
> alter tablespace TCA_REFERENCE begin backup
> Completed: alter tablespace TCA_REFERENCE begin backup
> Mon Mar 15 20:31:55 1999
> alter tablespace TCA_REFERENCE end backup
> Completed: alter tablespace TCA_REFERENCE end backup
> Mon Mar 15 20:31:55 1999
> alter tablespace KCA_RBS01 begin backup
> ORA-1128 signalled during: alter tablespace KCA_RBS01 begin backup...
> Mon Mar 15 20:32:08 1999
> alter tablespace KCA_RBS01 end backup
> Mon Mar 15 20:32:08 1999
> ORA-1142 signalled during: alter tablespace KCA_RBS01 end backup...
> Mon Mar 15 20:32:08 1999
> alter tablespace KCA_RBS02 begin backup
> Completed: alter tablespace KCA_RBS02 begin backup
> Mon Mar 15 20:32:20 1999
> alter tablespace KCA_RBS02 end backup
> Mon Mar 15 20:32:20 1999
> Completed: alter tablespace KCA_RBS02 end backup
> Mon Mar 15 20:32:20 1999
> alter tablespace TCA_SAFETYAUDIT begin backup
> Completed: alter tablespace TCA_SAFETYAUDIT begin backup
> Mon Mar 15 20:32:26 1999
> alter tablespace TCA_SAFETYAUDIT end backup
> Completed: alter tablespace TCA_SAFETYAUDIT end backup
> Mon Mar 15 20:32:26 1999
> alter tablespace TCA_STAFFLINK begin backup
> Completed: alter tablespace TCA_STAFFLINK begin backup
> Mon Mar 15 20:33:36 1999
> alter tablespace TCA_STAFFLINK end backup
> Mon Mar 15 20:33:36 1999
> Completed: alter tablespace TCA_STAFFLINK end backup
> Mon Mar 15 20:33:36 1999
> alter tablespace XCA_AUDIT begin backup
> Completed: alter tablespace XCA_AUDIT begin backup
> Mon Mar 15 20:33:38 1999
> alter tablespace XCA_AUDIT end backup
> Completed: alter tablespace XCA_AUDIT end backup
> Mon Mar 15 20:33:38 1999
> alter tablespace XCA_HELD begin backup
> Completed: alter tablespace XCA_HELD begin backup
> Mon Mar 15 20:33:51 1999
> alter tablespace XCA_HELD end backup
> Mon Mar 15 20:33:51 1999
> Completed: alter tablespace XCA_HELD end backup
> Mon Mar 15 20:33:51 1999
> alter tablespace XCA_MISC begin backup
> Completed: alter tablespace XCA_MISC begin backup
> Mon Mar 15 20:33:52 1999
> alter tablespace XCA_MISC end backup
> Completed: alter tablespace XCA_MISC end backup
> Mon Mar 15 20:33:52 1999
> alter tablespace KCA_RBS01 begin backup
> ORA-1128 signalled during: alter tablespace KCA_RBS01 begin backup...
> Mon Mar 15 20:34:02 1999
> alter tablespace KCA_RBS01 end backup
> ORA-1142 signalled during: alter tablespace KCA_RBS01 end backup...
> Mon Mar 15 20:34:02 1999
> Beginning database checkpoint by background
> Thread 1 advanced to log sequence 1199
> Current log# 2 seq# 1199 mem# 0: D:\ORANT\DATABASE\LOG2S002.ORA
> Completed database checkpoint by background
> Mon Mar 15 20:34:06 1999
> alter database backup controlfile to 'd:\temp\ca\HOT\CTL1S002.ORA' REUSE
> Mon Mar 15 20:34:06 1999
> Completed: alter database backup controlfile to 'd:\temp\ca\H...
> Mon Mar 15 20:34:06 1999
> alter database backup controlfile to 'd:\temp\ca\HOT\CTL2S002.ORA' REUSE
> Completed: alter database backup controlfile to 'd:\temp\ca\H...
> Shutting down instance (immediate)
> License high water mark = 3
> Mon Mar 15 20:34:08 1999
> ALTER DATABASE CLOSE NORMAL
> Mon Mar 15 20:34:08 1999
> SMON: disabling tx recovery
> SMON: disabling cache recovery
> Mon Mar 15 20:34:09 1999
> Thread 1 closed at log sequence 1199
> Current log# 2 seq# 1199 mem# 0: D:\ORANT\DATABASE\LOG2S002.ORA
> Mon Mar 15 20:34:09 1999
> Completed: ALTER DATABASE CLOSE NORMAL
> Mon Mar 15 20:34:09 1999
> ALTER DATABASE DISMOUNT
> Completed: ALTER DATABASE DISMOUNT
> Starting up ORACLE RDBMS Version: 7.3.2.3.1.
> System parameters with non-default values:
> processes = 200
> license_max_sessions = 20
> shared_pool_size = 9000000
> nls_date_format = DD-MON-RR
> control_files = D:\ORANT\DATABASE\ctl1s002.ora,
> D:\ORANT\DATABASE\ctl2s002.ora
> compatible = 7.3.2.0.0
> log_archive_start = TRUE
> log_archive_dest = d:\orant\database\contauth\archivelog
> log_archive_format = archca%S.arc
> log_buffer = 163840
> log_checkpoint_interval = 20000
> log_checkpoint_timeout = 3600
> log_checkpoints_to_alert = TRUE
> rollback_segments = Rca_rollback1, Rca_rollback2, Rca_rollback3,
> Rca_rollback4, Rca_rollback5, Rca_rollback6, Rca_rollback7, Rca_rollback8
> sequence_cache_entries = 100
> sequence_cache_hash_buckets= 89
> remote_login_passwordfile= EXCLUSIVE
> global_names = TRUE
> distributed_lock_timeout = 300
> mts_servers = 0
> mts_max_servers = 0
> mts_max_dispatchers = 0
> audit_trail = NONE
> sort_area_retained_size = 65536
> sort_direct_writes = AUTO
> db_name = contauth
> job_queue_processes = 2
> job_queue_interval = 10
> snapshot_refresh_processes= 1
> background_dump_dest = %RDBMS73%\trace
> user_dump_dest = %RDBMS73%\trace
> max_dump_file_size = 10240
>
> Mon Mar 15 20:34:12 1999
>
> PMON started
> Mon Mar 15 20:34:12 1999
>
> DBWR started
> Mon Mar 15 20:34:12 1999
>
> ARCH started
> Mon Mar 15 20:34:12 1999
>
> LGWR started
> Mon Mar 15 20:34:12 1999
>
> RECO started
> Mon Mar 15 20:34:12 1999
>
> SNP0 started
> Mon Mar 15 20:34:12 1999
>
> SNP1 started
> Mon Mar 15 20:34:12 1999
> alter database mount exclusive
> Mon Mar 15 20:34:12 1999
> Successful mount of redo thread 1.
> Mon Mar 15 20:34:12 1999
> Completed: alter database mount exclusive
> Mon Mar 15 20:34:12 1999
> alter database open
> Mon Mar 15 20:34:13 1999
> Thread 1 opened at log sequence 1199
> Current log# 2 seq# 1199 mem# 0: D:\ORANT\DATABASE\LOG2S002.ORA
> Successful open of redo thread 1.
> Mon Mar 15 20:34:13 1999
> SMON: enabling cache recovery
> SMON: enabling tx recovery
> Mon Mar 15 20:34:14 1999
> Completed: alter database open
> Mon Mar 15 21:34:12 1999
> Beginning database checkpoint by background
> Completed database checkpoint by background
> Mon Mar 15 22:34:13 1999
> Beginning database checkpoint by background
> Completed database checkpoint by background
> Mon Mar 15 23:34:13 1999
> Beginning database checkpoint by background
> Completed database checkpoint by background
> Tue Mar 16 00:34:14 1999
> Beginning database checkpoint by background
> Completed database checkpoint by background
> Tue Mar 16 01:34:15 1999
> Beginning database checkpoint by background
> Completed database checkpoint by background
> Tue Mar 16 02:34:15 1999
> Beginning database checkpoint by background
> Completed database checkpoint by background
> Tue Mar 16 03:34:16 1999
> Beginning database checkpoint by background
> Completed database checkpoint by background
> Tue Mar 16 04:34:16 1999
> Beginning database checkpoint by background
> Completed database checkpoint by background
> Tue Mar 16 05:34:17 1999
> Beginning database checkpoint by background
> Completed database checkpoint by background
> Tue Mar 16 06:34:17 1999
> Beginning database checkpoint by background
> Completed database checkpoint by background
> Tue Mar 16 07:34:18 1999
> Beginning database checkpoint by background
> Completed database checkpoint by background
> Tue Mar 16 08:34:18 1999
> Beginning database checkpoint by background
> Completed database checkpoint by background
> Tue Mar 16 09:34:19 1999
> Beginning database checkpoint by background
> Completed database checkpoint by background
> Tue Mar 16 10:34:19 1999
> Beginning database checkpoint by background
> Completed database checkpoint by background
> Tue Mar 16 11:34:20 1999
> Beginning database checkpoint by background
> Completed database checkpoint by background
> Tue Mar 16 12:34:20 1999
> Beginning database checkpoint by background
> Completed database checkpoint by background
> Tue Mar 16 13:02:35 1999
> Beginning database checkpoint by background
> Thread 1 advanced to log
Received on Sat Mar 20 1999 - 00:00:00 CET