Oracle Database Discussions

At start of the appliction working with oracle 10 XE the message stands out:
"oracle initialization or shutdown in progress "
the Base does not open. In SQL plus:

SQL> connect sys/manager as sysdba
Connected.
SQL> shutdown immediate
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 570425344 bytes
Fixed Size 1288652 bytes
Variable Size 159385140 bytes
Database Buffers 406847488 bytes
Redo Buffers 2904064 bytes
Database mounted.
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1:
'D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_3Z79HW9R_.LOG'

SQL> select log_mode from v$database;

LOG_MODE
------------
NOARCHIVELOG

alert.log:

Sun Jul 13 14:35:20 2008
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 2
CPU : 2 - type 586
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:642M/1007M, Ph+PgF:1984M/2256M, VA:1945M/2047M
Sun Jul 13 14:35:20 2008
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =10
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
sessions = 49
__shared_pool_size = 150994944
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = D:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DBS\SPFILEXE.ORA
sga_target = 570425344
control_files = D:\ORACLEXE\ORADATA\XE\CONTROL.DBF
__db_cache_size = 406847488
compatible = 10.2.0.1.0
db_recovery_file_dest = D:\oraclexe\app\oracle\flash_recovery_area
db_recovery_file_dest_size= 10737418240
undo_management = AUTO
undo_tablespace = UNDO
remote_login_passwordfile= EXCLUSIVE
dispatchers = (PROTOCOL=TCP) (SERVICE=XEXDB)
shared_servers = 4
job_queue_processes = 4
audit_file_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\ADUMP
background_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\BDUMP
user_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\UDUMP
core_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\CDUMP
db_name = XE
open_cursors = 300
os_authent_prefix =
pga_aggregate_target = 188743680
MMAN started with pid=4, OS id=3360
LGWR started with pid=6, OS id=3496
CKPT started with pid=7, OS id=3564
RECO started with pid=9, OS id=3700
CJQ0 started with pid=10, OS id=3768
MMNL started with pid=12, OS id=3904
Sun Jul 13 14:35:24 2008
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 4 shared server(s) ...
Oracle Data Guard is not available in this edition of Oracle.
Sun Jul 13 14:35:24 2008
alter database mount exclusive
PSP0 started with pid=3, OS id=3292
DBW0 started with pid=5, OS id=3428
SMON started with pid=8, OS id=3632
MMON started with pid=11, OS id=3836
PMON started with pid=2, OS id=3224
Setting recovery target incarnation to 2
Sun Jul 13 14:35:29 2008
Successful mount of redo thread 1, with mount id 2541098476
Sun Jul 13 14:35:29 2008
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Sun Jul 13 14:35:29 2008
alter database open
Sun Jul 13 14:35:29 2008
Beginning crash recovery of 1 threads
Sun Jul 13 14:35:29 2008
Started redo scan
Sun Jul 13 14:35:29 2008
Completed redo scan
113 redo blocks read, 59 data blocks need recovery
Sun Jul 13 14:35:30 2008
Started redo application at
Thread 1: logseq 245, block 3
Sun Jul 13 14:35:30 2008
Recovery of Online Redo Log: Thread 1 Group 2 Seq 245 Reading mem 0
Mem# 0 errs 0: D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_2_3Z79HXG5_.LOG
Sun Jul 13 14:35:30 2008
Completed redo application
Sun Jul 13 14:35:30 2008
Completed crash recovery at
Thread 1: logseq 245, block 116, scn 7569674
59 data blocks read, 59 data blocks written, 113 redo blocks read
Sun Jul 13 14:35:30 2008
Thread 1 advanced to log sequence 246
Thread 1 opened at log sequence 246
Current log# 1 seq# 246 mem# 0: D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_3Z79HW9R_.LOG
Successful open of redo thread 1
Sun Jul 13 14:35:31 2008
SMON: enabling cache recovery
Sun Jul 13 14:35:33 2008
Successfully onlined Undo Tablespace 1.
Sun Jul 13 14:35:33 2008
SMON: enabling tx recovery
Sun Jul 13 14:35:33 2008
Database Characterset is CL8MSWIN1251
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=18, OS id=2792
Sun Jul 13 14:35:47 2008
Completed: alter database open
Sun Jul 13 14:35:48 2008
db_recovery_file_dest_size of 10240 MB is 0.98% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Dump file d:\oraclexe\app\oracle\admin\xe\bdump\alert_xe.log
Mon Jul 14 07:18:44 2008
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 2
CPU : 2 - type 586
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:637M/1007M, Ph+PgF:1977M/2256M, VA:1945M/2047M
Mon Jul 14 07:18:44 2008
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =10
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
sessions = 49
__shared_pool_size = 150994944
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = D:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DBS\SPFILEXE.ORA
sga_target = 570425344
control_files = D:\ORACLEXE\ORADATA\XE\CONTROL.DBF
__db_cache_size = 406847488
compatible = 10.2.0.1.0
db_recovery_file_dest = D:\oraclexe\app\oracle\flash_recovery_area
db_recovery_file_dest_size= 10737418240
undo_management = AUTO
undo_tablespace = UNDO
remote_login_passwordfile= EXCLUSIVE
dispatchers = (PROTOCOL=TCP) (SERVICE=XEXDB)
shared_servers = 4
job_queue_processes = 4
audit_file_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\ADUMP
background_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\BDUMP
user_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\UDUMP
core_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\CDUMP
db_name = XE
open_cursors = 300
os_authent_prefix =
pga_aggregate_target = 188743680
MMAN started with pid=4, OS id=3404
LGWR started with pid=6, OS id=3540
CKPT started with pid=7, OS id=3608
RECO started with pid=9, OS id=3744
CJQ0 started with pid=10, OS id=3812
MMNL started with pid=12, OS id=3948
Mon Jul 14 07:18:48 2008
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 4 shared server(s) ...
Oracle Data Guard is not available in this edition of Oracle.
Mon Jul 14 07:18:49 2008
alter database mount exclusive
PMON started with pid=2, OS id=3268
DBW0 started with pid=5, OS id=3472
SMON started with pid=8, OS id=3676
MMON started with pid=11, OS id=3880
PSP0 started with pid=3, OS id=3336
Setting recovery target incarnation to 2
Mon Jul 14 07:18:53 2008
Successful mount of redo thread 1, with mount id 2541191961
Mon Jul 14 07:18:53 2008
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Mon Jul 14 07:18:54 2008
alter database open
Mon Jul 14 07:18:54 2008
Beginning crash recovery of 1 threads
Mon Jul 14 07:18:54 2008
Started redo scan
Mon Jul 14 07:18:54 2008
Completed redo scan
98 redo blocks read, 35 data blocks need recovery
Mon Jul 14 07:18:55 2008
Started redo application at
Thread 1: logseq 246, block 11394
Mon Jul 14 07:18:55 2008
Recovery of Online Redo Log: Thread 1 Group 1 Seq 246 Reading mem 0
Mem# 0 errs 0: D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_3Z79HW9R_.LOG
Mon Jul 14 07:18:55 2008
Completed redo application
Mon Jul 14 07:18:55 2008
Completed crash recovery at
Thread 1: logseq 246, block 11492, scn 7600775
35 data blocks read, 35 data blocks written, 98 redo blocks read
Mon Jul 14 07:19:02 2008
Errors in file d:\oraclexe\app\oracle\admin\xe\bdump\xe_lgwr_3540.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: 'D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_3Z79HW9R_.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) Не удается найти указанный файл.

