19.3版本非PDB迁移至PDB测试(一次失败的测试)

一、非PDB创建描述文件

startup mount;
alter database open read only;

begin
dbms_pdb.describe(pdb_descr_file=>'/home/oracle/pdb.xml');
end;
/
shutdown immediate

此处必须是read only状态，否则后面会因为描述文件与数据库不一致而报错。

ORA-65139: Mismatch between XML metadata file and data file
+DATA/ORCL/DATAFILE/system.256.1104538157 for value of fcpsb (3586829 in the
plug XML file, 3587893 in the data file)

二、CDB操作

1、验证兼容性

SET SERVEROUTPUT ON
DECLARE
hold_var boolean;
begin
hold_var := DBMS_PDB.CHECK_PLUG_COMPATIBILITY(pdb_descr_file=>'/home/oracle/pdb.xml');
if hold_var then
  dbms_output.put_line('YES');
else
  dbms_output.put_line('NO');
end if;
end;
/

SQL> SET SERVEROUTPUT ON
DECLARE
SQL>   2  hold_var boolean;
  3  begin
  4  hold_var := DBMS_PDB.CHECK_PLUG_COMPATIBILITY(pdb_descr_file=>'/home/oracle/pdb.xml');
  5  if hold_var then
  6    dbms_output.put_line('YES');
  7  else
  8    dbms_output.put_line('NO');
  9  end if;
 10  end;
 11  /
YES

PL/SQL procedure successfully completed.

如果输出NO，查询一下sql处理
select * from pdb_plug_in_violations;

2、复制数据库

SQL> CREATE PLUGGABLE DATABASE orclpdb
  2  using '/home/oracle/pdb.xml'
  3  copy
  4  file_name_convert=('+DATA/ORCL/DATAFILE/','+ARCH/CDB/orclpdb');
CREATE PLUGGABLE DATABASE orclpdb
*
ERROR at line 1:
ORA-65180: duplicate file name encountered -
+DATA/ORCL/DATAFILE/sysaux.257.1104538191

这是因为源库temp文件并不在+DATA/ORCL/DATAFILE/路径。

SQL> CREATE PLUGGABLE DATABASE orclpdb as clone
  2  using '/home/oracle/pdb.xml'
  3  copy
  4  file_name_convert=('+DATA/ORCL/DATAFILE','+ARCH','+DATA/ORCL/TEMPFILE','+ARCH');
CREATE PLUGGABLE DATABASE orclpdb as clone
*
ERROR at line 1:
ORA-65169: error encountered while attempting to copy file
ORA-12801: error signaled in parallel query server

什么鬼，看看alert

ORA-65169 signalled during: CREATE PLUGGABLE DATABASE orclpdb as clone
using '/home/oracle/pdb.xml'
copy
file_name_convert=('+DATA/ORCL/DATAFILE','+ARCH','+DATA/ORCL/TEMPFILE','+ARCH')...
2022-07-11T21:17:00.459692+08:00
CREATE PLUGGABLE DATABASE orclpdb as clone
using '/home/oracle/pdb.xml'
copy
file_name_convert=('+DATA/ORCL/DATAFILE','+ARCH','+DATA/ORCL/TEMPFILE','+ARCH')
Errors in file /u01/app/oracle/diag/rdbms/cdb/CDB/trace/CDB_ora_22439.trc  (incident=10083) (PDBNAME=CDB$ROOT):
ORA-00600: internal error code, arguments: [2901], [0], [1], [], [], [], [], [], [], [], [], []
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Errors in file /u01/app/oracle/diag/rdbms/cdb/CDB/trace/CDB_ora_22439.trc  (incident=10084) (PDBNAME=CDB$ROOT):
ORA-00600: internal error code, arguments: [2901], [0], [896], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [2901], [0], [1], [], [], [], [], [], [], [], [], []

看看mos ORA-00600 [2901] When Creating PDB (Doc ID 2579868.1)

Upgraded to 19c and trying to convert non-CDB to PDB.

CAUSE
Bug 29332763 - HIT ORA 600 [2901] WHILE PLUGIN PDB ON SPARSE DG PDITDBCONSOLIDATION
Bug 29399046 - FRA E6POD RELOCATE FAIL DUE TO ORA-01578
 

醉了。总结，操作的时候开一个窗口刷alert日志是个好习惯。