Hi Bill,

This is how I turned on the Archive log mode (from the DBA guide):

To turn on ARCHIVELOG mode:
1.Using SQL Command Line, log in to the database and connect as SYSDBA
2.At the SQL Command Line prompt, enter the following command:
SHUTDOWN IMMEDIATE
If the command is successful, it displays the following output.
Database closed.
Database dismounted.
ORACLE instance shut down.
3.At the SQL Command Line prompt, enter the following command:
STARTUP MOUNT
If the command is successful, it displays the following output.
(System global area sizes will vary depending on the amount of physical memory in
your Oracle Database XE host computer.)
ORACLE instance started.
Total System Global Area 599785472 bytes
Fixed Size 1220804 bytes
Variable Size 180358972 bytes
Database Buffers 415236096 bytes
Redo Buffers 2969600 bytes
Database mounted.
Enter the following command:
ALTER DATABASE ARCHIVELOG;
If the command is successful, it displays the following output:
Database altered.
Enter the following command:
ALTER DATABASE OPEN;
If the command is successful, it displays the following output:
Database altered.
The database is now running with the new ARCHIVELOG mode setting.

I don't know where to find the alert log.

/John

Hi,

Sorry, I am totally new to this... where is the pfile? I found a folder on Oracle root called pfile but it had nothing in it.

/John

I put in the command and the output exists, this is the contents of the alert log:

Dump file d:\oraclexe\app\oracle\admin\xe\bdump\alert_xe.log
Tue Jun 06 10:40:28 2006
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 1
CPU : 1 - type 586
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:422M/887M, Ph+PgF:797M/1018M, VA:1945M/2047M
Tue Jun 06 10:40:28 2006
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Shared memory segment for instance monitoring created
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
sga_target = 222298112
control_files = D:\ORACLEXE\ORADATA\XE\CONTROL.DBF
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 = 73400320
PSP0 started with pid=3, OS id=2812
PMON started with pid=2, OS id=2800
MMAN started with pid=4, OS id=2792
DBW0 started with pid=5, OS id=2752
LGWR started with pid=6, OS id=2748
CKPT started with pid=7, OS id=2996
SMON started with pid=8, OS id=2684
RECO started with pid=9, OS id=2688
CJQ0 started with pid=10, OS id=2692
MMON started with pid=11, OS id=2696
MMNL started with pid=12, OS id=2712
Tue Jun 06 10:40:32 2006
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.
Tue Jun 06 10:40:36 2006
The input backup piece D:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\CONFIG\SEEDDB\EXPRESS.DFB is in compressed format.
Tue Jun 06 10:41:06 2006
Full restore complete of datafile 4 to datafile copy D:\ORACLEXE\ORADATA\XE\USERS.DBF. Elapsed time: 0:00:29
checkpoint is 193065
Full restore complete of datafile 2 to datafile copy D:\ORACLEXE\ORADATA\XE\UNDO.DBF. Elapsed time: 0:00:31
checkpoint is 193065
Tue Jun 06 10:41:22 2006
Full restore complete of datafile 3 to datafile copy D:\ORACLEXE\ORADATA\XE\SYSAUX.DBF. Elapsed time: 0:00:46
checkpoint is 193065
Full restore complete of datafile 1 to datafile copy D:\ORACLEXE\ORADATA\XE\SYSTEM.DBF. Elapsed time: 0:00:53
checkpoint is 193065
Tue Jun 06 10:41:29 2006
Create controlfile reuse set database "XE"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
Datafile
'D:\oraclexe\oradata\XE\system.dbf',
'D:\oraclexe\oradata\XE\undo.dbf',
'D:\oraclexe\oradata\XE\sysaux.dbf',
'D:\oraclexe\oradata\XE\users.dbf'
LOGFILE
GROUP 1 SIZE 51200K,
GROUP 2 SIZE 51200K,
RESETLOGS
WARNING: Default Temporary Tablespace not specified in CREATE DATABASE command
Default Temporary Tablespace will be necessary for a locally managed database in future release
Setting recovery target incarnation to 1
Tue Jun 06 10:41:30 2006
Successful mount of redo thread 1, with mount id 2473529113
Tue Jun 06 10:41:30 2006
Completed: Create controlfile reuse set database "XE"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
Datafile
'D:\oraclexe\oradata\XE\system.dbf',
'D:\oraclexe\oradata\XE\undo.dbf',
'D:\oraclexe\oradata\XE\sysaux.dbf',
'D:\oraclexe\oradata\XE\users.dbf'
LOGFILE
GROUP 1 SIZE 51200K,
GROUP 2 SIZE 51200K,
RESETLOGS
Shutting down instance: further logons disabled
Tue Jun 06 10:41:30 2006
Stopping background process CJQ0
Tue Jun 06 10:41:30 2006
Stopping background process MMNL
Tue Jun 06 10:41:31 2006
Stopping background process MMON
Tue Jun 06 10:41:31 2006
Shutting down instance (immediate)
License high water mark = 1
Tue Jun 06 10:41:31 2006
Stopping Job queue slave processes
Tue Jun 06 10:41:31 2006
Job queue slave processes stopped
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Tue Jun 06 10:41:32 2006
ALTER DATABASE CLOSE NORMAL
ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
Tue Jun 06 10:41:32 2006
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
Tue Jun 06 10:41:35 2006
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
sga_target = 222298112
control_files = D:\ORACLEXE\ORADATA\XE\CONTROL.DBF
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
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 = 73400320
PMON started with pid=2, OS id=3232
PSP0 started with pid=3, OS id=3216
MMAN started with pid=4, OS id=3240
DBW0 started with pid=5, OS id=3236
LGWR started with pid=6, OS id=3252
CKPT started with pid=7, OS id=3264
SMON started with pid=8, OS id=3260
RECO started with pid=9, OS id=2412
MMON started with pid=10, OS id=3380
MMNL started with pid=11, OS id=3376
Tue Jun 06 10:41:35 2006
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.
Tue Jun 06 10:41:36 2006
Create controlfile reuse set database "XE"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
Datafile
'D:\oraclexe\oradata\XE\system.dbf',
'D:\oraclexe\oradata\XE\undo.dbf',
'D:\oraclexe\oradata\XE\sysaux.dbf',
'D:\oraclexe\oradata\XE\users.dbf'
LOGFILE
GROUP 1 SIZE 51200K,
GROUP 2 SIZE 51200K,
RESETLOGS
Tue Jun 06 10:41:36 2006
WARNING: Default Temporary Tablespace not specified in CREATE DATABASE command
Default Temporary Tablespace will be necessary for a locally managed database in future release
Setting recovery target incarnation to 1
Tue Jun 06 10:41:36 2006
Successful mount of redo thread 1, with mount id 2473564704
Tue Jun 06 10:41:36 2006
Completed: Create controlfile reuse set database "XE"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
Datafile
'D:\oraclexe\oradata\XE\system.dbf',
'D:\oraclexe\oradata\XE\undo.dbf',
'D:\oraclexe\oradata\XE\sysaux.dbf',
'D:\oraclexe\oradata\XE\users.dbf'
LOGFILE
GROUP 1 SIZE 51200K,
GROUP 2 SIZE 51200K,
RESETLOGS
Tue Jun 06 10:41:36 2006
Stopping background process MMNL
Tue Jun 06 10:41:36 2006
Stopping background process MMON
Starting background process MMON
Starting background process MMNL
MMON started with pid=10, OS id=3412
MMNL started with pid=11, OS id=3372
Tue Jun 06 10:41:36 2006
ALTER SYSTEM enable restricted session;
Tue Jun 06 10:41:36 2006
alter database "XE" open resetlogs
Tue Jun 06 10:41:36 2006
RESETLOGS after incomplete recovery UNTIL CHANGE 193065
Tue Jun 06 10:41:37 2006
Errors in file d:\oraclexe\app\oracle\admin\xe\udump\xe_ora_2784.trc:
ORA-00313: open failed for members of log group 1 of thread 1

db_recovery_file_dest_size of 10240 MB is 0.49% 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.
Tue Jun 06 10:41:38 2006
Errors in file d:\oraclexe\app\oracle\admin\xe\udump\xe_ora_2784.trc:
ORA-00313: open failed for members of log group 2 of thread 1

Tue Jun 06 10:41:39 2006
Errors in file d:\oraclexe\app\oracle\admin\xe\udump\xe_ora_2784.trc:
ORA-00313: open failed for members of log group 3 of thread 1

Tue Jun 06 10:41:43 2006
Setting recovery target incarnation to 2
Tue Jun 06 10:41:43 2006
Assigning activation ID 2473564704 (0x936f9a20)
Thread 1 opened at log sequence 1
Current log# 3 seq# 1 mem# 0: D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_3_28BMGMQR_.LOG
Successful open of redo thread 1
Tue Jun 06 10:41:43 2006
SMON: enabling cache recovery
Tue Jun 06 10:41:46 2006
Successfully onlined Undo Tablespace 1.
Dictionary check beginning
Tablespace 'TEMP' #3 found in data dictionary,
but not in the controlfile. Adding to controlfile.
Dictionary check complete
Tue Jun 06 10:41:46 2006
SMON: enabling tx recovery
Tue Jun 06 10:41:46 2006
*********************************************************************
WARNING: The following temporary tablespaces contain no files.
This condition can occur when a backup controlfile has
been restored. It may be necessary to add files to these
tablespaces. That can be done using the SQL statement:

ALTER TABLESPACE <tablespace_name> ADD TEMPFILE

Alternatively, if these temporary tablespaces are no longer
needed, then they can be dropped.
Empty temporary tablespace: TEMP
*********************************************************************
Updating character set in controlfile to WE8MSWIN1252
**********************************************************
WARNING: Files may exists in db_recovery_file_dest
that are not known to the database. Use the RMAN command
CATALOG RECOVERY AREA to re-catalog any such files.
One of the following events caused this:
1. A backup controlfile was restored.
2. A standby controlfile was restored.
3. The controlfile was re-created.
4. db_recovery_file_dest had previously been enabled and
then disabled.
**********************************************************
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=18, OS id=3424
Tue Jun 06 10:41:50 2006
LOGSTDBY: Validating controlfile with logical metadata
Tue Jun 06 10:41:50 2006
LOGSTDBY: Validation complete
Global Name changed to XE
Completed: alter database "XE" open resetlogs
Tue Jun 06 10:41:53 2006
alter database rename global_name to "XE"
Completed: alter database rename global_name to "XE"
Tue Jun 06 10:41:53 2006
Thread 1 advanced to log sequence 2
Current log# 1 seq# 2 mem# 0: D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_28BMGK1R_.LOG
Tue Jun 06 10:41:53 2006
alter database drop logfile group 3
Tue Jun 06 10:41:54 2006
Deleted Oracle managed file D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_3_28BMGMQR_.LOG
Completed: alter database drop logfile group 3
Tue Jun 06 10:41:54 2006
ALTER TABLESPACE TEMP ADD TEMPFILE 'D:\oraclexe\oradata\XE\temp.dbf' SIZE 20480K REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
Completed: ALTER TABLESPACE TEMP ADD TEMPFILE 'D:\oraclexe\oradata\XE\temp.dbf' SIZE 20480K REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
Tue Jun 06 10:41:58 2006
ALTER SYSTEM disable restricted session;
Tue Jun 06 10:42:02 2006
Starting background process CJQ0
CJQ0 started with pid=17, OS id=3488
Tue Jun 06 10:42:12 2006
Memory Notification: Library Cache Object loaded into SGA
Heap size 2289K exceeds notification threshold (2048K)
KGL object name :XDB.XDbD/PLZ01TcHgNAgAIIegtw==

Tue Jun 06 10:42:13 2006
Memory Notification: Library Cache Object loaded into SGA
Heap size 2254K exceeds notification threshold (2048K)
Details in trace file d:\oraclexe\app\oracle\admin\xe\udump\xe_ora_3400.trc
KGL object name :XDB.XD8Vf3vgTDR1aSQOGkEtR2uQ==

Tue Jun 06 10:42:16 2006
Shutting down instance: further logons disabled
Tue Jun 06 10:42:17 2006
Stopping background process CJQ0
Tue Jun 06 10:42:17 2006
Stopping background process QMNC
Tue Jun 06 10:42:18 2006
Stopping background process MMNL
Tue Jun 06 10:42:19 2006
Stopping background process MMON
Tue Jun 06 10:42:20 2006
Shutting down instance (immediate)
License high water mark = 2
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Tue Jun 06 10:42:21 2006
ALTER DATABASE CLOSE NORMAL
Tue Jun 06 10:42:22 2006
SMON: disabling tx recovery
SMON: disabling cache recovery
Tue Jun 06 10:42:22 2006
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 2
Successful close of redo thread 1
Tue Jun 06 10:42:23 2006
Completed: ALTER DATABASE CLOSE NORMAL
Tue Jun 06 10:42:23 2006
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
Tue Jun 06 10:42:25 2006
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
spfile = D:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DBS\SPFILEXE.ORA
sga_target = 222298112
control_files = D:\ORACLEXE\ORADATA\XE\CONTROL.DBF
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 = 73400320
PMON started with pid=2, OS id=3616
PSP0 started with pid=3, OS id=3720
MMAN started with pid=4, OS id=3624
DBW0 started with pid=5, OS id=3584
LGWR started with pid=6, OS id=3724
CKPT started with pid=7, OS id=3728
SMON started with pid=8, OS id=3732
RECO started with pid=9, OS id=3716
CJQ0 started with pid=10, OS id=3712
MMON started with pid=11, OS id=3744
MMNL started with pid=12, OS id=3740
Tue Jun 06 10:42:25 2006
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.
Tue Jun 06 10:42:26 2006
ALTER DATABASE MOUNT
Tue Jun 06 10:42:30 2006
Setting recovery target incarnation to 2
Tue Jun 06 10:42:30 2006
Successful mount of redo thread 1, with mount id 2473504594
Tue Jun 06 10:42:30 2006
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Tue Jun 06 10:42:30 2006
ALTER DATABASE OPEN
Tue Jun 06 10:42:30 2006
Thread 1 opened at log sequence 2
Current log# 1 seq# 2 mem# 0: D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_28BMGK1R_.LOG
Successful open of redo thread 1
Tue Jun 06 10:42:31 2006
SMON: enabling cache recovery
Tue Jun 06 10:42:33 2006
Successfully onlined Undo Tablespace 1.
Tue Jun 06 10:42:33 2006
SMON: enabling tx recovery
Tue Jun 06 10:42:33 2006
Database Characterset is WE8MSWIN1252
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=18, OS id=4036
Tue Jun 06 10:42:37 2006
Completed: ALTER DATABASE OPEN
Tue Jun 06 10:42:39 2006
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.
Tue Jun 06 10:43:22 2006
Memory Notification: Library Cache Object loaded into SGA
Heap size 2196K exceeds notification threshold (2048K)
KGL object name :XDB.XDbD/PLZ01TcHgNAgAIIegtw==

Tue Jun 06 10:43:23 2006
Memory Notification: Library Cache Object loaded into SGA
Heap size 2145K exceeds notification threshold (2048K)
Details in trace file d:\oraclexe\app\oracle\admin\xe\bdump\xe_s000_3588.trc
KGL object name :XDB.XD8Vf3vgTDR1aSQOGkEtR2uQ==

Tue Jun 06 10:43:46 2006
Starting ORACLE instance (normal)
Wed Jun 07 11:00:23 2006
Thread 1 advanced to log sequence 3
Current log# 2 seq# 3 mem# 0: D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_2_28BMGLD1_.LOG
Thu Jun 08 22:17:01 2006
Thread 1 advanced to log sequence 4
Current log# 1 seq# 4 mem# 0: D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_28BMGK1R_.LOG
Sat Jun 10 20:30:14 2006
Thread 1 advanced to log sequence 5
Current log# 2 seq# 5 mem# 0: D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_2_28BMGLD1_.LOG
Mon Jun 12 22:01:31 2006
Thread 1 advanced to log sequence 6
Current log# 1 seq# 6 mem# 0: D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_28BMGK1R_.LOG
Dump file d:\oraclexe\app\oracle\admin\xe\bdump\alert_xe.log
Tue Jun 13 17:22:53 2006
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 1
CPU : 1 - type 586
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:662M/887M, Ph+PgF:878M/1018M, VA:1944M/2047M
Tue Jun 13 17:22:53 2006
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 = 71303168
__large_pool_size = 8388608
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = D:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DBS\SPFILEXE.ORA
sga_target = 222298112
control_files = D:\ORACLEXE\ORADATA\XE\CONTROL.DBF
__db_cache_size = 134217728
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 = 73400320
PMON started with pid=2, OS id=288
PSP0 started with pid=3, OS id=2044
MMAN started with pid=4, OS id=252
DBW0 started with pid=5, OS id=312
LGWR started with pid=6, OS id=316
CKPT started with pid=7, OS id=320
SMON started with pid=8, OS id=324
RECO started with pid=9, OS id=336
CJQ0 started with pid=10, OS id=340
MMON started with pid=11, OS id=344
Tue Jun 13 17:23:00 2006
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=348
Tue Jun 13 17:23:00 2006
starting up 4 shared server(s) ...
Oracle Data Guard is not available in this edition of Oracle.
Tue Jun 13 17:23:04 2006
alter database mount exclusive
Tue Jun 13 17:23:09 2006
Setting recovery target incarnation to 2
Tue Jun 13 17:23:10 2006
Successful mount of redo thread 1, with mount id 2474154680
Tue Jun 13 17:23:10 2006
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Tue Jun 13 17:23:10 2006
alter database open
Tue Jun 13 17:23:10 2006
Beginning crash recovery of 1 threads
Tue Jun 13 17:23:10 2006
Started redo scan
Tue Jun 13 17:23:11 2006
Completed redo scan
1122 redo blocks read, 241 data blocks need recovery
Tue Jun 13 17:23:11 2006
Started redo application at
Thread 1: logseq 6, block 24005
Tue Jun 13 17:23:12 2006
Recovery of Online Redo Log: Thread 1 Group 1 Seq 6 Reading mem 0
Mem# 0 errs 0: D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_28BMGK1R_.LOG
Tue Jun 13 17:23:13 2006
Completed redo application
Tue Jun 13 17:23:13 2006
Completed crash recovery at
Thread 1: logseq 6, block 25127, scn 474543
241 data blocks read, 241 data blocks written, 1122 redo blocks read
Tue Jun 13 17:23:15 2006
Thread 1 advanced to log sequence 7
Thread 1 opened at log sequence 7
Current log# 2 seq# 7 mem# 0: D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_2_28BMGLD1_.LOG
Successful open of redo thread 1
Tue Jun 13 17:23:15 2006
SMON: enabling cache recovery
Tue Jun 13 17:23:19 2006
Successfully onlined Undo Tablespace 1.
Tue Jun 13 17:23:19 2006
SMON: enabling tx recovery
Tue Jun 13 17:23:19 2006
Database Characterset is WE8MSWIN1252
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=19, OS id=2268
Tue Jun 13 17:23:30 2006
Completed: alter database open
Tue Jun 13 17:23:32 2006
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.
Wed Jun 14 11:58:19 2006
Memory Notification: Library Cache Object loaded into SGA
Heap size 2201K exceeds notification threshold (2048K)
KGL object name :XDB.XDbD/PLZ01TcHgNAgAIIegtw==

