太多怕粘不下,所以我只取部分啊
Dump file c:\oracle\product\10.2.0/admin/jbxl/bdump\alert_jbxl.log
Sat Nov 24 09:54:28 2007
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 2
CPU : 1 - type 586
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:46M/446M, Ph+PgF:146M/617M, VA:1940M/2047M
Sat Nov 24 09:54:28 2007
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 =18
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:
processes = 150
sga_target = 167772160
control_files = C:\ORACLE\PRODUCT\10.2.0\ORADATA\JBXL\CONTROL01.CTL, C:\ORACLE\PRODUCT\10.2.0\ORADATA\JBXL\CONTROL02.CTL, C:\ORACLE\PRODUCT\10.2.0\ORADATA\JBXL\CONTROL03.CTL
db_block_size = 8192
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = C:\oracle\product\10.2.0/flash_recovery_area
db_recovery_file_dest_size= 2147483648
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=jbxlXDB)
job_queue_processes = 10
audit_file_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\JBXL\ADUMP
background_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\JBXL\BDUMP
user_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\JBXL\UDUMP
core_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\JBXL\CDUMP
db_name = jbxl
open_cursors = 300
pga_aggregate_target = 16777216
MMAN started with pid=4, OS id=3872
PMON started with pid=2, OS id=700
PSP0 started with pid=3, OS id=1788
DBW0 started with pid=5, OS id=3196
LGWR started with pid=6, OS id=420
CKPT started with pid=7, OS id=3408
SMON started with pid=8, OS id=2864
RECO started with pid=9, OS id=2764
CJQ0 started with pid=10, OS id=3384
MMON started with pid=11, OS id=120
Sat Nov 24 09:54:31 2007
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=3224
Sat Nov 24 09:54:31 2007
starting up 1 shared server(s) ...
Sat Nov 24 09:54:39 2007
The input backup piece C:\ORACLE\PRODUCT\10.2.0\DB_1\ASSISTANTS\DBCA\TEMPLATES\SEED_DATABASE.DFB is in compressed format.
Sat Nov 24 09:54:56 2007
Full restore complete of datafile 4 to datafile copy C:\ORACLE\PRODUCT\10.2.0\ORADATA\JBXL\USERS01.DBF. Elapsed time: 0:00:00
checkpoint is 534906
Full restore complete of datafile 2 to datafile copy C:\ORACLE\PRODUCT\10.2.0\ORADATA\JBXL\UNDOTBS01.DBF. Elapsed time: 0:00:03
checkpoint is 534906
Sat Nov 24 09:55:20 2007
Full restore complete of datafile 3 to datafile copy C:\ORACLE\PRODUCT\10.2.0\ORADATA\JBXL\SYSAUX01.DBF. Elapsed time: 0:00:26
checkpoint is 534906
Sat Nov 24 09:55:46 2007
Full restore complete of datafile 1 to datafile copy C:\ORACLE\PRODUCT\10.2.0\ORADATA\JBXL\SYSTEM01.DBF. Elapsed time: 0:00:57
checkpoint is 534906
Sat Nov 24 09:55:48 2007
Create controlfile reuse set database "jbxl"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
Datafile
'C:\oracle\product\10.2.0\oradata\jbxl\SYSTEM01.DBF',
'C:\oracle\product\10.2.0\oradata\jbxl\UNDOTBS01.DBF',
'C:\oracle\product\10.2.0\oradata\jbxl\SYSAUX01.DBF',
'C:\oracle\product\10.2.0\oradata\jbxl\USERS01.DBF'
LOGFILE GROUP 1 ('C:\oracle\product\10.2.0\oradata\jbxl\redo01.log') SIZE 51200K,
GROUP 2 ('C:\oracle\product\10.2.0\oradata\jbxl\redo02.log') SIZE 51200K,
GROUP 3 ('C:\oracle\product\10.2.0\oradata\jbxl\redo03.log') 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
Sat Nov 24 09:55:50 2007
Successful mount of redo thread 1, with mount id 1687285796
Sat Nov 24 09:55:50 2007
Completed: Create controlfile reuse set database "jbxl"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
Datafile
'C:\oracle\product\10.2.0\oradata\jbxl\SYSTEM01.DBF',
'C:\oracle\product\10.2.0\oradata\jbxl\UNDOTBS01.DBF',
'C:\oracle\product\10.2.0\oradata\jbxl\SYSAUX01.DBF',
'C:\oracle\product\10.2.0\oradata\jbxl\USERS01.DBF'
LOGFILE GROUP 1 ('C:\oracle\product\10.2.0\oradata\jbxl\redo01.log') SIZE 51200K,
GROUP 2 ('C:\oracle\product\10.2.0\oradata\jbxl\redo02.log') SIZE 51200K,
GROUP 3 ('C:\oracle\product\10.2.0\oradata\jbxl\redo03.log') SIZE 51200K RESETLOGS
Shutting down instance: further logons disabled
Sat Nov 24 09:55:50 2007
Stopping background process CJQ0
Sat Nov 24 09:55:50 2007
Stopping background process MMNL
Sat Nov 24 09:55:50 2007
Stopping background process MMON
Sat Nov 24 09:55:51 2007
Shutting down instance (immediate)
License high water mark = 1
Sat Nov 24 09:55:51 2007
Stopping Job queue slave processes
Sat Nov 24 09:55:51 2007
Job queue slave processes stopped
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Sat Nov 24 09:55:52 2007
ALTER DATABASE CLOSE NORMAL
ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
Sat Nov 24 09:55:52 2007
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
Sat Nov 24 09:55:55 2007
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 =18
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:
processes = 150
sga_target = 167772160
control_files = C:\ORACLE\PRODUCT\10.2.0\ORADATA\JBXL\CONTROL01.CTL, C:\ORACLE\PRODUCT\10.2.0\ORADATA\JBXL\CONTROL02.CTL, C:\ORACLE\PRODUCT\10.2.0\ORADATA\JBXL\CONTROL03.CTL
db_block_size = 8192
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = C:\oracle\product\10.2.0/flash_recovery_area
db_recovery_file_dest_size= 2147483648
_no_recovery_through_resetlogs= TRUE
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=jbxlXDB)
audit_file_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\JBXL\ADUMP
background_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\JBXL\BDUMP
user_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\JBXL\UDUMP
core_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\JBXL\CDUMP
db_name = jbxl
open_cursors = 300
pga_aggregate_target = 16777216
PMON started with pid=2, OS id=1888
PSP0 started with pid=3, OS id=2656
MMAN started with pid=4, OS id=2564
DBW0 started with pid=5, OS id=908
LGWR started with pid=6, OS id=2676
CKPT started with pid=7, OS id=2684
SMON started with pid=8, OS id=2364
RECO started with pid=9, OS id=2692
MMON started with pid=10, OS id=3732
Sat Nov 24 09:55:55 2007
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=11, OS id=2508
Sat Nov 24 09:55:55 2007
starting up 1 shared server(s) ...
Sat Nov 24 09:55:56 2007
Create controlfile reuse set database "jbxl"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
Datafile
'C:\oracle\product\10.2.0\oradata\jbxl\SYSTEM01.DBF',
'C:\oracle\product\10.2.0\oradata\jbxl\UNDOTBS01.DBF',
'C:\oracle\product\10.2.0\oradata\jbxl\SYSAUX01.DBF',
'C:\oracle\product\10.2.0\oradata\jbxl\USERS01.DBF'
LOGFILE GROUP 1 ('C:\oracle\product\10.2.0\oradata\jbxl\redo01.log') SIZE 51200K,
GROUP 2 ('C:\oracle\product\10.2.0\oradata\jbxl\redo02.log') SIZE 51200K,
GROUP 3 ('C:\oracle\product\10.2.0\oradata\jbxl\redo03.log') SIZE 51200K RESETLOGS
Sat Nov 24 09:55:56 2007
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
Sat Nov 24 09:55:57 2007
Successful mount of redo thread 1, with mount id 1687280684
Sat Nov 24 09:55:57 2007
Completed: Create controlfile reuse set database "jbxl"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
Datafile
'C:\oracle\product\10.2.0\oradata\jbxl\SYSTEM01.DBF',
'C:\oracle\product\10.2.0\oradata\jbxl\UNDOTBS01.DBF',
'C:\oracle\product\10.2.0\oradata\jbxl\SYSAUX01.DBF',
'C:\oracle\product\10.2.0\oradata\jbxl\USERS01.DBF'
LOGFILE GROUP 1 ('C:\oracle\product\10.2.0\oradata\jbxl\redo01.log') SIZE 51200K,
GROUP 2 ('C:\oracle\product\10.2.0\oradata\jbxl\redo02.log') SIZE 51200K,
GROUP 3 ('C:\oracle\product\10.2.0\oradata\jbxl\redo03.log') SIZE 51200K RESETLOGS
Sat Nov 24 09:55:57 2007
Stopping background process MMNL
Sat Nov 24 09:55:57 2007
Stopping background process MMON
Starting background process MMON
Starting background process MMNL
MMON started with pid=10, OS id=2052
MMNL started with pid=11, OS id=3496
Sat Nov 24 09:55:57 2007
ALTER SYSTEM enable restricted session;
Sat Nov 24 09:55:57 2007
alter database "jbxl" open resetlogs
RESETLOGS after incomplete recovery UNTIL CHANGE 534906
Sat Nov 24 09:55:57 2007
Errors in file c:\oracle\product\10.2.0\admin\jbxl\udump\jbxl_ora_3920.trc:
ORA-00313: ??????? 1 (???? 1) ???
ORA-00312: ???? 1 ?? 1: 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\JBXL\REDO01.LOG'
ORA-27041: ??????
OSD-04002: 无法打开文件
O/S-Error: (OS 2) 系统找不到指定的文件。
Sat Nov 24 09:55:59 2007
Errors in file c:\oracle\product\10.2.0\admin\jbxl\udump\jbxl_ora_3920.trc:
ORA-00313: ??????? 2 (???? 1) ???
ORA-00312: ???? 2 ?? 1: 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\JBXL\REDO02.LOG'
ORA-27041: ??????
OSD-04002: 无法打开文件
O/S-Error: (OS 2) 系统找不到指定的文件。
Sat Nov 24 09:56:02 2007
Errors in file c:\oracle\product\10.2.0\admin\jbxl\udump\jbxl_ora_3920.trc:
ORA-00313: ??????? 3 (???? 1) ???
ORA-00312: ???? 3 ?? 1: 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\JBXL\REDO03.LOG'
ORA-27041: ??????
OSD-04002: 无法打开文件
O/S-Error: (OS 2) 系统找不到指定的文件。
Sat Nov 24 09:56:04 2007
Setting recovery target incarnation to 2
Sat Nov 24 09:56:05 2007
Assigning activation ID 1687280684 (0x6491dc2c)
Thread 1 opened at log sequence 1
Current log# 3 seq# 1 mem# 0: C:\ORACLE\PRODUCT\10.2.0\ORADATA\JBXL\REDO03.LOG
Successful open of redo thread 1
Sat Nov 24 09:56:05 2007
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Sat Nov 24 09:56:05 2007
SMON: enabling cache recovery
Sat Nov 24 09:56:07 2007
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
Sat Nov 24 09:56:07 2007
SMON: enabling tx recovery
Sat Nov 24 09:56:08 2007
*********************************************************************
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 ADD TEMPFILE
Alternatively, if these temporary tablespaces are no longer
needed, then they can be dropped.
Empty temporary tablespace: TEMP
*********************************************************************
Database Characterset is US7ASCII
Threshold validation cannot be done before catproc is loaded.
Threshold validation cannot be done before catproc is loaded.
**********************************************************
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=15, OS id=1856
Sat Nov 24 09:56:13 2007
LOGSTDBY: Validating controlfile with logical metadata
Sat Nov 24 09:56:14 2007
LOGSTDBY: Validation complete
Global Name changed to JBXL
Completed: alter database "jbxl" open resetlogs
Sat Nov 24 09:56:19 2007
alter database rename global_name to "jbxl"
Completed: alter database rename global_name to "jbxl"
Sat Nov 24 09:56:19 2007
ALTER TABLESPACE TEMP ADD TEMPFILE 'C:\oracle\product\10.2.0\oradata\jbxl\TEMP01.DBF' SIZE 20480K REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
Completed: ALTER TABLESPACE TEMP ADD TEMPFILE 'C:\oracle\product\10.2.0\oradata\jbxl\TEMP01.DBF' SIZE 20480K REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
Sat Nov 24 09:56:21 2007
ALTER DATABASE DEFAULT TABLESPACE "USERS"
Completed: ALTER DATABASE DEFAULT TABLESPACE "USERS"
Sat Nov 24 09:56:21 2007
alter database character set INTERNAL_CONVERT ZHS16GBK
Sat Nov 24 09:56:42 2007
Updating character set in controlfile to ZHS16GBK
Synchronizing connection with database character set information
SYS.METASTYLESHEET (STYLESHEET) - CLOB representation altered
SYS.ATTRIBUTE_TRANSFORMATIONS$ (XSL_TRANSFORMATION) - CLOB representation altered
SYS.RULE$ (CONDITION) - CLOB representation altered
SYS.SCHEDULER$_EVENT_LOG (ADDITIONAL_INFO) - CLOB representation altered
SYS.WRI$_DBU_FEATURE_METADATA (INST_CHK_LOGIC) - CLOB representation altered
SYS.WRI$_DBU_FEATURE_METADATA (USG_DET_LOGIC) - CLOB representation altered
SYS.WRI$_DBU_HWM_METADATA (LOGIC) - CLOB representation altered
XDB.XDB$RESOURCE (SYS_NC00027$) - CLOB representation altered
Sat Nov 24 09:56:57 2007
Thread 1 advanced to log sequence 2
Current log# 1 seq# 2 mem# 0: C:\ORACLE\PRODUCT\10.2.0\ORADATA\JBXL\REDO01.LOG
Sat Nov 24 09:56:58 2007
MDSYS.SDO_COORD_OP_PARAM_VALS (PARAM_VALUE_FILE) - CLOB representation altered
MDSYS.SDO_COORD_OP_PARAM_VALS (SYS_NC00008$) - CLOB representation altered
MDSYS.SDO_STYLES_TABLE (DEFINITION) - CLOB representation altered
MDSYS.SDO_XML_SCHEMAS (XMLSCHEMA) - CLOB representation altered
MDSYS.SDO_GEOR_XMLSCHEMA_TABLE (XMLSCHEMA) - CLOB representation altered
Refreshing type attributes with new character set information
ORA-4030 signalled during: alter database character set INTERNAL_CONVERT ZHS16GBK...
Sat Nov 24 10:11:03 2007
db_recovery_file_dest_size of 2048 MB is 0.00% 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.
Sat Nov 24 10:13:29 2007
ALTER SYSTEM disable restricted session;
Sat Nov 24 10:13:37 2007
Starting background process CJQ0
CJQ0 started with pid=19, OS id=3540
Sat Nov 24 10:13:42 2007
Errors in file c:\oracle\product\10.2.0\admin\jbxl\udump\jbxl_ora_3608.trc:
Sat Nov 24 10:40:52 2007
Starting background process EMN0
EMN0 started with pid=18, OS id=396
Sat Nov 24 10:40:52 2007
Shutting down instance: further logons disabled
Sat Nov 24 10:40:52 2007
Stopping background process CJQ0
Sat Nov 24 10:40:52 2007
Stopping background process QMNC
Sat Nov 24 10:40:53 2007
Stopping background process MMNL
Sat Nov 24 10:40:54 2007
Stopping background process MMON
Sat Nov 24 10:40:55 2007
Shutting down instance (immediate)
License high water mark = 4
All dispatchers and shared servers shutdown
Sat Nov 24 10:40:57 2007
ALTER DATABASE CLOSE NORMAL
Sat Nov 24 10:40:58 2007
SMON: disabling tx recovery
SMON: disabling cache recovery
Sat Nov 24 10:40:58 2007
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
Sat Nov 24 10:40:59 2007
Completed: ALTER DATABASE CLOSE NORMAL
Sat Nov 24 10:40:59 2007
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
Sat Nov 24 10:41:02 2007
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 =18
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:
processes = 150
spfile = C:\ORACLE\PRODUCT\10.2.0\DB_1\DBS\SPFILEJBXL.ORA
sga_target = 167772160
control_files = C:\ORACLE\PRODUCT\10.2.0\ORADATA\JBXL\CONTROL01.CTL, C:\ORACLE\PRODUCT\10.2.0\ORADATA\JBXL\CONTROL02.CTL, C:\ORACLE\PRODUCT\10.2.0\ORADATA\JBXL\CONTROL03.CTL
db_block_size = 8192
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = C:\oracle\product\10.2.0/flash_recovery_area
db_recovery_file_dest_size= 2147483648
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=jbxlXDB)
job_queue_processes = 10
audit_file_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\JBXL\ADUMP
background_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\JBXL\BDUMP
user_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\JBXL\UDUMP
core_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\JBXL\CDUMP
db_name = jbxl
open_cursors = 300
pga_aggregate_target = 16777216
PMON started with pid=2, OS id=3284
PSP0 started with pid=3, OS id=3084
MMAN started with pid=4, OS id=2080
DBW0 started with pid=5, OS id=2204
LGWR started with pid=6, OS id=2424
CKPT started with pid=7, OS id=2292
SMON started with pid=8, OS id=3340
RECO started with pid=9, OS id=420
CJQ0 started with pid=10, OS id=1788
MMON started with pid=11, OS id=2864
Sat Nov 24 10:41:03 2007
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=3872
Sat Nov 24 10:41:03 2007
starting up 1 shared server(s) ...
Sat Nov 24 10:41:04 2007
ALTER DATABASE MOUNT
Sat Nov 24 10:41:08 2007
Setting recovery target incarnation to 2
Sat Nov 24 10:41:08 2007
Successful mount of redo thread 1, with mount id 1687302592
Sat Nov 24 10:41:08 2007
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Sat Nov 24 10:41:08 2007
ALTER DATABASE OPEN
Sat Nov 24 10:41:09 2007
Thread 1 opened at log sequence 2
Current log# 1 seq# 2 mem# 0: C:\ORACLE\PRODUCT\10.2.0\ORADATA\JBXL\REDO01.LOG
Successful open of redo thread 1
Sat Nov 24 10:41:09 2007
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Sat Nov 24 10:41:09 2007
SMON: enabling cache recovery
Sat Nov 24 10:41:10 2007
Successfully onlined Undo Tablespace 1.
Sat Nov 24 10:41:10 2007
SMON: enabling tx recovery
Sat Nov 24 10:41:11 2007
Updating character set in controlfile to US7ASCII
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=15, OS id=3592
Sat Nov 24 10:41:16 2007
Completed: ALTER DATABASE OPEN
Sat Nov 24 10:41:17 2007
db_recovery_file_dest_size of 2048 MB is 0.00% 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.
Sat Nov 24 11:38:00 2007
Starting background process EMN0
EMN0 started with pid=20, OS id=456
Sat Nov 24 11:38:00 2007
Shutting down instance: further logons disabled
Sat Nov 24 11:38:01 2007
Stopping background process CJQ0
Sat Nov 24 11:38:02 2007
Stopping background process QMNC
Sat Nov 24 11:38:03 2007
Stopping background process MMNL
Sat Nov 24 11:38:04 2007
Stopping background process MMON
Sat Nov 24 11:38:06 2007
Shutting down instance (immediate)
License high water mark = 5
Sat Nov 24 11:38:06 2007
Stopping Job queue slave processes
Sat Nov 24 11:38:06 2007
Job queue slave processes stopped
All dispatchers and shared servers shutdown
Sat Nov 24 11:38:13 2007
ALTER DATABASE CLOSE NORMAL
Sat Nov 24 11:38:13 2007
SMON: disabling tx recovery
SMON: disabling cache recovery
Sat Nov 24 11:38:15 2007
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
Sat Nov 24 11:38:15 2007
Completed: ALTER DATABASE CLOSE NORMAL
Sat Nov 24 11:38:15 2007
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
Dump file c:\oracle\product\10.2.0/admin/jbxl/bdump\alert_jbxl.log
Sun Nov 25 08:30:35 2007
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 2
CPU : 1 - type 586
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:130M/446M, Ph+PgF:92M/548M, VA:1940M/2047M
Sun Nov 25 08:30:35 2007
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 =18
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:
processes = 150
__shared_pool_size = 54525952
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = C:\ORACLE\PRODUCT\10.2.0\DB_1\DBS\SPFILEJBXL.ORA
sga_target = 167772160
control_files = C:\ORACLE\PRODUCT\10.2.0\ORADATA\JBXL\CONTROL01.CTL, C:\ORACLE\PRODUCT\10.2.0\ORADATA\JBXL\CONTROL02.CTL, C:\ORACLE\PRODUCT\10.2.0\ORADATA\JBXL\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 100663296
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = C:\oracle\product\10.2.0/flash_recovery_area
db_recovery_file_dest_size= 2147483648
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=jbxlXDB)
job_queue_processes = 10
audit_file_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\JBXL\ADUMP
background_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\JBXL\BDUMP
user_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\JBXL\UDUMP
core_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\JBXL\CDUMP
db_name = jbxl
open_cursors = 300
pga_aggregate_target = 16777216
MMAN started with pid=4, OS id=3364
PMON started with pid=2, OS id=2656
PSP0 started with pid=3, OS id=3384
DBW0 started with pid=5, OS id=2680
LGWR started with pid=6, OS id=2684
CKPT started with pid=7, OS id=2688
SMON started with pid=8, OS id=2708
RECO started with pid=9, OS id=2712
CJQ0 started with pid=10, OS id=944
MMON started with pid=11, OS id=2716
MMNL started with pid=12, OS id=2720
Sun Nov 25 08:30:40 2007
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Sun Nov 25 08:30:42 2007
alter database mount exclusive
Sun Nov 25 08:30:47 2007
Setting recovery target incarnation to 2
Sun Nov 25 08:30:47 2007
Successful mount of redo thread 1, with mount id 1687380146
Sun Nov 25 08:30:47 2007
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Sun Nov 25 08:30:47 2007
alter database open
Sun Nov 25 08:30:48 2007
Thread 1 opened at log sequence 2
Current log# 1 seq# 2 mem# 0: C:\ORACLE\PRODUCT\10.2.0\ORADATA\JBXL\REDO01.LOG
Successful open of redo thread 1
Sun Nov 25 08:30:48 2007
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Sun Nov 25 08:30:48 2007
SMON: enabling cache recovery
Sun Nov 25 08:30:53 2007
Successfully onlined Undo Tablespace 1.
Sun Nov 25 08:30:53 2007
SMON: enabling tx recovery
Sun Nov 25 08:30:53 2007
Database Characterset is US7ASCII
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=16, OS id=2944
Sun Nov 25 08:31:02 2007
Completed: alter database open
Sun Nov 25 08:31:04 2007
db_recovery_file_dest_size of 2048 MB is 0.00% 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.