Mon Jul 14 07:19:02 2008
Errors in file d:\oraclexe\app\oracle\admin\xe\bdump\xe_lgwr_3540.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: 'D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_3Z79HW9R_.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) Не удается найти указанный файл.

ORA-313 signalled during: alter database open...
Mon Jul 14 07:33:10 2008
db_recovery_file_dest_size of 10240 MB is 0.98% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Dump file d:\oraclexe\app\oracle\admin\xe\bdump\alert_xe.log
Mon Jul 14 09:43:45 2008
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 2
CPU : 2 - type 586
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:641M/1007M, Ph+PgF:1984M/2256M, VA:1945M/2047M
Mon Jul 14 09:43:45 2008
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =10
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
sessions = 49
__shared_pool_size = 150994944
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = D:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DBS\SPFILEXE.ORA
sga_target = 570425344
control_files = D:\ORACLEXE\ORADATA\XE\CONTROL.DBF
__db_cache_size = 406847488
compatible = 10.2.0.1.0
db_recovery_file_dest = D:\oraclexe\app\oracle\flash_recovery_area
db_recovery_file_dest_size= 10737418240
undo_management = AUTO
undo_tablespace = UNDO
remote_login_passwordfile= EXCLUSIVE
dispatchers = (PROTOCOL=TCP) (SERVICE=XEXDB)
shared_servers = 4
job_queue_processes = 4
audit_file_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\ADUMP
background_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\BDUMP
user_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\UDUMP
core_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\CDUMP
db_name = XE
open_cursors = 300
os_authent_prefix =
pga_aggregate_target = 188743680
PSP0 started with pid=3, OS id=3428
MMAN started with pid=4, OS id=3496
DBW0 started with pid=5, OS id=3564
CKPT started with pid=7, OS id=3700
SMON started with pid=8, OS id=3768
MMON started with pid=11, OS id=3972
Mon Jul 14 09:43:49 2008
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 4 shared server(s) ...
Oracle Data Guard is not available in this edition of Oracle.
PMON started with pid=2, OS id=3360
LGWR started with pid=6, OS id=3632
RECO started with pid=9, OS id=3836
CJQ0 started with pid=10, OS id=3904
MMNL started with pid=12, OS id=4040
Mon Jul 14 09:43:51 2008
alter database mount exclusive
Setting recovery target incarnation to 2
Mon Jul 14 09:43:55 2008
Successful mount of redo thread 1, with mount id 2541172503
Mon Jul 14 09:43:56 2008
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Mon Jul 14 09:43:56 2008
alter database open
Mon Jul 14 09:43:56 2008
Errors in file d:\oraclexe\app\oracle\admin\xe\bdump\xe_lgwr_3632.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: 'D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_3Z79HW9R_.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) Не удается найти указанный файл.

