rac+dg 主库redo文件在asm存储上一套，在本地一套

1.数据库已经安装完
2.主备库的数据库版本一致
3.主库一节点配置
127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6
#Use for oracle11g RAC
#Public ip
192.168.6.40   rac11gn01
192.168.6.41   rac11gn02

#Virtual ip
192.168.6.42   rac11gn01-vip
192.168.6.43   rac11gn02-vip

#Private ip
172.16.6.40    rac11gn01-priv
172.16.6.41    rac11gn02-priv

#Scan ip 
192.168.6.44   rac11gn-ip

4.主库二节点配置
127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6
#Use for oracle11g RAC
#Public ip
192.168.6.40   rac11gn01
192.168.6.41   rac11gn02

#Virtual ip
192.168.6.42   rac11gn01-vip
192.168.6.43   rac11gn02-vip

#Private ip
172.16.6.40    rac11gn01-priv
172.16.6.41    rac11gn02-priv

#Scan ip 
192.168.6.44   rac11gn-ip

5.主库数据库路径
SYS@orcl1> select name from v$datafile;

NAME
--------------------------------------------------
+DATA/orcl/datafile/system.256.1046601667
+DATA/orcl/datafile/sysaux.257.1046601667
+DATA/orcl/datafile/undotbs1.258.1046601667
+DATA/orcl/datafile/users.259.1046601667
+DATA/orcl/datafile/example.264.1046601745
+DATA/orcl/datafile/undotbs2.265.1046601843

6 rows selected.

6.数据库大小大小
SYS@orcl1> select sum(bytes)/1024/1024 M from v$datafile;

	 M
----------
  1718.125

7.查看redo日志组
SYS@orcl1> select l.thread#,l.group#,l.members,bytes/1024/1024,lf.member from v$log l, v$logfile lf where l.group#=lf.group#;

   THREAD#     GROUP#	 MEMBERS BYTES/1024/1024 MEMBER
---------- ---------- ---------- --------------- --------------------------------------------------
	 1	    2	       2	      50 +DATA/orcl/onlinelog/group_2.262.1046601743
	 1	    1	       2	      50 +DATA/orcl/onlinelog/group_1.261.1046601743
	 2	    3	       2	      50 +DATA/orcl/onlinelog/group_3.266.1046601899
	 2	    4	       2	      50 +DATA/orcl/onlinelog/group_4.267.1046601899
	 1	    1	       2	      50 /u01/app/oracle/oradata/orcl/redo01.log
	 1	    2	       2	      50 /u01/app/oracle/oradata/orcl/redo02.log
	 2	    3	       2	      50 /u01/app/oracle/oradata/orcl/redo03.log
	 2	    4	       2	      50 /u01/app/oracle/oradata/orcl/redo04.log

8 rows selected.

9.打开force logging
SYS@orcl1> alter database force logging；

10.添加standby_redo日志
10.1主库一节点操作
alter database add standby logfile thread 1 group 5 ('+DATA','/u01/app/oracle/oradata/orcl/standby_redo05.log') size 50m;
alter database add standby logfile thread 1 group 6 ('+DATA','/u01/app/oracle/oradata/orcl/standby_redo06.log') size 50m;
alter database add standby logfile thread 1 group 7 ('+DATA','/u01/app/oracle/oradata/orcl/standby_redo07.log') size 50m;
10.2主库二节点操作
alter database add standby logfile thread 2 group 8  ('+DATA','/u01/app/oracle/oradata/orcl/standby_redo08.log') size 50m;
alter database add standby logfile thread 2 group 9  ('+DATA','/u01/app/oracle/oradata/orcl/standby_redo09.log') size 50m;
alter database add standby logfile thread 2 group 10 ('+DATA','/u01/app/oracle/oradata/orcl/standby_redo010.log') size 50m;

11.备份spfile文件
10.1主库一节点备份
SYS@orcl1> create pfile='/home/oracle/pfile0724.ora' from spfile;
10.2主库二节点备份
SYS@orcl2> create pfile='/home/oracle/pfile0724.ora' from spfile;