Wed Jun 14 11:58:20 2006
Memory Notification: Library Cache Object loaded into SGA
Heap size 2224K exceeds notification threshold (2048K)
Details in trace file d:\oraclexe\app\oracle\admin\xe\bdump\xe_s000_356.trc
KGL object name :XDB.XD8Vf3vgTDR1aSQOGkEtR2uQ==

Wed Jun 14 22:00:18 2006
Thread 1 advanced to log sequence 8
Current log# 1 seq# 8 mem# 0: D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_28BMGK1R_.LOG
Thu Jun 15 22:22:59 2006
Thread 1 advanced to log sequence 9
Current log# 2 seq# 9 mem# 0: D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_2_28BMGLD1_.LOG
Fri Jun 16 22:52:58 2006
Thread 1 advanced to log sequence 10
Current log# 1 seq# 10 mem# 0: D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_28BMGK1R_.LOG
Sun Jun 18 12:00:12 2006
Thread 1 advanced to log sequence 11
Current log# 2 seq# 11 mem# 0: D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_2_28BMGLD1_.LOG
Dump file d:\oraclexe\app\oracle\admin\xe\bdump\alert_xe.log
Mon Jun 19 14:34:29 2006
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 1
CPU : 1 - type 586
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:661M/887M, Ph+PgF:884M/1018M, VA:1944M/2047M
Mon Jun 19 14:34:29 2006
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 = 71303168
__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 = 222298112
control_files = D:\ORACLEXE\ORADATA\XE\CONTROL.DBF
__db_cache_size = 138412032
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 = 73400320
MMAN started with pid=4, OS id=1216
PSP0 started with pid=3, OS id=1272
PMON started with pid=2, OS id=1264
DBW0 started with pid=5, OS id=1352
LGWR started with pid=6, OS id=1108
CKPT started with pid=7, OS id=1384
SMON started with pid=8, OS id=1388
RECO started with pid=9, OS id=1392
CJQ0 started with pid=10, OS id=1396
MMON started with pid=11, OS id=1400
Mon Jun 19 14:34:36 2006
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=1368
Mon Jun 19 14:34:37 2006
starting up 4 shared server(s) ...
Oracle Data Guard is not available in this edition of Oracle.
Mon Jun 19 14:34:39 2006
alter database mount exclusive
Mon Jun 19 14:34:43 2006
Setting recovery target incarnation to 2
Mon Jun 19 14:34:43 2006
Successful mount of redo thread 1, with mount id 2474628927
Mon Jun 19 14:34:43 2006
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Mon Jun 19 14:34:43 2006
alter database open
Mon Jun 19 14:34:44 2006
Beginning crash recovery of 1 threads
Mon Jun 19 14:34:44 2006
Started redo scan
Mon Jun 19 14:34:45 2006
Completed redo scan
1160 redo blocks read, 76 data blocks need recovery
Mon Jun 19 14:34:45 2006
Started redo application at
Thread 1: logseq 11, block 53569
Mon Jun 19 14:34:46 2006
Recovery of Online Redo Log: Thread 1 Group 2 Seq 11 Reading mem 0
Mem# 0 errs 0: D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_2_28BMGLD1_.LOG
Mon Jun 19 14:34:46 2006
Completed redo application
Mon Jun 19 14:34:46 2006
Completed crash recovery at
Thread 1: logseq 11, block 54729, scn 713699
76 data blocks read, 76 data blocks written, 1160 redo blocks read
Mon Jun 19 14:34:49 2006
Thread 1 advanced to log sequence 12
Thread 1 opened at log sequence 12
Current log# 1 seq# 12 mem# 0: D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_28BMGK1R_.LOG
Successful open of redo thread 1
Mon Jun 19 14:34:50 2006
SMON: enabling cache recovery
Mon Jun 19 14:34:57 2006
Successfully onlined Undo Tablespace 1.
Mon Jun 19 14:34:57 2006
SMON: enabling tx recovery
Mon Jun 19 14:34:58 2006
Database Characterset is WE8MSWIN1252
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=19, OS id=1724
Mon Jun 19 14:35:12 2006
Completed: alter database open
Mon Jun 19 14:35:15 2006
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 Jun 19 16:06:19 2006
WARNING: inbound connection timed out (ORA-3136)
Tue Jun 20 13:06:42 2006
Thread 1 advanced to log sequence 13
Current log# 2 seq# 13 mem# 0: D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_2_28BMGLD1_.LOG
Wed Jun 21 15:26:06 2006
Memory Notification: Library Cache Object loaded into SGA
Heap size 2198K exceeds notification threshold (2048K)
KGL object name :XDB.XDbD/PLZ01TcHgNAgAIIegtw==

