ORA-01122: database file 23 failed verification check
I am facing below error while recovering the datafile. My database is 10.2.0.4 , linux platform and noarchive log mode. we dont have backup of the database .
In v$ datafile output I saw the MISSING00012 files like below
/apps/app/oracle/product/10.2.0/db_1/dbs/MISSING00010 . Then I tried to rename the below files
SQL>alter database rename file 'MISSING00010' to '/data04/oradata/BIPSGTST/datafile/bistage_idx01.dbf';
Database altered.
If I query the v$datafile the output is showing
10 RECOVER READ WRITE /apps/app/oracle/product/10.2.0/db_1/dbs/MISSING00010
Then I tried to recover the file below steps .But it failed .