Oracle12CDG的搭建教程
Oracle12CDGOracle12CDG 的搭建教程:的搭建教程:RAC-RAC/RAC-RAC-RAC/RAC-单机单机主库上操作1.开启 RAC 的 force loggingSQL> alter database force logging;SQL>2.修改 RAC 初始化参数文件SQL> alter system set log_archive_config='DG_CONFIG=(eisoo,eisoos)'SQL> alter system set log_archive_dest_2='SERVICE=eisoos ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=eisoos' scope=spfile;SQL> alter system set log_archive_dest_state_1=ENABLE;SQL> alter system set log_archive_dest_state_2=ENABLE;SQL> alter system set fal_server=eisoos;SQL> alter system set db_file_name_convert='eisoos','eisoo' scope=spfile;SQL> alter system set db_file_name_convert='/data/oradata/eisoos','+DATA/EISOO/DATAFILE' scope=spfile; /如果备库没有使用 asmSQL> alter system set log_file_name_convert='eisoos','eisoo' scope=spfile;SQL> alter system set log_file_name_convert='/data/oradata/eisoos','+DATA/EISOO/ONLINELOG' scope=spfile;/如果备库没有使用 asmSQL> alter system set standby_file_management='AUTO'SQL> alter system set log_archive_max_processes=30;3.开启归档模式srvctl stop database -d eisoosrvctl start database -d eisoo-i eisoo -o mountSQL>alter database archivelog;SQL>alter database open;4.创建 standby logfile;SQL> select thread#,group#,bytes/1024/1024 from v$log;THREAD# GROUP# BYTES/1024/1024- - -1 1 501 2 502 3 502 4 50SQL> alter database add standby logfile thread 1 group 10 size 50M;SQL> alter database add standby logfile thread 1 group 11 size 50M;SQL> alter database add standby logfile thread 1 group 12 size 50M;SQL> alter database add standby logfile thread 2 group 13 size 50M;SQL> alter database add standby logfile thread 2 group 14 size 50M;SQL> alter database add standby logfile thread 2 group 15 size 50M;SQL> select thread#,group#,bytes/1024/1024 from v$standby_log;THREAD# GROUP# BYTES/1024/1024- - -1 10 501 11 501 12 502 13 502 14 502 15 505.创建备库参数文件 棋牌评测网 http:/www.77884.netSQL> show parameter spfile;NAME TYPE VALUE- - -spfile string +DATA/EISOO/PARAMETERFILE/spfile.281.923255053SQL> create pfile='/tmp/initeisoos.ora' from spfile='+DATA/EISOO/PARAMETERFILE/spfile.281.923255053'oraclerac1 tmp$ scp initeisoos.ora 192.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_create_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='DG_CONFIG=(eisoo,eisoos)'*.log_archive_dest_1='LOCATION=/data/oradata/eisoos/archivelog'*.log_archive_dest_2='SERVICE=eisoo ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=eisoo'*.log_archive_dest_state_1='ENABLE'*.log_archive_dest_state_2='ENABLE'*.log_archive_format='%t_%s_%r.arc'*.log_archive_max_processes=30*.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'eisoos.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/oradata/eisoos'*.db_domain=''*.db_file_name_convert='+DATA/EISOO/DATAFILE','/data/oradata/eisoos','+DATA/EISOO/TEMPFILE','/data/oradata/eisoos'*.db_name='eisoo'*.db_unique_name='eisoos'*.diagnostic_dest='/u01/app/oracle'*.dispatchers='(PROTOCOL=TCP) (SERVICE=eisoosXDB)'*.fal_server='EISOOS'*.log_archive_config='DG_CONFIG=(eisoo,eisoos)'*.log_archive_dest_1='LOCATION=/data/oradata/eisoos/archivelog'*.log_archive_dest_2='SERVICE=eisoo ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=eisoo'*.log_archive_dest_state_1='ENABLE'*.log_archive_dest_state_2='ENABLE'*.log_archive_format='%t_%s_%r.arc'*.log_archive_max_processes=30*.log_file_name_convert='+DATA/EISOO/ONLINELOG','/data/oradata/eisoos'*.open_cursors=300*.pga_aggregate_target=453m*.processes=300*.remote_login_passwordfile='exclusive'*.sga_target=1361m*.standby_file_management='AUTO'eisoos.undo_tablespace='UNDOTBS1'2.启动到 nomout 状态SQL> startup nomount pfile='/u01/app/oracle/product/12.1.0/db_1/dbs/initeisoos.ora'ORACLE instance started.Total System Global Area 1442840576 bytesFixed Size 2924448 bytesVariable Size 486539360 bytesDatabase Buffers 939524096 bytesRedo Buffers 13852672 bytesSQL>SQL>ALTER SYSTEM SET SEC_CASE_SENSITIVE_LOGON=false;备注:SEC_CASE_SENSITIVE_LOGON 参数是决定密码文件是否可以在本地创建,否则只能从主库拷贝到备库。默认值是“true”。易火棋牌 http:/www.482223.com3.在本地创建密码文件ocrl:/u01/app/oracle/product/12.1.0/db_1/dbsoracle1>orapwd file=orapweisoos password=oracle entries=10 ignorecase=y force=y4.配置监听文件,保证 primary 和 standby 能够互连备库:LISTENER =(DESCRIPT