Oracle12CDG的搭建教程：RAC-RAC/RAC-单机主库上操作1.开启RAC的forceloggingSQL>alterd
atabaseforcelogging;SQL>2.修改RAC初始化参数文件SQL>altersystemsetlog
_archive_config=''DG_CONFIG=(eisoo,eisoos)'';SQL>altersystemset
log_archive_dest_2=''SERVICE=eisoosASYNCVALID_FOR=(ONLINE_LOGFIL
ES,PRIMARY_ROLE)DB_UNIQUE_NAME=eisoos''scope=spfile;SQL>alters
ystemsetlog_archive_dest_state_1=ENABLE;SQL>altersystemsetl
og_archive_dest_state_2=ENABLE;SQL>altersystemsetfal_server=e
isoos;SQL>altersystemsetdb_file_name_convert=''eisoos'',''eisoo''
scope=spfile;SQL>altersystemsetdb_file_name_convert=''/data/o
radata/eisoos'',''+DATA/EISOO/DATAFILE''scope=spfile;//如果备库没有使用asm
SQL>altersystemsetlog_file_name_convert=''eisoos'',''eisoo''scop
e=spfile;SQL>altersystemsetlog_file_name_convert=''/data/orada
ta/eisoos'',''+DATA/EISOO/ONLINELOG''scope=spfile;//如果备库没有使用asmSQL>
altersystemsetstandby_file_management=''AUTO'';SQL>altersyste
msetlog_archive_max_processes=30;3.开启归档模式srvctlstopdatabase-
deisoosrvctlstartdatabase-deisoo-ieisoo-omountSQL>alterd
atabasearchivelog;SQL>alterdatabaseopen;4.创建standbylogfile;SQ
L>selectthread#,group#,bytes/1024/1024fromv$log;THREAD#GROUP
#BYTES/1024/1024-----------------------------------1150125
023502450SQL>alterdatabaseaddstandbylogfilethread1gro
up10size50M;SQL>alterdatabaseaddstandbylogfilethread1g
roup11size50M;SQL>alterdatabaseaddstandbylogfilethread1
group12size50M;SQL>alterdatabaseaddstandbylogfilethread
2group13size50M;SQL>alterdatabaseaddstandbylogfilethre
ad2group14size50M;SQL>alterdatabaseaddstandbylogfileth
read2group15size50M;SQL>selectthread#,group#,bytes/1024/10
24fromv$standby_log;THREAD#GROUP#BYTES/1024/1024------------
-----------------------11050111501125021350214502155
05.创建备库参数文件棋牌评测网http://www.77884.netSQL>showparameterspfile;N
AMETYPEVALUE-------------------------------------------------
----------------------------spfilestring+DATA/EISOO/PARAMETERFI
LE/spfile.281.923255053SQL>createpfile=''/tmp/initeisoos.ora''fr
omspfile=''+DATA/EISOO/PARAMETERFILE/spfile.281.923255053'';[oracl
e@rac1tmp]$scpiniteisoos.ora192.168.180.48:$ORACLE_HOME/dbs备库
上操作：1.修改参数文件使用asm：.audit_file_dest=''/u01/app/oracle/admin/eisoos
/adump''.audit_trail=''db''.compatible=''12.1.0.2.0''.control_files
=''/data/oradata/eisoos/control01.ctl''.db_block_size=8192.db_cre
ate_file_dest=''/data/oradata/eisoos''.db_domain=''''.db_file_name_
convert=''eisoo'',''eisoos''.db_name=''eisoo''.db_unique_name=''eisoos
''.diagnostic_dest=''/u01/app/oracle''.dispatchers=''(PROTOCOL=TCP)
(SERVICE=eisoosXDB)''.fal_server=''EISOOS''.log_archive_config=''D
G_CONFIG=(eisoo,eisoos)''.log_archive_dest_1=''LOCATION=/data/orad
ata/eisoos/archivelog''.log_archive_dest_2=''SERVICE=eisooASYNCV
ALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)DB_UNIQUE_NAME=eisoo''.lo
g_archive_dest_state_1=''ENABLE''.log_archive_dest_state_2=''ENABLE
''.log_archive_format=''%t_%s_%r.arc''.log_archive_max_processes=3
0.log_file_name_convert=''eisoo'',''eisoos''.open_cursors=300.pga_
aggregate_target=453m.processes=300.remote_login_passwordfile=''
exclusive''.sga_target=1361m.standby_file_management=''AUTO''eisoo
s.undo_tablespace=''UNDOTBS1''单机未使用asm：.audit_file_dest=''/u01/app/
oracle/admin/eisoos/adump''.audit_trail=''db''.compatible=''12.1.0.
2.0''.control_files=''/data/oradata/eisoos/control01.ctl''#Restore
Controlfile.db_block_size=8192.db_create_file_dest=''/data/orada
ta/eisoos''.db_domain=''''.db_file_name_convert=''+DATA/EISOO/DATAF
ILE'',''/data/oradata/eisoos'',''+DATA/EISOO/TEMPFILE'',''/data/oradata
/eisoos''.db_name=''eisoo''.db_unique_name=''eisoos''.diagnostic_de
st=''/u01/app/oracle''.dispatchers=''(PROTOCOL=TCP)(SERVICE=eisoos
XDB)''.fal_server=''EISOOS''.log_archive_config=''DG_CONFIG=(eisoo,
eisoos)''.log_archive_dest_1=''LOCATION=/data/oradata/eisoos/archi
velog''.log_archive_dest_2=''SERVICE=eisooASYNCVALID_FOR=(ONLINE
_LOGFILES,PRIMARY_ROLE)DB_UNIQUE_NAME=eisoo''.log_archive_dest_s
tate_1=''ENABLE''.log_archive_dest_state_2=''ENABLE''.log_archive_f
ormat=''%t_%s_%r.arc''.log_archive_max_processes=30.log_file_name
_convert=''+DATA/EISOO/ONLINELOG'',''/data/oradata/eisoos''.open_cur
sors=300.pga_aggregate_target=453m.processes=300.remote_login_
passwordfile=''exclusive''.sga_target=1361m.standby_file_manageme
nt=''AUTO''eisoos.undo_tablespace=''UNDOTBS1''2.启动到nomout状态SQL>star
tupnomountpfile=''/u01/app/oracle/product/12.1.0/db_1/dbs/initei
soos.ora'';ORACLEinstancestarted.TotalSystemGlobalArea144284
0576bytesFixedSize2924448bytesVariableSize486539360bytesDa
tabaseBuffers939524096bytesRedoBuffers13852672bytesSQL>SQL>
ALTERSYSTEMSETSEC_CASE_SENSITIVE_LOGON=false;备注：SEC_CASE_SENSI
TIVE_LOGON参数是决定密码文件是否可以在本地创建，否则只能从主库拷贝到备库。默认值是“true”。易火棋牌http://w
ww.482223.com3.在本地创建密码文件ocrl:/u01/app/oracle/product/12.1.0/db_1/
dbs@oracle1>orapwdfile=orapweisoospassword=oracleentries=10ig
norecase=yforce=y4.配置监听文件，保证primary和standby能够互连备库:LISTENER=(DES
CRIPTION_LIST=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=1
92.168.180.41)(PORT=1521))(ADDRESS=(PROTOCOL=IPC)(KEY=EXT
PROC1521))))SID_LIST_LISTENER=(SID_LIST=(SID_DESC=(GLOBAL_DBNA
ME=eisoos)(ORACLE_HOME=/u01/app/oracle/product/12.1.0/db_1)(S
ID_NAME=eisoos)))或者SID_LIST_LISTENER_EISOOS=(SID_LIST=(SID_DE
SC=(GLOBAL_DBNAME=eisoos)(ORACLE_HOME=/u01/app/oracle/produc
t/12.1.0/db_1)(SID_NAME=eisoos)))主库和备库是tnsname.ora配置如下：eisoo=
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.180.51)(
PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=e
isoo)))eisoos=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=1
92.168.180.41)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(S
ERVICE_NAME=eisoos)))主备分别验证：[oracle@rac1~]$sqlplussys/oracle
@eisooassysdba[oracle@rac1~]$sqlplussys/oracle@eisoosassys
dba[oracle@rac2~]$sqlplussys/oracle@eisooassysdba[oracle@rac
2~]$sqlplussys/oracle@eisoosassysdba5.备份恢复数据eisoos:/home/ora
cle@oracle1>rmantargetsys/oracle@eisooauxiliarysys/oracle@eis
oosRecoveryManager:Release12.1.0.2.0-ProductiononMonSep2
616:50:422016Copyright(c)1982,2014,?Oracle?and/oritsaffili
ates.Allrightsreserved.connectedtotargetdatabase:EISOO(DB
ID=3774196505)connectedtoauxiliarydatabase:EISOO(notmounted
)RMAN>duplicatetargetdatabaseforstandbyfromactivedatabase
;StartingDuplicateDbat2016/09/2616:52:126.开启实时同步SQL>alterd
atabaserecovermanagedstandbydatabaseusingcurrentlogfiledi
sconnectfromsession;验证:1)SQL>selectdest_name,errorfromv$arc
hive_dest;//通过查看archive_log_dest_2列是否有error报错，如果有报错，则需要先根据报错内容解决问
题2)查询主库最大归档序号和备库最大归档序号selectmax(sequence#)fromv$archived_log;然
后在主库切换日志：altersystemswitchlogfile;再次查询备库最大归档序号，一致即归档同步成功。主库：SQ
L>selectmax(sequence#)fromv$archived_log;MAX(SEQUENCE#)------
--------133SQL>altersystemswitchlogfile;Systemaltered.SQL>s
electmax(sequence#)fromv$archived_log;MAX(SEQUENCE#)----------
----134SQL>备库：SQL>selectmax(sequence#)fromv$archived_log;MAX(
SEQUENCE#)--------------134SQL>3)主库验证SQL>selectSEQUENCE#,FIRST_
TIME,NEXT_TIME,APPLIED,ARCHIVEDfromV$ARCHIVED_LOG;备库验证SQL>se
lectSEQUENCE#,FIRST_TIME,NEXT_TIME,APPLIED,ARCHIVEDfromV$A
RCHIVED_LOG;备注：观察主备库日志是否同步，如一致则表示日志CDP同步正常。主备切换1.检查DG是否同步是否正常主库：S
QL>selectswitchover_status,database_rolefromgv$database;SWITC
HOVER_STATUSDATABASE_ROLE------------------------------------TO
STANDBYPRIMARYTOSTANDBYPRIMARY备库:SQL>selectswitchover_statu
s,database_rolefromgv$database;SWITCHOVER_STATUSDATABASE_ROLE-
-----------------------------------NOTALLOWEDPHYSICALSTANDBY2
.准备切换工作:关闭RAC库，并把rac1起到open状态[oracle@rac1~]$srvctlstopdataba
se-deisoo[oracle@rac1~]$sqlplus/assysdbaSQLPlus:Release
12.1.0.2.0ProductiononTueSep2709:12:252016Copyright(c)19
82,2014,Oracle.Allrightsreserved.Connectedtoanidleinstan
ce.SQL>startupORACLEinstancestarted.TotalSystemGlobalArea1
442840576bytesFixedSize2924448bytesVariableSize553648224by
tesDatabaseBuffers872415232bytesRedoBuffers13852672bytesDat
abasemounted.Databaseopened.SQL>3.开始切换主库：SQL>alterdatabaseco
mmittoswitchovertophysicalstandbywithsessionshutdown;重启数据
库到mount状态SQL>startupmountORACLEinstancestarted.TotalSystemGlobalArea1442840576bytesFixedSize2924448bytesVariableSize553648224bytesDatabaseBuffers872415232bytesRedoBuffers13852672bytesDatabasemounted.SQL>查看数据库角色与状态SQL>selectstatusfromv$instance;STATUS------------MOUNTEDSQL>selectdatabase_rolefromv$database;DATABASE_ROLE----------------PHYSICALSTANDBYSQL>此时rac1已变成备库捕鱼游戏http://www.44771.net备库：SQL>alterdatabasecommittoswitchovertoprimarywithsessionshutdown;Databasealtered.SQL>alterdatabaseopen;Databasealtered. |
|
