Database Backup and Recovery (MOSC)

MOSC Banner

ORA-01122: database file 23 failed verification check

edited Dec 21, 2011 5:14PM in Database Backup and Recovery (MOSC) 10 comments
Hi ,

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 .

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center