Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ORA-01033 1

Status
Not open for further replies.
CatPlus

CatPlus

Technical User
Joined
Jan 30, 2003
Messages
236
Hello!

We got error message 'ORA-01033' and Oracle remote support determination was that the database was corrupted.

Since no HOT abckup was ever initiated, we had to restore from the last available DMP losing about 2 days of work which had to be re-generated before we could begin day-to-day operations

What are the many factors that would cause database corruption and can it be sabotage?

Is there a way to capture logs that can reveal a cause?

Please advise

Thanks
Mickey
 
Sort by date Sort by votes
Do you have access to the alert log? Perhaps you should be considering putting the DB into archivelog mode to obviate (as far as possible) this kind of thing.

Alan Bennett said:
I don't mind people who aren't what they seem. I just wish they'd make their mind up.
Click to expand...
 
Upvote 0 Downvote
CatPlus,

For the benefit of other readers who might not be aware, "ORA-01033" represents the error, "ORACLE initialization or shutdown in progress".

When this error remains in effect for longer than just a few minutes, it is typically because the database is attempting to startup, but cannot, due to (among other possibilities) a corrupted data file. Regardless of the cause, the reason should, as Ken mentions, appear in your database's alert log.

So that we can be of best help to you, could you please examine the related alert log and post your findings here. (Your posting should include alert contents from the time of the startup command to its current status.)

Also, if your business cannot afford to lose any transactions, then, as Ken also mentions, you must pay the disk-space "insurance premium" of being in ARCHIVELOG mode, which allows you to recover a corrupted database right up until the most recently committed transaction.

You can only do a HOT backup if your database is in ARCHIVELOG mode. Can you please confirm whether or not the database is, in fact, in ARCHIVELOG mode? If your database is in ARCHIVELOG mode, you do not need to take HOT backups...COLD (full) backups are also satisfactory.

If your database is NOT in ARCHIVELOG mode, then Oracle will not allow you to produce official Oracle HOT backups...alternately, unofficial HOT backups (i.e., simply copying your database datafiles while the database is up and running, but without the benefit of ARCHIVELOG mode and without your issuing the command, "ALTER TABLESPACE <ts_name> BEGIN BACKUP;" with its counterpart "ALTER TABLESPACE <ts_name> END BACKUP;") then such backups are absolutely useless.

If your database is not in ARCHIVELOG mode, then you cannot hope to recover a database...your best hope is simply to restore the database to its status at the last full, COLD backup.

If your database is in ARCHIVELOG mode, then someone in your organisation had to explicitly place the database into that status. If/when they did so, they should have taken a full COLD/HOT backup (or someone should have taken such a backup since then), else having your database in ARCHIVELOG mode is vitually useless since having a full database backup upon which to base a database recovery is absolutely vital.

So, please advise us regarding both your ARCHIVELOG status and what is happening from your alert log.


[santa]Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
 
Upvote 0 Downvote
Ken and Dave,

Thank you both for your contribution... And yes, we had to hit the rock and find out the importance of having enabled the ARCHIVELOG mode! Meantime, are there parameters you can recommend that can be set to optimize ARCHIVELOG mode

I will retrieve the alert log and post it for your review. I also need to get to the bottom of what happened and whether there we were sabotage striken and I am hoping that the alert log will give us some clues!

Thank you indeed!

 
Upvote 0 Downvote
Hello Mufasa...

I have copied the log below since I did not know how I could have attached it to this thread.

Thank you for your input!

Mickey

+++++++++++++++++++++++++++++++++++++++++++++++++++++++

Tue Sep 26 09:40:21 2006
alter database rename global_name to orcl
Completed: alter database rename global_name to orcl
Tue Sep 26 09:40:22 2006
ALTER TABLESPACE TEMP ADD TEMPFILE 'D:\Oracle\oradata\orcl\TEMP01.DBF' REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
Completed: ALTER TABLESPACE TEMP ADD TEMPFILE 'D:\Oracle\orad
Tue Sep 26 09:40:22 2006
alter database character set INTERNAL_CONVERT WE8MSWIN1252
Updating character set in controlfile to WE8MSWIN1252
Completed: alter database character set INTERNAL_CONVERT WE8M
Tue Sep 26 09:40:27 2006
alter database national character set INTERNAL_CONVERT AL16UTF16
Completed: alter database national character set INTERNAL_CON
Tue Sep 26 09:40:51 2006
Shutting down instance: further logons disabled
Shutting down instance (normal)
License high water mark = 1
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Tue Sep 26 09:40:54 2006
ALTER DATABASE CLOSE NORMAL
Tue Sep 26 09:40:54 2006
SMON: disabling tx recovery
SMON: disabling cache recovery
Tue Sep 26 09:40:54 2006
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 1
Successful close of redo thread 1.
Tue Sep 26 09:40:54 2006
Completed: ALTER DATABASE CLOSE NORMAL
Tue Sep 26 09:40:54 2006
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Tue Sep 26 09:40:58 2006
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 50331648
large_pool_size = 8388608
java_pool_size = 33554432
control_files = D:\Oracle\oradata\orcl\CONTROL01.CTL, D:\Oracle\oradata\orcl\CONTROL02.CTL, D:\Oracle\oradata\orcl\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 25165824
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = orcl
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = D:\Oracle\admin\orcl\bdump
user_dump_dest = D:\Oracle\admin\orcl\udump
core_dump_dest = D:\Oracle\admin\orcl\cdump
sort_area_size = 524288
db_name = orcl
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
aq_tm_processes = 1
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
CJQ0 started with pid=8
QMN0 started with pid=9
Tue Sep 26 09:41:01 2006
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Tue Sep 26 09:41:02 2006
ALTER DATABASE MOUNT
Tue Sep 26 09:41:06 2006
Successful mount of redo thread 1, with mount id 1129929262.
Tue Sep 26 09:41:06 2006
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Tue Sep 26 09:41:07 2006
ALTER DATABASE OPEN
Tue Sep 26 09:41:07 2006
Thread 1 opened at log sequence 1
Current log# 3 seq# 1 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO03.LOG
Successful open of redo thread 1.
Tue Sep 26 09:41:07 2006
SMON: enabling cache recovery
Tue Sep 26 09:41:07 2006
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Tue Sep 26 09:41:07 2006
SMON: enabling tx recovery
Tue Sep 26 09:41:07 2006
Database Characterset is WE8MSWIN1252
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: ALTER DATABASE OPEN
Tue Sep 26 10:06:33 2006
ALTER SYSTEM SET open_cursors=3000 SCOPE=BOTH;
Tue Sep 26 10:54:13 2006
ALTER SYSTEM SET sga_max_size='2000M' SCOPE=SPFILE;
Tue Sep 26 10:56:42 2006
CKPT: Begin resize of buffer pool 3 (DEFAULT for block size 8192)
CKPT: Current size = 24 MB, Target size = 352 MB
CKPT: Could not allocate memory for buffer pool DEFAULT,
blocksize 8192
Tue Sep 26 10:57:40 2006
ALTER SYSTEM SET sga_max_size='2048M' SCOPE=SPFILE;
Tue Sep 26 10:57:50 2006
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 3
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Tue Sep 26 10:57:52 2006
ALTER DATABASE CLOSE NORMAL
Tue Sep 26 10:57:52 2006
SMON: disabling tx recovery
SMON: disabling cache recovery
Tue Sep 26 10:57:52 2006
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 1
Successful close of redo thread 1.
Tue Sep 26 10:57:52 2006
Completed: ALTER DATABASE CLOSE NORMAL
Tue Sep 26 10:57:52 2006
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Tue Sep 26 10:57:59 2006
Starting ORACLE instance (normal)
Tue Sep 26 10:58:12 2006
Starting ORACLE instance (normal)
Tue Sep 26 10:59:22 2006
Starting ORACLE instance (normal)
Tue Sep 26 11:01:40 2006
Starting ORACLE instance (force)
Tue Sep 26 11:04:07 2006
Starting ORACLE instance (normal)
Tue Sep 26 11:08:09 2006
Starting ORACLE instance (normal)
Tue Sep 26 11:08:56 2006
Starting ORACLE instance (normal)
Dump file d:\oracle\admin\orcl\bdump\alert_orcl.log
Tue Sep 26 11:09:29 2006
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 1, CPU type 586
Tue Sep 26 11:09:29 2006
Starting ORACLE instance (normal)
Dump file d:\oracle\admin\orcl\bdump\alert_orcl.log
Tue Sep 26 11:10:43 2006
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 1, CPU type 586
Tue Sep 26 11:10:43 2006
Starting ORACLE instance (normal)
Tue Sep 26 11:11:37 2006
Starting ORACLE instance (normal)
Tue Sep 26 11:12:08 2006
Starting ORACLE instance (normal)
Tue Sep 26 11:16:24 2006
Starting ORACLE instance (normal)
Tue Sep 26 11:20:22 2006
Starting ORACLE instance (normal)
Tue Sep 26 11:20:57 2006
Starting ORACLE instance (normal)
Tue Sep 26 11:22:11 2006
Starting ORACLE instance (normal)
Dump file d:\oracle\admin\orcl\bdump\alert_orcl.log
Tue Sep 26 11:23:01 2006
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 1, CPU type 586
Tue Sep 26 11:23:01 2006
Starting ORACLE instance (normal)
Tue Sep 26 11:24:12 2006
Starting ORACLE instance (normal)
Tue Sep 26 11:27:29 2006
Starting ORACLE instance (normal)
Tue Sep 26 11:30:13 2006
Starting ORACLE instance (normal)
Tue Sep 26 11:34:08 2006
Starting ORACLE instance (normal)
Dump file d:\oracle\admin\orcl\bdump\alert_orcl.log
Tue Sep 26 11:38:25 2006
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 1, CPU type 586
Tue Sep 26 11:38:25 2006
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 50331648
large_pool_size = 8388608
java_pool_size = 33554432
control_files = D:\Oracle\oradata\orcl\CONTROL01.CTL, D:\Oracle\oradata\orcl\CONTROL02.CTL, D:\Oracle\oradata\orcl\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 25165824
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = orcl
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = D:\Oracle\admin\orcl\bdump
user_dump_dest = D:\Oracle\admin\orcl\udump
core_dump_dest = D:\Oracle\admin\orcl\cdump
sort_area_size = 524288
db_name = orcl
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
aq_tm_processes = 1
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
CJQ0 started with pid=8
QMN0 started with pid=9
Tue Sep 26 11:38:28 2006
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Tue Sep 26 11:38:30 2006
alter database mount exclusive
Tue Sep 26 11:38:34 2006
Successful mount of redo thread 1, with mount id 1129934774.
Tue Sep 26 11:38:34 2006
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Tue Sep 26 11:38:34 2006
alter database open
Tue Sep 26 11:38:34 2006
Thread 1 opened at log sequence 1
Current log# 3 seq# 1 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO03.LOG
Successful open of redo thread 1.
Tue Sep 26 11:38:34 2006
SMON: enabling cache recovery
Tue Sep 26 11:38:35 2006
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Tue Sep 26 11:38:35 2006
SMON: enabling tx recovery
Tue Sep 26 11:38:35 2006
Database Characterset is WE8MSWIN1252
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: alter database open
Tue Sep 26 11:47:48 2006
ALTER SYSTEM SET sga_max_size='2048M' SCOPE=SPFILE;
Tue Sep 26 11:47:55 2006
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 3
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Tue Sep 26 11:47:57 2006
ALTER DATABASE CLOSE NORMAL
Tue Sep 26 11:47:57 2006
SMON: disabling tx recovery
SMON: disabling cache recovery
Tue Sep 26 11:47:57 2006
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 1
Successful close of redo thread 1.
Tue Sep 26 11:47:57 2006
Completed: ALTER DATABASE CLOSE NORMAL
Tue Sep 26 11:47:57 2006
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Tue Sep 26 11:48:06 2006
Starting ORACLE instance (normal)
Tue Sep 26 11:49:23 2006
Starting ORACLE instance (normal)
Tue Sep 26 11:50:03 2006
Starting ORACLE instance (normal)
Dump file d:\oracle\admin\orcl\bdump\alert_orcl.log
Tue Sep 26 11:53:18 2006
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 1, CPU type 586
Tue Sep 26 11:53:18 2006
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 50331648
large_pool_size = 8388608
java_pool_size = 33554432
control_files = D:\Oracle\oradata\orcl\CONTROL01.CTL, D:\Oracle\oradata\orcl\CONTROL02.CTL, D:\Oracle\oradata\orcl\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 25165824
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = orcl
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = D:\Oracle\admin\orcl\bdump
user_dump_dest = D:\Oracle\admin\orcl\udump
core_dump_dest = D:\Oracle\admin\orcl\cdump
sort_area_size = 524288
db_name = orcl
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
aq_tm_processes = 1
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
CJQ0 started with pid=8
QMN0 started with pid=9
Tue Sep 26 11:53:21 2006
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Tue Sep 26 11:53:22 2006
alter database mount exclusive
Tue Sep 26 11:53:26 2006
Successful mount of redo thread 1, with mount id 1129974834.
Tue Sep 26 11:53:26 2006
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Tue Sep 26 11:53:26 2006
alter database open
Tue Sep 26 11:53:26 2006
Thread 1 opened at log sequence 1
Current log# 3 seq# 1 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO03.LOG
Successful open of redo thread 1.
Tue Sep 26 11:53:26 2006
SMON: enabling cache recovery
Tue Sep 26 11:53:27 2006
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Tue Sep 26 11:53:27 2006
SMON: enabling tx recovery
Tue Sep 26 11:53:27 2006
Database Characterset is WE8MSWIN1252
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: alter database open
Tue Sep 26 12:06:55 2006
ALTER SYSTEM SET db_cache_size='800M' SCOPE=SPFILE;
Tue Sep 26 12:07:21 2006
ALTER SYSTEM SET shared_pool_size='256M' SCOPE=SPFILE;
Tue Sep 26 12:07:28 2006
Starting ORACLE instance (force)
License high water mark = 3
Instance terminated by USER, pid = 2920
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 268435456
large_pool_size = 8388608
java_pool_size = 33554432
control_files = D:\Oracle\oradata\orcl\CONTROL01.CTL, D:\Oracle\oradata\orcl\CONTROL02.CTL, D:\Oracle\oradata\orcl\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 838860800
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = orcl
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = D:\Oracle\admin\orcl\bdump
user_dump_dest = D:\Oracle\admin\orcl\udump
core_dump_dest = D:\Oracle\admin\orcl\cdump
sort_area_size = 524288
db_name = orcl
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
aq_tm_processes = 1
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
CJQ0 started with pid=8
QMN0 started with pid=9
Tue Sep 26 12:07:32 2006
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Tue Sep 26 12:07:33 2006
ALTER DATABASE MOUNT
Tue Sep 26 12:07:37 2006
Successful mount of redo thread 1, with mount id 1129949317.
Tue Sep 26 12:07:37 2006
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Tue Sep 26 12:07:38 2006
ALTER DATABASE OPEN
Tue Sep 26 12:07:38 2006
Beginning crash recovery of 1 threads
Tue Sep 26 12:07:38 2006
Started first pass scan
Tue Sep 26 12:07:38 2006
Completed first pass scan
1956 redo blocks read, 114 data blocks need recovery
Tue Sep 26 12:07:38 2006
Started recovery at
Thread 1: logseq 1, block 46981, scn 0.0
Recovery of Online Redo Log: Thread 1 Group 3 Seq 1 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\ORCL\REDO03.LOG
Tue Sep 26 12:07:38 2006
Ended recovery at
Thread 1: logseq 1, block 48937, scn 0.236589
114 data blocks read, 114 data blocks written, 1956 redo blocks read
Crash recovery completed successfully
Tue Sep 26 12:07:38 2006
Thread 1 advanced to log sequence 2
Thread 1 opened at log sequence 2
Current log# 1 seq# 2 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG
Successful open of redo thread 1.
Tue Sep 26 12:07:38 2006
SMON: enabling cache recovery
Tue Sep 26 12:07:38 2006
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Tue Sep 26 12:07:38 2006
SMON: enabling tx recovery
Tue Sep 26 12:07:38 2006
Database Characterset is WE8MSWIN1252
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: ALTER DATABASE OPEN
Tue Sep 26 12:09:59 2006
ALTER SYSTEM SET open_cursors=10000 SCOPE=BOTH;
Tue Sep 26 12:21:22 2006
create tablespace orion datafile 'd:\datafile\orion01.dbf' size 4096m
Tue Sep 26 12:22:00 2006
Completed: create tablespace orion datafile 'd:\datafile\orio
Tue Sep 26 12:23:46 2006
alter tablespace orion add datafile 'd:\datafile\orion02.dbf' size 4096m
Tue Sep 26 12:24:25 2006
Completed: alter tablespace orion add datafile 'd:\datafile\o
Tue Sep 26 13:17:48 2006
Thread 1 advanced to log sequence 3
Current log# 2 seq# 3 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO02.LOG
Tue Sep 26 13:18:15 2006
Thread 1 advanced to log sequence 4
Current log# 3 seq# 4 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO03.LOG
Tue Sep 26 13:18:43 2006
Thread 1 advanced to log sequence 5
Current log# 1 seq# 5 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG
Tue Sep 26 13:19:13 2006
Thread 1 advanced to log sequence 6
Current log# 2 seq# 6 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO02.LOG
Tue Sep 26 13:19:43 2006
Thread 1 advanced to log sequence 7
Current log# 3 seq# 7 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO03.LOG
Tue Sep 26 13:20:15 2006
Thread 1 advanced to log sequence 8
Current log# 1 seq# 8 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG
Tue Sep 26 13:20:32 2006
Thread 1 advanced to log sequence 9
Current log# 2 seq# 9 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO02.LOG
Tue Sep 26 13:21:17 2006
Thread 1 advanced to log sequence 10
Current log# 3 seq# 10 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO03.LOG
Tue Sep 26 13:22:04 2006
Thread 1 advanced to log sequence 11
Current log# 1 seq# 11 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG
Tue Sep 26 13:23:08 2006
Thread 1 advanced to log sequence 12
Current log# 2 seq# 12 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO02.LOG
Tue Sep 26 13:23:36 2006
Thread 1 advanced to log sequence 13
Current log# 3 seq# 13 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO03.LOG
Tue Sep 26 13:24:50 2006
Thread 1 advanced to log sequence 14
Current log# 1 seq# 14 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG
Tue Sep 26 13:26:28 2006
Thread 1 advanced to log sequence 15
Current log# 2 seq# 15 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO02.LOG
Tue Sep 26 13:26:47 2006
Thread 1 advanced to log sequence 16
Current log# 3 seq# 16 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO03.LOG
Tue Sep 26 13:26:59 2006
Thread 1 advanced to log sequence 17
Current log# 1 seq# 17 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG
Tue Sep 26 13:27:10 2006
Thread 1 advanced to log sequence 18
Current log# 2 seq# 18 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO02.LOG
Tue Sep 26 13:27:22 2006
Thread 1 advanced to log sequence 19
Current log# 3 seq# 19 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO03.LOG
Tue Sep 26 13:27:33 2006
Thread 1 advanced to log sequence 20
Current log# 1 seq# 20 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG
Tue Sep 26 13:27:45 2006
Thread 1 advanced to log sequence 21
Current log# 2 seq# 21 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO02.LOG
Tue Sep 26 13:27:57 2006
Thread 1 advanced to log sequence 22
Current log# 3 seq# 22 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO03.LOG
Tue Sep 26 13:28:10 2006
Thread 1 advanced to log sequence 23
Current log# 1 seq# 23 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG
Tue Sep 26 13:28:22 2006
Thread 1 advanced to log sequence 24
Current log# 2 seq# 24 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO02.LOG
Tue Sep 26 13:28:58 2006
Thread 1 advanced to log sequence 25
Current log# 3 seq# 25 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO03.LOG
Tue Sep 26 13:29:50 2006
Thread 1 advanced to log sequence 26
Current log# 1 seq# 26 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG
Tue Sep 26 13:31:46 2006
Thread 1 advanced to log sequence 27
Current log# 2 seq# 27 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO02.LOG
Tue Sep 26 13:32:48 2006
Thread 1 advanced to log sequence 28
Current log# 3 seq# 28 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO03.LOG
Tue Sep 26 13:34:08 2006
Thread 1 advanced to log sequence 29
Current log# 1 seq# 29 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG
Tue Sep 26 13:35:12 2006
Thread 1 advanced to log sequence 30
Current log# 2 seq# 30 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO02.LOG
Dump file d:\oracle\admin\orcl\bdump\alert_orcl.log
Tue Sep 26 13:48:05 2006
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 1, CPU type 586
Tue Sep 26 13:48:05 2006
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 268435456
large_pool_size = 8388608
java_pool_size = 33554432
control_files = D:\Oracle\oradata\orcl\CONTROL01.CTL, D:\Oracle\oradata\orcl\CONTROL02.CTL, D:\Oracle\oradata\orcl\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 838860800
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = orcl
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = D:\Oracle\admin\orcl\bdump
user_dump_dest = D:\Oracle\admin\orcl\udump
core_dump_dest = D:\Oracle\admin\orcl\cdump
sort_area_size = 524288
db_name = orcl
open_cursors = 10000
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
aq_tm_processes = 1
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
CJQ0 started with pid=8
QMN0 started with pid=9
Tue Sep 26 13:48:08 2006
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Tue Sep 26 13:48:09 2006
alter database mount exclusive
Tue Sep 26 13:48:14 2006
Successful mount of redo thread 1, with mount id 1129987865.
Tue Sep 26 13:48:14 2006
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Tue Sep 26 13:48:14 2006
alter database open
Tue Sep 26 13:48:14 2006
Beginning crash recovery of 1 threads
Tue Sep 26 13:48:14 2006
Started first pass scan
Tue Sep 26 13:48:15 2006
Completed first pass scan
184193 redo blocks read, 7970 data blocks need recovery
Tue Sep 26 13:48:15 2006
Started recovery at
Thread 1: logseq 30, block 13994, scn 0.0
Recovery of Online Redo Log: Thread 1 Group 2 Seq 30 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\ORCL\REDO02.LOG
Tue Sep 26 13:48:30 2006
Ended recovery at
Thread 1: logseq 30, block 198187, scn 0.454597
7970 data blocks read, 7970 data blocks written, 184193 redo blocks read
Crash recovery completed successfully
Tue Sep 26 13:48:30 2006
Thread 1 advanced to log sequence 31
Thread 1 opened at log sequence 31
Current log# 3 seq# 31 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO03.LOG
Successful open of redo thread 1.
Tue Sep 26 13:48:30 2006
SMON: enabling cache recovery
Tue Sep 26 13:48:31 2006
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Tue Sep 26 13:48:31 2006
SMON: enabling tx recovery
Tue Sep 26 13:48:31 2006
Database Characterset is WE8MSWIN1252
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: alter database open
Dump file d:\oracle\admin\orcl\bdump\alert_orcl.log
Tue Sep 26 13:51:53 2006
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 1, CPU type 586
Tue Sep 26 13:51:53 2006
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 268435456
large_pool_size = 8388608
java_pool_size = 33554432
control_files = D:\Oracle\oradata\orcl\CONTROL01.CTL, D:\Oracle\oradata\orcl\CONTROL02.CTL, D:\Oracle\oradata\orcl\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 838860800
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = orcl
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = D:\Oracle\admin\orcl\bdump
user_dump_dest = D:\Oracle\admin\orcl\udump
core_dump_dest = D:\Oracle\admin\orcl\cdump
sort_area_size = 524288
db_name = orcl
open_cursors = 10000
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
aq_tm_processes = 1
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
CJQ0 started with pid=8
QMN0 started with pid=9
Tue Sep 26 13:51:56 2006
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Tue Sep 26 13:51:57 2006
alter database mount exclusive
Tue Sep 26 13:52:01 2006
Successful mount of redo thread 1, with mount id 1129929213.
Tue Sep 26 13:52:01 2006
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Tue Sep 26 13:52:01 2006
alter database open
Tue Sep 26 13:52:01 2006
Beginning crash recovery of 1 threads
Tue Sep 26 13:52:01 2006
Started first pass scan
Tue Sep 26 13:52:01 2006
Completed first pass scan
845 redo blocks read, 832 data blocks need recovery
Tue Sep 26 13:52:01 2006
Started recovery at
Thread 1: logseq 31, block 3, scn 0.0
Recovery of Online Redo Log: Thread 1 Group 3 Seq 31 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\ORCL\REDO03.LOG
Tue Sep 26 13:52:02 2006
Ended recovery at
Thread 1: logseq 31, block 848, scn 0.475256
832 data blocks read, 832 data blocks written, 845 redo blocks read
Crash recovery completed successfully
Tue Sep 26 13:52:02 2006
Thread 1 advanced to log sequence 32
Thread 1 opened at log sequence 32
Current log# 1 seq# 32 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG
Successful open of redo thread 1.
Tue Sep 26 13:52:02 2006
SMON: enabling cache recovery
Tue Sep 26 13:52:03 2006
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Tue Sep 26 13:52:03 2006
SMON: enabling tx recovery
Tue Sep 26 13:52:03 2006
Database Characterset is WE8MSWIN1252
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: alter database open
Tue Sep 26 14:30:29 2006
Errors in file d:\oracle\admin\orcl\udump\orcl_ora_3584.trc:

Wed Sep 27 01:51:56 2006
Thread 1 advanced to log sequence 33
Current log# 2 seq# 33 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO02.LOG
Wed Sep 27 12:06:04 2006
Thread 1 advanced to log sequence 34
Current log# 3 seq# 34 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO03.LOG
Wed Sep 27 18:01:53 2006
Errors in file d:\oracle\admin\orcl\udump\orcl_ora_3684.trc:
ORA-04021: timeout occurred while waiting to lock object ACCUMED.OT_LOCN_TRF_OUT_HEAD

Dump file d:\oracle\admin\orcl\bdump\alert_orcl.log
Wed Sep 27 21:59:32 2006
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 1, CPU type 586
Wed Sep 27 21:59:32 2006
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 268435456
large_pool_size = 8388608
java_pool_size = 33554432
control_files = D:\Oracle\oradata\orcl\CONTROL01.CTL, D:\Oracle\oradata\orcl\CONTROL02.CTL, D:\Oracle\oradata\orcl\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 838860800
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = orcl
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = D:\Oracle\admin\orcl\bdump
user_dump_dest = D:\Oracle\admin\orcl\udump
core_dump_dest = D:\Oracle\admin\orcl\cdump
sort_area_size = 524288
db_name = orcl
open_cursors = 10000
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
aq_tm_processes = 1
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
CJQ0 started with pid=8
QMN0 started with pid=9
Wed Sep 27 21:59:36 2006
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Wed Sep 27 21:59:37 2006
alter database mount exclusive
Wed Sep 27 21:59:41 2006
Successful mount of redo thread 1, with mount id 1130114505.
Wed Sep 27 21:59:41 2006
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Wed Sep 27 21:59:41 2006
alter database open
Wed Sep 27 21:59:41 2006
Beginning crash recovery of 1 threads
Wed Sep 27 21:59:41 2006
Started first pass scan
Wed Sep 27 21:59:41 2006
Completed first pass scan
5153 redo blocks read, 261 data blocks need recovery
Wed Sep 27 21:59:42 2006
Started recovery at
Thread 1: logseq 34, block 171980, scn 0.0
Recovery of Online Redo Log: Thread 1 Group 3 Seq 34 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\ORCL\REDO03.LOG
Wed Sep 27 21:59:42 2006
Ended recovery at
Thread 1: logseq 34, block 177133, scn 0.1071098
261 data blocks read, 261 data blocks written, 5153 redo blocks read
Crash recovery completed successfully
Wed Sep 27 21:59:42 2006
Thread 1 advanced to log sequence 35
Thread 1 opened at log sequence 35
Current log# 1 seq# 35 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG
Successful open of redo thread 1.
Wed Sep 27 21:59:42 2006
SMON: enabling cache recovery
Wed Sep 27 21:59:43 2006
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Wed Sep 27 21:59:43 2006
SMON: enabling tx recovery
Wed Sep 27 21:59:43 2006
Database Characterset is WE8MSWIN1252
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: alter database open
Thu Sep 28 13:59:21 2006
Thread 1 advanced to log sequence 36
Current log# 2 seq# 36 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO02.LOG
Thu Sep 28 22:19:25 2006
Thread 1 advanced to log sequence 37
Current log# 3 seq# 37 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO03.LOG
Dump file d:\oracle\admin\orcl\bdump\alert_orcl.log
Fri Sep 29 08:39:16 2006
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 1, CPU type 586
Fri Sep 29 08:39:16 2006
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 268435456
large_pool_size = 8388608
java_pool_size = 33554432
control_files = D:\Oracle\oradata\orcl\CONTROL01.CTL, D:\Oracle\oradata\orcl\CONTROL02.CTL, D:\Oracle\oradata\orcl\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 838860800
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = orcl
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = D:\Oracle\admin\orcl\bdump
user_dump_dest = D:\Oracle\admin\orcl\udump
core_dump_dest = D:\Oracle\admin\orcl\cdump
sort_area_size = 524288
db_name = orcl
open_cursors = 10000
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
aq_tm_processes = 1
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
CJQ0 started with pid=8
QMN0 started with pid=9
Fri Sep 29 08:39:19 2006
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Fri Sep 29 08:39:20 2006
alter database mount exclusive
Fri Sep 29 08:39:24 2006
Successful mount of redo thread 1, with mount id 1130216760.
Fri Sep 29 08:39:24 2006
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Fri Sep 29 08:39:24 2006
alter database open
Fri Sep 29 08:39:24 2006
Beginning crash recovery of 1 threads
Fri Sep 29 08:39:24 2006
Started first pass scan
Fri Sep 29 08:39:24 2006
Completed first pass scan
3902 redo blocks read, 67 data blocks need recovery
Fri Sep 29 08:39:24 2006
Started recovery at
Thread 1: logseq 37, block 79351, scn 0.0
Recovery of Online Redo Log: Thread 1 Group 3 Seq 37 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\ORCL\REDO03.LOG
Fri Sep 29 08:39:24 2006
Ended recovery at
Thread 1: logseq 37, block 83253, scn 0.1677642
67 data blocks read, 67 data blocks written, 3902 redo blocks read
Crash recovery completed successfully
Fri Sep 29 08:39:25 2006
Thread 1 advanced to log sequence 38
Thread 1 opened at log sequence 38
Current log# 1 seq# 38 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG
Successful open of redo thread 1.
Fri Sep 29 08:39:25 2006
SMON: enabling cache recovery
Fri Sep 29 08:39:25 2006
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Fri Sep 29 08:39:25 2006
SMON: enabling tx recovery
Fri Sep 29 08:39:25 2006
Database Characterset is WE8MSWIN1252
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: alter database open
Fri Sep 29 16:16:04 2006
Thread 1 advanced to log sequence 39
Current log# 2 seq# 39 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO02.LOG
Sat Sep 30 09:49:31 2006
Thread 1 advanced to log sequence 40
Current log# 3 seq# 40 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO03.LOG
Sat Sep 30 14:10:00 2006
ORA-000060: Deadlock detected. More info in file d:\oracle\admin\orcl\udump\orcl_ora_3060.trc.

Sat Sep 30 14:10:00 2006
Errors in file d:\oracle\admin\orcl\udump\orcl_ora_3060.trc:
ORA-00060: deadlock detected while waiting for resource

Sun Oct 01 07:14:58 2006
Thread 1 advanced to log sequence 41
Current log# 1 seq# 41 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG
Sun Oct 01 21:04:34 2006
Thread 1 advanced to log sequence 42
Current log# 2 seq# 42 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO02.LOG
Mon Oct 02 11:50:36 2006
Created Undo Segment _SYSSMU11$
Undo Segment 11 Onlined
Mon Oct 02 13:48:10 2006
Thread 1 advanced to log sequence 43
Current log# 3 seq# 43 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO03.LOG
Mon Oct 02 20:54:50 2006
SMON offlining US=11
Tue Oct 03 06:53:36 2006
Thread 1 advanced to log sequence 44
Current log# 1 seq# 44 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG
Tue Oct 03 17:05:29 2006
Thread 1 advanced to log sequence 45
Current log# 2 seq# 45 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO02.LOG
Wed Oct 04 09:29:58 2006
Thread 1 advanced to log sequence 46
Current log# 3 seq# 46 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO03.LOG
Wed Oct 04 09:30:30 2006
Thread 1 advanced to log sequence 47
Current log# 1 seq# 47 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG
Wed Oct 04 09:30:58 2006
Thread 1 advanced to log sequence 48
Current log# 2 seq# 48 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO02.LOG
Wed Oct 04 09:31:27 2006
Thread 1 advanced to log sequence 49
Current log# 3 seq# 49 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO03.LOG
Wed Oct 04 09:31:55 2006
Thread 1 advanced to log sequence 50
Current log# 1 seq# 50 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG
Wed Oct 04 09:32:23 2006
Thread 1 advanced to log sequence 51
Current log# 2 seq# 51 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO02.LOG
Wed Oct 04 09:32:53 2006
Thread 1 advanced to log sequence 52
Current log# 3 seq# 52 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO03.LOG
Wed Oct 04 09:33:14 2006
Thread 1 advanced to log sequence 53
Current log# 1 seq# 53 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG
Wed Oct 04 09:33:45 2006
Thread 1 advanced to log sequence 54
Current log# 2 seq# 54 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO02.LOG
Wed Oct 04 09:34:18 2006
Thread 1 advanced to log sequence 55
Current log# 3 seq# 55 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO03.LOG
Wed Oct 04 09:34:50 2006
Thread 1 advanced to log sequence 56
Current log# 1 seq# 56 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG
Wed Oct 04 09:35:19 2006
Thread 1 advanced to log sequence 57
Current log# 2 seq# 57 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO02.LOG
Wed Oct 04 09:35:58 2006
Thread 1 advanced to log sequence 58
Current log# 3 seq# 58 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO03.LOG
Wed Oct 04 09:36:10 2006
Thread 1 advanced to log sequence 59
Current log# 1 seq# 59 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG
Wed Oct 04 09:36:23 2006
Thread 1 advanced to log sequence 60
Current log# 2 seq# 60 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO02.LOG
Wed Oct 04 09:36:35 2006
Thread 1 advanced to log sequence 61
Current log# 3 seq# 61 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO03.LOG
Wed Oct 04 09:36:48 2006
Thread 1 advanced to log sequence 62
Current log# 1 seq# 62 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG
Wed Oct 04 09:37:01 2006
Thread 1 advanced to log sequence 63
Current log# 2 seq# 63 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO02.LOG
Wed Oct 04 09:37:13 2006
Thread 1 advanced to log sequence 64
Current log# 3 seq# 64 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO03.LOG
Wed Oct 04 09:37:26 2006
Thread 1 advanced to log sequence 65
Current log# 1 seq# 65 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG
Wed Oct 04 09:37:38 2006
Thread 1 advanced to log sequence 66
Current log# 2 seq# 66 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO02.LOG
Wed Oct 04 09:38:38 2006
Thread 1 advanced to log sequence 67
Current log# 3 seq# 67 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO03.LOG
Wed Oct 04 09:39:21 2006
Thread 1 advanced to log sequence 68
Current log# 1 seq# 68 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG
Wed Oct 04 09:41:10 2006
Thread 1 advanced to log sequence 69
Current log# 2 seq# 69 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO02.LOG
Wed Oct 04 09:42:25 2006
Thread 1 advanced to log sequence 70
Current log# 3 seq# 70 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO03.LOG
Wed Oct 04 09:44:05 2006
Thread 1 advanced to log sequence 71
Current log# 1 seq# 71 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG
Wed Oct 04 09:44:58 2006
Thread 1 advanced to log sequence 72
Current log# 2 seq# 72 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO02.LOG
Wed Oct 04 10:30:10 2006
Created Undo Segment _SYSSMU11$
Undo Segment 11 Onlined
Wed Oct 04 15:28:14 2006
Thread 1 advanced to log sequence 73
Current log# 3 seq# 73 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO03.LOG
Wed Oct 04 21:03:27 2006
SMON offlining US=11
Thu Oct 05 10:15:16 2006
Thread 1 advanced to log sequence 74
Current log# 1 seq# 74 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG
Thu Oct 05 15:12:20 2006
Created Undo Segment _SYSSMU11$
Undo Segment 11 Onlined
Thu Oct 05 21:07:57 2006
SMON offlining US=11
Thu Oct 05 21:26:20 2006
Thread 1 advanced to log sequence 75
Current log# 2 seq# 75 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO02.LOG
Fri Oct 06 13:05:01 2006
Thread 1 advanced to log sequence 76
Current log# 3 seq# 76 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO03.LOG
Fri Oct 06 13:25:24 2006
Errors in file d:\oracle\admin\orcl\udump\orcl_ora_768.trc:

Fri Oct 06 13:25:24 2006
Errors in file d:\oracle\admin\orcl\udump\orcl_ora_4980.trc:
ORA-04021: timeout occurred while waiting to lock object ACCUMED.OT_LOCN_TRF_OUT_ITEM

Fri Oct 06 13:28:50 2006
Errors in file d:\oracle\admin\orcl\udump\orcl_ora_4512.trc:
ORA-00028: your session has been killed

Fri Oct 06 13:29:14 2006
Errors in file d:\oracle\admin\orcl\udump\orcl_ora_6120.trc:

Fri Oct 06 13:29:14 2006
Errors in file d:\oracle\admin\orcl\udump\orcl_ora_5496.trc:
ORA-00028: your session has been killed

Fri Oct 06 13:32:24 2006
Errors in file d:\oracle\admin\orcl\udump\orcl_ora_3796.trc:
ORA-00028: your session has been killed

Fri Oct 06 13:44:34 2006
Errors in file d:\oracle\admin\orcl\udump\orcl_ora_1776.trc:
ORA-00028: your session has been killed

Fri Oct 06 16:20:46 2006
Thread 1 advanced to log sequence 77
Current log# 1 seq# 77 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG
Fri Oct 06 19:22:47 2006
Thread 1 advanced to log sequence 78
Current log# 2 seq# 78 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO02.LOG
Sat Oct 07 18:29:00 2006
Thread 1 advanced to log sequence 79
Current log# 3 seq# 79 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO03.LOG
Sun Oct 08 20:56:52 2006
Thread 1 advanced to log sequence 80
Current log# 1 seq# 80 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG
Mon Oct 09 22:52:44 2006
Thread 1 advanced to log sequence 81
Current log# 2 seq# 81 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO02.LOG
Tue Oct 10 12:09:28 2006
Created Undo Segment _SYSSMU11$
Undo Segment 11 Onlined
Tue Oct 10 13:17:44 2006
Thread 1 advanced to log sequence 82
Current log# 3 seq# 82 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO03.LOG
Tue Oct 10 21:23:29 2006
SMON offlining US=11
Wed Oct 11 03:04:48 2006
Thread 1 advanced to log sequence 83
Current log# 1 seq# 83 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG
Wed Oct 11 11:41:05 2006
Thread 1 advanced to log sequence 84
Current log# 2 seq# 84 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO02.LOG
Wed Oct 11 12:16:27 2006
Created Undo Segment _SYSSMU11$
Undo Segment 11 Onlined
Wed Oct 11 14:09:26 2006
Created Undo Segment _SYSSMU12$
Undo Segment 12 Onlined
Wed Oct 11 15:05:00 2006
Errors in file d:\oracle\admin\orcl\udump\orcl_ora_3884.trc:

Wed Oct 11 15:05:00 2006
Errors in file d:\oracle\admin\orcl\udump\orcl_ora_1480.trc:

Wed Oct 11 15:05:00 2006
Errors in file d:\oracle\admin\orcl\udump\orcl_ora_2752.trc:

Wed Oct 11 15:05:00 2006
Errors in file d:\oracle\admin\orcl\udump\orcl_ora_3788.trc:

Wed Oct 11 15:05:00 2006
Errors in file d:\oracle\admin\orcl\udump\orcl_ora_5192.trc:

Wed Oct 11 19:22:01 2006
Thread 1 advanced to log sequence 85
Current log# 3 seq# 85 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO03.LOG
Wed Oct 11 21:27:19 2006
SMON offlining US=11
SMON offlining US=12
Thu Oct 12 12:11:15 2006
Thread 1 advanced to log sequence 86
Current log# 1 seq# 86 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG
Thu Oct 12 23:25:45 2006
Thread 1 advanced to log sequence 87
Current log# 2 seq# 87 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO02.LOG
Fri Oct 13 14:33:34 2006
Thread 1 advanced to log sequence 88
Current log# 3 seq# 88 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO03.LOG
Sat Oct 14 07:56:08 2006
Thread 1 advanced to log sequence 89
Current log# 1 seq# 89 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG
Dump file d:\oracle\admin\orcl\bdump\alert_orcl.log
Sat Oct 14 14:25:08 2006
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 1, CPU type 586
Sat Oct 14 14:25:08 2006
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 268435456
large_pool_size = 8388608
java_pool_size = 33554432
control_files = D:\Oracle\oradata\orcl\CONTROL01.CTL, D:\Oracle\oradata\orcl\CONTROL02.CTL, D:\Oracle\oradata\orcl\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 838860800
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = orcl
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = D:\Oracle\admin\orcl\bdump
user_dump_dest = D:\Oracle\admin\orcl\udump
core_dump_dest = D:\Oracle\admin\orcl\cdump
sort_area_size = 524288
db_name = orcl
open_cursors = 10000
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
aq_tm_processes = 1
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
CJQ0 started with pid=8
QMN0 started with pid=9
Sat Oct 14 14:25:11 2006
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Sat Oct 14 14:25:12 2006
alter database mount exclusive
Sat Oct 14 14:25:17 2006
Successful mount of redo thread 1, with mount id 1131626824.
Sat Oct 14 14:25:17 2006
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Sat Oct 14 14:25:17 2006
alter database open
Sat Oct 14 14:25:17 2006
Beginning crash recovery of 1 threads
Sat Oct 14 14:25:17 2006
Started first pass scan
Sat Oct 14 14:25:17 2006
Completed first pass scan
4012 redo blocks read, 67 data blocks need recovery
Sat Oct 14 14:25:17 2006
Started recovery at
Thread 1: logseq 89, block 52459, scn 0.0
Recovery of Online Redo Log: Thread 1 Group 1 Seq 89 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG
Sat Oct 14 14:25:17 2006
Ended recovery at
Thread 1: logseq 89, block 56471, scn 0.7705490
67 data blocks read, 66 data blocks written, 4012 redo blocks read
Crash recovery completed successfully
Sat Oct 14 14:25:17 2006
Thread 1 advanced to log sequence 90
Thread 1 opened at log sequence 90
Current log# 2 seq# 90 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO02.LOG
Successful open of redo thread 1.
Sat Oct 14 14:25:17 2006
SMON: enabling cache recovery
Sat Oct 14 14:25:18 2006
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Sat Oct 14 14:25:18 2006
SMON: enabling tx recovery
Sat Oct 14 14:25:18 2006
Database Characterset is WE8MSWIN1252
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: alter database open
Sun Oct 15 15:41:12 2006
Thread 1 advanced to log sequence 91
Current log# 3 seq# 91 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO03.LOG
Mon Oct 16 09:58:09 2006
Thread 1 advanced to log sequence 92
Current log# 1 seq# 92 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG
Mon Oct 16 11:12:27 2006
ALTER SYSTEM SET trace_enabled=FALSE SCOPE=BOTH;
Mon Oct 16 11:12:31 2006
ALTER SYSTEM SET timed_statistics=FALSE SCOPE=BOTH;
Mon Oct 16 11:12:37 2006
ALTER SYSTEM SET trace_enabled=FALSE SCOPE=BOTH;
Mon Oct 16 11:13:18 2006
ALTER SYSTEM SET statistics_level='BASIC' SCOPE=BOTH;
Mon Oct 16 11:13:41 2006
ALTER SYSTEM SET pga_aggregate_target='251658240' SCOPE=BOTH;
Mon Oct 16 11:14:02 2006
ALTER SYSTEM SET pga_aggregate_target='25165824' SCOPE=BOTH;
Mon Oct 16 11:16:21 2006
ALTER SYSTEM SET sort_area_size=124288 DEFERRED SCOPE=BOTH;
Mon Oct 16 18:11:54 2006
Thread 1 advanced to log sequence 93
Current log# 2 seq# 93 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO02.LOG
Tue Oct 17 08:31:25 2006
Thread 1 advanced to log sequence 94
Current log# 3 seq# 94 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO03.LOG
Tue Oct 17 12:28:04 2006
Thread 1 advanced to log sequence 95
Current log# 1 seq# 95 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG
Wed Oct 18 02:43:25 2006
Thread 1 advanced to log sequence 96
Current log# 2 seq# 96 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO02.LOG
Wed Oct 18 14:02:02 2006
Thread 1 advanced to log sequence 97
Current log# 3 seq# 97 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO03.LOG
Wed Oct 18 15:09:47 2006
Created Undo Segment _SYSSMU11$
Undo Segment 11 Onlined
Wed Oct 18 15:55:08 2006
Errors in file d:\oracle\admin\orcl\udump\orcl_ora_3272.trc:

Wed Oct 18 15:55:08 2006
Errors in file d:\oracle\admin\orcl\udump\orcl_ora_4860.trc:

Thu Oct 19 02:35:06 2006
SMON offlining US=11
Thu Oct 19 03:03:49 2006
Thread 1 advanced to log sequence 98
Current log# 1 seq# 98 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG
Dump file d:\oracle\admin\orcl\bdump\alert_orcl.log
Thu Oct 19 07:31:13 2006
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 1, CPU type 586
Thu Oct 19 07:31:13 2006
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = FALSE
shared_pool_size = 268435456
large_pool_size = 8388608
java_pool_size = 33554432
trace_enabled = FALSE
control_files = D:\Oracle\oradata\orcl\CONTROL01.CTL, D:\Oracle\oradata\orcl\CONTROL02.CTL, D:\Oracle\oradata\orcl\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 838860800
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = orcl
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = D:\Oracle\admin\orcl\bdump
user_dump_dest = D:\Oracle\admin\orcl\udump
core_dump_dest = D:\Oracle\admin\orcl\cdump
sort_area_size = 124288
db_name = orcl
open_cursors = 10000
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
statistics_level = BASIC
aq_tm_processes = 1
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
CJQ0 started with pid=8
QMN0 started with pid=9
Thu Oct 19 07:31:16 2006
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Thu Oct 19 07:31:17 2006
alter database mount exclusive
Thu Oct 19 07:31:21 2006
Successful mount of redo thread 1, with mount id 1131993541.
Thu Oct 19 07:31:21 2006
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Thu Oct 19 07:31:21 2006
alter database open
Thu Oct 19 07:31:21 2006
Beginning crash recovery of 1 threads
Thu Oct 19 07:31:21 2006
Started first pass scan
Thu Oct 19 07:31:22 2006
Completed first pass scan
4938 redo blocks read, 153 data blocks need recovery
Thu Oct 19 07:31:22 2006
Started recovery at
Thread 1: logseq 98, block 30786, scn 0.0
Recovery of Online Redo Log: Thread 1 Group 1 Seq 98 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG
Thu Oct 19 07:31:22 2006
Ended recovery at
Thread 1: logseq 98, block 35724, scn 0.9560658
153 data blocks read, 153 data blocks written, 4938 redo blocks read
Crash recovery completed successfully
Thu Oct 19 07:31:22 2006
Thread 1 advanced to log sequence 99
Thread 1 opened at log sequence 99
Current log# 2 seq# 99 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO02.LOG
Successful open of redo thread 1.
Thu Oct 19 07:31:22 2006
SMON: enabling cache recovery
Thu Oct 19 07:31:23 2006
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Thu Oct 19 07:31:23 2006
SMON: enabling tx recovery
Thu Oct 19 07:31:23 2006
Database Characterset is WE8MSWIN1252
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: alter database open
Thu Oct 19 16:22:48 2006
Thread 1 advanced to log sequence 100
Current log# 3 seq# 100 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO03.LOG
Fri Oct 20 09:06:16 2006
Thread 1 advanced to log sequence 101
Current log# 1 seq# 101 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG
Fri Oct 20 11:59:42 2006
Created Undo Segment _SYSSMU11$
Undo Segment 11 Onlined
Fri Oct 20 12:00:48 2006
Created Undo Segment _SYSSMU12$
Undo Segment 12 Onlined
Fri Oct 20 13:44:36 2006
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 111
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Fri Oct 20 13:44:44 2006
alter database close normal
Fri Oct 20 13:44:44 2006
SMON: disabling tx recovery
SMON: disabling cache recovery
Fri Oct 20 13:44:44 2006
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 101
Successful close of redo thread 1.
Fri Oct 20 13:44:45 2006
Completed: alter database close normal
Fri Oct 20 13:44:45 2006
alter database dismount
Completed: alter database dismount
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Dump file d:\oracle\admin\orcl\bdump\alert_orcl.log
Fri Oct 20 13:48:00 2006
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 1, CPU type 586
Fri Oct 20 13:48:00 2006
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = FALSE
shared_pool_size = 268435456
large_pool_size = 8388608
java_pool_size = 33554432
trace_enabled = FALSE
control_files = D:\Oracle\oradata\orcl\CONTROL01.CTL, D:\Oracle\oradata\orcl\CONTROL02.CTL, D:\Oracle\oradata\orcl\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 838860800
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = orcl
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = D:\Oracle\admin\orcl\bdump
user_dump_dest = D:\Oracle\admin\orcl\udump
core_dump_dest = D:\Oracle\admin\orcl\cdump
sort_area_size = 124288
db_name = orcl
open_cursors = 10000
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
statistics_level = BASIC
aq_tm_processes = 1
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
CJQ0 started with pid=8
QMN0 started with pid=9
Fri Oct 20 13:48:04 2006
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Fri Oct 20 13:48:05 2006
alter database mount exclusive
Fri Oct 20 13:48:09 2006
Successful mount of redo thread 1, with mount id 1132129685.
Fri Oct 20 13:48:09 2006
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Fri Oct 20 13:48:09 2006
alter database open
Fri Oct 20 13:48:09 2006
Thread 1 opened at log sequence 101
Current log# 1 seq# 101 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG
Successful open of redo thread 1.
Fri Oct 20 13:48:09 2006
SMON: enabling cache recovery
Fri Oct 20 13:48:10 2006
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Fri Oct 20 13:48:10 2006
SMON: enabling tx recovery
Fri Oct 20 13:48:10 2006
Database Characterset is WE8MSWIN1252
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: alter database open
Fri Oct 20 14:50:46 2006
Thread 1 advanced to log sequence 102
Current log# 2 seq# 102 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO02.LOG
Fri Oct 20 16:10:48 2006
Undo Segment 11 Onlined
Fri Oct 20 18:30:00 2006
Errors in file d:\oracle\admin\orcl\udump\orcl_ora_3072.trc:

Sat Oct 21 01:52:53 2006
SMON offlining US=11
Sat Oct 21 06:48:04 2006
Thread 1 advanced to log sequence 103
Current log# 3 seq# 103 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO03.LOG
Sun Oct 22 05:52:24 2006
Thread 1 advanced to log sequence 104
Current log# 1 seq# 104 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG
Mon Oct 23 07:54:35 2006
Thread 1 advanced to log sequence 105
Current log# 2 seq# 105 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO02.LOG
Mon Oct 23 10:58:44 2006
Created Undo Segment _SYSSMU11$
Undo Segment 11 Onlined
Mon Oct 23 11:17:53 2006
Errors in file d:\oracle\admin\orcl\udump\orcl_j000_4180.trc:
ORA-12012: error on auto execute of job 21
ORA-20000: ORA-29261: bad argument
ORA-06512: at "ACCUMED.O_DBSEND_MAIL", line 227
ORA-06512: at "ACCUMED.O_DBEVENT_TRIGGER", line 160
ORA-06512: at line 1

Mon Oct 23 11:19:58 2006
Errors in file d:\oracle\admin\orcl\udump\orcl_j000_4572.trc:
ORA-12012: error on auto execute of job 21
ORA-20000: ORA-29261: bad argument
ORA-06512: at "ACCUMED.O_DBSEND_MAIL", line 227
ORA-06512: at "ACCUMED.O_DBEVENT_TRIGGER", line 160
ORA-06512: at line 1

Mon Oct 23 11:24:05 2006
Errors in file d:\oracle\admin\orcl\udump\orcl_j000_5856.trc:
ORA-12012: error on auto execute of job 21
ORA-20000: ORA-29261: bad argument
ORA-06512: at "ACCUMED.O_DBSEND_MAIL", line 227
ORA-06512: at "ACCUMED.O_DBEVENT_TRIGGER", line 160
ORA-06512: at line 1

Mon Oct 23 11:30:09 2006
Errors i
 
Upvote 0 Downvote
Mickey,

Although I am grateful for your posting the contents of your alert<SID>.log file, I am very puzzled: The last entry of your alert log has the time stamp, "Wed Oct 04 09:39:21 2006"; you created this thread "24 Nov 06 8:44"...7 weeks after the last entry in your alert log. Has your database been non functional since Wed Oct 04? If not, then where is the rest of the alert log, including the messages relating to this thread?

If you do find more meaningful alert log entries, please post only an excerpt of the alert log that includes just the messages since your last database startup (attempt).

[santa]Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
 
Upvote 0 Downvote
Hello Mufasa,

Did not realize I was pasting more bytes than allowed here...

We experienced problems 11/21 afternoon! and had to restore from the dump 11/20

Below is the log from 11/19 to 11/22 inclusive of some corruption!

Thank you Mufasa!

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++


Sun Nov 19 18:11:01 2006
Thread 1 advanced to log sequence 381
Current log# 2 seq# 381 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO02.LOG
Mon Nov 20 12:14:31 2006
Thread 1 advanced to log sequence 382
Current log# 3 seq# 382 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO03.LOG
Tue Nov 21 02:14:48 2006
Thread 1 advanced to log sequence 383
Current log# 1 seq# 383 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG
Tue Nov 21 11:41:36 2006
Thread 1 advanced to log sequence 384
Current log# 2 seq# 384 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO02.LOG
Tue Nov 21 11:44:25 2006
Thread 1 advanced to log sequence 385
Current log# 3 seq# 385 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO03.LOG
Tue Nov 21 11:45:49 2006
Thread 1 advanced to log sequence 386
Current log# 1 seq# 386 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG
Tue Nov 21 11:57:34 2006
Thread 1 advanced to log sequence 387
Current log# 2 seq# 387 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO02.LOG
Tue Nov 21 12:01:52 2006
Thread 1 advanced to log sequence 388
Current log# 3 seq# 388 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO03.LOG
Tue Nov 21 12:04:26 2006
Thread 1 advanced to log sequence 389
Current log# 1 seq# 389 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG
Tue Nov 21 12:05:43 2006
Thread 1 advanced to log sequence 390
Current log# 2 seq# 390 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO02.LOG
Tue Nov 21 14:05:39 2006
Thread 1 advanced to log sequence 391
Current log# 3 seq# 391 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO03.LOG
Tue Nov 21 14:47:44 2006
Thread 1 advanced to log sequence 392
Current log# 1 seq# 392 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG
Tue Nov 21 14:49:29 2006
Thread 1 advanced to log sequence 393
Current log# 2 seq# 393 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO02.LOG
Tue Nov 21 14:50:58 2006
Thread 1 advanced to log sequence 394
Current log# 3 seq# 394 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO03.LOG
Tue Nov 21 15:47:59 2006
Thread 1 advanced to log sequence 395
Current log# 1 seq# 395 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG


Tue Nov 21 17:00:16 2006
Errors in file d:\oracle\admin\orcl\udump\orcl_ora_4808.trc:
ORA-00600: internal error code, arguments: [kdddgb1], [0], [], [], [], [], [], []

*****************************************************************************************
Tue Nov 21 17:03:01 2006
Errors in file d:\oracle\admin\orcl\udump\orcl_ora_4808.trc:
ORA-00600: internal error code, arguments: [kdddgb1], [0], [], [], [], [], [], []
Corrupt block relative dba: 0x00000001 (file 0, block 1)
Completely zero block found during control file header read

*****************************************************************************************

Tue Nov 21 17:04:02 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_ckpt_3516.trc:
ORA-00202: controlfile: 'D:\ORACLE\ORADATA\ORCL\CONTROL01.CTL'

Tue Nov 21 17:04:02 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_ckpt_3516.trc:
ORA-00227: corrupt block detected in controlfile: (block 1, # blocks 1)
ORA-00202: controlfile: 'D:\ORACLE\ORADATA\ORCL\CONTROL01.CTL'

CKPT: terminating instance due to error 227
Tue Nov 21 17:04:03 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_pmon_3104.trc:
ORA-00227: corrupt block detected in controlfile: (block , # blocks )

Instance terminated by CKPT, pid = 3516
Dump file d:\oracle\admin\orcl\bdump\alert_orcl.log
Tue Nov 21 17:12:15 2006
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 1, CPU type 586
Tue Nov 21 17:12:15 2006
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = FALSE
shared_pool_size = 268435456
large_pool_size = 8388608
java_pool_size = 33554432
trace_enabled = FALSE
control_files = D:\Oracle\oradata\orcl\CONTROL01.CTL, D:\Oracle\oradata\orcl\CONTROL02.CTL, D:\Oracle\oradata\orcl\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 838860800
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = orcl
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = D:\Oracle\admin\orcl\bdump
user_dump_dest = D:\Oracle\admin\orcl\udump
core_dump_dest = D:\Oracle\admin\orcl\cdump
sort_area_size = 124288
db_name = orcl
open_cursors = 10000
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
statistics_level = BASIC
aq_tm_processes = 1
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
CJQ0 started with pid=8
QMN0 started with pid=9

Tue Nov 21 17:12:19 2006
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Tue Nov 21 17:12:19 2006
alter database mount exclusive
***
Corrupt block relative dba: 0x00000001 (file 0, block 1)
Completely zero block found during control file header read
Tue Nov 21 17:12:20 2006
Errors in file d:\oracle\admin\orcl\udump\orcl_ora_3036.trc:
ORA-00202: controlfile: 'D:\ORACLE\ORADATA\ORCL\CONTROL01.CTL'


ORA-227 signalled during: alter database mount exclusive...
Tue Nov 21 17:31:15 2006
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 3
All dispatchers and shared servers shutdown
Tue Nov 21 17:31:23 2006
alter database close normal
ORA-1507 signalled during: alter database close normal...
Dump file d:\oracle\admin\orcl\bdump\alert_orcl.log
Tue Nov 21 17:31:28 2006
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 1, CPU type 586
Tue Nov 21 17:31:28 2006
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = FALSE
shared_pool_size = 268435456
large_pool_size = 8388608
java_pool_size = 33554432
trace_enabled = FALSE
control_files = D:\Oracle\oradata\orcl\CONTROL01.CTL, D:\Oracle\oradata\orcl\CONTROL02.CTL, D:\Oracle\oradata\orcl\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 838860800
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = orcl
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = D:\Oracle\admin\orcl\bdump
user_dump_dest = D:\Oracle\admin\orcl\udump
core_dump_dest = D:\Oracle\admin\orcl\cdump
sort_area_size = 124288
db_name = orcl
open_cursors = 10000
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
statistics_level = BASIC
aq_tm_processes = 1
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
CJQ0 started with pid=8
QMN0 started with pid=9
Tue Nov 21 17:31:30 2006
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Tue Nov 21 17:31:31 2006
alter database mount exclusive
***
Corrupt block relative dba: 0x00000001 (file 0, block 1)
Completely zero block found during control file header read
Tue Nov 21 17:31:31 2006
Errors in file d:\oracle\admin\orcl\udump\orcl_ora_5428.trc:
ORA-00202: controlfile: 'D:\ORACLE\ORADATA\ORCL\CONTROL01.CTL'

ORA-227 signalled during: alter database mount exclusive...
Shutting down instance: further logons disabled
Shutting down instance (normal)
License high water mark = 3
All dispatchers and shared servers shutdown
Tue Nov 21 17:32:18 2006
ALTER DATABASE CLOSE NORMAL
ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL...
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Tue Nov 21 17:32:29 2006
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = FALSE
shared_pool_size = 268435456
large_pool_size = 8388608
java_pool_size = 33554432
trace_enabled = FALSE
control_files = D:\Oracle\oradata\orcl\CONTROL01.CTL, D:\Oracle\oradata\orcl\CONTROL02.CTL, D:\Oracle\oradata\orcl\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 838860800
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = orcl
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = D:\Oracle\admin\orcl\bdump
user_dump_dest = D:\Oracle\admin\orcl\udump
core_dump_dest = D:\Oracle\admin\orcl\cdump
sort_area_size = 124288
db_name = orcl
open_cursors = 10000
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
statistics_level = BASIC
aq_tm_processes = 1
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
CJQ0 started with pid=8
QMN0 started with pid=9
Tue Nov 21 17:32:31 2006
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Tue Nov 21 17:32:33 2006
ALTER DATABASE MOUNT
***
Corrupt block relative dba: 0x00000001 (file 0, block 1)
Completely zero block found during control file header read
Tue Nov 21 17:32:33 2006
Errors in file d:\oracle\admin\orcl\udump\orcl_ora_5356.trc:
ORA-00202: controlfile: 'D:\ORACLE\ORADATA\ORCL\CONTROL01.CTL'

ORA-227 signalled during: ALTER DATABASE MOUNT...
Tue Nov 21 17:33:10 2006
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 4
All dispatchers and shared servers shutdown
Tue Nov 21 17:33:20 2006
alter database close normal
ORA-1507 signalled during: alter database close normal...
Dump file d:\oracle\admin\orcl\bdump\alert_orcl.log
Tue Nov 21 17:33:24 2006
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 1, CPU type 586
Tue Nov 21 17:33:24 2006
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = FALSE
shared_pool_size = 268435456
large_pool_size = 8388608
java_pool_size = 33554432
trace_enabled = FALSE
control_files = D:\Oracle\oradata\orcl\CONTROL01.CTL, D:\Oracle\oradata\orcl\CONTROL02.CTL, D:\Oracle\oradata\orcl\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 838860800
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = orcl
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = D:\Oracle\admin\orcl\bdump
user_dump_dest = D:\Oracle\admin\orcl\udump
core_dump_dest = D:\Oracle\admin\orcl\cdump
sort_area_size = 124288
db_name = orcl
open_cursors = 10000
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
statistics_level = BASIC
aq_tm_processes = 1
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
CJQ0 started with pid=8
QMN0 started with pid=9
Tue Nov 21 17:33:26 2006
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Tue Nov 21 17:33:27 2006
alter database mount exclusive
***
Corrupt block relative dba: 0x00000001 (file 0, block 1)
Completely zero block found during control file header read
Tue Nov 21 17:33:27 2006
Errors in file d:\oracle\admin\orcl\udump\orcl_ora_4280.trc:
ORA-00202: controlfile: 'D:\ORACLE\ORADATA\ORCL\CONTROL01.CTL'

ORA-227 signalled during: alter database mount exclusive...
Tue Nov 21 17:45:09 2006
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 3
All dispatchers and shared servers shutdown
Tue Nov 21 17:45:12 2006
alter database close normal
ORA-1507 signalled during: alter database close normal...
Dump file d:\oracle\admin\orcl\bdump\alert_orcl.log
Tue Nov 21 17:45:14 2006
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 1, CPU type 586
Tue Nov 21 17:45:14 2006
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = FALSE
shared_pool_size = 268435456
large_pool_size = 8388608
java_pool_size = 33554432
trace_enabled = FALSE
control_files = D:\Oracle\oradata\orcl\CONTROL01.CTL, D:\Oracle\oradata\orcl\CONTROL02.CTL, D:\Oracle\oradata\orcl\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 838860800
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = orcl
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = D:\Oracle\admin\orcl\bdump
user_dump_dest = D:\Oracle\admin\orcl\udump
core_dump_dest = D:\Oracle\admin\orcl\cdump
sort_area_size = 124288
db_name = orcl
open_cursors = 10000
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
statistics_level = BASIC
aq_tm_processes = 1
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
CJQ0 started with pid=8
QMN0 started with pid=9
Tue Nov 21 17:45:17 2006
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Tue Nov 21 17:45:17 2006
alter database mount exclusive
Tue Nov 21 17:45:22 2006
Successful mount of redo thread 1, with mount id 1134856237.
Tue Nov 21 17:45:22 2006
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Tue Nov 21 17:45:22 2006
alter database open
Tue Nov 21 17:45:22 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_dbw0_4320.trc:
ORA-01157: cannot identify/lock data file 12 - see DBWR trace file
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch
O/S-Error: (OS 8205) The specified directory service attribute or value already exists.

ORA-1122 signalled during: alter database open...
Starting ORACLE instance (force)
License high water mark = 4
Instance terminated by USER, pid = 3352
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = FALSE
shared_pool_size = 268435456
large_pool_size = 8388608
java_pool_size = 33554432
trace_enabled = FALSE
control_files = D:\Oracle\oradata\orcl\CONTROL01.CTL, D:\Oracle\oradata\orcl\CONTROL02.CTL, D:\Oracle\oradata\orcl\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 838860800
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = orcl
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = D:\Oracle\admin\orcl\bdump
user_dump_dest = D:\Oracle\admin\orcl\udump
core_dump_dest = D:\Oracle\admin\orcl\cdump
sort_area_size = 124288
db_name = orcl
open_cursors = 10000
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
statistics_level = BASIC
aq_tm_processes = 1
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
CJQ0 started with pid=8
QMN0 started with pid=9
Tue Nov 21 17:47:38 2006
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Tue Nov 21 17:47:40 2006
ALTER DATABASE MOUNT
Tue Nov 21 17:47:44 2006
Successful mount of redo thread 1, with mount id 1134857404.
Tue Nov 21 17:47:44 2006
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Tue Nov 21 17:47:45 2006
ALTER DATABASE OPEN
Tue Nov 21 17:47:45 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_dbw0_3320.trc:
ORA-01157: cannot identify/lock data file 12 - see DBWR trace file
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch
O/S-Error: (OS 8205) The specified directory service attribute or value already exists.

ORA-1122 signalled during: ALTER DATABASE OPEN...
Tue Nov 21 17:51:42 2006
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 4
All dispatchers and shared servers shutdown
Tue Nov 21 17:51:52 2006
alter database close normal
ORA-1109 signalled during: alter database close normal...
Dump file d:\oracle\admin\orcl\bdump\alert_orcl.log
Tue Nov 21 17:54:06 2006
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 1, CPU type 586
Tue Nov 21 17:54:06 2006
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = FALSE
shared_pool_size = 268435456
large_pool_size = 8388608
java_pool_size = 33554432
trace_enabled = FALSE
control_files = D:\Oracle\oradata\orcl\CONTROL01.CTL, D:\Oracle\oradata\orcl\CONTROL02.CTL, D:\Oracle\oradata\orcl\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 838860800
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = orcl
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = D:\Oracle\admin\orcl\bdump
user_dump_dest = D:\Oracle\admin\orcl\udump
core_dump_dest = D:\Oracle\admin\orcl\cdump
sort_area_size = 124288
db_name = orcl
open_cursors = 10000
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
statistics_level = BASIC
aq_tm_processes = 1
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
CJQ0 started with pid=8
QMN0 started with pid=9
Tue Nov 21 17:54:08 2006
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Tue Nov 21 17:54:09 2006
alter database mount exclusive
***
Corrupt block relative dba: 0x00000001 (file 0, block 1)
Completely zero block found during control file header read
Tue Nov 21 17:54:09 2006
Errors in file d:\oracle\admin\orcl\udump\orcl_ora_3464.trc:
ORA-00202: controlfile: 'D:\ORACLE\ORADATA\ORCL\CONTROL01.CTL'

ORA-227 signalled during: alter database mount exclusive...
Shutting down instance: further logons disabled
Shutting down instance (normal)
License high water mark = 3
All dispatchers and shared servers shutdown
Tue Nov 21 17:54:37 2006
ALTER DATABASE CLOSE NORMAL
ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL...
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Tue Nov 21 17:55:44 2006
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = FALSE
shared_pool_size = 268435456
large_pool_size = 8388608
java_pool_size = 33554432
trace_enabled = FALSE
control_files = D:\Oracle\oradata\orcl\CONTROL01.CTL, D:\Oracle\oradata\orcl\CONTROL02.CTL, D:\Oracle\oradata\orcl\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 838860800
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = orcl
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = D:\Oracle\admin\orcl\bdump
user_dump_dest = D:\Oracle\admin\orcl\udump
core_dump_dest = D:\Oracle\admin\orcl\cdump
sort_area_size = 124288
db_name = orcl
open_cursors = 10000
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
statistics_level = BASIC
aq_tm_processes = 1
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
CJQ0 started with pid=8
QMN0 started with pid=9
Tue Nov 21 17:55:46 2006
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Tue Nov 21 17:55:48 2006
ALTER DATABASE MOUNT
Tue Nov 21 17:55:52 2006
Successful mount of redo thread 1, with mount id 1134898852.
Tue Nov 21 17:55:52 2006
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Tue Nov 21 17:55:53 2006
ALTER DATABASE OPEN
Tue Nov 21 17:55:53 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_dbw0_4776.trc:
ORA-01157: cannot identify/lock data file 12 - see DBWR trace file
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch
O/S-Error: (OS 8205) The specified directory service attribute or value already exists.

ORA-1122 signalled during: ALTER DATABASE OPEN...
Tue Nov 21 17:56:29 2006
ALTER DATABASE RECOVER database
Tue Nov 21 17:56:29 2006
Media Recovery Start
Tue Nov 21 17:56:29 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_dbw0_4776.trc:
ORA-01157: cannot identify/lock data file 12 - see DBWR trace file
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch
O/S-Error: (OS 8205) The specified directory service attribute or value already exists.

Media Recovery failed with error 1110
ORA-283 signalled during: ALTER DATABASE RECOVER database ...
Tue Nov 21 17:58:35 2006
alter database open
Tue Nov 21 17:58:35 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_dbw0_4776.trc:
ORA-01157: cannot identify/lock data file 12 - see DBWR trace file
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch
O/S-Error: (OS 8205) The specified directory service attribute or value already exists.

Tue Nov 21 17:58:35 2006
ORA-1122 signalled during: alter database open...
Tue Nov 21 18:03:08 2006
Shutting down instance: further logons disabled
Shutting down instance (normal)
License high water mark = 4
All dispatchers and shared servers shutdown
Tue Nov 21 18:03:11 2006
ALTER DATABASE CLOSE NORMAL
ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
Tue Nov 21 18:03:11 2006
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Tue Nov 21 18:03:42 2006
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = FALSE
shared_pool_size = 268435456
large_pool_size = 8388608
java_pool_size = 33554432
trace_enabled = FALSE
control_files = D:\Oracle\oradata\orcl\CONTROL02.CTL, D:\Oracle\oradata\orcl\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 838860800
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = orcl
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = D:\Oracle\admin\orcl\bdump
user_dump_dest = D:\Oracle\admin\orcl\udump
core_dump_dest = D:\Oracle\admin\orcl\cdump
sort_area_size = 124288
db_name = orcl
open_cursors = 10000
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
statistics_level = BASIC
aq_tm_processes = 1
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
CJQ0 started with pid=8
QMN0 started with pid=9
Tue Nov 21 18:03:45 2006
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Tue Nov 21 18:03:46 2006
ALTER DATABASE MOUNT
Tue Nov 21 18:03:50 2006
Successful mount of redo thread 1, with mount id 1134896002.
Tue Nov 21 18:03:50 2006
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Tue Nov 21 18:03:51 2006
ALTER DATABASE OPEN
Tue Nov 21 18:03:51 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_dbw0_5300.trc:
ORA-01157: cannot identify/lock data file 12 - see DBWR trace file
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch
O/S-Error: (OS 8205) The specified directory service attribute or value already exists.

ORA-1122 signalled during: ALTER DATABASE OPEN...
Tue Nov 21 19:06:55 2006
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 4
All dispatchers and shared servers shutdown
Tue Nov 21 19:07:04 2006
alter database close normal
ORA-1109 signalled during: alter database close normal...
Dump file d:\oracle\admin\orcl\bdump\alert_orcl.log
Tue Nov 21 19:11:16 2006
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 1, CPU type 586
Tue Nov 21 19:11:16 2006
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = FALSE
shared_pool_size = 268435456
large_pool_size = 8388608
java_pool_size = 33554432
trace_enabled = FALSE
control_files = D:\Oracle\oradata\orcl\CONTROL01.CTL, D:\Oracle\oradata\orcl\CONTROL02.CTL, D:\Oracle\oradata\orcl\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 838860800
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = orcl
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = D:\Oracle\admin\orcl\bdump
user_dump_dest = D:\Oracle\admin\orcl\udump
core_dump_dest = D:\Oracle\admin\orcl\cdump
sort_area_size = 124288
db_name = orcl
open_cursors = 10000
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
statistics_level = BASIC
aq_tm_processes = 1
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
CJQ0 started with pid=8
QMN0 started with pid=9
Tue Nov 21 19:11:19 2006
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Tue Nov 21 19:11:19 2006
alter database mount exclusive
Informational message:
Controlfile 1 has seq# 9785, lowest 9784 file 0, cksret 0
Informational message:
Controlfile 2 has seq# 9785, lowest 9784 file 0, cksret 0
Tue Nov 21 19:11:23 2006
Successful mount of redo thread 1, with mount id 1134878295.
Tue Nov 21 19:11:23 2006
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Tue Nov 21 19:11:23 2006
alter database open
Tue Nov 21 19:11:23 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_dbw0_3116.trc:
ORA-01157: cannot identify/lock data file 12 - see DBWR trace file
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch
O/S-Error: (OS 8205) The specified directory service attribute or value already exists.

ORA-1122 signalled during: alter database open...
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 3
All dispatchers and shared servers shutdown
Tue Nov 21 19:50:31 2006
alter database close normal
ORA-1109 signalled during: alter database close normal...
Dump file d:\oracle\admin\orcl\bdump\alert_orcl.log
Tue Nov 21 20:45:09 2006
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 1, CPU type 586
Tue Nov 21 20:45:09 2006
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = FALSE
shared_pool_size = 268435456
large_pool_size = 8388608
java_pool_size = 33554432
trace_enabled = FALSE
control_files = D:\Oracle\oradata\orcl\CONTROL01.CTL, D:\Oracle\oradata\orcl\CONTROL02.CTL, D:\Oracle\oradata\orcl\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 838860800
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = orcl
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = D:\Oracle\admin\orcl\bdump
user_dump_dest = D:\Oracle\admin\orcl\udump
core_dump_dest = D:\Oracle\admin\orcl\cdump
sort_area_size = 124288
db_name = orcl
open_cursors = 10000
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
statistics_level = BASIC
aq_tm_processes = 1
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
CJQ0 started with pid=8
QMN0 started with pid=9
Tue Nov 21 20:45:13 2006
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Tue Nov 21 20:45:13 2006
alter database mount exclusive
Tue Nov 21 20:45:18 2006
Successful mount of redo thread 1, with mount id 1134888282.
Tue Nov 21 20:45:18 2006
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Tue Nov 21 20:45:18 2006
alter database open
Tue Nov 21 20:45:19 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_dbw0_1424.trc:
ORA-01157: cannot identify/lock data file 12 - see DBWR trace file
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch
O/S-Error: (OS 8205) The specified directory service attribute or value already exists.

ORA-1122 signalled during: alter database open...
Tue Nov 21 20:48:51 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_dbw0_1424.trc:
ORA-01157: cannot identify/lock data file 12 - see DBWR trace file
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch
O/S-Error: (OS 8205) The specified directory service attribute or value already exists.

Tue Nov 21 20:48:51 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_dbw0_1424.trc:
ORA-01157: cannot identify/lock data file 12 - see DBWR trace file
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch
O/S-Error: (OS 8205) The specified directory service attribute or value already exists.

Tue Nov 21 20:48:51 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_dbw0_1424.trc:
ORA-01157: cannot identify/lock data file 12 - see DBWR trace file
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch
O/S-Error: (OS 8205) The specified directory service attribute or value already exists.

Tue Nov 21 20:48:51 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_dbw0_1424.trc:
ORA-01157: cannot identify/lock data file 12 - see DBWR trace file
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch
O/S-Error: (OS 8205) The specified directory service attribute or value already exists.

Tue Nov 21 20:48:51 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_dbw0_1424.trc:
ORA-01157: cannot identify/lock data file 12 - see DBWR trace file
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch
O/S-Error: (OS 8205) The specified directory service attribute or value already exists.

Tue Nov 21 20:48:51 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_dbw0_1424.trc:
ORA-01157: cannot identify/lock data file 12 - see DBWR trace file
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch
O/S-Error: (OS 8205) The specified directory service attribute or value already exists.

Tue Nov 21 20:48:51 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_dbw0_1424.trc:
ORA-01157: cannot identify/lock data file 12 - see DBWR trace file
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch
O/S-Error: (OS 8205) The specified directory service attribute or value already exists.

Tue Nov 21 20:48:52 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_dbw0_1424.trc:
ORA-01157: cannot identify/lock data file 12 - see DBWR trace file
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch
O/S-Error: (OS 8205) The specified directory service attribute or value already exists.

Tue Nov 21 20:53:04 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_dbw0_1424.trc:
ORA-01157: cannot identify/lock data file 12 - see DBWR trace file
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch
O/S-Error: (OS 8205) The specified directory service attribute or value already exists.

Tue Nov 21 20:53:04 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_dbw0_1424.trc:
ORA-01157: cannot identify/lock data file 12 - see DBWR trace file
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch
O/S-Error: (OS 8205) The specified directory service attribute or value already exists.

Tue Nov 21 20:53:04 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_dbw0_1424.trc:
ORA-01157: cannot identify/lock data file 12 - see DBWR trace file
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch
O/S-Error: (OS 8205) The specified directory service attribute or value already exists.

Tue Nov 21 20:53:04 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_dbw0_1424.trc:
ORA-01157: cannot identify/lock data file 12 - see DBWR trace file
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch
O/S-Error: (OS 8205) The specified directory service attribute or value already exists.

Tue Nov 21 20:53:04 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_dbw0_1424.trc:
ORA-01157: cannot identify/lock data file 12 - see DBWR trace file
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch
O/S-Error: (OS 8205) The specified directory service attribute or value already exists.

Tue Nov 21 20:53:04 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_dbw0_1424.trc:
ORA-01157: cannot identify/lock data file 12 - see DBWR trace file
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch
O/S-Error: (OS 8205) The specified directory service attribute or value already exists.

Tue Nov 21 20:53:04 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_dbw0_1424.trc:
ORA-01157: cannot identify/lock data file 12 - see DBWR trace file
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch
O/S-Error: (OS 8205) The specified directory service attribute or value already exists.

Tue Nov 21 20:53:04 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_dbw0_1424.trc:
ORA-01157: cannot identify/lock data file 12 - see DBWR trace file
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch
O/S-Error: (OS 8205) The specified directory service attribute or value already exists.

Tue Nov 21 21:22:19 2006
Shutting down instance: further logons disabled
Shutting down instance (normal)
License high water mark = 3
All dispatchers and shared servers shutdown
Tue Nov 21 21:22:22 2006
ALTER DATABASE CLOSE NORMAL
ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
Tue Nov 21 21:22:22 2006
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Tue Nov 21 21:22:44 2006
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = FALSE
shared_pool_size = 268435456
large_pool_size = 8388608
java_pool_size = 33554432
trace_enabled = FALSE
control_files = D:\Oracle\oradata\orcl\CONTROL01.CTL, D:\Oracle\oradata\orcl\CONTROL02.CTL, D:\Oracle\oradata\orcl\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 838860800
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = orcl
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = D:\Oracle\admin\orcl\bdump
user_dump_dest = D:\Oracle\admin\orcl\udump
core_dump_dest = D:\Oracle\admin\orcl\cdump
sort_area_size = 124288
db_name = orcl
open_cursors = 10000
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
statistics_level = BASIC
aq_tm_processes = 1
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
CJQ0 started with pid=8
QMN0 started with pid=9
Tue Nov 21 21:22:47 2006
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Tue Nov 21 21:22:47 2006
ALTER DATABASE MOUNT
Tue Nov 21 21:22:51 2006
Successful mount of redo thread 1, with mount id 1134865959.
Tue Nov 21 21:22:51 2006
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Tue Nov 21 21:22:51 2006
ALTER DATABASE OPEN
Tue Nov 21 21:22:51 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_dbw0_6116.trc:
ORA-01157: cannot identify/lock data file 12 - see DBWR trace file
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch
O/S-Error: (OS 8205) The specified directory service attribute or value already exists.

ORA-1122 signalled during: ALTER DATABASE OPEN...
Tue Nov 21 21:23:34 2006
alter database recover datafile 11
Tue Nov 21 21:23:34 2006
Media Recovery Datafile: 11
Media Recovery Start
Media Recovery failed with error 1110
ORA-283 signalled during: alter database recover datafile 11...
Tue Nov 21 21:24:05 2006
alter database recover datafile 11
Tue Nov 21 21:24:05 2006
Media Recovery Datafile: 11
Media Recovery Start
Media Recovery failed with error 1110
ORA-283 signalled during: alter database recover datafile 11...
Tue Nov 21 21:24:11 2006
alter database recover datafile 11
Media Recovery Datafile: 11
Media Recovery Start
Media Recovery failed with error 1110
ORA-283 signalled during: alter database recover datafile 11...
Tue Nov 21 21:25:39 2006
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 4
All dispatchers and shared servers shutdown
Tue Nov 21 21:25:49 2006
alter database close normal
ORA-1109 signalled during: alter database close normal...
Dump file d:\oracle\admin\orcl\bdump\alert_orcl.log
Tue Nov 21 22:13:45 2006
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 1, CPU type 586
Tue Nov 21 22:13:45 2006
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = FALSE
shared_pool_size = 268435456
large_pool_size = 8388608
java_pool_size = 33554432
trace_enabled = FALSE
control_files = D:\Oracle\oradata\orcl\CONTROL01.CTL, D:\Oracle\oradata\orcl\CONTROL02.CTL, D:\Oracle\oradata\orcl\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 838860800
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = orcl
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = D:\Oracle\admin\orcl\bdump
user_dump_dest = D:\Oracle\admin\orcl\udump
core_dump_dest = D:\Oracle\admin\orcl\cdump
sort_area_size = 124288
db_name = orcl
open_cursors = 10000
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
statistics_level = BASIC
aq_tm_processes = 1
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
CJQ0 started with pid=8
QMN0 started with pid=9
Tue Nov 21 22:13:48 2006
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Tue Nov 21 22:13:49 2006
alter database mount exclusive
Tue Nov 21 22:13:53 2006
Successful mount of redo thread 1, with mount id 1134931997.
Tue Nov 21 22:13:53 2006
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Tue Nov 21 22:13:53 2006
alter database open
Tue Nov 21 22:13:53 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_dbw0_2276.trc:
ORA-01157: cannot identify/lock data file 12 - see DBWR trace file
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch
O/S-Error: (OS 8205) The specified directory service attribute or value already exists.

ORA-1122 signalled during: alter database open...
Tue Nov 21 23:03:22 2006
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 3
All dispatchers and shared servers shutdown
Tue Nov 21 23:03:25 2006
ALTER DATABASE CLOSE NORMAL
ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
Tue Nov 21 23:03:25 2006
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Tue Nov 21 23:03:34 2006
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = FALSE
shared_pool_size = 268435456
large_pool_size = 8388608
java_pool_size = 33554432
trace_enabled = FALSE
control_files = D:\Oracle\oradata\orcl\CONTROL01.CTL, D:\Oracle\oradata\orcl\CONTROL02.CTL, D:\Oracle\oradata\orcl\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 838860800
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = orcl
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = D:\Oracle\admin\orcl\bdump
user_dump_dest = D:\Oracle\admin\orcl\udump
core_dump_dest = D:\Oracle\admin\orcl\cdump
sort_area_size = 124288
db_name = orcl
open_cursors = 10000
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
statistics_level = BASIC
aq_tm_processes = 1
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
CJQ0 started with pid=8
QMN0 started with pid=9
Tue Nov 21 23:03:36 2006
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Tue Nov 21 23:03:38 2006
ALTER DATABASE MOUNT
Tue Nov 21 23:03:42 2006
Successful mount of redo thread 1, with mount id 1134911690.
Tue Nov 21 23:03:42 2006
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Tue Nov 21 23:03:43 2006
ALTER DATABASE OPEN
Tue Nov 21 23:03:43 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_dbw0_5556.trc:
ORA-01157: cannot identify/lock data file 12 - see DBWR trace file
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch
O/S-Error: (OS 8205) The specified directory service attribute or value already exists.

ORA-1122 signalled during: ALTER DATABASE OPEN...
Tue Nov 21 23:16:17 2006
ALTER DATABASE RECOVER database
Tue Nov 21 23:16:17 2006
Media Recovery Start
Tue Nov 21 23:16:17 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_dbw0_5556.trc:
ORA-01157: cannot identify/lock data file 12 - see DBWR trace file
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch
O/S-Error: (OS 8205) The specified directory service attribute or value already exists.

Media Recovery failed with error 1110
ORA-283 signalled during: ALTER DATABASE RECOVER database ...
Wed Nov 22 00:31:32 2006
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 3
All dispatchers and shared servers shutdown
Wed Nov 22 00:31:35 2006
ALTER DATABASE CLOSE NORMAL
ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
Wed Nov 22 00:31:35 2006
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Wed Nov 22 00:31:45 2006
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = FALSE
shared_pool_size = 268435456
large_pool_size = 8388608
java_pool_size = 33554432
trace_enabled = FALSE
control_files = D:\Oracle\oradata\orcl\CONTROL01.CTL, D:\Oracle\oradata\orcl\CONTROL02.CTL, D:\Oracle\oradata\orcl\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 838860800
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = orcl
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = D:\Oracle\admin\orcl\bdump
user_dump_dest = D:\Oracle\admin\orcl\udump
core_dump_dest = D:\Oracle\admin\orcl\cdump
sort_area_size = 124288
db_name = orcl
open_cursors = 10000
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
statistics_level = BASIC
aq_tm_processes = 1
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
CJQ0 started with pid=8
QMN0 started with pid=9
Wed Nov 22 00:31:48 2006
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Wed Nov 22 00:31:49 2006
ALTER DATABASE MOUNT
Wed Nov 22 00:31:53 2006
Successful mount of redo thread 1, with mount id 1134915701.
Wed Nov 22 00:31:53 2006
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Wed Nov 22 00:31:54 2006
ALTER DATABASE OPEN
Wed Nov 22 00:31:54 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_dbw0_4868.trc:
ORA-01157: cannot identify/lock data file 12 - see DBWR trace file
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch
O/S-Error: (OS 8205) The specified directory service attribute or value already exists.

ORA-1122 signalled during: ALTER DATABASE OPEN...
Wed Nov 22 00:32:33 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_dbw0_4868.trc:
ORA-01157: cannot identify/lock data file 12 - see DBWR trace file
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch
O/S-Error: (OS 8205) The specified directory service attribute or value already exists.

Wed Nov 22 00:35:09 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_dbw0_4868.trc:
ORA-01157: cannot identify/lock data file 12 - see DBWR trace file
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch
O/S-Error: (OS 8205) The specified directory service attribute or value already exists.

Wed Nov 22 00:36:33 2006
ALTER DATABASE RECOVER DATAFILE 11
Wed Nov 22 00:36:33 2006
Media Recovery Datafile: 11
Media Recovery Start
Media Recovery failed with error 1110
ORA-283 signalled during: ALTER DATABASE RECOVER DATAFILE 11 ...
Wed Nov 22 00:38:36 2006
ALTER DATABASE DATAFILE 11 OFFLINE
Wed Nov 22 00:38:37 2006
ORA-1145 signalled during: ALTER DATABASE DATAFILE 11 OFFLINE...
Wed Nov 22 00:39:44 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_dbw0_4868.trc:
ORA-01157: cannot identify/lock data file 12 - see DBWR trace file
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch
O/S-Error: (OS 8205) The specified directory service attribute or value already exists.

Wed Nov 22 00:41:21 2006
ALTER DATABASE RECOVER DATAFILE 12
Wed Nov 22 00:41:21 2006
Media Recovery Datafile: 12
Media Recovery Start
Wed Nov 22 00:41:21 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_dbw0_4868.trc:
ORA-01157: cannot identify/lock data file 12 - see DBWR trace file
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch
O/S-Error: (OS 8205) The specified directory service attribute or value already exists.

Media Recovery failed with error 1110
ORA-283 signalled during: ALTER DATABASE RECOVER DATAFILE 12 ...
Wed Nov 22 00:42:05 2006
ALTER DATABASE DATAFILE 12 OFFLINE
Wed Nov 22 00:42:05 2006
ORA-1145 signalled during: ALTER DATABASE DATAFILE 12 OFFLINE...
Wed Nov 22 00:42:16 2006
ALTER DATABASE RECOVER DATABASE
Wed Nov 22 00:42:16 2006
Media Recovery Start
Wed Nov 22 00:42:16 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_dbw0_4868.trc:
ORA-01157: cannot identify/lock data file 12 - see DBWR trace file
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch
O/S-Error: (OS 8205) The specified directory service attribute or value already exists.

Media Recovery failed with error 1110
ORA-283 signalled during: ALTER DATABASE RECOVER DATABASE ...
Wed Nov 22 00:57:34 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_dbw0_4868.trc:
ORA-01157: cannot identify/lock data file 12 - see DBWR trace file
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch
O/S-Error: (OS 8205) The specified directory service attribute or value already exists.

Wed Nov 22 01:12:38 2006
alter database backup controlfile to trace
Completed: alter database backup controlfile to trace
Wed Nov 22 01:16:17 2006
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 3
All dispatchers and shared servers shutdown
Wed Nov 22 01:16:20 2006
ALTER DATABASE CLOSE NORMAL
ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
Wed Nov 22 01:16:20 2006
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Wed Nov 22 01:16:32 2006
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = FALSE
shared_pool_size = 268435456
large_pool_size = 8388608
java_pool_size = 33554432
trace_enabled = FALSE
control_files = D:\Oracle\oradata\orcl\CONTROL01.CTL, D:\Oracle\oradata\orcl\CONTROL02.CTL, D:\Oracle\oradata\orcl\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 838860800
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = orcl
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = D:\Oracle\admin\orcl\bdump
user_dump_dest = D:\Oracle\admin\orcl\udump
core_dump_dest = D:\Oracle\admin\orcl\cdump
sort_area_size = 124288
db_name = orcl
open_cursors = 10000
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
statistics_level = BASIC
aq_tm_processes = 1
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
CJQ0 started with pid=8
QMN0
 
Upvote 0 Downvote
And some more that got truncated+++++++++++++++

Tue Nov 21 20:48:51 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_dbw0_1424.trc:
ORA-01157: cannot identify/lock data file 12 - see DBWR trace file
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch
O/S-Error: (OS 8205) The specified directory service attribute or value already exists.

Tue Nov 21 20:48:51 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_dbw0_1424.trc:
ORA-01157: cannot identify/lock data file 12 - see DBWR trace file
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch
O/S-Error: (OS 8205) The specified directory service attribute or value already exists.

Tue Nov 21 20:48:51 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_dbw0_1424.trc:
ORA-01157: cannot identify/lock data file 12 - see DBWR trace file
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch
O/S-Error: (OS 8205) The specified directory service attribute or value already exists.

Tue Nov 21 20:48:51 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_dbw0_1424.trc:
ORA-01157: cannot identify/lock data file 12 - see DBWR trace file
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch
O/S-Error: (OS 8205) The specified directory service attribute or value already exists.

Tue Nov 21 20:48:51 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_dbw0_1424.trc:
ORA-01157: cannot identify/lock data file 12 - see DBWR trace file
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch
O/S-Error: (OS 8205) The specified directory service attribute or value already exists.

Tue Nov 21 20:48:51 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_dbw0_1424.trc:
ORA-01157: cannot identify/lock data file 12 - see DBWR trace file
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch
O/S-Error: (OS 8205) The specified directory service attribute or value already exists.

Tue Nov 21 20:48:51 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_dbw0_1424.trc:
ORA-01157: cannot identify/lock data file 12 - see DBWR trace file
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch
O/S-Error: (OS 8205) The specified directory service attribute or value already exists.

Tue Nov 21 20:48:52 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_dbw0_1424.trc:
ORA-01157: cannot identify/lock data file 12 - see DBWR trace file
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch
O/S-Error: (OS 8205) The specified directory service attribute or value already exists.

Tue Nov 21 20:53:04 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_dbw0_1424.trc:
ORA-01157: cannot identify/lock data file 12 - see DBWR trace file
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch
O/S-Error: (OS 8205) The specified directory service attribute or value already exists.

Tue Nov 21 20:53:04 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_dbw0_1424.trc:
ORA-01157: cannot identify/lock data file 12 - see DBWR trace file
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch
O/S-Error: (OS 8205) The specified directory service attribute or value already exists.

Tue Nov 21 20:53:04 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_dbw0_1424.trc:
ORA-01157: cannot identify/lock data file 12 - see DBWR trace file
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch
O/S-Error: (OS 8205) The specified directory service attribute or value already exists.

Tue Nov 21 20:53:04 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_dbw0_1424.trc:
ORA-01157: cannot identify/lock data file 12 - see DBWR trace file
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch
O/S-Error: (OS 8205) The specified directory service attribute or value already exists.

Tue Nov 21 20:53:04 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_dbw0_1424.trc:
ORA-01157: cannot identify/lock data file 12 - see DBWR trace file
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch
O/S-Error: (OS 8205) The specified directory service attribute or value already exists.

Tue Nov 21 20:53:04 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_dbw0_1424.trc:
ORA-01157: cannot identify/lock data file 12 - see DBWR trace file
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch
O/S-Error: (OS 8205) The specified directory service attribute or value already exists.

Tue Nov 21 20:53:04 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_dbw0_1424.trc:
ORA-01157: cannot identify/lock data file 12 - see DBWR trace file
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch
O/S-Error: (OS 8205) The specified directory service attribute or value already exists.

Tue Nov 21 20:53:04 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_dbw0_1424.trc:
ORA-01157: cannot identify/lock data file 12 - see DBWR trace file
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch
O/S-Error: (OS 8205) The specified directory service attribute or value already exists.

Tue Nov 21 21:22:19 2006
Shutting down instance: further logons disabled
Shutting down instance (normal)
License high water mark = 3
All dispatchers and shared servers shutdown
Tue Nov 21 21:22:22 2006
ALTER DATABASE CLOSE NORMAL
ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
Tue Nov 21 21:22:22 2006
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Tue Nov 21 21:22:44 2006
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = FALSE
shared_pool_size = 268435456
large_pool_size = 8388608
java_pool_size = 33554432
trace_enabled = FALSE
control_files = D:\Oracle\oradata\orcl\CONTROL01.CTL, D:\Oracle\oradata\orcl\CONTROL02.CTL, D:\Oracle\oradata\orcl\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 838860800
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = orcl
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = D:\Oracle\admin\orcl\bdump
user_dump_dest = D:\Oracle\admin\orcl\udump
core_dump_dest = D:\Oracle\admin\orcl\cdump
sort_area_size = 124288
db_name = orcl
open_cursors = 10000
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
statistics_level = BASIC
aq_tm_processes = 1
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
CJQ0 started with pid=8
QMN0 started with pid=9
Tue Nov 21 21:22:47 2006
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Tue Nov 21 21:22:47 2006
ALTER DATABASE MOUNT
Tue Nov 21 21:22:51 2006
Successful mount of redo thread 1, with mount id 1134865959.
Tue Nov 21 21:22:51 2006
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Tue Nov 21 21:22:51 2006
ALTER DATABASE OPEN
Tue Nov 21 21:22:51 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_dbw0_6116.trc:
ORA-01157: cannot identify/lock data file 12 - see DBWR trace file
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch
O/S-Error: (OS 8205) The specified directory service attribute or value already exists.

ORA-1122 signalled during: ALTER DATABASE OPEN...
Tue Nov 21 21:23:34 2006
alter database recover datafile 11
Tue Nov 21 21:23:34 2006
Media Recovery Datafile: 11
Media Recovery Start
Media Recovery failed with error 1110
ORA-283 signalled during: alter database recover datafile 11...
Tue Nov 21 21:24:05 2006
alter database recover datafile 11
Tue Nov 21 21:24:05 2006
Media Recovery Datafile: 11
Media Recovery Start
Media Recovery failed with error 1110
ORA-283 signalled during: alter database recover datafile 11...
Tue Nov 21 21:24:11 2006
alter database recover datafile 11
Media Recovery Datafile: 11
Media Recovery Start
Media Recovery failed with error 1110
ORA-283 signalled during: alter database recover datafile 11...
Tue Nov 21 21:25:39 2006
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 4
All dispatchers and shared servers shutdown
Tue Nov 21 21:25:49 2006
alter database close normal
ORA-1109 signalled during: alter database close normal...
Dump file d:\oracle\admin\orcl\bdump\alert_orcl.log
Tue Nov 21 22:13:45 2006
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 1, CPU type 586
Tue Nov 21 22:13:45 2006
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = FALSE
shared_pool_size = 268435456
large_pool_size = 8388608
java_pool_size = 33554432
trace_enabled = FALSE
control_files = D:\Oracle\oradata\orcl\CONTROL01.CTL, D:\Oracle\oradata\orcl\CONTROL02.CTL, D:\Oracle\oradata\orcl\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 838860800
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = orcl
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = D:\Oracle\admin\orcl\bdump
user_dump_dest = D:\Oracle\admin\orcl\udump
core_dump_dest = D:\Oracle\admin\orcl\cdump
sort_area_size = 124288
db_name = orcl
open_cursors = 10000
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
statistics_level = BASIC
aq_tm_processes = 1
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
CJQ0 started with pid=8
QMN0 started with pid=9
Tue Nov 21 22:13:48 2006
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Tue Nov 21 22:13:49 2006
alter database mount exclusive
Tue Nov 21 22:13:53 2006
Successful mount of redo thread 1, with mount id 1134931997.
Tue Nov 21 22:13:53 2006
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Tue Nov 21 22:13:53 2006
alter database open
Tue Nov 21 22:13:53 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_dbw0_2276.trc:
ORA-01157: cannot identify/lock data file 12 - see DBWR trace file
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch
O/S-Error: (OS 8205) The specified directory service attribute or value already exists.

ORA-1122 signalled during: alter database open...
Tue Nov 21 23:03:22 2006
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 3
All dispatchers and shared servers shutdown
Tue Nov 21 23:03:25 2006
ALTER DATABASE CLOSE NORMAL
ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
Tue Nov 21 23:03:25 2006
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Tue Nov 21 23:03:34 2006
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = FALSE
shared_pool_size = 268435456
large_pool_size = 8388608
java_pool_size = 33554432
trace_enabled = FALSE
control_files = D:\Oracle\oradata\orcl\CONTROL01.CTL, D:\Oracle\oradata\orcl\CONTROL02.CTL, D:\Oracle\oradata\orcl\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 838860800
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = orcl
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = D:\Oracle\admin\orcl\bdump
user_dump_dest = D:\Oracle\admin\orcl\udump
core_dump_dest = D:\Oracle\admin\orcl\cdump
sort_area_size = 124288
db_name = orcl
open_cursors = 10000
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
statistics_level = BASIC
aq_tm_processes = 1
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
CJQ0 started with pid=8
QMN0 started with pid=9
Tue Nov 21 23:03:36 2006
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Tue Nov 21 23:03:38 2006
ALTER DATABASE MOUNT
Tue Nov 21 23:03:42 2006
Successful mount of redo thread 1, with mount id 1134911690.
Tue Nov 21 23:03:42 2006
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Tue Nov 21 23:03:43 2006
ALTER DATABASE OPEN
Tue Nov 21 23:03:43 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_dbw0_5556.trc:
ORA-01157: cannot identify/lock data file 12 - see DBWR trace file
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch
O/S-Error: (OS 8205) The specified directory service attribute or value already exists.

ORA-1122 signalled during: ALTER DATABASE OPEN...
Tue Nov 21 23:16:17 2006
ALTER DATABASE RECOVER database
Tue Nov 21 23:16:17 2006
Media Recovery Start
Tue Nov 21 23:16:17 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_dbw0_5556.trc:
ORA-01157: cannot identify/lock data file 12 - see DBWR trace file
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch
O/S-Error: (OS 8205) The specified directory service attribute or value already exists.

Media Recovery failed with error 1110
ORA-283 signalled during: ALTER DATABASE RECOVER database ...
Wed Nov 22 00:31:32 2006
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 3
All dispatchers and shared servers shutdown
Wed Nov 22 00:31:35 2006
ALTER DATABASE CLOSE NORMAL
ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
Wed Nov 22 00:31:35 2006
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Wed Nov 22 00:31:45 2006
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = FALSE
shared_pool_size = 268435456
large_pool_size = 8388608
java_pool_size = 33554432
trace_enabled = FALSE
control_files = D:\Oracle\oradata\orcl\CONTROL01.CTL, D:\Oracle\oradata\orcl\CONTROL02.CTL, D:\Oracle\oradata\orcl\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 838860800
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = orcl
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = D:\Oracle\admin\orcl\bdump
user_dump_dest = D:\Oracle\admin\orcl\udump
core_dump_dest = D:\Oracle\admin\orcl\cdump
sort_area_size = 124288
db_name = orcl
open_cursors = 10000
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
statistics_level = BASIC
aq_tm_processes = 1
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
CJQ0 started with pid=8
QMN0 started with pid=9
Wed Nov 22 00:31:48 2006
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Wed Nov 22 00:31:49 2006
ALTER DATABASE MOUNT
Wed Nov 22 00:31:53 2006
Successful mount of redo thread 1, with mount id 1134915701.
Wed Nov 22 00:31:53 2006
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Wed Nov 22 00:31:54 2006
ALTER DATABASE OPEN
Wed Nov 22 00:31:54 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_dbw0_4868.trc:
ORA-01157: cannot identify/lock data file 12 - see DBWR trace file
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch
O/S-Error: (OS 8205) The specified directory service attribute or value already exists.

ORA-1122 signalled during: ALTER DATABASE OPEN...
Wed Nov 22 00:32:33 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_dbw0_4868.trc:
ORA-01157: cannot identify/lock data file 12 - see DBWR trace file
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch
O/S-Error: (OS 8205) The specified directory service attribute or value already exists.

Wed Nov 22 00:35:09 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_dbw0_4868.trc:
ORA-01157: cannot identify/lock data file 12 - see DBWR trace file
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch
O/S-Error: (OS 8205) The specified directory service attribute or value already exists.

Wed Nov 22 00:36:33 2006
ALTER DATABASE RECOVER DATAFILE 11
Wed Nov 22 00:36:33 2006
Media Recovery Datafile: 11
Media Recovery Start
Media Recovery failed with error 1110
ORA-283 signalled during: ALTER DATABASE RECOVER DATAFILE 11 ...
Wed Nov 22 00:38:36 2006
ALTER DATABASE DATAFILE 11 OFFLINE
Wed Nov 22 00:38:37 2006
ORA-1145 signalled during: ALTER DATABASE DATAFILE 11 OFFLINE...
Wed Nov 22 00:39:44 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_dbw0_4868.trc:
ORA-01157: cannot identify/lock data file 12 - see DBWR trace file
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch
O/S-Error: (OS 8205) The specified directory service attribute or value already exists.

Wed Nov 22 00:41:21 2006
ALTER DATABASE RECOVER DATAFILE 12
Wed Nov 22 00:41:21 2006
Media Recovery Datafile: 12
Media Recovery Start
Wed Nov 22 00:41:21 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_dbw0_4868.trc:
ORA-01157: cannot identify/lock data file 12 - see DBWR trace file
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch
O/S-Error: (OS 8205) The specified directory service attribute or value already exists.

Media Recovery failed with error 1110
ORA-283 signalled during: ALTER DATABASE RECOVER DATAFILE 12 ...
Wed Nov 22 00:42:05 2006
ALTER DATABASE DATAFILE 12 OFFLINE
Wed Nov 22 00:42:05 2006
ORA-1145 signalled during: ALTER DATABASE DATAFILE 12 OFFLINE...
Wed Nov 22 00:42:16 2006
ALTER DATABASE RECOVER DATABASE
Wed Nov 22 00:42:16 2006
Media Recovery Start
Wed Nov 22 00:42:16 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_dbw0_4868.trc:
ORA-01157: cannot identify/lock data file 12 - see DBWR trace file
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch
O/S-Error: (OS 8205) The specified directory service attribute or value already exists.

Media Recovery failed with error 1110
ORA-283 signalled during: ALTER DATABASE RECOVER DATABASE ...
Wed Nov 22 00:57:34 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_dbw0_4868.trc:
ORA-01157: cannot identify/lock data file 12 - see DBWR trace file
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch
O/S-Error: (OS 8205) The specified directory service attribute or value already exists.

Wed Nov 22 01:12:38 2006
alter database backup controlfile to trace
Completed: alter database backup controlfile to trace
Wed Nov 22 01:16:17 2006
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 3
All dispatchers and shared servers shutdown
Wed Nov 22 01:16:20 2006
ALTER DATABASE CLOSE NORMAL
ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
Wed Nov 22 01:16:20 2006
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Wed Nov 22 01:16:32 2006
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = FALSE
shared_pool_size = 268435456
large_pool_size = 8388608
java_pool_size = 33554432
trace_enabled = FALSE
control_files = D:\Oracle\oradata\orcl\CONTROL01.CTL, D:\Oracle\oradata\orcl\CONTROL02.CTL, D:\Oracle\oradata\orcl\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 838860800
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = orcl
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = D:\Oracle\admin\orcl\bdump
user_dump_dest = D:\Oracle\admin\orcl\udump
core_dump_dest = D:\Oracle\admin\orcl\cdump
sort_area_size = 124288
db_name = orcl
open_cursors = 10000
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
statistics_level = BASIC
aq_tm_processes = 1
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
CJQ0 started with pid=8
QMN0 started with pid=9
Wed Nov 22 01:16:35 2006
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Wed Nov 22 01:17:19 2006
CREATE CONTROLFILE REUSE DATABASE "ORCL" NORESETLOGS NOARCHIVELOG
MAXLOGFILES 50
MAXLOGMEMBERS 5
MAXDATAFILES 100
MAXINSTANCES 1
MAXLOGHISTORY 453
LOGFILE
GROUP 1 'D:\ORACLE\ORADATA\ORCL\REDO01.LOG' SIZE 100M,
GROUP 2 'D:\ORACLE\ORADATA\ORCL\REDO02.LOG' SIZE 100M,
GROUP 3 'D:\ORACLE\ORADATA\ORCL\REDO03.LOG' SIZE 100M
DATAFILE
'D:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF',
'D:\ORACLE\ORADATA\ORCL\UNDOTBS01.DBF',
'D:\ORACLE\ORADATA\ORCL\CWMLITE01.DBF',
'D:\ORACLE\ORADATA\ORCL\DRSYS01.DBF',
'D:\ORACLE\ORADATA\ORCL\EXAMPLE01.DBF',
'D:\ORACLE\ORADATA\ORCL\INDX01.DBF',
'D:\ORACLE\ORADATA\ORCL\ODM01.DBF',
'D:\ORACLE\ORADATA\ORCL\TOOLS01.DBF',
'D:\ORACLE\ORADATA\ORCL\USERS01.DBF',
'D:\ORACLE\ORADATA\ORCL\XDB01.DBF',
'D:\DATAFILE\ORION01.DBF',
'D:\DATAFILE\ORION02.DBF',
'D:\DATAFILE\ORION101.DBF'
CHARACTER SET WE8MSWIN1252

Wed Nov 22 01:17:22 2006
ORA-1503 signalled during: CREATE CONTROLFILE REUSE DATABASE "ORCL" NORESETLO...
Wed Nov 22 01:22:47 2006
alter database mount

Wed Nov 22 01:22:52 2006
Successful mount of redo thread 1, with mount id 1134953831.
Wed Nov 22 01:22:52 2006
Database mounted in Exclusive Mode.
Completed: alter database mount
Wed Nov 22 01:23:03 2006
alter database datafile 11 offline
Wed Nov 22 01:23:03 2006
ORA-1145 signalled during: alter database datafile 11 offline...
Wed Nov 22 01:23:09 2006
alter database datafile 11 offline drop
Completed: alter database datafile 11 offline drop
Wed Nov 22 01:23:15 2006
alter database datafile 12 offline drop
Completed: alter database datafile 12 offline drop
Wed Nov 22 01:23:23 2006
alter database open
Wed Nov 22 01:23:23 2006
Beginning crash recovery of 1 threads
Wed Nov 22 01:23:24 2006
Started first pass scan
Wed Nov 22 01:23:24 2006
Completed first pass scan
112146 redo blocks read, 177 data blocks need recovery
Wed Nov 22 01:23:24 2006
Started recovery at
Thread 1: logseq 395, block 2, scn 0.24339581
Recovery of Online Redo Log: Thread 1 Group 1 Seq 395 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG
Wed Nov 22 01:23:25 2006
Ended recovery at
Thread 1: logseq 395, block 112148, scn 0.24383092
177 data blocks read, 177 data blocks written, 112146 redo blocks read
Crash recovery completed successfully
Wed Nov 22 01:23:25 2006
Thread 1 advanced to log sequence 396
Thread 1 opened at log sequence 396
Current log# 2 seq# 396 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO02.LOG
Successful open of redo thread 1.
Wed Nov 22 01:23:25 2006
SMON: enabling cache recovery
Wed Nov 22 01:23:25 2006
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Wed Nov 22 01:23:25 2006
SMON: enabling tx recovery
Wed Nov 22 01:23:25 2006
Database Characterset is WE8MSWIN1252
Wed Nov 22 01:23:25 2006
ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (4, 17) on object 34462.
Wed Nov 22 01:23:25 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

Wed Nov 22 01:23:27 2006
replication_dependency_tracking turned off (no async multimaster replication found)
Wed Nov 22 01:23:28 2006
ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (6, 19) on object 33917.
Wed Nov 22 01:23:28 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

Wed Nov 22 01:23:29 2006
Completed: alter database open
Wed Nov 22 01:23:31 2006
ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (4, 17) on object 34462.
Wed Nov 22 01:23:31 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (6, 19) on object 33917.
Wed Nov 22 01:23:33 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

Wed Nov 22 01:24:05 2006
alter database datafile 12 online
Wed Nov 22 01:24:05 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_dbw0_4220.trc:
ORA-01157: cannot identify/lock data file 12 - see DBWR trace file
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch
O/S-Error: (OS 8205) The specified directory service attribute or value already exists.

Wed Nov 22 01:24:05 2006
ORA-1157 signalled during: alter database datafile 12 online...
Wed Nov 22 01:24:13 2006
alter database datafile 11 online
ORA-1122 signalled during: alter database datafile 11 online...
Wed Nov 22 01:28:20 2006
drop tablespace orion including contents and datafiles
Wed Nov 22 01:28:21 2006
ORA-2449 signalled during: drop tablespace orion including contents and dataf...
Wed Nov 22 01:28:21 2006
ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (4, 17) on object 34462.
Wed Nov 22 01:28:21 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (6, 19) on object 33917.
Wed Nov 22 01:28:23 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

Wed Nov 22 01:30:15 2006
drop tablespace orion including contents and datafiles
Wed Nov 22 01:30:16 2006
ORA-2449 signalled during: drop tablespace orion including contents and dataf...
Wed Nov 22 01:30:16 2006
ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (4, 17) on object 34462.
Wed Nov 22 01:30:16 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (6, 19) on object 33917.
Wed Nov 22 01:30:17 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

Wed Nov 22 01:35:14 2006
ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (4, 17) on object 34462.
Wed Nov 22 01:35:14 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (6, 19) on object 33917.
Wed Nov 22 01:35:16 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (4, 17) on object 34462.
Wed Nov 22 01:35:18 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (6, 19) on object 33917.
Wed Nov 22 01:35:19 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (4, 17) on object 34462.
Wed Nov 22 01:35:21 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (6, 19) on object 33917.
Wed Nov 22 01:35:23 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (4, 17) on object 34462.
Wed Nov 22 01:35:24 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (6, 19) on object 33917.
Wed Nov 22 01:35:26 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (4, 17) on object 34462.
Wed Nov 22 01:35:28 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (6, 19) on object 33917.
Wed Nov 22 01:35:29 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (4, 17) on object 34462.
Wed Nov 22 01:35:31 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (6, 19) on object 33917.
Wed Nov 22 01:35:33 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (4, 17) on object 34462.
Wed Nov 22 01:35:34 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (6, 19) on object 33917.
Wed Nov 22 01:35:37 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (4, 17) on object 34462.
Wed Nov 22 01:35:38 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (6, 19) on object 33917.
Wed Nov 22 01:35:40 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (4, 17) on object 34462.
Wed Nov 22 01:35:42 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (6, 19) on object 33917.
Wed Nov 22 01:35:43 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (4, 17) on object 34462.
Wed Nov 22 01:35:45 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (6, 19) on object 33917.
Wed Nov 22 01:35:47 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (4, 17) on object 34462.
Wed Nov 22 01:35:49 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (6, 19) on object 33917.
Wed Nov 22 01:35:51 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (4, 17) on object 34462.
Wed Nov 22 01:35:53 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (6, 19) on object 33917.
Wed Nov 22 01:35:54 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (4, 17) on object 34462.
Wed Nov 22 01:35:56 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (6, 19) on object 33917.
Wed Nov 22 01:35:57 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (4, 17) on object 34462.
Wed Nov 22 01:35:59 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (6, 19) on object 33917.
Wed Nov 22 01:36:01 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

Wed Nov 22 01:36:02 2006
Thread 1 advanced to log sequence 397
Current log# 3 seq# 397 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO03.LOG
Wed Nov 22 01:36:03 2006
ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (4, 17) on object 34462.
Wed Nov 22 01:36:03 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (6, 19) on object 33917.
Wed Nov 22 01:36:04 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (4, 17) on object 34462.
Wed Nov 22 01:36:06 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (6, 19) on object 33917.
Wed Nov 22 01:36:08 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (4, 17) on object 34462.
Wed Nov 22 01:36:10 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (6, 19) on object 33917.
Wed Nov 22 01:36:11 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (4, 17) on object 34462.
Wed Nov 22 01:36:13 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (6, 19) on object 33917.
Wed Nov 22 01:36:15 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (4, 17) on object 34462.
Wed Nov 22 01:36:16 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (6, 19) on object 33917.
Wed Nov 22 01:36:18 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (4, 17) on object 34462.
Wed Nov 22 01:36:19 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (6, 19) on object 33917.
Wed Nov 22 01:36:21 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (4, 17) on object 34462.
Wed Nov 22 01:36:23 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (6, 19) on object 33917.
Wed Nov 22 01:36:25 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (4, 17) on object 34462.
Wed Nov 22 01:36:26 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (6, 19) on object 33917.
Wed Nov 22 01:36:28 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (4, 17) on object 34462.
Wed Nov 22 01:36:30 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (6, 19) on object 33917.
Wed Nov 22 01:36:32 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (4, 17) on object 34462.
Wed Nov 22 01:36:34 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (6, 19) on object 33917.
Wed Nov 22 01:36:35 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (4, 17) on object 34462.
Wed Nov 22 01:36:37 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (6, 19) on object 33917.
Wed Nov 22 01:36:39 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (4, 17) on object 34462.
Wed Nov 22 01:36:41 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (6, 19) on object 33917.
Wed Nov 22 01:36:43 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (4, 17) on object 34462.
Wed Nov 22 01:36:44 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (6, 19) on object 33917.
Wed Nov 22 01:36:46 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (4, 17) on object 34462.
Wed Nov 22 01:36:48 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (6, 19) on object 33917.
Wed Nov 22 01:36:49 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (4, 17) on object 34462.
Wed Nov 22 01:36:51 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (6, 19) on object 33917.
Wed Nov 22 01:36:53 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (4, 17) on object 34462.
Wed Nov 22 01:36:54 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (6, 19) on object 33917.
Wed Nov 22 01:36:56 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (4, 17) on object 34462.
Wed Nov 22 01:36:58 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (6, 19) on object 33917.
Wed Nov 22 01:37:00 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (4, 17) on object 34462.
Wed Nov 22 01:37:02 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (6, 19) on object 33917.
Wed Nov 22 01:37:03 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (4, 17) on object 34462.
Wed Nov 22 01:37:05 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (6, 19) on object 33917.
Wed Nov 22 01:37:07 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (4, 17) on object 34462.
Wed Nov 22 01:37:09 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (6, 19) on object 33917.
Wed Nov 22 01:37:11 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (4, 17) on object 34462.
Wed Nov 22 01:37:12 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (6, 19) on object 33917.
Wed Nov 22 01:37:14 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (4, 17) on object 34462.
Wed Nov 22 01:37:16 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (6, 19) on object 33917.
Wed Nov 22 01:37:18 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (4, 17) on object 34462.
Wed Nov 22 01:37:19 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (6, 19) on object 33917.
Wed Nov 22 01:37:21 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (4, 17) on object 34462.
Wed Nov 22 01:37:23 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (6, 19) on object 33917.
Wed Nov 22 01:37:25 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (4, 17) on object 34462.
Wed Nov 22 01:37:26 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (6, 19) on object 33917.
Wed Nov 22 01:37:28 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (4, 17) on object 34462.
Wed Nov 22 01:37:30 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (6, 19) on object 33917.
Wed Nov 22 01:37:31 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (4, 17) on object 34462.
Wed Nov 22 01:37:33 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (6, 19) on object 34567.
Wed Nov 22 01:37:34 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 11 cannot be read at this time
ORA-01110: data file 11: 'D:\DATAFILE\ORION01.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (4, 17) on object 34462.
Wed Nov 22 01:37:36 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (6, 19) on object 34567.
Wed Nov 22 01:37:38 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 11 cannot be read at this time
ORA-01110: data file 11: 'D:\DATAFILE\ORION01.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (4, 17) on object 34462.
Wed Nov 22 01:37:40 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (6, 19) on object 34567.
Wed Nov 22 01:37:41 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 11 cannot be read at this time
ORA-01110: data file 11: 'D:\DATAFILE\ORION01.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (4, 17) on object 34462.
Wed Nov 22 01:37:43 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (6, 19) on object 34567.
Wed Nov 22 01:37:45 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 11 cannot be read at this time
ORA-01110: data file 11: 'D:\DATAFILE\ORION01.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (6, 19) on object 34567.
Wed Nov 22 01:37:46 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 11 cannot be read at this time
ORA-01110: data file 11: 'D:\DATAFILE\ORION01.DBF'

Wed Nov 22 01:37:53 2006
Thread 1 advanced to log sequence 398
Current log# 1 seq# 398 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG
Wed Nov 22 01:38:31 2006
Thread 1 advanced to log sequence 399
Current log# 2 seq# 399 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO02.LOG
Wed Nov 22 01:39:08 2006
Thread 1 advanced to log sequence 400
Current log# 3 seq# 400 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO03.LOG
Wed Nov 22 01:41:22 2006
drop tablespace orion including contents and datafiles
Wed Nov 22 01:42:22 2006
Thread 1 advanced to log sequence 401
Current log# 1 seq# 401 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG
Wed Nov 22 01:42:57 2006
Errors in file d:\oracle\admin\orcl\udump\orcl_ora_5520.trc:
ORA-01122: database file 11 failed verification check
ORA-01110: data file 11: 'D:\DATAFILE\ORION01.DBF'
ORA-01251: Unknown File Header Version read for file number 11

Wed Nov 22 01:42:57 2006
Errors in file d:\oracle\admin\orcl\udump\orcl_ora_5520.trc:
ORA-01259: unable to delete datafile D:\DATAFILE\ORION01.DBF

Wed Nov 22 01:42:57 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_dbw0_4220.trc:
ORA-01157: cannot identify/lock data file 12 - see DBWR trace file
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch
O/S-Error: (OS 8205) The specified directory service attribute or value already exists.

Wed Nov 22 01:42:57 2006
Errors in file d:\oracle\admin\orcl\udump\orcl_ora_5520.trc:
ORA-01157: cannot identify/lock data file 12 - see DBWR trace file
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'
ORA-01259: unable to delete datafile D:\DATAFILE\ORION01.DBF

Wed Nov 22 01:42:57 2006
Errors in file d:\oracle\admin\orcl\udump\orcl_ora_5520.trc:
ORA-01259: unable to delete datafile D:\DATAFILE\ORION02.DBF

Wed Nov 22 01:42:59 2006
Completed: drop tablespace orion including contents and dataf
Wed Nov 22 01:45:52 2006
alter tablespace orion1 add datafile 'd:\datafile\orion102.dbf' size 3072m
Wed Nov 22 01:46:21 2006
Completed: alter tablespace orion1 add datafile 'd:\datafile\
Wed Nov 22 01:55:20 2006
Thread 1 advanced to log sequence 402
Current log# 2 seq# 402 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO02.LOG
Wed Nov 22 01:56:30 2006
Thread 1 advanced to log sequence 403
Current log# 3 seq# 403 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO03.LOG
Wed Nov 22 01:56:58 2006
Thread 1 advanced to log sequence 404
Current log# 1 seq# 404 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG
Wed Nov 22 01:57:26 2006
Thread 1 advanced to log sequence 405
Current log# 2 seq# 405 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO02.LOG
Wed Nov 22 01:58:58 2006
Thread 1 advanced to log sequence 406
Current log# 3 seq# 406 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO03.LOG
Wed Nov 22 01:59:25 2006
Thread 1 advanced to log sequence 407
Current log# 1 seq# 407 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG
Wed Nov 22 01:59:53 2006
Thread 1 advanced to log sequence 408
Current log# 2 seq# 408 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO02.LOG
Wed Nov 22 02:00:38 2006
Thread 1 advanced to log sequence 409
Current log# 3 seq# 409 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO03.LOG
Wed Nov 22 02:01:25 2006
Thread 1 advanced to log sequence 410
Current log# 1 seq# 410 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG
Wed Nov 22 02:02:15 2006
Thread 1 advanced to log sequence 411
Current log# 2 seq# 411 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO02.LOG
Wed Nov 22 02:03:17 2006
Thread 1 advanced to log sequence 412
Current log# 3 seq# 412 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO03.LOG
Wed Nov 22 02:03:48 2006
Thread 1 advanced to log sequence 413
Current log# 1 seq# 413 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG
Wed Nov 22 02:04:07 2006
Thread 1 advanced to log sequence 414
Current log# 2 seq# 414 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO02.LOG
Wed Nov 22 02:04:24 2006
Thread 1 advanced to log sequence 415
Current log# 3 seq# 415 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO03.LOG
Wed Nov 22 02:05:09 2006
Thread 1 advanced to log sequence 416
Current log# 1 seq# 416 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG
Wed Nov 22 02:05:39 2006
Thread 1 advanced to log sequence 417
Current log# 2 seq# 417 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO02.LOG
Wed Nov 22 02:06:23 2006
Thread 1 advanced to log sequence 418
Current log# 3 seq# 418 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO03.LOG
Wed Nov 22 02:06:43 2006
Thread 1 advanced to log
 
Upvote 0 Downvote
and some more!
++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Wed Nov 22 01:36:41 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (6, 19) on object 33917.
Wed Nov 22 01:36:43 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (4, 17) on object 34462.
Wed Nov 22 01:36:44 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (6, 19) on object 33917.
Wed Nov 22 01:36:46 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (4, 17) on object 34462.
Wed Nov 22 01:36:48 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (6, 19) on object 33917.
Wed Nov 22 01:36:49 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (4, 17) on object 34462.
Wed Nov 22 01:36:51 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (6, 19) on object 33917.
Wed Nov 22 01:36:53 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (4, 17) on object 34462.
Wed Nov 22 01:36:54 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (6, 19) on object 33917.
Wed Nov 22 01:36:56 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (4, 17) on object 34462.
Wed Nov 22 01:36:58 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (6, 19) on object 33917.
Wed Nov 22 01:37:00 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (4, 17) on object 34462.
Wed Nov 22 01:37:02 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (6, 19) on object 33917.
Wed Nov 22 01:37:03 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (4, 17) on object 34462.
Wed Nov 22 01:37:05 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (6, 19) on object 33917.
Wed Nov 22 01:37:07 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (4, 17) on object 34462.
Wed Nov 22 01:37:09 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (6, 19) on object 33917.
Wed Nov 22 01:37:11 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (4, 17) on object 34462.
Wed Nov 22 01:37:12 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (6, 19) on object 33917.
Wed Nov 22 01:37:14 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (4, 17) on object 34462.
Wed Nov 22 01:37:16 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (6, 19) on object 33917.
Wed Nov 22 01:37:18 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (4, 17) on object 34462.
Wed Nov 22 01:37:19 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (6, 19) on object 33917.
Wed Nov 22 01:37:21 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (4, 17) on object 34462.
Wed Nov 22 01:37:23 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (6, 19) on object 33917.
Wed Nov 22 01:37:25 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (4, 17) on object 34462.
Wed Nov 22 01:37:26 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (6, 19) on object 33917.
Wed Nov 22 01:37:28 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (4, 17) on object 34462.
Wed Nov 22 01:37:30 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (6, 19) on object 33917.
Wed Nov 22 01:37:31 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (4, 17) on object 34462.
Wed Nov 22 01:37:33 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (6, 19) on object 34567.
Wed Nov 22 01:37:34 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 11 cannot be read at this time
ORA-01110: data file 11: 'D:\DATAFILE\ORION01.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (4, 17) on object 34462.
Wed Nov 22 01:37:36 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (6, 19) on object 34567.
Wed Nov 22 01:37:38 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 11 cannot be read at this time
ORA-01110: data file 11: 'D:\DATAFILE\ORION01.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (4, 17) on object 34462.
Wed Nov 22 01:37:40 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (6, 19) on object 34567.
Wed Nov 22 01:37:41 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 11 cannot be read at this time
ORA-01110: data file 11: 'D:\DATAFILE\ORION01.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (4, 17) on object 34462.
Wed Nov 22 01:37:43 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 12 cannot be read at this time
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (6, 19) on object 34567.
Wed Nov 22 01:37:45 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 11 cannot be read at this time
ORA-01110: data file 11: 'D:\DATAFILE\ORION01.DBF'

ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (6, 19) on object 34567.
Wed Nov 22 01:37:46 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_smon_5224.trc:
ORA-00376: file 11 cannot be read at this time
ORA-01110: data file 11: 'D:\DATAFILE\ORION01.DBF'

Wed Nov 22 01:37:53 2006
Thread 1 advanced to log sequence 398
Current log# 1 seq# 398 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG
Wed Nov 22 01:38:31 2006
Thread 1 advanced to log sequence 399
Current log# 2 seq# 399 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO02.LOG
Wed Nov 22 01:39:08 2006
Thread 1 advanced to log sequence 400
Current log# 3 seq# 400 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO03.LOG
Wed Nov 22 01:41:22 2006
drop tablespace orion including contents and datafiles
Wed Nov 22 01:42:22 2006
Thread 1 advanced to log sequence 401
Current log# 1 seq# 401 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG
Wed Nov 22 01:42:57 2006
Errors in file d:\oracle\admin\orcl\udump\orcl_ora_5520.trc:
ORA-01122: database file 11 failed verification check
ORA-01110: data file 11: 'D:\DATAFILE\ORION01.DBF'
ORA-01251: Unknown File Header Version read for file number 11

Wed Nov 22 01:42:57 2006
Errors in file d:\oracle\admin\orcl\udump\orcl_ora_5520.trc:
ORA-01259: unable to delete datafile D:\DATAFILE\ORION01.DBF

Wed Nov 22 01:42:57 2006
Errors in file d:\oracle\admin\orcl\bdump\orcl_dbw0_4220.trc:
ORA-01157: cannot identify/lock data file 12 - see DBWR trace file
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch
O/S-Error: (OS 8205) The specified directory service attribute or value already exists.

Wed Nov 22 01:42:57 2006
Errors in file d:\oracle\admin\orcl\udump\orcl_ora_5520.trc:
ORA-01157: cannot identify/lock data file 12 - see DBWR trace file
ORA-01110: data file 12: 'D:\DATAFILE\ORION02.DBF'
ORA-01259: unable to delete datafile D:\DATAFILE\ORION01.DBF

Wed Nov 22 01:42:57 2006
Errors in file d:\oracle\admin\orcl\udump\orcl_ora_5520.trc:
ORA-01259: unable to delete datafile D:\DATAFILE\ORION02.DBF

Wed Nov 22 01:42:59 2006
Completed: drop tablespace orion including contents and dataf
Wed Nov 22 01:45:52 2006
alter tablespace orion1 add datafile 'd:\datafile\orion102.dbf' size 3072m
Wed Nov 22 01:46:21 2006
Completed: alter tablespace orion1 add datafile 'd:\datafile\
Wed Nov 22 01:55:20 2006
Thread 1 advanced to log sequence 402
Current log# 2 seq# 402 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO02.LOG
Wed Nov 22 01:56:30 2006
Thread 1 advanced to log sequence 403
Current log# 3 seq# 403 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO03.LOG
Wed Nov 22 01:56:58 2006
Thread 1 advanced to log sequence 404
Current log# 1 seq# 404 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG
Wed Nov 22 01:57:26 2006
Thread 1 advanced to log sequence 405
Current log# 2 seq# 405 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO02.LOG
Wed Nov 22 01:58:58 2006
Thread 1 advanced to log sequence 406
Current log# 3 seq# 406 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO03.LOG
Wed Nov 22 01:59:25 2006
Thread 1 advanced to log sequence 407
Current log# 1 seq# 407 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG
Wed Nov 22 01:59:53 2006
Thread 1 advanced to log sequence 408
Current log# 2 seq# 408 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO02.LOG
Wed Nov 22 02:00:38 2006
Thread 1 advanced to log sequence 409
Current log# 3 seq# 409 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO03.LOG
Wed Nov 22 02:01:25 2006
Thread 1 advanced to log sequence 410
Current log# 1 seq# 410 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG
Wed Nov 22 02:02:15 2006
Thread 1 advanced to log sequence 411
Current log# 2 seq# 411 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO02.LOG
Wed Nov 22 02:03:17 2006
Thread 1 advanced to log sequence 412
Current log# 3 seq# 412 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO03.LOG
Wed Nov 22 02:03:48 2006
Thread 1 advanced to log sequence 413
Current log# 1 seq# 413 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG
Wed Nov 22 02:04:07 2006
Thread 1 advanced to log sequence 414
Current log# 2 seq# 414 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO02.LOG
Wed Nov 22 02:04:24 2006
Thread 1 advanced to log sequence 415
Current log# 3 seq# 415 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO03.LOG
Wed Nov 22 02:05:09 2006
Thread 1 advanced to log sequence 416
Current log# 1 seq# 416 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG
Wed Nov 22 02:05:39 2006
Thread 1 advanced to log sequence 417
Current log# 2 seq# 417 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO02.LOG
Wed Nov 22 02:06:23 2006
Thread 1 advanced to log sequence 418
Current log# 3 seq# 418 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO03.LOG
Wed Nov 22 02:06:43 2006
Thread 1 advanced to log sequence 419
Current log# 1 seq# 419 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG
Wed Nov 22 02:06:56 2006
Thread 1 advanced to log sequence 420
Current log# 2 seq# 420 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO02.LOG
Wed Nov 22 02:07:08 2006
Thread 1 advanced to log sequence 421
Current log# 3 seq# 421 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO03.LOG
Wed Nov 22 02:07:20 2006
Thread 1 advanced to log sequence 422
Current log# 1 seq# 422 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG
Wed Nov 22 02:07:34 2006
Thread 1 advanced to log sequence 423
Current log# 2 seq# 423 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO02.LOG
Wed Nov 22 02:07:47 2006
Thread 1 advanced to log sequence 424
Current log# 3 seq# 424 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO03.LOG
Wed Nov 22 02:07:59 2006
Thread 1 advanced to log sequence 425
Current log# 1 seq# 425 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG
Wed Nov 22 02:08:11 2006
Thread 1 advanced to log sequence 426
Current log# 2 seq# 426 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO02.LOG
Wed Nov 22 02:08:24 2006
Thread 1 advanced to log sequence 427
Current log# 3 seq# 427 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO03.LOG
Wed Nov 22 02:08:36 2006
Thread 1 advanced to log sequence 428
Current log# 1 seq# 428 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG
Wed Nov 22 02:08:49 2006
Thread 1 advanced to log sequence 429
Current log# 2 seq# 429 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO02.LOG
Wed Nov 22 02:09:00 2006
Thread 1 advanced to log sequence 430
Current log# 3 seq# 430 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO03.LOG
Wed Nov 22 02:09:13 2006
Thread 1 advanced to log sequence 431
Current log# 1 seq# 431 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG
Wed Nov 22 02:09:28 2006
Thread 1 advanced to log sequence 432
Current log# 2 seq# 432 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO02.LOG
Wed Nov 22 02:09:46 2006
Thread 1 advanced to log sequence 433
Current log# 3 seq# 433 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO03.LOG
Wed Nov 22 02:10:05 2006
Thread 1 advanced to log sequence 434
Current log# 1 seq# 434 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG
Wed Nov 22 02:10:21 2006
Thread 1 advanced to log sequence 435
Current log# 2 seq# 435 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO02.LOG
Wed Nov 22 02:10:38 2006
Thread 1 advanced to log sequence 436
Current log# 3 seq# 436 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO03.LOG
Wed Nov 22 02:11:01 2006
Thread 1 advanced to log sequence 437
Current log# 1 seq# 437 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG
Wed Nov 22 02:11:27 2006
Thread 1 advanced to log sequence 438
Current log# 2 seq# 438 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO02.LOG
Wed Nov 22 02:12:18 2006
Thread 1 advanced to log sequence 439
Current log# 3 seq# 439 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO03.LOG
Wed Nov 22 02:13:14 2006
Thread 1 advanced to log sequence 440
Current log# 1 seq# 440 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG
Wed Nov 22 02:15:25 2006
Thread 1 advanced to log sequence 441
Current log# 2 seq# 441 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO02.LOG
Wed Nov 22 02:16:45 2006
Thread 1 advanced to log sequence 442
Current log# 3 seq# 442 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO03.LOG
Wed Nov 22 02:18:17 2006
Thread 1 advanced to log sequence 443
Current log# 1 seq# 443 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG
Wed Nov 22 02:19:41 2006
Thread 1 advanced to log sequence 444
Current log# 2 seq# 444 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO02.LOG
Wed Nov 22 02:25:11 2006
Thread 1 advanced to log sequence 445
Current log# 3 seq# 445 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO03.LOG
Wed Nov 22 12:05:13 2006
Thread 1 advanced to log sequence 446
Current log# 1 seq# 446 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG
Wed Nov 22 14:01:14 2006
Created Undo Segment _SYSSMU11$
Undo Segment 11 Onlined
Wed Nov 22 16:35:29 2006
ALTER SYSTEM SET log_archive_dest='' SCOPE=MEMORY;
Wed Nov 22 16:35:29 2006
ALTER SYSTEM SET log_archive_dest_1='LOCATION=F:\Orion MANDATORY REOPEN' SCOPE=MEMORY;
Wed Nov 22 16:35:29 2006
ALTER SYSTEM SET log_archive_dest_1='LOCATION=F:\Orion MANDATORY REOPEN' SCOPE=SPFILE;
Wed Nov 22 16:35:36 2006
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 99
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Wed Nov 22 16:35:47 2006
ALTER DATABASE CLOSE NORMAL
Wed Nov 22 16:35:49 2006
SMON: disabling tx recovery
SMON: disabling cache recovery
Wed Nov 22 16:35:49 2006
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 446
Successful close of redo thread 1.
Wed Nov 22 16:35:49 2006
Completed: ALTER DATABASE CLOSE NORMAL
Wed Nov 22 16:35:49 2006
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Wed Nov 22 16:35:53 2006
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = FALSE
shared_pool_size = 268435456
large_pool_size = 8388608
java_pool_size = 33554432
trace_enabled = FALSE
control_files = D:\Oracle\oradata\orcl\CONTROL01.CTL, D:\Oracle\oradata\orcl\CONTROL02.CTL, D:\Oracle\oradata\orcl\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 838860800
compatible = 9.2.0.0.0
log_archive_dest_1 = LOCATION=F:\Orion MANDATORY REOPEN
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = orcl
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = D:\Oracle\admin\orcl\bdump
user_dump_dest = D:\Oracle\admin\orcl\udump
core_dump_dest = D:\Oracle\admin\orcl\cdump
sort_area_size = 124288
db_name = orcl
open_cursors = 10000
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
statistics_level = BASIC
aq_tm_processes = 1
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
CJQ0 started with pid=8
QMN0 started with pid=9
Wed Nov 22 16:35:55 2006
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Wed Nov 22 16:35:56 2006
/* OracleOEM */ ALTER DATABASE MOUNT
Wed Nov 22 16:36:00 2006
Successful mount of redo thread 1, with mount id 1134999660.
Wed Nov 22 16:36:00 2006
Database mounted in Exclusive Mode.
Completed: /* OracleOEM */ ALTER DATABASE MOUNT
Wed Nov 22 16:36:00 2006
/* OracleOEM */ ALTER DATABASE ARCHIVELOG
Completed: /* OracleOEM */ ALTER DATABASE ARCHIVELOG
Wed Nov 22 16:36:00 2006
/* OracleOEM */ ALTER DATABASE OPEN
Wed Nov 22 16:36:00 2006
LGWR: Primary database is in CLUSTER CONSISTENT mode
Thread 1 opened at log sequence 446
Current log# 1 seq# 446 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO01.LOG
Successful open of redo thread 1.
Wed Nov 22 16:36:00 2006
SMON: enabling cache recovery
 
Upvote 0 Downvote
So, CatPlus, from reading your alert log, it is evident that you have troubles with both datafile 'D:\DATAFILE\ORION02.DBF' and control file 'D:\ORACLE\ORADATA\ORCL\CONTROL01.CTL'. It also appears that you corrected/worked around the problem with control file 'D:\ORACLE\ORADATA\ORCL\CONTROL01.CTL'.

I also infer that you do not have usable, consistent physical backup copies of all of your

1) control files,
2) database data files, and
3) on-line redo log files