Wed Jun 21 22:00:13 2006
Thread 1 advanced to log sequence 14
Current log# 1 seq# 14 mem# 0: D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_28BMGK1R_.LOG
Dump file d:\oraclexe\app\oracle\admin\xe\bdump\alert_xe.log
Thu Jun 22 10:16:40 2006
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 1
CPU : 1 - type 586
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:672M/887M, Ph+PgF:890M/1018M, VA:1944M/2047M
Thu Jun 22 10:16:40 2006
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 = 71303168
__large_pool_size = 8388608
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = D:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DBS\SPFILEXE.ORA
sga_target = 222298112
control_files = D:\ORACLEXE\ORADATA\XE\CONTROL.DBF
__db_cache_size = 134217728
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 = 73400320
MMAN started with pid=4, OS id=1164
PSP0 started with pid=3, OS id=752
PMON started with pid=2, OS id=1144
DBW0 started with pid=5, OS id=1188
LGWR started with pid=6, OS id=1184
CKPT started with pid=7, OS id=1168
SMON started with pid=8, OS id=1200
RECO started with pid=9, OS id=1216
CJQ0 started with pid=10, OS id=1220
MMON started with pid=11, OS id=1212
MMNL started with pid=12, OS id=1252
Thu Jun 22 10:16:43 2006
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.
Thu Jun 22 10:16:44 2006
alter database mount exclusive
Thu Jun 22 10:16:49 2006
Setting recovery target incarnation to 2
Thu Jun 22 10:16:49 2006
Successful mount of redo thread 1, with mount id 2474905164
Thu Jun 22 10:16:49 2006
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Thu Jun 22 10:16:49 2006
alter database open
Thu Jun 22 10:16:50 2006
Beginning crash recovery of 1 threads
Thu Jun 22 10:16:50 2006
Started redo scan
Thu Jun 22 10:16:51 2006
Completed redo scan
1121 redo blocks read, 214 data blocks need recovery
Thu Jun 22 10:16:51 2006
Started redo application at
Thread 1: logseq 14, block 54967
Thu Jun 22 10:16:52 2006
Recovery of Online Redo Log: Thread 1 Group 1 Seq 14 Reading mem 0
Mem# 0 errs 0: D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_28BMGK1R_.LOG
Thu Jun 22 10:16:53 2006
Completed redo application
Thu Jun 22 10:16:53 2006
Completed crash recovery at
Thread 1: logseq 14, block 56088, scn 842291
214 data blocks read, 214 data blocks written, 1121 redo blocks read
Thu Jun 22 10:16:54 2006
Thread 1 advanced to log sequence 15
Thread 1 opened at log sequence 15
Current log# 2 seq# 15 mem# 0: D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_2_28BMGLD1_.LOG
Successful open of redo thread 1
Thu Jun 22 10:16:54 2006
SMON: enabling cache recovery
Thu Jun 22 10:16:57 2006
Successfully onlined Undo Tablespace 1.
Thu Jun 22 10:16:57 2006
SMON: enabling tx recovery
Thu Jun 22 10:16:57 2006
Database Characterset is WE8MSWIN1252
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=19, OS id=1432
Thu Jun 22 10:17:05 2006
Completed: alter database open
Thu Jun 22 10:17:07 2006
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
Thu Jun 22 18:47:31 2006
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 1
CPU : 1 - type 586
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:672M/887M, Ph+PgF:890M/1018M, VA:1944M/2047M
Thu Jun 22 18:47:31 2006
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 = 71303168
__large_pool_size = 8388608
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = D:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DBS\SPFILEXE.ORA
sga_target = 222298112
control_files = D:\ORACLEXE\ORADATA\XE\CONTROL.DBF
__db_cache_size = 134217728
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 = 73400320
PMON started with pid=2, OS id=1144
PSP0 started with pid=3, OS id=1148
MMAN started with pid=4, OS id=1152
DBW0 started with pid=5, OS id=1160
LGWR started with pid=6, OS id=1188
CKPT started with pid=7, OS id=1184
SMON started with pid=8, OS id=1164
RECO started with pid=9, OS id=1208
CJQ0 started with pid=10, OS id=1212
MMON started with pid=11, OS id=1204
MMNL started with pid=12, OS id=1244
Thu Jun 22 18:47:34 2006
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.
Thu Jun 22 18:47:35 2006
alter database mount exclusive
Thu Jun 22 18:47:39 2006
Setting recovery target incarnation to 2
Thu Jun 22 18:47:39 2006
Successful mount of redo thread 1, with mount id 2474919943
Thu Jun 22 18:47:39 2006
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Thu Jun 22 18:47:39 2006
alter database open
Thu Jun 22 18:47:40 2006
Beginning crash recovery of 1 threads
Thu Jun 22 18:47:41 2006
Started redo scan
Thu Jun 22 18:47:41 2006
Completed redo scan
595 redo blocks read, 77 data blocks need recovery
Thu Jun 22 18:47:42 2006
Started redo application at
Thread 1: logseq 15, block 18616
Thu Jun 22 18:47:42 2006
Recovery of Online Redo Log: Thread 1 Group 2 Seq 15 Reading mem 0
Mem# 0 errs 0: D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_2_28BMGLD1_.LOG
Thu Jun 22 18:47:43 2006
Completed redo application
Thu Jun 22 18:47:43 2006
Completed crash recovery at
Thread 1: logseq 15, block 19211, scn 874977
77 data blocks read, 77 data blocks written, 595 redo blocks read
Thu Jun 22 18:47:43 2006
Thread 1 advanced to log sequence 16
Thread 1 opened at log sequence 16
Current log# 1 seq# 16 mem# 0: D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_28BMGK1R_.LOG
Successful open of redo thread 1
Thu Jun 22 18:47:43 2006
SMON: enabling cache recovery
Thu Jun 22 18:47:47 2006
Successfully onlined Undo Tablespace 1.
Thu Jun 22 18:47:47 2006
SMON: enabling tx recovery
Thu Jun 22 18:47:47 2006
Database Characterset is WE8MSWIN1252
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=19, OS id=1480
Thu Jun 22 18:47:55 2006
Completed: alter database open
Thu Jun 22 18:47:57 2006
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
Thu Jun 22 18:58:33 2006
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 1
CPU : 1 - type 586
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:672M/887M, Ph+PgF:890M/1018M, VA:1944M/2047M
Thu Jun 22 18:58:33 2006
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 = 71303168
__large_pool_size = 8388608
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = D:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DBS\SPFILEXE.ORA
sga_target = 222298112
control_files = D:\ORACLEXE\ORADATA\XE\CONTROL.DBF
__db_cache_size = 134217728
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 = 73400320
PSP0 started with pid=3, OS id=1192
MMAN started with pid=4, OS id=1188
PMON started with pid=2, OS id=1168
DBW0 started with pid=5, OS id=1172
LGWR started with pid=6, OS id=1216
CKPT started with pid=7, OS id=1220
SMON started with pid=8, OS id=1212
RECO started with pid=9, OS id=1252
CJQ0 started with pid=10, OS id=1256
MMON started with pid=11, OS id=1272
MMNL started with pid=12, OS id=1280
Thu Jun 22 18:58:36 2006
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.
Thu Jun 22 18:58:37 2006
alter database mount exclusive
Thu Jun 22 18:58:41 2006
Setting recovery target incarnation to 2
Thu Jun 22 18:58:42 2006
Successful mount of redo thread 1, with mount id 2474915741
Thu Jun 22 18:58:42 2006
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Thu Jun 22 18:58:42 2006
alter database open
Thu Jun 22 18:58:42 2006
Beginning crash recovery of 1 threads
Thu Jun 22 18:58:42 2006
Started redo scan
Thu Jun 22 18:58:43 2006
Completed redo scan
131 redo blocks read, 80 data blocks need recovery
Thu Jun 22 18:58:44 2006
Started redo application at
Thread 1: logseq 16, block 3
Thu Jun 22 18:58:44 2006
Recovery of Online Redo Log: Thread 1 Group 1 Seq 16 Reading mem 0
Mem# 0 errs 0: D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_28BMGK1R_.LOG
Thu Jun 22 18:58:45 2006
Completed redo application
Thu Jun 22 18:58:45 2006
Completed crash recovery at
Thread 1: logseq 16, block 134, scn 895274
80 data blocks read, 80 data blocks written, 131 redo blocks read
Thu Jun 22 18:58:46 2006
Thread 1 advanced to log sequence 17
Thread 1 opened at log sequence 17
Current log# 2 seq# 17 mem# 0: D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_2_28BMGLD1_.LOG
Successful open of redo thread 1
Thu Jun 22 18:58:46 2006
SMON: enabling cache recovery
Thu Jun 22 18:58:49 2006
Successfully onlined Undo Tablespace 1.
Thu Jun 22 18:58:49 2006
SMON: enabling tx recovery
Thu Jun 22 18:58:50 2006
Database Characterset is WE8MSWIN1252
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=19, OS id=1428
Thu Jun 22 18:58:58 2006
Completed: alter database open
Thu Jun 22 18:58:59 2006
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.
Thu Jun 22 19:23:50 2006
Memory Notification: Library Cache Object loaded into SGA
Heap size 2208K exceeds notification threshold (2048K)
KGL object name :XDB.XDbD/PLZ01TcHgNAgAIIegtw==

Thu Jun 22 19:23:51 2006
Memory Notification: Library Cache Object loaded into SGA
Heap size 2137K exceeds notification threshold (2048K)
Details in trace file d:\oraclexe\app\oracle\admin\xe\bdump\xe_s000_1288.trc
KGL object name :XDB.XD8Vf3vgTDR1aSQOGkEtR2uQ==

Fri Jun 23 13:19:40 2006
WARNING: inbound connection timed out (ORA-3136)
Fri Jun 23 22:00:12 2006
Thread 1 advanced to log sequence 18
Current log# 1 seq# 18 mem# 0: D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_28BMGK1R_.LOG
Sat Jun 24 19:37:38 2006
Thread 1 advanced to log sequence 19
Current log# 2 seq# 19 mem# 0: D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_2_28BMGLD1_.LOG
Mon Jun 26 12:49:26 2006
Shutting down instance: further logons disabled
Mon Jun 26 12:49:26 2006
Stopping background process CJQ0
Mon Jun 26 12:49:26 2006
Stopping background process QMNC
Mon Jun 26 12:49:28 2006
Stopping background process MMNL
Mon Jun 26 12:49:29 2006
Stopping background process MMON
Mon Jun 26 12:49:30 2006
Shutting down instance (immediate)
License high water mark = 6
Mon Jun 26 12:49:30 2006
Stopping Job queue slave processes
Mon Jun 26 12:49:30 2006
Job queue slave processes stopped
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Mon Jun 26 12:49:32 2006
ALTER DATABASE CLOSE NORMAL
Mon Jun 26 12:49:32 2006
SMON: disabling tx recovery
SMON: disabling cache recovery
Mon Jun 26 12:49:33 2006
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 19
Successful close of redo thread 1
Mon Jun 26 12:49:33 2006
Completed: ALTER DATABASE CLOSE NORMAL
Mon Jun 26 12:49:33 2006
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 Jun 26 12:49:52 2006
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 = 71303168
__large_pool_size = 8388608
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = D:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DBS\SPFILEXE.ORA
sga_target = 222298112
control_files = D:\ORACLEXE\ORADATA\XE\CONTROL.DBF
__db_cache_size = 134217728
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 = 73400320
PMON started with pid=2, OS id=3996
PSP0 started with pid=3, OS id=312
MMAN started with pid=4, OS id=3504
DBW0 started with pid=5, OS id=3312
LGWR started with pid=6, OS id=2372
CKPT started with pid=7, OS id=3660
SMON started with pid=8, OS id=2248
RECO started with pid=9, OS id=3236
CJQ0 started with pid=10, OS id=3392
MMON started with pid=11, OS id=2776
MMNL started with pid=12, OS id=3548
Mon Jun 26 12:49:53 2006
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 Jun 26 12:49:54 2006
ALTER DATABASE MOUNT
Mon Jun 26 12:49:58 2006
Setting recovery target incarnation to 2
Mon Jun 26 12:49:58 2006
Successful mount of redo thread 1, with mount id 2475232050
Mon Jun 26 12:49:58 2006
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Mon Jun 26 12:50:25 2006
alter database archivelog
Mon Jun 26 12:50:25 2006
Completed: alter database archivelog
Mon Jun 26 12:50:35 2006
alter database open
Mon Jun 26 12:50:36 2006
LGWR: STARTING ARCH PROCESSES
ARC0 started with pid=18, OS id=3900
Mon Jun 26 12:50:36 2006
ARC0: Archival started
ARC1 started with pid=20, OS id=3024
Mon Jun 26 12:50:36 2006
ARC1: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
Thread 1 opened at log sequence 19
Current log# 2 seq# 19 mem# 0: D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_2_28BMGLD1_.LOG
Successful open of redo thread 1
Mon Jun 26 12:50:36 2006
ARC0: STARTING ARCH PROCESSES
Mon Jun 26 12:50:36 2006
ARC1: Becoming the 'no FAL' ARCH
ARC1: Becoming the 'no SRL' ARCH
Mon Jun 26 12:50:36 2006
SMON: enabling cache recovery
Mon Jun 26 12:50:36 2006
ARC2: Archival started
ARC2 started with pid=21, OS id=3840
Mon Jun 26 12:50:36 2006
ARC0: STARTING ARCH PROCESSES COMPLETE
ARC0: Becoming the heartbeat ARCH
Mon Jun 26 12:50:38 2006
Successfully onlined Undo Tablespace 1.
Mon Jun 26 12:50:38 2006
SMON: enabling tx recovery
Mon Jun 26 12:50:38 2006
Database Characterset is WE8MSWIN1252
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=22, OS id=4072
Mon Jun 26 12:50:45 2006
Completed: alter database open
Mon Jun 26 12:50:46 2006
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 Jun 26 12:56:36 2006
Shutting down archive processes
Mon Jun 26 12:56:41 2006
ARCH shutting down
ARC2: Archival stopped
Mon Jun 26 13:46:15 2006
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Mon Jun 26 13:46:15 2006
ALTER SYSTEM SET db_recovery_file_dest='d:\db' SCOPE=BOTH;
Mon Jun 26 14:27:38 2006
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Mon Jun 26 14:27:38 2006
ALTER SYSTEM SET db_recovery_file_dest='d:\DB_Backup' SCOPE=BOTH;
Mon Jun 26 14:28:02 2006
alter database add logfile thread 1 size 51200K
Mon Jun 26 14:28:04 2006
Completed: alter database add logfile thread 1 size 51200K
Mon Jun 26 14:28:04 2006
alter database drop logfile group 1
Deleted Oracle managed file D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_28BMGK1R_.LOG
Completed: alter database drop logfile group 1
Mon Jun 26 14:28:04 2006
alter database add logfile thread 1 size 51200K
Mon Jun 26 14:28:05 2006
Thread 1 advanced to log sequence 20
Current log# 3 seq# 20 mem# 0: D:\DB_BACKUP\XE\ONLINELOG\O1_MF_3_29ZR72NO_.LOG
Mon Jun 26 14:28:09 2006
Completed: alter database add logfile thread 1 size 51200K
Mon Jun 26 14:28:09 2006
alter database drop logfile group 2
ORA-1624 signalled during: alter database drop logfile group 2...
Mon Jun 26 14:28:09 2006
Thread 1 advanced to log sequence 21
Current log# 1 seq# 21 mem# 0: D:\DB_BACKUP\XE\ONLINELOG\O1_MF_1_29ZR74NO_.LOG
Mon Jun 26 14:28:13 2006
alter database drop logfile group 2
Mon Jun 26 14:28:13 2006
Deleted Oracle managed file D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_2_28BMGLD1_.LOG
Completed: alter database drop logfile group 2
Mon Jun 26 14:28:13 2006
Thread 1 advanced to log sequence 22
Current log# 3 seq# 22 mem# 0: D:\DB_BACKUP\XE\ONLINELOG\O1_MF_3_29ZR72NO_.LOG
Mon Jun 26 14:28:33 2006
alter database add logfile thread 1 size 51200K
Mon Jun 26 14:28:34 2006
Completed: alter database add logfile thread 1 size 51200K
Mon Jun 26 14:28:34 2006
alter database drop logfile group 1
ORA-1624 signalled during: alter database drop logfile group 1...
Mon Jun 26 14:28:34 2006
Thread 1 advanced to log sequence 23
Current log# 2 seq# 23 mem# 0: D:\DB_BACKUP\XE\ONLINELOG\O1_MF_2_29ZR81M4_.LOG
Mon Jun 26 14:28:40 2006
alter database drop logfile group 1
Mon Jun 26 14:28:40 2006
Deleted Oracle managed file D:\DB_BACKUP\XE\ONLINELOG\O1_MF_1_29ZR74NO_.LOG
Completed: alter database drop logfile group 1
Mon Jun 26 14:28:40 2006
alter database add logfile thread 1 size 51200K
Mon Jun 26 14:28:41 2006
Thread 1 advanced to log sequence 24
Current log# 3 seq# 24 mem# 0: D:\DB_BACKUP\XE\ONLINELOG\O1_MF_3_29ZR72NO_.LOG
Mon Jun 26 14:28:42 2006
Completed: alter database add logfile thread 1 size 51200K
Mon Jun 26 14:28:42 2006
alter database drop logfile group 3
ORA-1623 signalled during: alter database drop logfile group 3...
Mon Jun 26 14:28:42 2006
Thread 1 advanced to log sequence 25
Current log# 1 seq# 25 mem# 0: D:\DB_BACKUP\XE\ONLINELOG\O1_MF_1_29ZR88Q1_.LOG
Mon Jun 26 14:28:46 2006
alter database drop logfile group 3
Mon Jun 26 14:28:46 2006
Deleted Oracle managed file D:\DB_BACKUP\XE\ONLINELOG\O1_MF_3_29ZR72NO_.LOG
Completed: alter database drop logfile group 3
Mon Jun 26 14:28:46 2006
Thread 1 advanced to log sequence 26
Current log# 2 seq# 26 mem# 0: D:\DB_BACKUP\XE\ONLINELOG\O1_MF_2_29ZR81M4_.LOG
Mon Jun 26 14:31:42 2006
Shutting down instance: further logons disabled
Mon Jun 26 14:31:43 2006
Stopping background process CJQ0
Mon Jun 26 14:31:43 2006
Stopping background process QMNC
Mon Jun 26 14:31:44 2006
Stopping background process MMNL
Mon Jun 26 14:31:45 2006
Stopping background process MMON
Mon Jun 26 14:31:46 2006
Shutting down instance (immediate)
License high water mark = 3
Mon Jun 26 14:31:46 2006
Stopping Job queue slave processes
Mon Jun 26 14:31:46 2006
Job queue slave processes stopped
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Mon Jun 26 14:31:47 2006
ALTER DATABASE CLOSE NORMAL
Mon Jun 26 14:31:47 2006
SMON: disabling tx recovery
SMON: disabling cache recovery
Mon Jun 26 14:31:47 2006
Shutting down archive processes
Archiving is disabled
Mon Jun 26 14:31:52 2006
ARCH shutting down
ARC1: Archival stopped
Mon Jun 26 14:31:57 2006
ARCH shutting down
ARC0: Archival stopped
Mon Jun 26 14:31:58 2006
Thread 1 closed at log sequence 26
Successful close of redo thread 1
Mon Jun 26 14:31:58 2006
Completed: ALTER DATABASE CLOSE NORMAL
Mon Jun 26 14:31:58 2006
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 Jun 26 14:32:09 2006
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 = 71303168
__large_pool_size = 8388608
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = D:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DBS\SPFILEXE.ORA
sga_target = 222298112
control_files = D:\ORACLEXE\ORADATA\XE\CONTROL.DBF
__db_cache_size = 134217728
compatible = 10.2.0.1.0
db_recovery_file_dest = d:\DB_Backup
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 = 73400320
PMON started with pid=2, OS id=3176
PSP0 started with pid=3, OS id=2928
MMAN started with pid=4, OS id=532
DBW0 started with pid=5, OS id=2068
LGWR started with pid=6, OS id=276
CKPT started with pid=7, OS id=2196
SMON started with pid=8, OS id=3528
RECO started with pid=9, OS id=3700
CJQ0 started with pid=10, OS id=4088
MMON started with pid=11, OS id=3444
MMNL started with pid=12, OS id=2628
Mon Jun 26 14:32:10 2006
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 Jun 26 14:32:10 2006
ALTER DATABASE MOUNT
Mon Jun 26 14:32:14 2006
Setting recovery target incarnation to 2
Mon Jun 26 14:32:14 2006
Successful mount of redo thread 1, with mount id 2475225642
Mon Jun 26 14:32:14 2006
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Mon Jun 26 14:32:28 2006
alter database archivelog
Mon Jun 26 14:32:29 2006
Completed: alter database archivelog
Mon Jun 26 14:32:36 2006
alter database open
Mon Jun 26 14:32:37 2006
LGWR: STARTING ARCH PROCESSES
ARC0 started with pid=18, OS id=2236
Mon Jun 26 14:32:37 2006
ARC0: Archival started
ARC1 started with pid=20, OS id=3156
Mon Jun 26 14:32:37 2006
ARC1: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
Thread 1 opened at log sequence 26
Current log# 2 seq# 26 mem# 0: D:\DB_BACKUP\XE\ONLINELOG\O1_MF_2_29ZR81M4_.LOG
Successful open of redo thread 1
Mon Jun 26 14:32:37 2006
ARC0: STARTING ARCH PROCESSES
Mon Jun 26 14:32:37 2006
ARC1: Becoming the 'no FAL' ARCH
ARC1: Becoming the 'no SRL' ARCH
Mon Jun 26 14:32:37 2006
SMON: enabling cache recovery
Mon Jun 26 14:32:37 2006
ARC2: Archival started
ARC2 started with pid=21, OS id=3804
Mon Jun 26 14:32:37 2006
ARC0: STARTING ARCH PROCESSES COMPLETE
ARC0: Becoming the heartbeat ARCH
Mon Jun 26 14:32:39 2006
Successfully onlined Undo Tablespace 1.
Mon Jun 26 14:32:39 2006
SMON: enabling tx recovery
Mon Jun 26 14:32:39 2006
Database Characterset is WE8MSWIN1252
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=22, OS id=3648
Mon Jun 26 14:32:45 2006
Completed: alter database open
Mon Jun 26 14:32:47 2006
db_recovery_file_dest_size of 10240 MB is 1.37% 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 Jun 26 14:35:45 2006
Shutting down instance: further logons disabled
Mon Jun 26 14:35:46 2006
Stopping background process CJQ0
Mon Jun 26 14:35:46 2006
Stopping background process QMNC
Mon Jun 26 14:35:47 2006
Stopping background process MMNL
Mon Jun 26 14:35:47 2006
Stopping background process MMON
Mon Jun 26 14:35:48 2006
Shutting down instance (immediate)
License high water mark = 2
Mon Jun 26 14:35:48 2006
Stopping Job queue slave processes
Mon Jun 26 14:35:48 2006
Job queue slave processes stopped
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Mon Jun 26 14:35:51 2006
ALTER DATABASE CLOSE NORMAL
Mon Jun 26 14:35:51 2006
SMON: disabling tx recovery
SMON: disabling cache recovery
Mon Jun 26 14:35:51 2006
Shutting down archive processes
Archiving is disabled
Mon Jun 26 14:35:56 2006
ARCH shutting down
ARC2: Archival stopped
Mon Jun 26 14:36:01 2006
ARCH shutting down
ARC1: Archival stopped
Mon Jun 26 14:36:06 2006
ARCH shutting down
ARC0: Archival stopped
Mon Jun 26 14:36:07 2006
Thread 1 closed at log sequence 26
Successful close of redo thread 1
Mon Jun 26 14:36:08 2006
Completed: ALTER DATABASE CLOSE NORMAL
Mon Jun 26 14:36:08 2006
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 Jun 26 14:37:13 2006
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 = 71303168
__large_pool_size = 8388608
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = D:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DBS\SPFILEXE.ORA
sga_target = 222298112
control_files = D:\ORACLEXE\ORADATA\XE\CONTROL.DBF
__db_cache_size = 134217728
compatible = 10.2.0.1.0
db_recovery_file_dest = d:\DB_Backup
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 = 73400320
PMON started with pid=2, OS id=1092
PSP0 started with pid=3, OS id=2640
MMAN started with pid=4, OS id=3288
DBW0 started with pid=5, OS id=2544
LGWR started with pid=6, OS id=2148
CKPT started with pid=7, OS id=3576
SMON started with pid=8, OS id=1864
RECO started with pid=9, OS id=2392
CJQ0 started with pid=10, OS id=2772
MMON started with pid=11, OS id=3316
MMNL started with pid=12, OS id=1564
Mon Jun 26 14:37:14 2006
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 Jun 26 14:37:14 2006
ALTER DATABASE MOUNT
Mon Jun 26 14:37:18 2006
Setting recovery target incarnation to 2
Mon Jun 26 14:37:19 2006
Successful mount of redo thread 1, with mount id 2475239770
Mon Jun 26 14:37:19 2006
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Dump file d:\oraclexe\app\oracle\admin\xe\bdump\alert_xe.log
Mon Jun 26 14:39:25 2006
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 1
CPU : 1 - type 586
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:664M/887M, Ph+PgF:882M/1018M, VA:1944M/2047M
Mon Jun 26 14:39:25 2006
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 = 71303168
__large_pool_size = 8388608
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = D:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DBS\SPFILEXE.ORA
sga_target = 222298112
control_files = D:\ORACLEXE\ORADATA\XE\CONTROL.DBF
__db_cache_size = 134217728
compatible = 10.2.0.1.0
db_recovery_file_dest = d:\DB_Backup
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 = 73400320
PSP0 started with pid=3, OS id=1252
PMON started with pid=2, OS id=1248
MMAN started with pid=4, OS id=1256
DBW0 started with pid=5, OS id=1260
LGWR started with pid=6, OS id=1268
CKPT started with pid=7, OS id=1212
SMON started with pid=8, OS id=1348
RECO started with pid=9, OS id=1380
CJQ0 started with pid=10, OS id=1116
MMON started with pid=11, OS id=1384
MMNL started with pid=12, OS id=1388
Mon Jun 26 14:39:31 2006
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 Jun 26 14:39:33 2006
alter database mount exclusive
Mon Jun 26 14:39:38 2006
Setting recovery target incarnation to 2
Mon Jun 26 14:39:38 2006
Successful mount of redo thread 1, with mount id 2475240165
Mon Jun 26 14:39:38 2006
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Mon Jun 26 14:39:38 2006
alter database open
Mon Jun 26 14:39:39 2006
LGWR: STARTING ARCH PROCESSES
ARC0 started with pid=19, OS id=1620
Mon Jun 26 14:39:39 2006
ARC0: Archival started
Mon Jun 26 14:39:39 2006
ARC1: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC1 started with pid=20, OS id=1636
Thread 1 opened at log sequence 26
Current log# 2 seq# 26 mem# 0: D:\DB_BACKUP\XE\ONLINELOG\O1_MF_2_29ZR81M4_.LOG
Successful open of redo thread 1
Mon Jun 26 14:39:41 2006
ARC0: STARTING ARCH PROCESSES
Mon Jun 26 14:39:41 2006
ARC1: Becoming the 'no FAL' ARCH
ARC1: Becoming the 'no SRL' ARCH
Mon Jun 26 14:39:41 2006
ARC2: Archival started
ARC2 started with pid=21, OS id=1640
Mon Jun 26 14:39:41 2006
ARC0: STARTING ARCH PROCESSES COMPLETE
ARC0: Becoming the heartbeat ARCH
Mon Jun 26 14:39:41 2006
SMON: enabling cache recovery
Mon Jun 26 14:39:48 2006
Successfully onlined Undo Tablespace 1.
Mon Jun 26 14:39:48 2006
SMON: enabling tx recovery
Mon Jun 26 14:39:48 2006
Database Characterset is WE8MSWIN1252
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=22, OS id=1660
Mon Jun 26 14:39:59 2006
Completed: alter database open
Mon Jun 26 14:40:01 2006
db_recovery_file_dest_size of 10240 MB is 1.37% 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 Jun 26 14:45:32 2006
Shutting down archive processes
Mon Jun 26 14:45:37 2006
ARCH shutting down
ARC2: Archival stopped
Mon Jun 26 15:04:53 2006
Memory Notification: Library Cache Object loaded into SGA
Heap size 2210K exceeds notification threshold (2048K)
KGL object name :XDB.XDbD/PLZ01TcHgNAgAIIegtw==

