数据dataguard

dataguard备库的数据文件的迁移

这里就不局限于数据文件了，不过目前的测试情况来说，还是数据文件是重点，还是主要以数据文件为例。在备库中目前尝试了两种方式，可以采用rename datafile的方式或者使用rman的方式，对于日志文件还是直接重建会比较方便。采用rename data...

dataguard添加临时数据文件的bug

开发的同学需要做一个大查询，数据只能全表，而且还有order by，势必会消耗大量的temp空间，这个时候充分利用备库就是好一些，有一个备库平时也没有用过，今天就用这个备库来完成查询需求。但是过了一会，开发同事说，查询失败了。让我看看...

oracle Dataguard数据库不同步处理备忘

一个让人紧张的消息：dataguard数据库主从不同步，赶紧爬起来干活。第一步，检查告警日志log.xml。睁大眼睛仔细找，没看到什么异常的输出；再用grep一类的工具过滤一下，也没有所获。看来情况还是不错啊，如果这里出现error一类的，问题就...

dataguard备库的数据文件的迁移实战

在前几天也花了一点时间测试了一下关于备库数据文件的迁移，这部分的工作看起来还是比较常规的，当然方法也很多。但是在实际工作中就更不能掉以轻心，所有的操作都要有理有据。都要经过一些严格的测试，如果测试不当，很可能在后期就会出现...

cdb 数据库搭建dataguard

数据库版本：12.2.0.1.0 实验环境：192.168.0.196 prod04 主数据库（sid cdb)192.168.0.197 prod05 备数据库（sid cdb)主备数据库数据文件目录相同。（/u01/app/oracle/oradata/cdb/）1,主数据库环境准备 1，开启归档2，启动监听3，配置...

【DATAGUARD 学习】如何停止standby数据库

主库：ORCL 备库：TESTDG 一般的，停止standby数据库之前，要先停用primary库，如果直接停用standby库，可能导致primary库也直接shutdown(最大保护模式)。对于测试环境可以进行如下步骤：一主库暂时取消向备库传输日志ORCL>alter system ...

Oracle9i数据库DataGuard实施及维护手册2

如果要使用LGWR进程传递redo数据，那么需要添加standby redolog，如果使用ARCH进程传递redo数据，那么这步可以省略 alter database add standby logfile group 4('/global/oradata/ctsdb/stdby_redo04.log')size 1024K;alter database add ...

dataguard中需要注意的一些数据文件操作

Recovered data files to a consistent state at change 2016680 Completed:ALTER DATABASE RECOVER MANAGED STANDBY DATABASE THROUGH ALL SWITCHOVER DISCONNECT USING CURRENT LOGFILE MRP0:Background Media Recovery process shutdown...

ORACLE逻辑DATAGUARD数据库如何恢复SKIP的表ORA-02019\ORA-16276\

错误现象-*ERROR at line 1:ORA-16276:specified database link does not correspond to primary database ORA-06512:at"SYS.DBMS_INTERNAL_LOGSTDBY",line 5394 ORA-02019:connection description for remote database not found ORA-...

搭建Dataguard，使用RMAN还原数据时无法连接ASM实例

Starting restore at 2018/02/26 14:18:35 using target database control file instead of recovery catalog allocated channel:ORA_DISK_1 channel ORA_DISK_1:SID=21 device type=DISK channel ORA_DISK_1:restoring control file RMAN-...

1 2 >

您可能感兴趣

.mvc数据 .数据连接池 .数据二叉树 .数据线程 .用户指南数据 .修炼之道数据 .java数据 .连接不上数据

{"moduleinfo":{"card_count":[{"count_phone":1,"count":1}],"search_count":[{"count_phone":5,"count":5}]},"card":[{"des":"数据集成（Data Integration）是阿里集团对外提供的可跨异构数据存储系统的、可靠、安全、低成本、可弹性扩展的数据同步平台，为400+对数据源提供不同网络环境下的全量/增量数据进出通道。","link1":"https://www.aliyun.com/product/cdp","link":"https://www.aliyun.com/product/cdp","icon":"https://img.alicdn.com/tfs/TB1fP99DeL2gK0jSZFmXXc7iXXa-201-200.png","btn2":"产品文档","tip":"大数据workshop，手把手教你如何通过数据集成同步数据并完成用户画像  <a href=\"https://www.aliyun.com/product/cdp\"  target=\"_blank\">立即查看</a>          最新产品和实时动态重磅发布 ，<a href=\"https://www.aliyun.com/product/new?source_type=out_sousuo_feature_0716\" target=\"_blank\">立即查看</a>","btn1":"立即开通","link2":"https://help.aliyun.com/document_detail/137663.html","title":"数据集成"}],"search":[{"txt":"数据集成","link":"https://www.aliyun.com/product/cdp"},{"txt":"Data Integration","link":"https://www.aliyun.com/product/cdp"},{"txt":"数据同步","link":"https://www.aliyun.com/product/cdp"},{"txt":"数据上云","link":"https://www.aliyun.com/product/cdp"},{"txt":"产品动态","link":"https://www.aliyun.com/product/new?source_type=out_sousuo_feature_0716"}],"countinfo":{"search":{"length_pc":0,"length":0},"card":{"length_pc":0,"length":0}},"newCard":[{"ifIcon":"icon","icon":"dide","link":"https://img.alicdn.com/tfs/TB1XY8hGYr1gK0jSZFDXXb9yVXa-1740-328.png","btn1":"立即开通","link1":"https://www.aliyun.com/product/cdp","title":"数据集成","des":"数据集成（Data Integration）是阿里集团对外提供的可跨异构数据存储系统的、可靠、安全、低成本、可弹性扩展的数据同步平台，为400+对数据源提供不同网络环境下的全量/增量数据进出通道。","btn3":"产品文档","link3":"https://help.aliyun.com/document_detail/137663.html","link2":"https://help.aliyun.com/document_detail/118545.html","btn2":"产品价格","iconImg":"","contentLink":"https://www.aliyun.com/product/cdp","infoGroup":[{"infoName":"产品入门","infoContent":{"firstContentName":"快速入门指导","firstContentLink":"https://help.aliyun.com/document_detail/137663.html?spm=a2c4g.11186623.6.685.7a29f8eaBVmURh","lastContentName":"常见问题","lastContentLink":"https://help.aliyun.com/document_detail/154074.html?spm=a2c4g.11186623.6.1157.7c786461qtbcgp"}},{"infoName":"产品动态","infoContent":{"firstContentName":"产品最新动态","firstContentLink":"https://www.aliyun.com/product/new?spm=5176.7946122.1265010.211view.2fbf313cKkub8k&category=218&product=66","lastContentName":"实时数据同步上线","lastContentLink":"https://help.aliyun.com/document_detail/181912.html"}},{"infoName":"最佳实践","infoContent":{"firstContentName":"整库迁移","firstContentLink":"https://help.aliyun.com/document_detail/137809.html","lastContentName":"批量上云","lastContentLink":"https://help.aliyun.com/document_detail/146671.html"}}]}],"simplifiedDisplay":"newEdition"}

