oracle dg如何取消,oracle dg 的基本命令

1，查看当前的保护模式

select DATABASE_ROLE,PROTECTION_MODE,PROTECTION_LEVEL from v$database;

2，查看日志的传送方式；

select dest_name,archiver from v$archive_dest;

3，停止standby的自动恢复状态

alter database recover manager standby database finish;

4，添加standby logfile

alter database add standby logfile group 4('/oracle/product/10.2.0/db_1/oradata/sjh10g/redo04.log') size 50m;

5，更改保护模式

alter database set standby database to maximize protextion;

alter database set standby database to maximize availability;

alter database set standby database to maximize performancen;

6，更改传输方式

alter system setlog_archive_dest_2='SERVICE=orcldg LGWR SYNC AFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=orcldg';

7，解决方式：将主备库的flash back 打开

启动到mount

select FLASHBACK_ON from v$database;

alter database flashback on;

8，取消自动恢复模式

alter database recover managed standby database cancel;

alter database recover managed standby database finish;

alter database recover managerd standby database finish force;