Mon Jun 26 15:04:54 2006
Memory Notification: Library Cache Object loaded into SGA
Heap size 2095K exceeds notification threshold (2048K)
Details in trace file d:\oraclexe\app\oracle\admin\xe\bdump\xe_s000_1488.trc
KGL object name :XDB.XD8Vf3vgTDR1aSQOGkEtR2uQ==

Mon Jun 26 15:13:16 2006
ALTER SYSTEM SET db_recovery_file_dest_size='5G' SCOPE=BOTH;
Dump file d:\oraclexe\app\oracle\admin\xe\bdump\alert_xe.log
Mon Jun 26 16:34:07 2006
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 1
CPU : 1 - type 586
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:649M/887M, Ph+PgF:864M/1018M, VA:1944M/2047M
Mon Jun 26 16:34:07 2006
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 = 71303168
__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 = 222298112
control_files = D:\ORACLEXE\ORADATA\XE\CONTROL.DBF
__db_cache_size = 138412032
compatible = 10.2.0.1.0
db_recovery_file_dest = d:\DB_Backup
db_recovery_file_dest_size= 5368709120
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 = 73400320
PSP0 started with pid=3, OS id=2180
PMON started with pid=2, OS id=2176
MMAN started with pid=4, OS id=2184
DBW0 started with pid=5, OS id=2188
LGWR started with pid=6, OS id=2196
CKPT started with pid=7, OS id=2200
SMON started with pid=8, OS id=2204
RECO started with pid=9, OS id=2208
CJQ0 started with pid=10, OS id=2216
MMON started with pid=11, OS id=2220
Mon Jun 26 16:34:18 2006
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=2224
Mon Jun 26 16:34:18 2006
starting up 4 shared server(s) ...
Oracle Data Guard is not available in this edition of Oracle.
Mon Jun 26 16:34:20 2006
alter database mount exclusive
Mon Jun 26 16:34:24 2006
Setting recovery target incarnation to 2
Mon Jun 26 16:34:25 2006
Successful mount of redo thread 1, with mount id 2475238604
Mon Jun 26 16:34:25 2006
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Mon Jun 26 16:34:26 2006
alter database open
Mon Jun 26 16:34:26 2006
Beginning crash recovery of 1 threads
Mon Jun 26 16:34:26 2006
Started redo scan
Mon Jun 26 16:34:27 2006
Completed redo scan
620 redo blocks read, 16 data blocks need recovery
Mon Jun 26 16:34:27 2006
Started redo application at
Thread 1: logseq 26, block 2226
Mon Jun 26 16:34:28 2006
Recovery of Online Redo Log: Thread 1 Group 2 Seq 26 Reading mem 0
Mem# 0 errs 0: D:\DB_BACKUP\XE\ONLINELOG\O1_MF_2_29ZR81M4_.LOG
Mon Jun 26 16:34:28 2006
Completed redo application
Mon Jun 26 16:34:28 2006
Completed crash recovery at
Thread 1: logseq 26, block 2846, scn 1059449
16 data blocks read, 16 data blocks written, 620 redo blocks read
Mon Jun 26 16:34:29 2006
LGWR: STARTING ARCH PROCESSES
ARC0 started with pid=19, OS id=2372
Mon Jun 26 16:34:29 2006
ARC0: Archival started
ARC1 started with pid=20, OS id=2376
Mon Jun 26 16:34:29 2006
ARC1: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
Thread 1 advanced to log sequence 27
Thread 1 opened at log sequence 27
Current log# 1 seq# 27 mem# 0: D:\DB_BACKUP\XE\ONLINELOG\O1_MF_1_29ZR88Q1_.LOG
Successful open of redo thread 1
Mon Jun 26 16:34:32 2006
SMON: enabling cache recovery
Mon Jun 26 16:34:32 2006
ARC0: STARTING ARCH PROCESSES
ARC2 started with pid=21, OS id=2392
Mon Jun 26 16:34:32 2006
ARC2: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
ARC0: Becoming the 'no FAL' ARCH
ARC0: Becoming the 'no SRL' ARCH
Mon Jun 26 16:34:32 2006
ARC1: Becoming the heartbeat ARCH
Mon Jun 26 16:34:34 2006
db_recovery_file_dest_size of 5120 MB is 2.76% 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 Jun 26 16:34:37 2006
Successfully onlined Undo Tablespace 1.
Mon Jun 26 16:34:37 2006
SMON: enabling tx recovery
Mon Jun 26 16:34:37 2006
Database Characterset is WE8MSWIN1252
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=22, OS id=2428
Mon Jun 26 16:34:47 2006
Completed: alter database open
Dump file d:\oraclexe\app\oracle\admin\xe\bdump\alert_xe.log
Mon Jun 26 16:35:54 2006
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 1
CPU : 1 - type 586
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:671M/887M, Ph+PgF:889M/1018M, VA:1944M/2047M
Mon Jun 26 16:35:54 2006
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 = 71303168
__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 = 222298112
control_files = D:\ORACLEXE\ORADATA\XE\CONTROL.DBF
__db_cache_size = 138412032
compatible = 10.2.0.1.0
db_recovery_file_dest = d:\DB_Backup
db_recovery_file_dest_size= 5368709120
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 = 73400320
PSP0 started with pid=3, OS id=1196
PMON started with pid=2, OS id=1168
MMAN started with pid=4, OS id=1192
DBW0 started with pid=5, OS id=1172
LGWR started with pid=6, OS id=1212
CKPT started with pid=7, OS id=1216
SMON started with pid=8, OS id=1208
RECO started with pid=9, OS id=1248
CJQ0 started with pid=10, OS id=1252
MMON started with pid=11, OS id=1268
MMNL started with pid=12, OS id=1276
Mon Jun 26 16:35:57 2006
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 Jun 26 16:35:58 2006
alter database mount exclusive
Mon Jun 26 16:36:02 2006
Setting recovery target incarnation to 2
Mon Jun 26 16:36:03 2006
Successful mount of redo thread 1, with mount id 2475246638
Mon Jun 26 16:36:03 2006
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Mon Jun 26 16:36:03 2006
alter database open
Mon Jun 26 16:36:03 2006
Beginning crash recovery of 1 threads
Mon Jun 26 16:36:04 2006
Started redo scan
Mon Jun 26 16:36:04 2006
Completed redo scan
102 redo blocks read, 49 data blocks need recovery
Mon Jun 26 16:36:04 2006
Started redo application at
Thread 1: logseq 27, block 3
Mon Jun 26 16:36:05 2006
Recovery of Online Redo Log: Thread 1 Group 1 Seq 27 Reading mem 0
Mem# 0 errs 0: D:\DB_BACKUP\XE\ONLINELOG\O1_MF_1_29ZR88Q1_.LOG
Mon Jun 26 16:36:05 2006
Completed redo application
Mon Jun 26 16:36:05 2006
Completed crash recovery at
Thread 1: logseq 27, block 105, scn 1079609
49 data blocks read, 49 data blocks written, 102 redo blocks read
Mon Jun 26 16:36:06 2006
LGWR: STARTING ARCH PROCESSES
ARC0 started with pid=19, OS id=1424
ARC1 started with pid=20, OS id=1428
Mon Jun 26 16:36:07 2006
ARC0: Archival started
ARC1: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
Thread 1 advanced to log sequence 28
Thread 1 opened at log sequence 28
Current log# 2 seq# 28 mem# 0: D:\DB_BACKUP\XE\ONLINELOG\O1_MF_2_29ZR81M4_.LOG
Successful open of redo thread 1
Mon Jun 26 16:36:08 2006
ARC1: STARTING ARCH PROCESSES
Mon Jun 26 16:36:08 2006
ARC0: Becoming the 'no FAL' ARCH
ARC0: Becoming the 'no SRL' ARCH
Mon Jun 26 16:36:08 2006
SMON: enabling cache recovery
Mon Jun 26 16:36:08 2006
ARC2: Archival started
ARC2 started with pid=21, OS id=1396
Mon Jun 26 16:36:08 2006
ARC1: STARTING ARCH PROCESSES COMPLETE
ARC1: Becoming the heartbeat ARCH
db_recovery_file_dest_size of 5120 MB is 2.76% 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 Jun 26 16:36:12 2006
Successfully onlined Undo Tablespace 1.
Mon Jun 26 16:36:12 2006
SMON: enabling tx recovery
Mon Jun 26 16:36:12 2006
Database Characterset is WE8MSWIN1252
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=22, OS id=1452
Mon Jun 26 16:36:21 2006
Completed: alter database open
Mon Jun 26 16:39:02 2006
Memory Notification: Library Cache Object loaded into SGA
Heap size 2208K exceeds notification threshold (2048K)
KGL object name :XDB.XDbD/PLZ01TcHgNAgAIIegtw==

