从SNAPSHOT STANDBY创建完refreable pdb后,手动刷新提示ORA-00326错误。
SQL> alter pluggable database bpmpdb refresh;
alter pluggable database bpmpdb refresh
*
第 1 行出现错误:
ORA-00326: 日志在更改 7447602937 开始, 需要更早的更改 7445775618
看日志,提示无法读取归档文件,但是源库归档文件是正确的。
2023-08-24 11:30:50.872000 +08:00
alter pluggable database bpmpdb refresh
Applying media recovery for pdb-4099 from SCN 7445775618 to SCN 7447605227
Remote log information: count-1
thr-1, seq-1, logfile-/u01/app/archive/ORCLDG_NEW/foreign_archivelog/BPMPDB/2023_08_24/o1_mf_1_1_2434822576_.arc, los-7447602937, nxs-18446744073709551615
Media Recovery Start
Serial Media Recovery started
2023-08-24 11:30:51.908000 +08:00
Media Recovery Log /u01/app/archive/ORCLDG_NEW/foreign_archivelog/BPMPDB/2023_08_24/o1_mf_1_1_2434822576_.arc
Errors with log /u01/app/archive/ORCLDG_NEW/foreign_archivelog/BPMPDB/2023_08_24/o1_mf_1_1_2434822576_.arc
ORA-326 signalled during: alter pluggable database bpmpdb refresh...
