设为首页 加入收藏

TOP

最简单的11g Active DataGuard(ADG)搭建配置过程(项目步骤)(四)
2015-07-25 12:07:01 来源: 作者: 【 】 浏览:139
Tags:简单 11g Active DataGuard ADG 搭建 配置 过程 项目 步骤
le 1 to /DBSoft/oracle/oradata/woo/temp01.dbf in control file


?executing command: SET NEWNAME


?executing command: SET NEWNAME


?executing command: SET NEWNAME


?executing command: SET NEWNAME


?Starting backup at 17-JUN-15
?using channel ORA_DISK_1
?channel ORA_DISK_1: starting datafile copy
?input datafile file number=00001 name=/DBSoft/oracle/oradata/woo/system01.dbf
?output file name=/DBSoft/oracle/oradata/woo/system01.dbf tag=TAG20150617T223532
?channel ORA_DISK_1: datafile copy complete, elapsed time: 00:05:58
?channel ORA_DISK_1: starting datafile copy
?input datafile file number=00002 name=/DBSoft/oracle/oradata/woo/sysaux01.dbf
?output file name=/DBSoft/oracle/oradata/woo/sysaux01.dbf tag=TAG20150617T223532
?channel ORA_DISK_1: datafile copy complete, elapsed time: 00:05:30
?channel ORA_DISK_1: starting datafile copy
?input datafile file number=00003 name=/DBSoft/oracle/oradata/woo/undotbs01.dbf
?output file name=/DBSoft/oracle/oradata/woo/undotbs01.dbf tag=TAG20150617T223532
?channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25
?channel ORA_DISK_1: starting datafile copy
?input datafile file number=00004 name=/DBSoft/oracle/oradata/woo/users01.dbf
?output file name=/DBSoft/oracle/oradata/woo/users01.dbf tag=TAG20150617T223532
?channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
?Finished backup at 17-JUN-15


?sql statement: alter system archive log current


?contents of Memory Script:
?{
? ? switch clone datafile all;
?}
?executing Memory Script


?datafile 1 switched to datafile copy
?input datafile copy RECID=1 STAMP=882658052 file name=/DBSoft/oracle/oradata/woo/system01.dbf
?datafile 2 switched to datafile copy
?input datafile copy RECID=2 STAMP=882658052 file name=/DBSoft/oracle/oradata/woo/sysaux01.dbf
?datafile 3 switched to datafile copy
?input datafile copy RECID=3 STAMP=882658052 file name=/DBSoft/oracle/oradata/woo/undotbs01.dbf
?datafile 4 switched to datafile copy
?input datafile copy RECID=4 STAMP=882658052 file name=/DBSoft/oracle/oradata/woo/users01.dbf
?Finished Duplicate Db at 17-JUN-15


#至此已经恢复完成


6、在primary 和standby端添加standby日志


SQL> alter database add standby logfile
?
group 4 ('/DBSoft/oracle/oradata/woo/styredo04.log') size 50m,


group 5 ('/DBSoft/oracle/oradata/woo/styredo05.log') size 50m,


group 6 ('/DBSoft/oracle/oradata/woo/styredo06.log') size 50m,


group 7 ('/DBSoft/oracle/oradata/woo/styredo07.log') size 50m;


SQL> SELECT GROUP#,THREAD#,SEQUENCE#,ARCHIVED,STATUS FROM V$STANDBY_LOG;


? ? GROUP# THREAD# SEQUENCE# ARC STATUS


---------- ---------- ---------- --- ----------


? ? ? ? 4 0 0 YES UNASSIGNED


? ? ? ? 5 0 0 YES UNASSIGNED


? ? ? ? 6 0 0 YES UNASSIGNED


? ? ? ? 7 0 0 YES UNASSIGNED


7、在standby端开启实时日志应用


SQL> recover managed standby database using current logfile disconnect from session;
?
Media recovery complete.


SQL>


首页 上一页 1 2 3 4 下一页 尾页 4/4/4
】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
分享到: 
上一篇Oracle 11g统计信息收集--多列统.. 下一篇Linux的Docker上如何安装MySQL

评论

帐  号: 密码: (新用户注册)
验 证 码:
表  情:
内  容: