Chinaunix首页 | 论坛 | 博客
  • 博客访问: 1586451
  • 博文数量: 148
  • 博客积分: 7697
  • 博客等级: 少将
  • 技术积分: 3071
  • 用 户 组: 普通用户
  • 注册时间: 2006-03-10 23:04
个人简介

MiBDP,数据开发、项目团队、数据应用和产品在路上,金融保险、互联网网游、电商、新零售行业、大数据和AI在路上。对数仓、模型、ETL、数据产品应用了解。DTCC 2013演讲嘉宾,曾做过两款大获好评的数据产品平台。知识星球ID:35863277

文章分类
文章存档

2020年(1)

2019年(2)

2017年(2)

2016年(5)

2015年(1)

2014年(1)

2013年(6)

2012年(5)

2011年(24)

2010年(28)

2009年(1)

2008年(6)

2007年(30)

2006年(36)

分类: Oracle

2006-12-11 17:01:22

27.Data Guard
Note: To protect against unlogged direct writes in the primary
database that cannot be propagated to the standby database, turn
on FORCE LOGGING at the primary database before taking datafile
backups for standby creation. Keep the database (or at least
important tablespaces) in FORCE LOGGING mode as long as the
standby database is active.
(在为备份库做数据备份前,主库需设置强迫提交属性(如何设置?))
As application transactions make changes to the primary database, the changes are
logged locally in redo logs, which are sent to the standby databases by log transport
services and applied by log apply services.
For physical standby databases, the changes are applied to each physical standby
database that is running in managed recovery mode. For logical standby databases,
the changes are applied using SQL regenerated from the archived redo logs.
(主库中应用事务的改变被记录到重做日志,通过日志传送服务及应用服务发送到备库)
(作为物理的备库必须运行在备份模式下,作为逻辑的备库应用的改变由归档日志通过SQL语句来应用)即:
SQL>startup nomount pfile=’ D:\oracle\admin\pennon\pfile\init.ora’
SQL>alter database mount standby database;
SQL>alter database recover managed standby database disconnect from session;
SQL>alter database recover managed standby database cancel;
SQL>alter database open read only;
阅读(934) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~