Mon Jul 14 09:43:56 2008
Errors in file d:\oraclexe\app\oracle\admin\xe\bdump\xe_lgwr_3632.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: 'D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_3Z79HW9R_.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) Не удается найти указанный файл.

ORA-313 signalled during: alter database open...
Mon Jul 14 09:56:06 2008
Shutting down instance: further logons disabled
Mon Jul 14 09:56:06 2008
Stopping background process CJQ0
Mon Jul 14 09:56:07 2008
Stopping background process MMNL
Mon Jul 14 09:56:08 2008
Stopping background process MMON
Mon Jul 14 09:56:09 2008
Shutting down instance (immediate)
License high water mark = 1
Mon Jul 14 09:56:09 2008
Stopping Job queue slave processes
Mon Jul 14 09:56:09 2008
Job queue slave processes stopped
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Mon Jul 14 09:56:11 2008
alter database close normal
ORA-1109 signalled during: alter database close normal...
Dump file d:\oraclexe\app\oracle\admin\xe\bdump\alert_xe.log
Mon Jul 14 09:56:19 2008
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 2
CPU : 2 - type 586
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:611M/1007M, Ph+PgF:1960M/2256M, VA:1945M/2047M
Mon Jul 14 09:56:19 2008
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =10
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
sessions = 49
__shared_pool_size = 150994944
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = D:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DBS\SPFILEXE.ORA
sga_target = 570425344
control_files = D:\ORACLEXE\ORADATA\XE\CONTROL.DBF
__db_cache_size = 406847488
compatible = 10.2.0.1.0
db_recovery_file_dest = D:\oraclexe\app\oracle\flash_recovery_area
db_recovery_file_dest_size= 10737418240
undo_management = AUTO
undo_tablespace = UNDO
remote_login_passwordfile= EXCLUSIVE
dispatchers = (PROTOCOL=TCP) (SERVICE=XEXDB)
shared_servers = 4
job_queue_processes = 4
audit_file_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\ADUMP
background_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\BDUMP
user_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\UDUMP
core_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\CDUMP
db_name = XE
open_cursors = 300
os_authent_prefix =
pga_aggregate_target = 188743680
PSP0 started with pid=3, OS id=3784
MMAN started with pid=4, OS id=3788
LGWR started with pid=6, OS id=3796
SMON started with pid=8, OS id=3804
CJQ0 started with pid=10, OS id=3812
MMON started with pid=11, OS id=3672
Mon Jul 14 09:56:20 2008
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 4 shared server(s) ...
PMON started with pid=2, OS id=3780
CKPT started with pid=7, OS id=3800
Oracle Data Guard is not available in this edition of Oracle.
RECO started with pid=9, OS id=3808
MMNL started with pid=12, OS id=3820
Mon Jul 14 09:56:21 2008
alter database mount exclusive
DBW0 started with pid=5, OS id=3792
Mon Jul 14 09:56:26 2008
Setting recovery target incarnation to 2
Mon Jul 14 09:56:26 2008
Successful mount of redo thread 1, with mount id 2541148166
Mon Jul 14 09:56:26 2008
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Mon Jul 14 09:56:26 2008
alter database open
Mon Jul 14 09:56:26 2008
Errors in file d:\oraclexe\app\oracle\admin\xe\bdump\xe_lgwr_3796.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: 'D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_3Z79HW9R_.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) Не удается найти указанный файл.

