记一次impdp设置错误导致数据库起不来

原因，昨天测试expdp和impdp，错误的把本来应该导入到pdb中的数据导入到根容器中了，之后看到没有报错就关掉了数据库，今天数据库起不来

报错：

Database mounted.
ORA-01122: database file 19 failed verification check
ORA-01110: data file 19: '/home/oracle/pdb2/exptbs01.dbf'
ORA-19735: wrong creation SCN - control file expects initial plugged-in datafile

看来是19号数据文件出了问题，先查看一下数据文件

SQL> select CON_ID,FILE#,NAME FROM V$DATAFILE;

    CON_ID    FILE# NAME
---------- ---------- ----------------------------------------------------------------------------------------------------
     1        1 /oracle/app/oracle/oradata/OCP19C/system01.dbf
     1        3 /oracle/app/oracle/oradata/OCP19C/sysaux01.dbf
     1        4 /oracle/app/oracle/oradata/OCP19C/undotbs01.dbf
     2        5 /oracle/app/oracle/oradata/OCP19C/pdbseed/system01.dbf
     2        6 /oracle/app/oracle/oradata/OCP19C/pdbseed/sysaux01.dbf
     1        7 /oracle/app/oracle/oradata/OCP19C/users01.dbf
     2        8 /oracle/app/oracle/oradata/OCP19C/pdbseed/undotbs01.dbf
     3        9 /oracle/app/oracle/oradata/OCP19C/pdb/system01.dbf
     3       10 /oracle/app/oracle/oradata/OCP19C/pdb/sysaux01.dbf
     3       11 /oracle/app/oracle/oradata/OCP19C/pdb/undotbs01.dbf
     3       12 /oracle/app/oracle/oradata/OCP19C/pdb/users01.dbf

    CON_ID    FILE# NAME
---------- ---------- ----------------------------------------------------------------------------------------------------
     4       13 /oracle/app/oracle/oradata/OCP19C/pdb2/system01.dbf
     4       14 /oracle/app/oracle/oradata/OCP19C/pdb2/sysaux01.dbf
     4       15 /oracle/app/oracle/oradata/OCP19C/pdb2/undotbs01.dbf
     3       16 /oracle/app/oracle/oradata/OCP19C/pdb/mig01.dbf
     4       17 /oracle/app/oracle/oradata/OCP19C/pdb2mig01.dbf
     3       18 /oracle/app/oracle/oradata/OCP19C/pdb/exptbs01.dbf
     1       19 /home/oracle/pdb2/exptbs01.dbf
     4       20 /home/oracle/pdb2/exptbs01.dbf

19 rows selected.

所以给他offline一下试试

SQL> alter database datafile '/home/oracle/pdb2/exptbs01.dbf' offline;

打开数据库测试一下，已经可以运行了

SQL> alter database open;

Database altered.

SQL> select open_mode from v$database;

OPEN_MODE
----------------------------------------
READ WRITE