请问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)
atafile #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)