{"$env":{"JSON":{}},"$page":{"env":"production"},"$context":{"moduleinfo":{"card_count":[{"count_phone":1,"count":1}],"search_count":[{"count_phone":5,"count":5}]},"card":[{"des":"数据集成（Data Integration）是阿里集团对外提供的可跨异构数据存储系统的、可靠、安全、低成本、可弹性扩展的数据同步平台，为400+对数据源提供不同网络环境下的全量/增量数据进出通道。","link1":"https://www.aliyun.com/product/cdp","link":"https://www.aliyun.com/product/cdp","icon":"https://img.alicdn.com/tfs/TB1fP99DeL2gK0jSZFmXXc7iXXa-201-200.png","btn2":"产品文档","tip":"大数据workshop，手把手教你如何通过数据集成同步数据并完成用户画像  <a href=\"https://www.aliyun.com/product/cdp\"  target=\"_blank\">立即查看</a>          最新产品和实时动态重磅发布 ，<a href=\"https://www.aliyun.com/product/new?source_type=out_sousuo_feature_0716\" target=\"_blank\">立即查看</a>","btn1":"立即开通","link2":"https://help.aliyun.com/document_detail/137663.html","title":"数据集成"}],"search":[{"txt":"数据集成","link":"https://www.aliyun.com/product/cdp"},{"txt":"Data Integration","link":"https://www.aliyun.com/product/cdp"},{"txt":"数据同步","link":"https://www.aliyun.com/product/cdp"},{"txt":"数据上云","link":"https://www.aliyun.com/product/cdp"},{"txt":"产品动态","link":"https://www.aliyun.com/product/new?source_type=out_sousuo_feature_0716"}],"countinfo":{"search":{"length_pc":0,"length":0},"card":{"length_pc":0,"length":0}},"newCard":[{"ifIcon":"icon","icon":"dide","link":"https://img.alicdn.com/tfs/TB1XY8hGYr1gK0jSZFDXXb9yVXa-1740-328.png","btn1":"立即开通","link1":"https://www.aliyun.com/product/cdp","title":"数据集成","des":"数据集成（Data Integration）是阿里集团对外提供的可跨异构数据存储系统的、可靠、安全、低成本、可弹性扩展的数据同步平台，为400+对数据源提供不同网络环境下的全量/增量数据进出通道。","btn3":"产品文档","link3":"https://help.aliyun.com/document_detail/137663.html","link2":"https://help.aliyun.com/document_detail/118545.html","btn2":"产品价格","iconImg":"","contentLink":"https://www.aliyun.com/product/cdp","infoGroup":[{"infoName":"产品入门","infoContent":{"firstContentName":"快速入门指导","firstContentLink":"https://help.aliyun.com/document_detail/137663.html?spm=a2c4g.11186623.6.685.7a29f8eaBVmURh","lastContentName":"常见问题","lastContentLink":"https://help.aliyun.com/document_detail/154074.html?spm=a2c4g.11186623.6.1157.7c786461qtbcgp"}},{"infoName":"产品动态","infoContent":{"firstContentName":"产品最新动态","firstContentLink":"https://www.aliyun.com/product/new?spm=5176.7946122.1265010.211view.2fbf313cKkub8k&category=218&product=66","lastContentName":"实时数据同步上线","lastContentLink":"https://help.aliyun.com/document_detail/181912.html"}},{"infoName":"最佳实践","infoContent":{"firstContentName":"整库迁移","firstContentLink":"https://help.aliyun.com/document_detail/137809.html","lastContentName":"批量上云","lastContentLink":"https://help.aliyun.com/document_detail/146671.html"}}]}],"simplifiedDisplay":"newEdition"}}

数据集成

数据集成（Data Integration）是阿里集团对外提供的可跨异构数据存储系统的、可靠、安全、低成本、可弹性扩展的数据同步平台，为400+对数据源提供不同网络环境下的全量/增量数据进出通道。

产品入门

产品动态

最佳实践