alter database add standby logfile thread 1 group 12 size 50M;
alter database add standby logfile thread 2 group 13 size 50M;
alter database add standby logfile thread 2 group 14 size 50M;
alter database add standby logfile thread 2 group 15 size 50M;
#我这里每个线程增加了三组 standby redo log
6. 在备库创建相关目录
--FRA 目录
mkdir -p /u01/app/oracle/fast_recovery_area/orcl
--DATAFILE
mkdir -p /u01/app/oracle/oradata/orcl
mkdir -p /u01/app/oracle/admin/orcl/adump
mkdir -p /u01/app/oracle/admin/orcl/data
mkdir -p /u01/app/oracle/admin/orcl/redo
mkdir -p /u01/app/oracle/admin/orcl/tempfile
7. 创建备库口令文件
cd /u01/app/oracle/product/11.2.0.4/db_1/dbs/
scp orapworcl1 192.168.0.10:/u01/app/oracle/product/11.2.0.4/db_1/dbs/orapworcl
8. 在主库修改初始化参数
show parameter db_unique_name; ---数据库唯一名字
select * from v$recovery_file_dest; ---查看归档日志路径
select * from v$logfile; ---查看在线日志路径
select name from v$datafile; ---查看数据文件路径
