Thu Jul 13 17:04:49 2006
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
KCCDEBUG_LEVEL = 0
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
Dynamic strands is set to TRUE
Running with 2 shared and 30 private strand(s). Zero-copy redo is FALSE
IMODE=BR
ILAT =30
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 10.1.0.2.0.
System parameters with non-default values:
processes = 250
__shared_pool_size = 138412032
__large_pool_size = 4194304
__java_pool_size = 8388608
nls_language = AMERICAN
sga_target = 285212672
control_files = /u02/oradata/cgnsdata/control01.ctl, /u02/oradata/cgnsdata/control02.ctl, /u02/oradata/cgnsdata/control03.ctl
db_block_size = 8192
__db_cache_size = 130023424
compatible = 10.1.0.2.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = /u01/app/oracle/flash_recovery_area
db_recovery_file_dest_size= 39147483648
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=cgnsdataXDB)
job_queue_processes = 10
background_dump_dest = /u01/app/oracle/admin/cgnsdata/bdump
user_dump_dest = /u01/app/oracle/admin/cgnsdata/udump
core_dump_dest = /u01/app/oracle/admin/cgnsdata/cdump
sort_area_size = 65536
db_name = cgnsdata
open_cursors = 300
pga_aggregate_target = 94371840
PMON started with pid=2, OS id=4778
MMAN started with pid=3, OS id=4780
DBW0 started with pid=4, OS id=4782
LGWR started with pid=5, OS id=4784
CKPT started with pid=6, OS id=4786
SMON started with pid=7, OS id=4788
RECO started with pid=8, OS id=4790
Thu Jul 13 17:04:49 2006
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
CJQ0 started with pid=9, OS id=4792
Thu Jul 13 17:04:49 2006
starting up 1 shared server(s) ...
Thu Jul 13 17:04:49 2006
ALTER DATABASE MOUNT
Thu Jul 13 17:04:49 2006
Controlfile identified with block size 16384
Thu Jul 13 17:04:53 2006
Setting recovery target incarnation to 2
Thu Jul 13 17:04:53 2006
Successful mount of redo thread 1, with mount id 1502107377
Thu Jul 13 17:04:53 2006
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Thu Jul 13 17:04:53 2006
ALTER DATABASE OPEN
Thu Jul 13 17:04:53 2006
Beginning crash recovery of 1 threads
attempting to start a parallel recovery with 3 processes
parallel recovery started with 3 processes
Thu Jul 13 17:04:54 2006
Started first pass scan
Thu Jul 13 17:04:54 2006
Completed first pass scan
1 redo blocks read, 0 data blocks need recovery
Thu Jul 13 17:04:54 2006
Started redo application at
Thread 1: logseq 191289, block 2, scn 0.805770165
Recovery of Online Redo Log: Thread 1 Group 2 Seq 191289 Reading mem 0
Mem# 0 errs 0: /u02/oradata/cgnsdata/redo02.log
Thu Jul 13 17:04:54 2006
Completed redo application
Thu Jul 13 17:04:54 2006
Completed crash recovery at
Thread 1: logseq 191289, block 3, scn 0.805790167
0 data blocks read, 0 data blocks written, 1 redo blocks read
Thu Jul 13 17:04:54 2006
LGWR: STARTING ARCH PROCESSES
ARC0 started with pid=16, OS id=4810
ARC0: Archival started
Thu Jul 13 17:04:54 2006
LGWR: STARTING ARCH PROCESSES COMPLETE
LGWR: Primary database is in CLUSTER CONSISTENT mode
Thu Jul 13 17:04:54 2006
ARC0: Becoming the 'no FAL' ARCH
ARC0: Becoming the 'no SRL' ARCH
ARC1 started with pid=17, OS id=4812
ARC1: Archival started
ARC1: Becoming the heartbeat ARCH
Thu Jul 13 17:04:54 2006
Thread 1 advanced to log sequence 191290
Maximum redo generation record size = 120832 bytes
Maximum redo generation change vector size = 116476 bytes
Private_strands 7 at log switch
Thread 1 opened at log sequence 191290
Current log# 1 seq# 191290 mem# 0: /u02/oradata/cgnsdata/redo01.log
Successful open of redo thread 1
Thu Jul 13 17:04:54 2006
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Thu Jul 13 17:04:54 2006
ARC1: Evaluating archive log 2 thread 1 sequence 191289
Thu Jul 13 17:04:54 2006
ARC0: Evaluating archive log 2 thread 1 sequence 191289
Thu Jul 13 17:04:54 2006
SMON: enabling cache recovery
Thu Jul 13 17:04:54 2006
cgnsdata; ARC1: Beginning to archive log 2 thread 1 sequence 191289 (0.805770164:0.805790168)
Thu Jul 13 17:04:54 2006
ARC0: Unable to archive log 2 thread 1 sequence 191289
Thu Jul 13 17:04:54 2006
ARCH: Connecting to console port...
Thu Jul 13 17:04:54 2006
Log actively being archived by another process
Thu Jul 13 17:04:54 2006
cgnsdata; ARC1: Creating local archive destination LOG_ARCHIVE_DEST_10: '/u01/app/oracle/flash_recovery_area/CGNSDATA/archivelog/2006_07_13/o1_mf_1_191289_%u_.arc' (thread 1 sequence 191289)
Thu Jul 13 17:04:54 2006
ARCH: Connecting to console port...
db_recovery_file_dest_size of 37333 MB is 2.45% 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 Jul 13 17:04:54 2006
cgnsdata; ARC1: Closing local archive destination LOG_ARCHIVE_DEST_10: '/u01/app/oracle/flash_recovery_area/CGNSDATA/archivelog/2006_07_13/o1_mf_1_191289_2cdr8pf5_.arc'
ARCH: Connecting to console port...
Committing creation of archivelog '/u01/app/oracle/flash_recovery_area/CGNSDATA/archivelog/2006_07_13/o1_mf_1_191289_2cdr8pf5_.arc'
Created Oracle managed file /u01/app/oracle/flash_recovery_area/CGNSDATA/archivelog/2006_07_13/o1_mf_1_191289_2cdr8pf5_.arc
Thu Jul 13 17:04:54 2006
Errors in file /u01/app/oracle/admin/cgnsdata/udump/cgnsdata_ora_4802.trc:
ORA-00704: bootstrap process failure
ORA-00604: error occurred at recursive SQL level 1
ORA-01502: index 'SYS.I_DEPENDENCY1' or partition of such index is in unusable state
Thu Jul 13 17:04:54 2006
Error 704 happened during db open, shutting down database
USER: terminating instance due to error 704
Instance terminated by USER, pid = 4802
ORA-1092 signalled during: ALTER DATABASE OPEN...
ORA-01092: ORACLE instance terminated. Disconnection forced
Répondre avec citation
Partager