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;