Total Pageviews

Sunday, June 25, 2023

How to resolve ORA-00214: control file inconsistent with file


Tried to startup or mount a database, we got ORA-00214.

SQL> startup
ORACLE instance started.
...
ORA-00214: control file
'/u01/app/oracle/fast_recovery_area/ORCLCDB/control02.ctl' version 2286
inconsistent with file '/u01/app/oracle/oradata/ORCLCDB/control01.ctl' version
2248

Let's see its status.

SQL> select status from v$instance;

STATUS
------------
STARTED

What does STARTED means? We can tell what state of database currently is by some means. It's at NOMOUNT now.

Read more....

No comments:

Post a Comment

The Fix for the Double Login Prompt when run report 6i from form

  Since you are running in a Desktop (client-server) architecture , the login prompt and buffering are directly tied to how the local Window...