ORA-00376: file 4 cannot be read at this time
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,
0