Mon Jul 14 09:56:26 2008
Errors in file d:\oraclexe\app\oracle\admin\xe\bdump\xe_lgwr_3796.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: 'D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_3Z79HW9R_.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) Не удается найти указанный файл.

ORA-313 signalled during: alter database open...
Shutting down instance: further logons disabled
Mon Jul 14 09:57:39 2008
Stopping background process MMNL
Mon Jul 14 09:57:40 2008
Stopping background process CJQ0
Mon Jul 14 09:57:40 2008
Stopping background process MMON
Mon Jul 14 09:57:40 2008
Shutting down instance (immediate)
License high water mark = 1
Mon Jul 14 09:57:40 2008
Stopping Job queue slave processes
Mon Jul 14 09:57:40 2008
Job queue slave processes stopped
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Mon Jul 14 09:57:42 2008
alter database close normal
ORA-1109 signalled during: alter database close normal...
Dump file d:\oraclexe\app\oracle\admin\xe\bdump\alert_xe.log
Mon Jul 14 09:57:46 2008
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 2
CPU : 2 - type 586
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:615M/1007M, Ph+PgF:1959M/2256M, VA:1945M/2047M
Mon Jul 14 09:57:46 2008
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =10
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
sessions = 49
__shared_pool_size = 150994944
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = D:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DBS\SPFILEXE.ORA
sga_target = 570425344
control_files = D:\ORACLEXE\ORADATA\XE\CONTROL.DBF
__db_cache_size = 406847488
compatible = 10.2.0.1.0
db_recovery_file_dest = D:\oraclexe\app\oracle\flash_recovery_area
db_recovery_file_dest_size= 10737418240
undo_management = AUTO
undo_tablespace = UNDO
remote_login_passwordfile= EXCLUSIVE
dispatchers = (PROTOCOL=TCP) (SERVICE=XEXDB)
shared_servers = 4
job_queue_processes = 4
audit_file_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\ADUMP
background_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\BDUMP
user_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\UDUMP
core_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\CDUMP
db_name = XE
open_cursors = 300
os_authent_prefix =
pga_aggregate_target = 188743680
PSP0 started with pid=3, OS id=556
MMAN started with pid=4, OS id=452
LGWR started with pid=6, OS id=816
SMON started with pid=8, OS id=652
RECO started with pid=9, OS id=1700
MMON started with pid=11, OS id=1208
Mon Jul 14 09:57:47 2008
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 4 shared server(s) ...
PMON started with pid=2, OS id=1252
DBW0 started with pid=5, OS id=2888
CKPT started with pid=7, OS id=372
Oracle Data Guard is not available in this edition of Oracle.
CJQ0 started with pid=10, OS id=1036
MMNL started with pid=12, OS id=1220
Mon Jul 14 09:57:48 2008
alter database mount exclusive
Mon Jul 14 09:57:52 2008
Setting recovery target incarnation to 2
Mon Jul 14 09:57:52 2008
Successful mount of redo thread 1, with mount id 2541170524
Mon Jul 14 09:57:52 2008
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Mon Jul 14 09:57:52 2008
alter database open
Mon Jul 14 09:57:53 2008
Errors in file d:\oraclexe\app\oracle\admin\xe\bdump\xe_lgwr_816.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: 'D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_3Z79HW9R_.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) Не удается найти указанный файл.

