环境描述源平台 windows目标平台 linux1.主库设置归档/强制归档模式SQL> alter database archivelog;Database altered.SQL> alter database open;Database altered.SQL> alter database force logging;Database altered.3.配置两边监听文件主库不用配置了,默认即可备库静态监听LISTENER1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=10.135.175.133)(PORT=1522))))SID_LIST_LISTENER1=(SID_LIST=(SID_DESC=(SID_NAME=lltest)(ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1)(GLOBAL_DBNAME=lltestdg)))ps: dataguard 我习惯都用 1522 来配置4.配置两边tnsnames.ora 文件lltest =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST=10.135.20.223)(PORT = 1521))(CONNECT_DATA =(SERVER = DEDICATED)(SID=lltest)))lltestdg =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST=10.135.175.133)(PORT = 1522))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = lltestdg)(UR=A)))5.主备库修改pfile主库*.log_archive_dest_1='LOCATION=E:\app\Administrator\oradata\lltest VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=lltest'*.log_archive_dest_2='SERVICE=lltestdg LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=lltestdg'*.log_archive_config='DG_CONFIG=(lltestdg,lltest)'*.log_file_name_convert='/u01/','E:\app\Administrator\oradata\lltest'*.db_file_name_convert='/u01/','E:\app\Administrator\oradata\lltest'备库*.log_archive_dest_1='LOCATION=/u01 VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=lltestdg'*.log_archive_dest_2='SERVICE=lltest LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=lltest'*.log_archive_config='DG_CONFIG=(lltest,lltestdg)'*.log_file_name_convert='E:\app\Administrator\oradata\lltest','/u01/'*.db_file_name_convert='E:\app\Administrator\oradata\lltest','/u01/'*.db_unique_name='lltestdg'6.主库添加 standby redoalter database add standby logfile group 11 'E:\app\Administrator\oradata\lltest\redo11.log' size 512M;alter database add standby logfile group 12 'E:\app\Administrator\oradata\lltest\redo12.log' size 512M;alter database add standby logfile group 13 'E:\app\Administrator\oradata\lltest\redo13.log' size 512M;alter database add standby logfile group 14 'E:\app\Administrator\oradata\lltest\redo14.log' size 512M;7.进行 duplicate 操作rman target sys/oracle auxiliary sys/oracle@lltestdg这里要注意备库的密码文件DUPLICATE TARGET DATABASE FOR STANDBY FROM ACTIVE DATABASE NOFILENAMECHECK;根据 文档 ID 413484.1 oracle是支持异构平台dg 的,但无论是 win => linux 还是 linux =>win 我均没有配置成功,报一些莫名其妙的错误,我已经放弃.
oracle dg异构系统,Oracle 异构平台dg (无法成功)
最新推荐文章于 2022-09-21 15:29:25 发布