修改主机/etc/hosts

修改主机/etc/sysconfig/network

若删除组：
alter database drop standby logfile group x;

查看standy日志组的信息：
SQL> select group#,sequence#,status, bytes/1024/1024 from v$standby_log;

在主服务上创建备份日志

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;

-------------主库创建standby文件

alter database create standby controlfile as '/home/oracle/standby.ctl';

-------------导出当前数据库参数文件并修改

执行下面代码：

create pfile='/opt/oracle/app/interlib/initora.ora' from spfile;