oracle 静默建RAC及设置多个event

oracle 11.2.0.4 静默建RAC库

dbca -silent -createDatabase -templateName General_Purpose.dbc \
-gdbName orcl -sid orcl -nodeinfo db1,db2 \
-sysPassword Ora!cle_123 -systemPassword Ora!cle_123 \
-storageType ASM \
-diskGroupName datadg -redoLogFileSize 200 \
-emConfiguration NONE \
-responseFile NO_VALUE \
-recoveryAreaDestination NONE \
-characterSet ZHS16GBK \
-nationalCharacterSet AL16UTF16 \
-totalMemory 8196 ;

几个简单、够用的参数：

alter system set "_gc_defer_time"=3 scope=spfile sid='*';
alter system set "_gc_policy_time"=0 scope=spfile sid='*';
alter system set "_gc_undo_affinity"=FALSE scope=spfile sid='*';
alter system set "_optimizer_adaptive_cursor_sharing"=FALSE scope=spfile sid='*';
alter system set "_optimizer_extended_cursor_sharing"='NONE' scope=spfile sid='*';
alter system set "_optimizer_extended_cursor_sharing_rel"='NONE' scope=spfile sid='*';
alter system set "_optimizer_use_feedback"=FALSE scope=spfile sid='*';
alter system set "_partition_large_extents"=FALSE scope=spfile sid='*';
alter system set "_PX_use_large_pool"=TRUE scope=spfile sid='*';
alter system set "_undo_autotune"=FALSE scope=spfile sid='*';
alter system set "_use_adaptive_log_file_sync"='FALSE' scope=spfile sid='*';
alter system set deferred_segment_creation=FALSE scope=spfile sid='*';
alter system set event='28401 trace name context forever,level 1','10949 trace name context forever,level 1' scope=spfile
alter system set open_cursors=300 scope=spfile sid='*';
alter system set parallel_force_local=TRUE scope=spfile sid='*';
alter system set processes=3000 scope=spfile sid='*';
alter system set result_cache_max_size=0 scope=spfile sid='*';
alter system set sec_case_sensitive_logon=FALSE scope=spfile sid='*';
alter system set undo_retention=10800 scope=spfile sid='*';

设置系统系统数据文件自动扩展
alter database datafile 1,2,3,5 autoextend on;

增加几组redo

alter database add logfile thread 1 group 5 '+datadg' size 200m;

alter database add logfile thread 1 group 6 '+datadg' size 200m;

alter database add logfile thread 2 group 7 '+datadg' size 200m;

alter database add logfile thread 2 group 8 '+datadg' size 200m;

设置归档模式