12.主库配置dg参数（可以使用sid='*',但是还需要两个节点执行，避免没有生效）
12.1主库一节点执行
alter system set log_archive_config='';
alter system set log_archive_dest_1='LOCATION=+FRA VALID_FOR=(ALL_LOGFILES,ALL_ROLES)';
alter system set log_archive_dest_2='SERVICE=orcldg lgwr async affirm VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)';
alter system set db_file_name_convert='/u02/oradata/orcl','+DATA/orcl/datafile','/u02/oradata/orcl','+DATA/orcl/tempfile' scope=spfile;
alter system set log_file_name_convert='/u02/oradata/orcl','+DATA/orcl/onlinelog','/u02/oradata/orcl','/u01/app/oracle/oradata/orcl' scope=spfile;
alter system set standby_file_management=AUTO scope=both;
alter system set fal_server='orcldg';
12.2主库二节点执行
alter system set log_archive_config='';
alter system set log_archive_dest_1='LOCATION=+FRA VALID_FOR=(ALL_LOGFILES,ALL_ROLES)';
alter system set log_archive_dest_2='SERVICE=orcldg lgwr async affirm VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)';
alter system set db_file_name_convert='/u02/oradata/orcl','+DATA/orcl/datafile','/u02/oradata/orcl','+DATA/orcl/tempfile' scope=spfile;
alter system set log_file_name_convert='/u02/oradata/orcl','+DATA/orcl/onlinelog','/u02/oradata/orcl','/u01/app/oracle/oradata/orcl' scope=spfile;
alter system set standby_file_management=AUTO scope=both;
alter system set fal_server='orcldg';

13.修改host文件
13.1主库一节点root用户下新增
vim /etc/hosts
192.168.6.45   yuanzj11g oracle
13.2主库二节点root用户下新增
vim /etc/hosts
192.168.6.45   yuanzj11g oracle

14修改tnsnames.ora文件
14.1主库一节点oracle用户新增
vim $ORACLE_HOME/network/admin/listener.ora
orcldg =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = yuanzj11g)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )
14.2主库二节点oracle用户新增
vim $ORACLE_HOME/network/admin/listener.ora
orcldg =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = yuanzj11g)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )
  
15，重启监听和数据库
15.1重启监听，grid用户下执行：
srvctl stop listener
srvctl start listener
srvctl status listener
15.2 重启数据库
srvctl stop database -d orcl 
srvctl start database -d orcl

16拷贝密码文件
16.1主库双节点互相拷贝密码文件
scp orapworcl1 rac11gn02:/u01/app/oracle/product/11.2.0/dbhome_1/dbs
scp rac11gn02:/u01/app/oracle/product/11.2.0/dbhome_1/dbs/orapworcl2 .
16.2拷贝密码文件到备库
scp orapworcl1 oracle@192.168.6.45:/u01/app/oracle/product/11.2.0/dbhome_1/dbs

17.主库生成rman备份
run{
allocate channel c1 type disk;
allocate channel c2 type disk;
backup database tag='db_full_bak' format='/home/oracle/rmanbak/db_%d_%T_%s_%p.bkp';
sql 'alter system archive log current';
backup archivelog all delete input tag='arch_bak' format='/home/oracle/rmanbak/log_%d_%T_%s_%p.bkp';
backup current controlfile tag='ctl_bak' format='/home/oracle/rmanbak/ctl_%d_%T_%s_%p.bkp';
release channel c1;
release channel c2;
}

18.拷贝rman备份集到备库
scp * oracle@192.168.6.45:/home/oracle/rmanbak/

19.备库修改hosts文件
127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.6.45 yuanzj11g oracle
192.168.6.44   rac11gn-ip oracle

20.修改tnsnames.ora文件
orcl =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = rac11gn-ip)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

orcldg =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = yuanzj11g)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

21.启动监听
lsnrctl start
lsnrctl status

22.新建pfile文件
vim initorcl.ora
*.audit_file_dest='/u01/app/oracle/admin/orcl/adump'
*.audit_trail='db'
*.compatible='11.2.0.4.0'
*.control_files='/u02/oradata/orcl/control01.ctl,','/u01/app/oracle/fast_recovery_area/orcl/control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='orcl'
*.db_unique_name='orcl'
*.db_recovery_file_dest='/u01/app/oracle/fast_recovery_area'
*.db_recovery_file_dest_size=10737418240
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'
*.fal_server='orcl'
*.log_archive_config=''
*.log_archive_dest_1='LOCATION=/u02/oradata/orcl_archive_log VALID_FOR=(ALL_LOGFILES,ALL_ROLES)'
*.log_archive_dest_2='SERVICE=orcl lgwr async affirm VALID_FOR=(ALL_LOGFILES,PRIMARY_ROLE)'
*.log_archive_dest_state_1='ENABLE'
*.log_archive_dest_state_2='ENABLE'
*.log_file_name_convert='+DATA/orcl/onlinelog','/u02/oradata/orcl','/u01/app/oracle/oradata/orcl','/u02/oradata/orcl'
*.db_file_name_convert='+DATA/orcl/datafile','/u02/oradata/orcl','+DATA/orcl/tempfile','/u02/oradata/orcl' 
*.log_archive_format='%t_%s_%r.dbf'
*.open_cursors=300
*.pga_aggregate_target=536870912
*.processes=150
*.remote_login_passwordfile='exclusive'
*.standby_file_management='AUTO'
*.sga_target=2147483648
*.service_names='orcl'

23.新建spfile文件
create spfile from pfile='/u01/app/oracle/product/11.2.0/dbhome_1/dbs/initorcl.ora';

24修改密码文件
mv orapworcl1 orapworcl

25.启动数据库到nomount状态
startup nomount;

26.设置dbid
rman target /
set dbid=xxxxxxxxxxxxxxx;

27.恢复控制文件
restore standby controlfile from '/home/oracle/rmanbak/ctl_xxxxxx'

28.恢复数据库
alter database mount

run{
allocate channel c1 type disk;
allocate channel c2 type disk;
restore database;
recover database;
release channel c1;
release channel c2;
}

recover database until scn XXXXX;

29.备库添加standby_redo

alter database add standby logfile thread 1 group 5 ('/u02/oradata/orcl/group_5.269.1046606587','/u02/oradata/orcl/standby_redo05.log') size 50m;
alter database add standby logfile thread 1 group 6 ('/u02/oradata/orcl/group_6.270.1046606599','/u02/oradata/orcl/standby_redo06.log') size 50m;
alter database add standby logfile thread 1 group 7 ('/u02/oradata/orcl/group_7.271.1046606609','/u02/oradata/orcl/standby_redo07.log') size 50m;
alter database add standby logfile thread 2 group 8  ('/u02/oradata/orcl/group_8.272.1046607265','/u02/oradata/orcl/standby_redo08.log') size 50m;
alter database add standby logfile thread 2 group 9  ('/u02/oradata/orcl/group_9.273.1046607277','/u02/oradata/orcl/standby_redo09.log') size 50m;
alter database add standby logfile thread 2 group 10 ('/u02/oradata/orcl/group_10.274.1046607287','/u02/oradata/orcl/standby_redo010.log') size 50m;

30.打开数据库

alter database recover managed standby database disconnect from session;
alter database recover managed standby database cancel;
alter database open;
alter database recover managed standby database disconnect from session;

31.检测数据库状态
1.查看主库状态
SYS@orcl1> archive log list;
Database log mode	       Archive Mode
Automatic archival	       Enabled
Archive destination	       +FRA
Oldest online log sequence     27
Next log sequence to archive   28
Current log sequence	       28
2.查看备库应用日志
[oracle@yuanzj11g dbs]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Fri Jul 24 14:07:58 2020

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SYS@orcl> select process, status, sequence# from v$managed_standby;

PROCESS   STATUS	SEQUENCE#
--------- ------------ ----------
ARCH	  CLOSING	       26
ARCH	  CLOSING	       17
ARCH	  CONNECTED		0
ARCH	  CLOSING	       27
MRP0	  APPLYING_LOG	       18
RFS	  IDLE			0
RFS	  IDLE			0
RFS	  IDLE			0
RFS	  IDLE			0
RFS	  IDLE			0
RFS	  IDLE		       28
RFS	  IDLE		       18

12 rows selected.