ORACLE LINUX 11G RAC 单实例DATAGUARD - 图文

五、 源库建立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：