利用flashback将DG中failover之后的主库变为备库,不必重新搭建DG

本文介绍了如何在Oracle Data Guard环境中,利用Flashback Database技术将故障切换后的新主库恢复为物理备库。通过查询新主库的SCN,然后在旧主库上执行特定SQL命令,包括闪回数据库到特定SCN,转换为物理备库等步骤,可以快速地将旧主库恢复到故障前的状态,重新成为备库。
摘要由CSDN通过智能技术生成

oracle官方文档

Data Guard Concepts and Administration

3 Creating a Physical Standby Database

3.3 Post-Creation Steps

3.3 Post-Creation Steps

At this point, the physical standby database is running and can provide the maximum performance level of data protection. The following list describes additional actions you can take on the physical standby database:

  • Upgrade the data protection mode

    The Data Guard configuration is initially set up in the maximum performance mode (the default).

  • Enable Flashback Database

    Flashback Database removes the need to re-create the primary database after a failover. Flashback Database enables you to return a database to its state at a time in the recent past much faster than traditional point-in-time recovery, because it does not require restoring datafiles from backup nor the extensive application of redo data. You can enable Flashback Database on the primary database, the standby database, or both. See

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值