Do you happen to have recent export dumpfiles of your Oracle users in this database?

If you do not have either consistent backups or recent export dumpfiles, then you are totally hosed. If you at least have export dumpfiles, then I would re-create a new database, import the dumpfiles, put the database in ARCHIVELOG mode, and proceed from there, despite your obligation to have people re-enter any data/transactions that do not appear in the imported dump files.

Let us know your findings/status based upon the above scenario(s).

[santa]Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
 
Upvote 0 Downvote
Hey Mufasa,

You are too good! You responded even before I could manage to completely post the log file! Kudos to you!!!

Yes... I learnt it the hard way! The database is in archival mode now and we take frequest dumps too!

Yet one question boggles me! What did happen to have caused the corruption?

We have a brand new Dell PowerEdge 6800 dual 3.2 GHz processor server with 4GB RAM on a Windows 2003 Enterprises Server

Did tablespace do this?

Thanks for your advise

Mickey
 
Upvote 0 Downvote
Cosmic space dust from the heavens landed on your disk surface! (aka "impossible to tell").

[santa]Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

J
  • Locked
  • Question Question
Oracle Simphony - GetPrintedCheck
Replies
0
Views
304
japl93
J
J
  • Locked
  • Question Question
Oracle iCare Gift & Loyalty Portlet - Setup and configurations.
Replies
0
Views
294
jandresHDS
J
rk68
  • Locked
  • Question Question
Data encryption in Oracle 19c
Replies
0
Views
519
rk68
rk68
J
  • Locked
  • Question Question
Oracle Simphony - Adding tip out percentages to Employee Tip Report
Replies
0
Views
605
jj10438
J
Rasheed Shaik
  • Locked
  • Question Question
\Orant\DBS\FMCUS.MSG not found
Replies
0
Views
1K
Rasheed Shaik
Rasheed Shaik

Part and Inventory Search

Sponsor

Back
Top