主库上操作
1.开启RAC的 force logging
SQL> 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; //如果备库没有使用asm
SQL> 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;//如果备库没有使用asm
SQL> alter system set standby_file_management='AUTO';
SQL> alter system set log_archive_max_processes=30;
3.开启归档模式
srvctl stop database -d eisoo
srvctl start database -d eisoo-i eisoo -o mount
SQL>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 50
1 2 50
2 3 50
2 4 50
SQL> 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 50
1 11 50
1 12 50
2 13 50
2 14 50
2 15 50
5.创建备库参数文件
SQL> show parameter spfile;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string +DATA/EISOO/PARAMETERFILE/spfile.281.923255053
SQL> create pfile='/tmp/initeisoos.ora' from spfile='+DATA/EISOO/PARAMETERFILE/spfile.281.923255053';
[oracle@rac1 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'
