oracle dg异构系统,Oracle 异构平台dg (无法成功)

环境描述源平台    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 我均没有配置成功,报一些莫名其妙的错误,我已经放弃.

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值