Mon Jun 26 16:41:59 2006
Shutting down archive processes
Mon Jun 26 16:42:04 2006
ARCH shutting down
ARC2: Archival stopped
Dump file d:\oraclexe\app\oracle\admin\xe\bdump\alert_xe.log
Tue Jun 27 11:20:20 2006
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 1
CPU : 1 - type 586
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:670M/887M, Ph+PgF:1689M/1818M, VA:1944M/2047M
Tue Jun 27 11:20:20 2006
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 = 71303168
__large_pool_size = 8388608
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = D:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DBS\SPFILEXE.ORA
sga_target = 222298112
control_files = D:\ORACLEXE\ORADATA\XE\CONTROL.DBF
__db_cache_size = 134217728
compatible = 10.2.0.1.0
db_recovery_file_dest = d:\DB_Backup
db_recovery_file_dest_size= 5368709120
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 = 73400320
PMON started with pid=2, OS id=1116
PSP0 started with pid=3, OS id=748
MMAN started with pid=4, OS id=1160
DBW0 started with pid=5, OS id=1188
LGWR started with pid=6, OS id=1184
CKPT started with pid=7, OS id=1164
SMON started with pid=8, OS id=1208
RECO started with pid=9, OS id=1212
CJQ0 started with pid=10, OS id=1204
MMON started with pid=11, OS id=1244
MMNL started with pid=12, OS id=1248
Tue Jun 27 11:20:23 2006
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.
Tue Jun 27 11:20:24 2006
alter database mount exclusive
Tue Jun 27 11:20:29 2006
Setting recovery target incarnation to 2
Tue Jun 27 11:20:29 2006
Successful mount of redo thread 1, with mount id 2475293112
Tue Jun 27 11:20:29 2006
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Tue Jun 27 11:20:29 2006
alter database open
Tue Jun 27 11:20:29 2006
Beginning crash recovery of 1 threads
Tue Jun 27 11:20:30 2006
Started redo scan
Tue Jun 27 11:20:31 2006
Completed redo scan
1061 redo blocks read, 229 data blocks need recovery
Tue Jun 27 11:20:31 2006
Started redo application at
Thread 1: logseq 28, block 77692
Tue Jun 27 11:20:32 2006
Recovery of Online Redo Log: Thread 1 Group 2 Seq 28 Reading mem 0
Mem# 0 errs 0: D:\DB_BACKUP\XE\ONLINELOG\O1_MF_2_29ZR81M4_.LOG
Tue Jun 27 11:20:33 2006
Completed redo application
Tue Jun 27 11:20:33 2006
Completed crash recovery at
Thread 1: logseq 28, block 78753, scn 1130857
229 data blocks read, 229 data blocks written, 1061 redo blocks read
Tue Jun 27 11:20:33 2006
LGWR: STARTING ARCH PROCESSES
ARC0 started with pid=19, OS id=1424
Tue Jun 27 11:20:33 2006
ARC0: Archival started
ARC1 started with pid=20, OS id=1388
Tue Jun 27 11:20:34 2006
ARC1: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
Thread 1 advanced to log sequence 29
Thread 1 opened at log sequence 29
Current log# 1 seq# 29 mem# 0: D:\DB_BACKUP\XE\ONLINELOG\O1_MF_1_29ZR88Q1_.LOG
Successful open of redo thread 1
Tue Jun 27 11:20:34 2006
ARC0: STARTING ARCH PROCESSES
Tue Jun 27 11:20:34 2006
ARC1: Becoming the 'no FAL' ARCH
Tue Jun 27 11:20:34 2006
ARC1: Becoming the 'no SRL' ARCH
Tue Jun 27 11:20:34 2006
ARC2: Archival started
ARC2 started with pid=21, OS id=1448
ARC0: STARTING ARCH PROCESSES COMPLETE
ARC0: Becoming the heartbeat ARCH
Tue Jun 27 11:20:35 2006
SMON: enabling cache recovery
Tue Jun 27 11:20:36 2006
db_recovery_file_dest_size of 5120 MB is 3.51% 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.
Tue Jun 27 11:20:42 2006
Successfully onlined Undo Tablespace 1.
Tue Jun 27 11:20:42 2006
SMON: enabling tx recovery
Tue Jun 27 11:20:42 2006
Database Characterset is WE8MSWIN1252
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=22, OS id=1500
Tue Jun 27 11:20:52 2006
Completed: alter database open
Dump file d:\oraclexe\app\oracle\admin\xe\bdump\alert_xe.log
Tue Jun 27 11:25:10 2006
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 1
CPU : 1 - type 586
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:655M/887M, Ph+PgF:1676M/1818M, VA:1944M/2047M
Tue Jun 27 11:25:10 2006
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 = 71303168
__large_pool_size = 8388608
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = D:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DBS\SPFILEXE.ORA
sga_target = 222298112
control_files = D:\ORACLEXE\ORADATA\XE\CONTROL.DBF
__db_cache_size = 134217728
compatible = 10.2.0.1.0
db_recovery_file_dest = d:\DB_Backup
db_recovery_file_dest_size= 5368709120
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 = 73400320
MMAN started with pid=4, OS id=2136
PMON started with pid=2, OS id=2128
PSP0 started with pid=3, OS id=2132
DBW0 started with pid=5, OS id=2140
LGWR started with pid=6, OS id=2144
CKPT started with pid=7, OS id=2148
SMON started with pid=8, OS id=2152
RECO started with pid=9, OS id=2156
CJQ0 started with pid=10, OS id=2160
MMON started with pid=11, OS id=2164
Tue Jun 27 11:25:19 2006
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=2168
Tue Jun 27 11:25:19 2006
starting up 4 shared server(s) ...
Oracle Data Guard is not available in this edition of Oracle.
Tue Jun 27 11:25:21 2006
alter database mount exclusive
Tue Jun 27 11:25:25 2006
Setting recovery target incarnation to 2
Tue Jun 27 11:25:25 2006
Successful mount of redo thread 1, with mount id 2475315937
Tue Jun 27 11:25:25 2006
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Tue Jun 27 11:25:25 2006
alter database open
Tue Jun 27 11:25:26 2006
Beginning crash recovery of 1 threads
Tue Jun 27 11:25:26 2006
Started redo scan
Tue Jun 27 11:25:27 2006
Completed redo scan
83 redo blocks read, 49 data blocks need recovery
Tue Jun 27 11:25:27 2006
Started redo application at
Thread 1: logseq 29, block 3
Tue Jun 27 11:25:27 2006
Recovery of Online Redo Log: Thread 1 Group 1 Seq 29 Reading mem 0
Mem# 0 errs 0: D:\DB_BACKUP\XE\ONLINELOG\O1_MF_1_29ZR88Q1_.LOG
Tue Jun 27 11:25:27 2006
Completed redo application
Tue Jun 27 11:25:27 2006
Completed crash recovery at
Thread 1: logseq 29, block 86, scn 1151072
49 data blocks read, 49 data blocks written, 83 redo blocks read
Tue Jun 27 11:25:29 2006
LGWR: STARTING ARCH PROCESSES
ARC0 started with pid=19, OS id=2252
ARC1 started with pid=20, OS id=2256
Tue Jun 27 11:25:29 2006
ARC0: Archival started
Tue Jun 27 11:25:29 2006
ARC1: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
Thread 1 advanced to log sequence 30
Thread 1 opened at log sequence 30
Current log# 2 seq# 30 mem# 0: D:\DB_BACKUP\XE\ONLINELOG\O1_MF_2_29ZR81M4_.LOG
Successful open of redo thread 1
Tue Jun 27 11:25:31 2006
ARC0: STARTING ARCH PROCESSES
Tue Jun 27 11:25:31 2006
ARC2: Archival started
ARC2 started with pid=21, OS id=2276
ARC0: STARTING ARCH PROCESSES COMPLETE
Tue Jun 27 11:25:31 2006
ARC1: Becoming the 'no FAL' ARCH
ARC1: Becoming the 'no SRL' ARCH
Tue Jun 27 11:25:31 2006
ARC0: Becoming the heartbeat ARCH
Tue Jun 27 11:25:31 2006
SMON: enabling cache recovery
Tue Jun 27 11:25:32 2006
db_recovery_file_dest_size of 5120 MB is 3.51% 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.
Tue Jun 27 11:25:36 2006
Successfully onlined Undo Tablespace 1.
Tue Jun 27 11:25:36 2006
SMON: enabling tx recovery
Tue Jun 27 11:25:36 2006
Database Characterset is WE8MSWIN1252
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=22, OS id=2296
Tue Jun 27 11:25:45 2006
Completed: alter database open
Tue Jun 27 11:31:20 2006
Shutting down archive processes
Tue Jun 27 11:31:25 2006
ARCH shutting down
ARC2: Archival stopped

I had a look at the batch file which does the back up and it seems to stop here:

if "%LOGMODE%" == "NOARCHIVELOG" goto process_noarchivelog
if "%LOGMODE%" == "ARCHIVELOG" goto process_archivelog
set Errorstr= Unknown log mode : %LOGMODE%
goto :backupfailederr

I don't know how it determines the value of %LOGMODE% It isn't set anywhere unless it is an environment variable.

/John

Hi Darrell,

Thanks very much for your response. It got me to the root of the problem. The script assumes that you can connect to the database as follows:
connect / as sysdba

I tried that in sqlplus and it didn't work so then I changed the script so that it included the user name and password. However, I wasn't able to modify the script as I don't have admin rights on this machine, so instead I made a copy. I ran that from the root of the D: drive and got the following:

Doing online backup of the database.
RMAN-00566: could not open TRACE "D:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\D
ATABASE\OXE_BACKUP_CURRENT.LOG"

Recovery Manager: Release 10.2.0.1.0 - Production on Tue Jun 27 17:55:05 2006

Copyright (c) 1982, 2005, Oracle. All rights reserved.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-01031: insufficient privileges
==================== ERROR =============================
Backup of the database failed.
RMAN Error - See log for details .
Log file is at D:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DATABASE\OX
E_BACKUP_CURRENT.LOG.
==================== ERROR =============================
Archive state is:
Press any key to continue . . .

I think this might be related to the fact that I am not using the original script and it can't write to certain directories as a result though I'm not sure. I put in all the sql commands listed and they look ok except for the spfile which doesn't seem to have any value:

SQL> show parameter db_recovery_file_dest;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string d:\DB_Backup
db_recovery_file_dest_size big integer 5G
SQL> show parameter spfile;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string
SQL> select log_mode from v$database;

LOG_MODE
------------
ARCHIVELOG

SQL>

/John

Hi Darell,

I feel like a fool... the whole thing was to do with permissions... You can only do backups as the person who installed Oracle XE. In this case the administrator. There is no point being added to the administrator group or getting local admin access - it seems to be tied to the exact user name of the person who installed the database, or started the Oracle service.

Thanks to everyone who helped me resolve this..

Darell - that error I got in the last post was because I didn't have a spfile, so I did:
CREATE SPFILE FROM PFILE;

retried the backup and it worked!

/John