Mon Jul 14 09:57:53 2008
Errors in file d:\oraclexe\app\oracle\admin\xe\bdump\xe_lgwr_816.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: 'D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_3Z79HW9R_.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) Не удается найти указанный файл.

ORA-313 signalled during: alter database open...
Mon Jul 14 09:58:15 2008
db_recovery_file_dest_size of 10240 MB is 0.98% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Mon Jul 14 10:08:50 2008
Shutting down instance: further logons disabled
Mon Jul 14 10:08:50 2008
Stopping background process MMNL
Mon Jul 14 10:08:51 2008
Stopping background process CJQ0
Mon Jul 14 10:08:52 2008
Stopping background process MMON
Mon Jul 14 10:08:52 2008
Shutting down instance (immediate)
License high water mark = 1
Mon Jul 14 10:08:52 2008
Stopping Job queue slave processes
Mon Jul 14 10:08:52 2008
Job queue slave processes stopped
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Mon Jul 14 10:08:54 2008
ALTER DATABASE CLOSE NORMAL
ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
Mon Jul 14 10:08:54 2008
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Mon Jul 14 10:09:10 2008
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =10
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
sessions = 49
__shared_pool_size = 150994944
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = D:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DBS\SPFILEXE.ORA
sga_target = 570425344
control_files = D:\ORACLEXE\ORADATA\XE\CONTROL.DBF
__db_cache_size = 406847488
compatible = 10.2.0.1.0
db_recovery_file_dest = D:\oraclexe\app\oracle\flash_recovery_area
db_recovery_file_dest_size= 10737418240
undo_management = AUTO
undo_tablespace = UNDO
remote_login_passwordfile= EXCLUSIVE
dispatchers = (PROTOCOL=TCP) (SERVICE=XEXDB)
shared_servers = 4
job_queue_processes = 4
audit_file_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\ADUMP
background_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\BDUMP
user_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\UDUMP
core_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\CDUMP
db_name = XE
open_cursors = 300
os_authent_prefix =
pga_aggregate_target = 188743680
PSP0 started with pid=3, OS id=2360
MMAN started with pid=4, OS id=2276
LGWR started with pid=6, OS id=2288
SMON started with pid=8, OS id=2292
RECO started with pid=9, OS id=2300
MMON started with pid=11, OS id=960
Mon Jul 14 10:09:11 2008
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 4 shared server(s) ...
PMON started with pid=2, OS id=2356
DBW0 started with pid=5, OS id=2280
CKPT started with pid=7, OS id=2284
Oracle Data Guard is not available in this edition of Oracle.
CJQ0 started with pid=10, OS id=900
MMNL started with pid=12, OS id=2348
Mon Jul 14 10:09:13 2008
ALTER DATABASE MOUNT
Mon Jul 14 10:09:17 2008
Setting recovery target incarnation to 2
Mon Jul 14 10:09:17 2008
Successful mount of redo thread 1, with mount id 2541185801
Mon Jul 14 10:09:17 2008
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Mon Jul 14 10:09:17 2008
ALTER DATABASE OPEN
Mon Jul 14 10:09:17 2008
Errors in file d:\oraclexe\app\oracle\admin\xe\bdump\xe_lgwr_2288.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: 'D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_3Z79HW9R_.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) Не удается найти указанный файл.

