五、 源库建立standby redolog：
查看每个实例的最大日志：
select inst_id,count(1),max(bytes) from gv$log group by inst_id;
每个实例有四组log，最大50M，每个实例需要建立count+1个strandby日志，大小为最大日志大小，也就是10组50M大小的standby日志：
ASMCMD> pwd +data/oem
ASMCMD> mkdir STANDBYLOG
alter system set standby_file_management=manual scope=both sid='*';
alter database add standby logfile thread 1 group 9
'+data/oem/standbylog/standby_group_01.log' size 52428800; alter database add standby logfile thread 1 group 10 '+data/oem/standbylog/standby_group_02.log' size 52428800; alter database add standby logfile thread 1 group 11 '+data/oem/standbylog/standby_group_03.log' size 52428800; alter database add standby logfile thread 1 group 12
'+data/oem/standbylog/standby_group_04.log' size 52428800; alter database add standby logfile thread 1 group 13 '+data/oem/standbylog/standby_group_05.log' size 52428800;
alter database add standby logfile thread 2 group 14 '+data/oem/standbylog/standby_group_06.log' size 52428800; alter database add standby logfile thread 2 group 15 '+data/oem/standbylog/standby_group_07.log' size 52428800; alter database add standby logfile thread 2 group 16 '+data/oem/standbylog/standby_group_08.log' size 52428800; alter database add standby logfile thread 2 group 17 '+data/oem/standbylog/standby_group_09.log' size 52428800; alter database add standby logfile thread 2 group 18 '+data/oem/standbylog/standby_group_10.log' size 52428800;
alter system set standby_file_management=auto scope=both sid='*';
select count(*) from v$standby_log;
六、 源库rman备份整个库：
rman target /
run {
sql \; allocate channel ch1 type disk format '/dbfs_backup/Primary_for_DG_%U'; backup database;
backup current controlfile for standby; sql \; }
七、
拷贝源库rman备份文件到DG库的相同的目录下：
八、
源库：建立standby的pfile，从primay的spfile：
相关推荐：
loading