Oracle - 11GR2 - RAC - to - RAC - DATAGUARD - 配置方案(4)

2019-08-30 23:53

种操作是destructive操作,一旦执行,备库需要重建。运行此操作需慎重。

sql> alter database recover managed standby database finish force; sql> alter database activate standby database [skip standby logfile]; sql> shutdown immediate; sql> startup mount; sql> alter database open resetlogs;

1.6.5 数据同步测试

主库: create tablespace test datafile '+data' size 128m autoextend off; create user test identified by test default tablespace test; grant connect,resource to test; conn test/test create table t1 as select * from user_objects; select count(*) from test.t1; conn / as sysdba alter system checkpoint; alter system archive log current; 备库: select count(*) from test.t1; 主库: drop user test cascade; drop tablespace test including contents and datafiles; alter system checkpoint; alter system archive log current; 备库: select count(*) from test.t1; select name from v$tablespace where name='TEST';

1.7 参考

Technical_Architecture_of_11g_R2_RAC_primary_to_RAC_standby_DataGuard配置指南(中

文)

Data Guard Concepts and Administration

Step By Step of Configuring Oracle 11gR2 (11.2.0.1) RAC to RAC Dataguard


Oracle - 11GR2 - RAC - to - RAC - DATAGUARD - 配置方案(4).doc 将本文的Word文档下载到电脑 下载失败或者文档不完整,请联系客服人员解决!

下一篇:财务分析报告期末考试复习-仅供参考

相关阅读
本类排行
× 注册会员免费下载(下载后可以自由复制和排版)

马上注册会员

注:下载文档有可能“只有目录或者内容不全”等情况,请下载之前注意辨别,如果您已付费且无法下载或内容有问题,请联系我们协助你处理。
微信: QQ: