Wed Nov 09 00:28:45 2005
Private_strands 7 at log switch
Thread 1 advanced to log sequence 11
Current log# 1 seq# 11 mem# 0: D:\PRODUITS\ORADATA\TEST2\REDO01.LOG
Wed Nov 09 02:13:43 2005
Private_strands 7 at log switch
Thread 1 advanced to log sequence 12
Current log# 2 seq# 12 mem# 0: D:\PRODUITS\ORADATA\TEST2\REDO02.LOG
Wed Nov 09 03:29:08 2005
Private_strands 7 at log switch
Thread 1 advanced to log sequence 13
Current log# 3 seq# 13 mem# 0: D:\PRODUITS\ORADATA\TEST2\REDO03.LOG
Wed Nov 09 05:28:46 2005
Private_strands 7 at log switch
Thread 1 advanced to log sequence 14
Current log# 1 seq# 14 mem# 0: D:\PRODUITS\ORADATA\TEST2\REDO01.LOG
Wed Nov 09 06:00:00 2005
Unable to restore resource manager plan to '':
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-00439: feature not enabled: Database resource manager
Wed Nov 09 07:13:44 2005
Private_strands 7 at log switch
Thread 1 advanced to log sequence 15
Current log# 2 seq# 15 mem# 0: D:\PRODUITS\ORADATA\TEST2\REDO02.LOG
Wed Nov 09 09:06:08 2005
Private_strands 7 at log switch
Thread 1 advanced to log sequence 16
Current log# 3 seq# 16 mem# 0: D:\PRODUITS\ORADATA\TEST2\REDO03.LOG
Wed Nov 09 10:33:23 2005
ALTER SYSTEM SET log_archive_dest_1='LOCATION=D:\Produits\oradata\test2\ARCH' SCOPE=BOTH;
Wed Nov 09 10:33:43 2005
Starting background process EMN0
EMN0 started with pid=19, OS id=3152
Wed Nov 09 10:33:43 2005
Shutting down instance: further logons disabled
Wed Nov 09 10:33:44 2005
Stopping background process QMNC
Wed Nov 09 10:33:45 2005
Stopping background process CJQ0
Wed Nov 09 10:33:45 2005
Stopping background process MMNL
Wed Nov 09 10:33:46 2005
Stopping background process MMON
Wed Nov 09 10:33:47 2005
Shutting down instance (immediate)
License high water mark = 15
Wed Nov 09 10:33:47 2005
Stopping Job queue slave processes
Wed Nov 09 10:33:47 2005
Job queue slave processes stopped
All dispatchers and shared servers shutdown
Wed Nov 09 10:33:53 2005
ALTER DATABASE CLOSE NORMAL
Wed Nov 09 10:33:53 2005
SMON: disabling tx recovery
SMON: disabling cache recovery
Wed Nov 09 10:33:53 2005
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 16
Successful close of redo thread 1
Wed Nov 09 10:33:53 2005
Completed: ALTER DATABASE CLOSE NORMAL
Wed Nov 09 10:33:53 2005
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
Wed Nov 09 10:34:07 2005
Running with 1 strand for Non-Enterprise Edition
Wed Nov 09 10:34:07 2005
Running without dynamic strand for Non-Enterprise Edition
Wed Nov 09 10:34:07 2005
Starting ORACLE instance (normal)
Wed Nov 09 10:34:07 2005
Running with 1 strand for Non-Enterprise Edition
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
KCCDEBUG_LEVEL = 0
Autotune of undo retention is turned on.
Running with 1 strand for Non-Enterprise Edition
Dynamic strands is set to FALSE
Running with 1 shared and 18 private strand(s). Zero-copy redo is FALSE
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 10.1.0.4.0.
System parameters with non-default values:
processes = 150
__shared_pool_size = 159383552
__large_pool_size = 4194304
__java_pool_size = 8388608
sga_target = 612368384
control_files = D:\PRODUITS\ORADATA\TEST2\CONTROL01.CTL, D:\PRODUITS\ORADATA\TEST2\CONTROL02.CTL, D:\PRODUITS\ORADATA\TEST2\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 436207616
compatible = 10.1.0.4.0
log_archive_dest_1 = LOCATION=D:\Produits\oradata\test2\ARCH
log_archive_format = redo_%S_%R_%T.arc
db_file_multiblock_read_count= 16
db_recovery_file_dest = D:\Produits\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=test2XDB)
job_queue_processes = 10
background_dump_dest = D:\PRODUITS\ADMIN\TEST2\BDUMP
user_dump_dest = D:\PRODUITS\ADMIN\TEST2\UDUMP
core_dump_dest = D:\PRODUITS\ADMIN\TEST2\CDUMP
db_name = test2
open_cursors = 300
pga_aggregate_target = 203423744
PMON started with pid=2, OS id=4032
MMAN started with pid=3, OS id=3508
DBW0 started with pid=4, OS id=2948
LGWR started with pid=5, OS id=2600
CKPT started with pid=6, OS id=2752
SMON started with pid=7, OS id=2964
RECO started with pid=8, OS id=3644
Wed Nov 09 10:34:08 2005
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
CJQ0 started with pid=9, OS id=1200
Wed Nov 09 10:34:08 2005
starting up 1 shared server(s) ...
Oracle Data Guard is not available in this edition of Oracle.
Wed Nov 09 10:34:44 2005
Shutting down instance: further logons disabled
Wed Nov 09 10:34:44 2005
Stopping background process CJQ0
Wed Nov 09 10:34:45 2005
Shutting down instance (immediate)
License high water mark = 1
Wed Nov 09 10:34:45 2005
Stopping Job queue slave processes
Wed Nov 09 10:34:45 2005
Job queue slave processes stopped
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Wed Nov 09 10:34:47 2005
alter database close normal
ORA-1507 signalled during: alter database close normal...
Starting up ORACLE RDBMS Version: 10.1.0.4.0.
System parameters with non-default values:
processes = 150
__shared_pool_size = 159383552
__large_pool_size = 4194304
__java_pool_size = 8388608
sga_target = 612368384
control_files = D:\PRODUITS\ORADATA\TEST2\CONTROL01.CTL, D:\PRODUITS\ORADATA\TEST2\CONTROL02.CTL, D:\PRODUITS\ORADATA\TEST2\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 436207616
compatible = 10.1.0.4.0
log_archive_dest_1 = LOCATION=D:\Produits\oradata\test2\ARCH
log_archive_format = redo_%S_%R_%T.arc
db_file_multiblock_read_count= 16
db_recovery_file_dest = D:\Produits\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=test2XDB)
job_queue_processes = 10
background_dump_dest = D:\PRODUITS\ADMIN\TEST2\BDUMP
user_dump_dest = D:\PRODUITS\ADMIN\TEST2\UDUMP
core_dump_dest = D:\PRODUITS\ADMIN\TEST2\CDUMP
db_name = test2
open_cursors = 300
pga_aggregate_target = 203423744
PMON started with pid=2, OS id=3208
MMAN started with pid=3, OS id=3720
DBW0 started with pid=4, OS id=3572
LGWR started with pid=5, OS id=676
CKPT started with pid=6, OS id=776
SMON started with pid=7, OS id=3316
RECO started with pid=8, OS id=3836
Wed Nov 09 10:34:48 2005
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
CJQ0 started with pid=9, OS id=1484
Wed Nov 09 10:34:48 2005
starting up 1 shared server(s) ...
Oracle Data Guard is not available in this edition of Oracle.
Wed Nov 09 10:34:48 2005
alter database mount exclusive
Wed Nov 09 10:34:48 2005
Controlfile identified with block size 16384
Wed Nov 09 10:34:52 2005
Setting recovery target incarnation to 2
Wed Nov 09 10:34:53 2005
Successful mount of redo thread 1, with mount id 657962568
Wed Nov 09 10:34:53 2005
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Wed Nov 09 10:34:53 2005
alter database open
Wed Nov 09 10:34:53 2005
Maximum redo generation record size = 120832 bytes
Maximum redo generation change vector size = 116476 bytes
Private_strands 1 at log switch
Thread 1 opened at log sequence 16
Current log# 3 seq# 16 mem# 0: D:\PRODUITS\ORADATA\TEST2\REDO03.LOG
Successful open of redo thread 1
Wed Nov 09 10:34:53 2005
SMON: enabling cache recovery
Wed Nov 09 10:34:54 2005
Successfully onlined Undo Tablespace 1.
Wed Nov 09 10:34:54 2005
SMON: enabling tx recovery
Wed Nov 09 10:34:54 2005
Database Characterset is WE8MSWIN1252
Wed Nov 09 10:34:55 2005
Starting background process QMNC
QMNC started with pid=13, OS id=2652
Wed Nov 09 10:34:56 2005
replication_dependency_tracking turned off (no async multimaster replication found)
Wed Nov 09 10:34:57 2005
Starting background process MMON
Starting background process MMNL
MMON started with pid=14, OS id=204
MMNL started with pid=15, OS id=1760
Wed Nov 09 10:34:57 2005
Completed: alter database open
Wed Nov 09 10:35:00 2005
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.
Wed Nov 09 10:51:35 2005
Private_strands 7 at log switch
Thread 1 advanced to log sequence 17
Current log# 1 seq# 17 mem# 0: D:\PRODUITS\ORADATA\TEST2\REDO01.LOG
Partager