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

loading 分享 2026-8-25 下载文档

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


ORACLE LINUX 11G RAC 单实例DATAGUARD - 图文.doc 将本文的Word文档下载到电脑
搜索更多关于: ORACLE LINUX 11G RAC 单实例DATAGU 的文档
相关推荐
相关阅读