ORA-00214: controlfile 'u01apporacleoradata[sid]control01.ctl' version inconsistent with file

    xiaoxiao2021-03-25  142

    错误:

    SQL> startup ORACLE instance started.

    Total System Global Area 285212672 bytes Fixed Size 1321368 bytes Variable Size 153605736 bytes Database Buffers 130023424 bytes Redo Buffers 262144 bytes  ORA-00214: controlfile '/u01/app/oracle/oradata/[SID]/control01.ctl' version 774562 inconsistent with file '/u01/app/oracle/oradata/[SID]/control03.ctl' version 774558

    解决方法

    get a backup of the control03.ctl

    $ cp /u01/app/oracle/oradata/[SID]/control03.ctl /u01/app/oracle/oradata/[SID]/control03_bak.ctl

    Replace control file

    cp /u01/app/oracle/oradata/[SID]/control01.ctl /u01/app/oracle/oradata/[SID]/control03.ctl

    output: cp: overwrite `/u01/app/oracle/oradata/[SID]/control03.ctl'? y

    alter database mount;

    recover database;

    alter database open;

    转载请注明原文地址: https://ju.6miu.com/read-13105.html

    最新回复(0)