Mon Jul 14 10:09:17 2008
Errors in file d:\oraclexe\app\oracle\admin\xe\bdump\xe_lgwr_2288.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: 'D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_3Z79HW9R_.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) Не удается найти указанный файл.

ORA-313 signalled during: ALTER DATABASE OPEN...
Mon Jul 14 10:24:14 2008
db_recovery_file_dest_size of 10240 MB is 0.98% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Mon Jul 14 10:42:38 2008
Shutting down instance: further logons disabled
Mon Jul 14 10:42:38 2008
Stopping background process CJQ0
Mon Jul 14 10:42:39 2008
Stopping background process MMNL
Mon Jul 14 10:42:40 2008
Stopping background process MMON
Mon Jul 14 10:42:41 2008
Shutting down instance (immediate)
License high water mark = 1
Mon Jul 14 10:42:41 2008
Stopping Job queue slave processes
Mon Jul 14 10:42:41 2008
Job queue slave processes stopped
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Mon Jul 14 10:42:43 2008
ALTER DATABASE CLOSE NORMAL
ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
Mon Jul 14 10:42:43 2008
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Mon Jul 14 10:42:56 2008
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =10
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
sessions = 49
__shared_pool_size = 150994944
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = D:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DBS\SPFILEXE.ORA
sga_target = 570425344
control_files = D:\ORACLEXE\ORADATA\XE\CONTROL.DBF
__db_cache_size = 406847488
compatible = 10.2.0.1.0
db_recovery_file_dest = D:\oraclexe\app\oracle\flash_recovery_area
db_recovery_file_dest_size= 10737418240
undo_management = AUTO
undo_tablespace = UNDO
remote_login_passwordfile= EXCLUSIVE
dispatchers = (PROTOCOL=TCP) (SERVICE=XEXDB)
shared_servers = 4
job_queue_processes = 4
audit_file_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\ADUMP
background_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\BDUMP
user_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\UDUMP
core_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\CDUMP
db_name = XE
open_cursors = 300
os_authent_prefix =
pga_aggregate_target = 188743680
PSP0 started with pid=3, OS id=1012
MMAN started with pid=4, OS id=2156
DBW0 started with pid=5, OS id=3156
CKPT started with pid=7, OS id=3164
SMON started with pid=8, OS id=308
RECO started with pid=9, OS id=2780
MMON started with pid=11, OS id=3604
Mon Jul 14 10:42:57 2008
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 4 shared server(s) ...
Oracle Data Guard is not available in this edition of Oracle.
Mon Jul 14 10:42:58 2008
ALTER DATABASE MOUNT
PMON started with pid=2, OS id=4084
LGWR started with pid=6, OS id=3172
MMNL started with pid=12, OS id=3516
CJQ0 started with pid=10, OS id=3844
Setting recovery target incarnation to 2
Mon Jul 14 10:43:02 2008
Successful mount of redo thread 1, with mount id 2541187826
Mon Jul 14 10:43:02 2008
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Mon Jul 14 10:43:03 2008
ALTER DATABASE OPEN
Mon Jul 14 10:43:04 2008
Errors in file d:\oraclexe\app\oracle\admin\xe\bdump\xe_lgwr_3172.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: 'D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_3Z79HW9R_.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) Не удается найти указанный файл.

Mon Jul 14 10:43:04 2008
Errors in file d:\oraclexe\app\oracle\admin\xe\bdump\xe_lgwr_3172.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: 'D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_3Z79HW9R_.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) Не удается найти указанный файл.

Mon Jul 14 10:43:04 2008
ORA-313 signalled during: ALTER DATABASE OPEN...
Mon Jul 14 10:58:01 2008
db_recovery_file_dest_size of 10240 MB is 0.98% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.

Prompt how to correct a situation and to start base...