|
|
不会记录的，下面给一个startup pfile='/home/oracle/init.ora';，这样方式启动后的完整的alert的日志：
Thu Apr 17 08:50:13 2008
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on.
IMODE=BR
ILAT =36
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.4.0.
System parameters with non-default values:
processes = 300
timed_statistics = TRUE
shared_pool_size = 314572800
large_pool_size = 268435456
shared_pool_reserved_size= 20971520
trace_enabled = FALSE
control_files = /u01/oradata/billdb/stdbycontrol01.dbf, /u01/oradata/billdb/stdbycontrol02.dbf
db_block_size = 8192
db_cache_size = 314572800
db_keep_cache_size = 16777216
db_writer_processes = 2
compatible = 10.2.0.2.0
log_archive_config = DG_CONFIG=(billdb,dg)
log_archive_dest =
log_archive_dest_1 = LOCATION=/u01/archive/billdb/ VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=dg
log_archive_dest_2 = SERVICE=billdb LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=billdb
log_archive_dest_3 = LOCATION=/u01/stdlog VALID_FOR=(STANDBY_LOGFILES,STANDBY_ROLE) DB_UNIQUE_NAME=dg
log_archive_format = arc%t_%s_%r.arc
fal_client = dg
fal_server = billdb
log_buffer = 2040832
log_checkpoint_interval = 10000
log_checkpoint_timeout = 14400
db_files = 1022
db_file_multiblock_read_count= 8
standby_file_management = auto
undo_management = AUTO
undo_tablespace = undotbs
undo_retention = 1800
remote_login_passwordfile= EXCLUSIVE
db_domain = 99bill.com
global_names = FALSE
session_cached_cursors = 50
utl_file_dir = /tmp
job_queue_processes = 4
parallel_max_servers = 32
background_dump_dest = /u01/app/admin/billdb/bdump
user_dump_dest = /u01/app/admin/billdb/udump
max_dump_file_size = 10240
core_dump_dest = /u01/app/admin/billdb/cdump
db_name = billdb
db_unique_name = dg
open_cursors = 500
star_transformation_enabled= true
optimizer_index_cost_adj = 15
optimizer_index_caching = 90
pga_aggregate_target = 536870912
workarea_size_policy = auto
PMON started with pid=2, OS id=10204
PSP0 started with pid=3, OS id=10206
MMAN started with pid=4, OS id=10208
DBW0 started with pid=5, OS id=10210
DBW1 started with pid=6, OS id=10212
LGWR started with pid=7, OS id=10214
CKPT started with pid=8, OS id=10216
SMON started with pid=9, OS id=10218
RECO started with pid=10, OS id=10220
CJQ0 started with pid=11, OS id=10222
MMON started with pid=12, OS id=10224
MMNL started with pid=13, OS id=10226
Thu Apr 17 08:50:16 2008
ALTER DATABASE MOUNT
Thu Apr 17 08:50:20 2008
Setting recovery target incarnation to 2
Thu Apr 17 08:50:20 2008
Successful mount of redo thread 1, with mount id 1579344200
Thu Apr 17 08:50:20 2008
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Thu Apr 17 08:50:20 2008
ALTER DATABASE OPEN
Thu Apr 17 08:50:20 2008
LGWR: STARTING ARCH PROCESSES
ARC0 started with pid=15, OS id=10230
Thu Apr 17 08:50:20 2008
ARC0: Archival started
ARC1: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC1 started with pid=16, OS id=10232
LNS1 started with pid=17, OS id=10234
Thu Apr 17 08:50:23 2008
Thread 1 advanced to log sequence 28 (thread open)
Thu Apr 17 08:50:23 2008
ARC0: STARTING ARCH PROCESSES
Thu Apr 17 08:50:23 2008
ARC1: Becoming the 'no FAL' ARCH
ARC1: Becoming the 'no SRL' ARCH
Thu Apr 17 08:50:23 2008
Thread 1 opened at log sequence 28
Current log# 2 seq# 28 mem# 0: /u01/oradata/billdb/redo2_01.log
Current log# 2 seq# 28 mem# 1: /u01/oradata/billdb/redo2_02.log
Successful open of redo thread 1
Thu Apr 17 08:50:24 2008
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Thu Apr 17 08:50:24 2008
******************************************************************
LGWR: Setting 'active' archival for destination LOG_ARCHIVE_DEST_2
******************************************************************
Thu Apr 17 08:50:24 2008
SMON: enabling cache recovery
Thu Apr 17 08:50:24 2008
ARC2: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
ARC0: Becoming the heartbeat ARCH
ARC2 started with pid=18, OS id=10236
Thu Apr 17 08:50:24 2008
LNS: Standby redo logfile selected for thread 1 sequence 28 for destination LOG_ARCHIVE_DEST_2
Thu Apr 17 08:50:24 2008
Successfully onlined Undo Tablespace 1.
Thu Apr 17 08:50:24 2008
SMON: enabling tx recovery
Thu Apr 17 08:50:24 2008
Database Characterset is AL32UTF8
Opening with internal Resource Manager plan
where NUMA PG = 1, CPUs = 2
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
Thu Apr 17 08:50:25 2008
ARC0: Standby redo logfile selected for thread 1 sequence 27 for destination LOG_ARCHIVE_DEST_2
QMNC started with pid=19, OS id=10238
Thu Apr 17 08:50:26 2008
Completed: ALTER DATABASE OPEN
原帖由 kdkd 于 2008-4-17 00:48 发表 ![]()
查alert log文件，alert log记录了启动的语句。 |
|
楼主: starndawn
IP卡
狗仔卡
发表于 2008-4-17 00:48
显身卡
发表于 2008-4-17 23:52