Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Need to know when datafile added to database.

781678Jun 28 2010 — edited Jun 28 2010

Hi

Currently in one of my database I see below error and physically datafile #10 does not exists on FS.
I need to know when was this datafile added to database. We have rman backups too when quering it threw error. for ex: show all;

FILE# ONLINE ONLINE_ ERROR CHANGE# TIME
---------- ------- ------- ------------------------------ ---------- ---------
10 OFFLINE OFFLINE FILE MISSING 0
ls -lrt /xxxx/oracle/9.2.0/dbs/MISSING00010

CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
could not read file header for datafile 10 error reason 1
could not read file header for datafile 10 error reason 1
could not read file header for datafile 10 error reason 1
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 26 2010

Added on Jun 28 2010

#general-database-discussions

16 comments

4,839 views