oracle dblink和dataguard,请问oracle12c的dataguard是不是不支持dblink对远程数据库的复制?...

请问oracle12c的dataguard是不是不支持对远程数据库的复制?h24pdb01是一个远程pdb,需要复制到这个容器中。

SQL> create pluggable database h26pdb02 from h24pdb01@h24pdb01 file_name_convert=('h24pdb01','h26pdb02');

Pluggable database created.

创建完备库就报错:

dgmgrl报错为:

Database - h27

Role:               PHYSICAL STANDBY

Intended State:     APPLY-ON

Transport Lag:      0 seconds (computed 1 second ago)

Apply Lag:          1 minute 2 seconds (computed 1 second ago)

Average Apply Rate: 3.00 KByte/s

Active Apply Rate:  258.00 KByte/s

Maximum Apply Rate: 259.00 KByte/s

Real Time Query:    OFF

Instance(s):

h26

Database Error(s):

ORA-16766: Redo Apply is stopped

Database Warning(s):

ORA-16853: apply lag has exceeded specified threshold

备库日志为,备库数据文件各种报错之后,MRP进程就停止了。在启用MRP还是报这些错误,之后MRP又会停止了:

2017-09-17T05:25:37.914779+08:00

(3):WARNING: File being created with same name as in Primary

(3):Existing file may be overwritten

(3):Recovery created file /u01/app/oracle/oradata/h26/pdb01admin/ocp01.dbf

(3):Successfully added datafile 12 to media recovery

(3)

266faa3e2451dd0bb0047cc3ca69ae30.gifatafile #12: '/u01/app/oracle/oradata/h26/pdb01admin/ocp01.dbf'

2017-09-17T06:45:29.095929+08:00

Recovery created pluggable database H26PDB02

MRP0: Background Media Recovery terminated with error 1274

2017-09-17T06:45:29.151840+08:00

Errors in file /u01/app/oracle/diag/rdbms/h27/h26/trace/h26_pr00_4576.trc:

ORA-01274: cannot add data file that was originally created as '/u01/app/oracle/oradata/h24/h26pdb02

/system01.dbf'ORA-01565: error in identifying file '/u01/app/oracle/oradata/h24/h26pdb02/system01.dbf'

ORA-27037: unable to obtain file status

Linux-x86_64 Error: 2: No such file or directory

Additional information: 7

Managed Standby Recovery not using Real Time Apply

Recovery interrupted!

2017-09-17T06:45:29.445056+08:00

Errors in file /u01/app/oracle/diag/rdbms/h27/h26/trace/h26_m000_4990.trc:

ORA-01110: data file 1: '/u01/app/oracle/oradata/h26/system01.dbf'

Recovered data files to a consistent state at change 1490259

2017-09-17T06:45:29.588708+08:00

Errors in file /u01/app/oracle/diag/rdbms/h27/h26/trace/h26_pr00_4576.trc:

ORA-01274: cannot add data file that was originally created as '/u01/app/oracle/oradata/h24/h26pdb02

/system01.dbf'ORA-01565: error in identifying file '/u01/app/oracle/oradata/h24/h26pdb02/system01.dbf'

ORA-27037: unable to obtain file status

Linux-x86_64 Error: 2: No such file or directory

Additional information: 7

2017-09-17T06:45:29.690565+08:00

MRP0: Background Media Recovery process shutdown (h26)

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值