Database Backup and Recovery (MOSC)

MOSC Banner

ORA-00376: file 4 cannot be read at this time

edited Sep 29, 2013 6:49PM in Database Backup and Recovery (MOSC) 4 commentsAnswered
 Hi Community,
Hope you people are fine. I am seeing ORA-00376: file 4 cannot be read at this time, ORA-01110: data file 4: 'D:\APP\ADMINISTRATOR\ORADATA\PBTEST\USERS01.DBF'

I have a big problem, the datafile is in one of test Database and I all archivelogs have been deleted somehow. now to solve the problem I need to follow the below steps:

1- sql> select tablespace_name, status from dba_tablespaces;  OR
    sql> select file#, status from dba_data_files;

I found the tablespace in OFFLINE mode and the Datafile was in RECOVER mode.

2-  I wanted to bring the tablespace online but the ORA-00376 generated. so,

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