修改主機(jī)/etc/hosts
修改主機(jī)/etc/sysconfig/network
若刪除組：
alter database drop standby logfile group x;
查看standy日志組的信息：
SQL> select group#,sequence#,status, bytes/1024/1024 from v$standby_log;
在主服務(wù)上創(chuàng)建備份日志
alter database add standby logfile group 4 ('/opt/oracle/app/oradata/orcl/standby_01.log') size 50M;
alter database add standby logfile group 5 ('/opt/oracle/app/oradata/orcl/standby_02.log') size 50M;
alter database add standby logfile group 6 ('/opt/oracle/app/oradata/orcl/standby_03.log') size 50M;
alter database add standby logfile group 7 ('/opt/oracle/app/oradata/orcl/standby_04.log') size 50M;
-------------主庫(kù)創(chuàng)建standby文件
alter database create standby controlfile as '/home/oracle/standby.ctl';
-------------導(dǎo)出當(dāng)前數(shù)據(jù)庫(kù)參數(shù)文件并修改
執(zhí)行下面代碼：
create pfile='/opt/oracle/app/interlib/initora.ora' from spfile;
