Oracle/oradata/logicdg'
*.log_file_name_convert='/oracle/oradata/test','/oracle/oradata/dgtest/dgtest','/Oracle/oradata/test','/
Oracle/oradata/logicdg'
2.查看兩台物理standby同步狀態
physics> select sequence#,applIEd from v$archived_log;
SEQUENCE# APPLIED
---------- ---------
66 YES
67 YES
68 YES
69 YES
70 YES
71 YES
72 YES
7 rows selected.
-----------------------------------------------------------------------------
logical> select sequence#,applIEd from v$archived_log;
SEQUENCE# APPLIED
---------- ---------
67 YES
68 YES
69 YES
70 YES
71 YES
72 YES
6 rows selected.
3.取消待轉換物理standby的redo應用
logical> alter database recover managed standby database cancel;
Database altered.
4.primary生成數據字典
primary> execute dbms_logstdby.build;
PL/SQL procedure successfully completed.
5.將物理standby轉換為邏輯standby
logical> alter database recover to logical standby logicdg;
Database altered.
logical> shutdown immediate
ORA-01507: database not mounted
Oracle instance shut down.
logical> startup mount
Oracle instance started.
Total System Global Area 2488635392 bytes
Fixed Size 2215904 bytes
Variable Size 1392508960 bytes
Database Buffers 1090519040 bytes
Redo Buffers 3391488 bytes
Database mounted.
6.調整standby初始化參數
logical> alter system set log_archive_dest_1='location=/Oracle/oradata/logicdg/local-archive valid_for=（online_logfiles,all_roles）
2 db_unique_name=logicdg';
System altered.
logical> alter system set log_archive_dest_5='location=/Oracle/oradata/logicdg/archive valid_for=（standby_logfiles,standby_role）
2 db_unique_name=logicdg';
System altered.
7.resetlogs方式打開數據庫
logical> alter database open resetlogs;
Database altered.
8.應用redo
創建standby redologs
logical> alter database add standby logfile group 11 '/Oracle/oradata/logicdg/standbyredo11.log' size 100m;
Database altered.
logical> alter database add standby logfile group 12 '/Oracle/oradata/logicdg/standbyredo12.log' size 100m;
Database altered.
logical> alter database add standby logfile group 13 '/Oracle/oradata/logicdg/standbyredo13.log' size 100m;
Database altered.
啟動redo實時應用
logical> alter database start logical standby apply immediate;
Database altered.
