oracle数据库以只读模式打开,Oracle Data Guard_ 备库以只读或读写方式打开访问

8.2Opening a Standby Database for Read-Only or Read/Write Access8.2以只读或者可读写方式打开备库来访问When a standby database is open for read-only access, users can query the standby database but cannot update it. Thu...
摘要由CSDN通过智能技术生成

8.2Opening a Standby Database for Read-Only or Read/Write Access

8.2以只读或者可读写方式打开备库来访问

When a standby database is open for read-only access, users can query the standby database but cannot update it. Thus, you can reduce the load on the primary database by using the standby database for reporting purposes. You can periodically open the standby database for read-only access and perform ad hoc queries to verify Redo Apply is updating the standby database correctly. (Note that for distributed queries, you must first issue theALTER DATABASE SET TRANSACTION READ ONLYstatement before you can issue a query on the read-only database.)

当备库是以只读方式打开时,用户只能在备库上查询而不能更新它。那么你可以为主库减轻负载而在备库上出报表,你可以定期的以只读方式打开备库,查询验证重做应用是否正确的更新到备库。针对分布式查询,你必须在只读数据库查询之前发出ALTER DATABASE SET TRANSACTION READ ONLY语句。

Figure 8-1shows a standby database open for read-only access.

A physical standby database can be opened temporarily in read/write mode for development, reporting, or testing purposes, and then flashed back to a point in the past to be reverted back to a physical standby database. When the database is flashed back, Data Guard automatically synchronizes the standby database with the primary database, without the need to re-create the physical standby database from a backup copy of the primary database.

物理备库可以暂时打开以读/写模式用来开发,报告或测试的目的,然后闪回到过去一个点来恢复到一个物理备用数据库。当数据库闪回以后,Data Guard自动同步主库与备库之间的数据,而不需要从主数据库的备份副本重新创建物理备用数据库。

See Also:

Section 12.6for a scenario that describes activating a physical standby database as a read/write reporting database, and then resynch

  • 0
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值