A-A+

oracle database 11g Snapshot Standby Easier than manual steps in 10.2

2016年08月13日 Oracle 暂无评论 阅读 592 次

Snapshot Standby Easier than manual steps in 10.2

inewup-standby-database

inewup-standby-database

10.2

Standby

> alter database recover managed standby database cancel;
> create restore point before_lt guarantee flashback database;

Primary

> alter system archive log current;
> alter system set log_archive_dest_state_2=defer;

Standby

> alter database activate standby database;
> startup mount force;
> alter database set standby database to maximize performance;
> alter system set log_archive_dest_state_2=defer;
> alter database open;

PERFORM TESTING, ARCHIVE LOGS NOT SHIPPED

> startup mount force;
> flashback database to restore point before_lt;
> alter database convert to physical standby;
> startup mount force;
> alter database recover managed standby database disconnect from session;

Primary

> Alter system set log_archive_dest_state_2=enable

 

11

Standby

> alter database convert to snapshot standby;

PERFORM TESTING, ARCHIVE LOGS CONTINUE TO BE SHIPPED

> alter database convert to physical standby;

给我留言

Copyright © 2011-2016 零下二十四度Theme By  Ality  京ICP备16007547号   关于本站

用户登录