Today, a colleague asked me to say that his local database was deleted by him by mistake, so he could not open the file. Let's take a look.
SQL> conn jjw/jjw
ERROR:
ORA-01033: Oracle initialization or shutdown in progress
Warning: You are no longer connected to ORACLE.
SQL>
The database has been started, but an error is returned. If yes, I will restart the system to see what error is reported.
SQL> conn/as sysdba
Connected.
SQL> shutdown immediate
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 1224736768 bytes
Fixed Size 2020384 bytes
Variable Size 218106848 bytes
Database Buffers 989855744 bytes
Redo Buffers 14753792 bytes
Database mounted.
ORA-01122: database file 10 failed verification check
ORA-01110: data file 10: '/oracle/database/tabj_tab.dbf'
ORA-01251: Unknown File Header Version read for file number 10
SQL>
First, you must delete the problematic file from the database.
SQL> startup mount
ORACLE instance started.
Total System Global Area 1224736768 bytes
Fixed Size 2020384 bytes
Variable Size 218106848 bytes
Database Buffers 989855744 bytes
Redo Buffers 14753792 bytes
Database mounted.
SQL> alter database datafile '/oracle/database/tabj_tab.dbf' offline drop;
Database altered.
SQL> alter database open;
Database altered.
SQL>
The database returns to normal.
The above is only an operation in the test environment. On the official system, you must not delete files as you like.