物理ADG转换逻辑ADG

1、构建物理DG

参考：https://blog.csdn.net/jisen_huang/article/details/115235908

2、转换逻辑DG

--不被SQL应用分析支持的表（主机执行）
SELECT OWNER, TABLE_NAME
  FROM DBA_LOGSTDBY_NOT_UNIQUE
 WHERE (OWNER, TABLE_NAME) NOT IN
      (SELECT DISTINCT OWNER, TABLE_NAME FROM DBA_LOGSTDBY_UNSUPPORTED)
   AND bad_column = 'Y'

2.1、停用备库MRP进程  

alter database recover managed standby database cancel;

2.2、主库构建LogMiner字典

create tablespace logmnrtbs datafile '+DATA/orcl/datafile/logmnrtbs1.dbf' size 1G autoextend on ;
execute dbms_logmnr_d.set_tablespace('logmnrtbs');
exec dbms_logstdby.build;

 

2.3、把物理备库恢复为逻辑备库

shutdown immediate;
 startup mount exclusive;
ALTER DATABASE RECOVER TO LOGICAL STANDBY ora11gdb parallel 10;

initorcl 中的参数db_name改为orcldg

alter system set log_archive_dest_1='location=+DATA/archivelog  valid_for=(online_logfiles,all_roles) db_unique_name=orcldg' scope=both;
  
alter system set log_archive_dest_2='location=+log/arch  valid_for=(standby_logfiles,standby_role) db_unique_name=orcldg' scope=both;

cp  orapworcl   orapworcldg

startup mount
ALTER DATABASE OPEN RESETLOGS;
alter database start logical standby apply immediate;

 

2.4、启停命令

alter database stop logical standby apply;
shutdown immediate



startup
alter database start logical standby apply immediate;