Fri Jan 09 03:11:17 2015DIAG started with pid=19, OS id=6031 Dumping diagnostic data in directory=[cdmp_20150109031118], requested by (instance=1, osid=2456 (CJQ0)), summary=[incident=45657].Mon Feb 09 01:51:09 2015Adjusting the default value of parameter parallel_max_serversfrom 160 to 120 due to the value of parameter processes (150) —>自动调整parallel_max_servers参数Starting ORACLE instance (normal)************************ Large Pages Information *******************Per process system memlock (soft) limit = 64 KB Total Shared Global Region in Large Pages = 0 KB (0%) Large Pages used by this instance: 0 (0 KB)Large Pages unused system wide = 0 (0 KB)Large Pages configured system wide = 0 (0 KB)Large Page size = 2048 KB RECOMMENDATION:—>推荐设置 Total System Global Area size is 1026 MB. For optimal performance, prior to the next instance restart: 1. Increase the number of unused large pages by at least 513 (page size 2048 KB, total size 1026 MB) system wide to get 100% of the System Global Area allocated with large pages 2. Large pages are automatically locked into physical memory. Increase the per process memlock (soft) limit to at least 1034 MB to lock 100% System Global Area's large pages into physical memory********************************************************************LICENSE_MAX_SESSION = 0LICENSE_SESSIONS_WARNING = 0Initial number of CPU is 4 —>启动时的cpu个数CELL communication is configured to use 0 interface(s):CELL IP affinity details:NUMA status: non-NUMA system—>启动时的NUMA信息cellaffinity.ora status: N/ACELL communication will use 1 IP group(s):Grp 0: Picked latch-free SCN scheme 3Using LOG_ARCHIVE_DEST_1 parameter default value as /u02/app/oracle/product/11.2.0.4/db_1/dbs/archAutotune of undo retention is turned on. IMODE=BRILAT =27LICENSE_MAX_USERS = 0SYS auditing is disabledStarting up:Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing options.ORACLE_HOME = /u02/app/oracle/product/11.2.0.4/db_1System name:LinuxNode name:rhel63singleRelease:2.6.32-279.el6.x86_64 —>linux 的内核版本号Version:#1 SMP Wed Jun 13 18:24:36 EDT 2012Machine:x86_64 VM name:VMWare Version: 6 —>主机是 vm虚拟机，vm虚拟机的版本Using parameter settings in server-side spfile /u02/app/oracle/product/11.2.0.4/db_1/dbs/spfiletest.oraSystem parameters with non-default values:—>上一行是启动时的所读取的spfile文件的位置 processes= 150 sga_max_size= 1G shared_pool_size= 256M java_pool_size= 256M sga_target= 1G control_files= "/u01/app/oracle/oradata/test/control01.ctl" control_files= "/u01/app/oracle/oradata/test/control02.ctl" db_block_size= 8192 compatible= "11.2.0.0.0" undo_tablespace= "UNDOTBS1" remote_login_passwordfile= "EXCLUSIVE" db_domain= "" dispatchers= "(PROTOCOL=TCP) (SERVICE=testXDB)" audit_file_dest= "/u01/app/oracle/admin/test/adump" audit_trail= "DB" db_name= "test" open_cursors= 300 pga_aggregate_target= 96M diagnostic_dest= "/u01/app/oracle"Mon Feb 09 01:51:13 2015PMON started with pid=2, OS id=2397 Mon Feb 09 01:51:13 2015PSP0 started with pid=3, OS id=2399 Mon Feb 09 01:51:15 2015VKTM started with pid=4, OS id=2401 at elevated priorityMon Feb 09 01:51:15 2015GEN0 started with pid=5, OS id=2405 VKTM running at (1)millisec precision with DBRM quantum (100)msMon Feb 09 01:51:15 2015DIAG started with pid=6, OS id=2407 Mon Feb 09 01:51:15 2015DBRM started with pid=7, OS id=2409 Mon Feb 09 01:51:15 2015DIA0 started with pid=8, OS id=2411 Mon Feb 09 01:51:15 2015MMAN started with pid=9, OS id=2413 Mon Feb 09 01:51:15 2015DBW0 started with pid=10, OS id=2415 Mon Feb 09 01:51:15 2015LGWR started with pid=11, OS id=2417 Mon Feb 09 01:51:15 2015CKPT started with pid=12, OS id=2419 Mon Feb 09 01:51:15 2015SMON started with pid=13, OS id=2421 Mon Feb 09 01:51:15 2015RECO started with pid=14, OS id=2423 Mon Feb 09 01:51:15 2015MMON started with pid=15, OS id=2425 starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'…Mon Feb 09 01:51:15 2015MMNL started with pid=16, OS id=2427 starting up 1 shared server(s) …ORACLE_BASE from environment = /u02/app/oracleMon Feb 09 01:51:17 2015ALTER DATABASE MOUNTSuccessful mount of redo thread 1, with mount id 2169318165Database mounted in Exclusive ModeLost write protection disabledCompleted: ALTER DATABASE MOUNTMon Feb 09 01:51:22 2015ALTER DATABASE OPENBeginning crash recovery of 1 threads parallel recovery started with 3 processesStarted redo scanCompleted redo scan read 7 KB redo, 0 data blocks need recoveryStarted redo application at Thread 1: logseq 124, block 3492Recovery of Online Redo Log: Thread 1 Group 1 Seq 124 Reading mem 0 Mem# 0: /u01/app/oracle/oradata/test/redo01.logCompleted redo application of 0.00MBCompleted crash recovery at Thread 1: logseq 124, block 3506, scn 3065931 0 data blocks read, 0 data blocks written, 7 redo k-bytes readThread 1 advanced to log sequence 125 (thread open)Thread 1 opened at log sequence 125 Current log# 2 seq# 125 mem# 0: /u01/app/oracle/oradata/test/redo02.logSuccessful open of redo thread 1MTTR advisory is disabled because FAST_START_MTTR_TARGET is not setSMON: enabling cache recovery[2437] Successfully onlined Undo Tablespace 2.Undo initialization finished serial:0 start:4867074 end:4868274 diff:1200 (12 seconds)Verifying file header compatibility for 11g tablespace encryption..Verifying 11g file header compatibility for tablespace encryption completedSMON: enabling tx recoveryDatabase Characterset is ZHS16GBKNo Resource Manager plan activereplication_dependency_tracking turned off (no async multimaster replication found)Starting background process QMNCMon Feb 09 01:51:29 2015QMNC started with pid=23, OS id=2465 Mon Feb 09 01:51:40 2015Completed: ALTER DATABASE OPENMon Feb 09 01:51:41 2015Starting background process CJQ0Mon Feb 09 01:51:41 2015CJQ0 started with pid=28, OS id=2483 Mon Feb 09 01:53:42 2015Shutting down instance (immediate)Shutting down instance: further logons disabledMon Feb 09 01:53:43 2015Stopping background process CJQ0Stopping background process QMNCStopping background process MMNLStopping background process MMONLicense high water mark = 13All dispatchers and shared servers shutdownALTER DATABASE CLOSE NORMALMon Feb 09 01:53:48 2015SMON: disabling tx recoverySMON: disabling cache recoveryMon Feb 09 01:53:48 2015Shutting down archive processesArchiving is disabledArchive process shutdown avoided: 0 activeThread 1 closed at log sequence 125Successful close of redo thread 1Completed: ALTER DATABASE CLOSE NORMALALTER DATABASE DISMOUNTShutting down archive processesArchiving is disabledCompleted: ALTER DATABASE DISMOUNTARCH: Archival disabled due to shutdown: 1089Shutting down archive processesArchiving is disabledMon Feb 09 01:53:50 2015Stopping background process VKTMARCH: Archival disabled due to shutdown: 1089Shutting down archive processesArchiving is disabledMon Feb 09 01:53:52 2015Instance shutdown completeMon Feb 09 01:54:34 2015Adjusting the default value of parameter parallel_max_serversfrom 160 to 120 due to the value of parameter processes (150)Starting ORACLE instance (normal)************************ Large Pages Information *******************Per process system memlock (soft) limit = 64 KB Total Shared Global Region in Large Pages = 0 KB (0%) Large Pages used by this instance: 0 (0 KB)Large Pages unused system wide = 0 (0 KB)Large Pages configured system wide = 0 (0 KB)Large Page size = 2048 KB RECOMMENDATION: Total System Global Area size is 1026 MB. For optimal performance, prior to the next instance restart: 1. Increase the number of unused large pages by at least 513 (page size 2048 KB, total size 1026 MB) system wide to get 100% of the System Global Area allocated with large pages 2. Large pages are automatically locked into physical memory. Increase the per process memlock (soft) limit to at least 1034 MB to lock 100% System Global Area's large pages into physical memory********************************************************************LICENSE_MAX_SESSION = 0LICENSE_SESSIONS_WARNING = 0Initial number of CPU is 4CELL communication is configured to use 0 interface(s):CELL IP affinity details:NUMA status: non-NUMA systemcellaffinity.ora status: N/ACELL communication will use 1 IP group(s):Grp 0: Picked latch-free SCN scheme 3Using LOG_ARCHIVE_DEST_1 parameter default value as /u02/app/oracle/product/11.2.0.4/db_1/dbs/archAutotune of undo retention is turned on. IMODE=BRILAT =27LICENSE_MAX_USERS = 0SYS auditing is disabledStarting up:Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing options.ORACLE_HOME = /u02/app/oracle/product/11.2.0.4/db_1System name:LinuxNode name:rhel63singleRelease:2.6.32-279.el6.x86_64Version:#1 SMP Wed Jun 13 18:24:36 EDT 2012Machine:x86_64VM name:VMWare Version: 6Using parameter settings in client-side pfile /home/oracle/lei20150212.ora on machine rhel63singleSystem parameters with non-default values:—>上一行是启动时的所读取的pfile文件的位置 processes= 150 sga_max_size= 1G shared_pool_size= 256M java_pool_size= 256M sga_target= 1G control_files= "/u01/app/oracle/oradata/test/control01.ctl" control_files= "/u01/app/oracle/oradata/test/control02.ctl" db_block_size= 8192 compatible= "11.2.0.0.0" undo_tablespace= "UNDOTBS1" remote_login_passwordfile= "EXCLUSIVE" db_domain= "" dispatchers= "(PROTOCOL=TCP) (SERVICE=testXDB)" audit_file_dest= "/u01/app/oracle/admin/test/adump" audit_trail= "DB" db_name= "test" open_cursors= 300 pga_aggregate_target= 96M diagnostic_dest= "/u01/app/oracle"Mon Feb 09 01:54:37 2015PMON started with pid=2, OS id=2519 Mon Feb 09 01:54:37 2015PSP0 started with pid=3, OS id=2521 Mon Feb 09 01:54:38 2015VKTM started with pid=4, OS id=2523 at elevated priorityVKTM running at (1)millisec precision with DBRM quantum (100)msMon Feb 09 01:54:38 2015GEN0 started with pid=5, OS id=2527 Mon Feb 09 01:54:39 2015DIAG started with pid=6, OS id=2529 Mon Feb 09 01:54:39 2015DBRM started with pid=7, OS id=2531 Mon Feb 09 01:54:39 2015DIA0 started with pid=8, OS id=2533 Mon Feb 09 01:54:39 2015MMAN started with pid=9, OS id=2535 Mon Feb 09 01:54:39 2015DBW0 started with pid=10, OS id=2537 Mon Feb 09 01:54:39 2015LGWR started with pid=11, OS id=2539 Mon Feb 09 01:54:39 2015CKPT started with pid=12, OS id=2541 Mon Feb 09 01:54:39 2015SMON started with pid=13, OS id=2543 Mon Feb 09 01:54:39 2015RECO started with pid=14, OS id=2545 Mon Feb 09 01:54:39 2015MMON started with pid=15, OS id=2547 Mon Feb 09 01:54:39 2015MMNL started with pid=16, OS id=2549 starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'…starting up 1 shared server(s) …ORACLE_BASE from environment = /u02/app/oracleMon Feb 09 01:54:39 2015ALTER DATABASE MOUNTSuccessful mount of redo thread 1, with mount id 2169320159Database mounted in Exclusive ModeLost write protection disabledCompleted: ALTER DATABASE MOUNTMon Feb 09 01:54:43 2015ALTER DATABASE OPENThread 1 opened at log sequence 125 Current log# 2 seq# 125 mem# 0: /u01/app/oracle/oradata/test/redo02.logSuccessful open of redo thread 1MTTR advisory is disabled because FAST_START_MTTR_TARGET is not setSMON: enabling cache recovery[2560] Successfully onlined Undo Tablespace 2.Undo initialization finished serial:0 start:5067704 end:5068244 diff:540 (5 seconds)Verifying file header compatibility for 11g tablespace encryption..Verifying 11g file header compatibility for tablespace encryption completedSMON: enabling tx recoveryDatabase Characterset is ZHS16GBK —>数据库字符集No Resource Manager plan activereplication_dependency_tracking turned off (no async multimaster replication found)Starting background process QMNCMon Feb 09 01:54:49 2015QMNC started with pid=20, OS id=2562 Mon Feb 09 01:54:57 2015Completed: ALTER DATABASE OPENMon Feb 09 01:54:58 2015Starting background process CJQ0Mon Feb 09 01:54:58 2015CJQ0 started with pid=22, OS id=2574 Mon Feb 09 01:59:50 2015Starting background process SMCOMon Feb 09 01:59:50 2015SMCO started with pid=21, OS id=2620
，往往为了自己的不能失败，而处心积虑前怕狼后怕虎，
