修改主机/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;
网友评论