Home > TroubleShooting > ORA-00376: file 3 cannot be read at this time

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

Symptoms

1. Application reported the following ORA errors

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

ORA-01110: data file 3: ‘+SG_DG/sgcmsqa/datafile/undotbs1.858.686595021’

2. From the database datafile status check, it showed that datafiles undotbs1  and sysaux are in recover status.

1 SYSTEM  +SG_DG/sgcmsqa/datafile/system.856.686595019
2 RECOVER +SG_DG/sgcmsqa/datafile/sysaux.857.686595021
3 RECOVER +SG_DG/sgcmsqa/datafile/undotbs1.858.686595021
4 ONLINE  +SG_DG/sgcmsqa/datafile/users.859.686595021
5 ONLINE  +SG_DG/sgcmsqa/datafile/example.867.686595235
6 ONLINE  +SG_DG/sgcmsqa/datafile/undotbs2.871.686595689
7 ONLINE  +SG_DG/sgcmsqa/datafile/sgcms_tbs.886.686598679

Fixed

1. Recover the datafiles by the command recover datafile

SQL> set autorecovery on

SQL> recover datafile 2;

SQL>recpver datafile 3;

SQL> select file#, status, name from v$datafile;

FILE# STATUS  NAME
———- ——- ——————————————————————————–
1 SYSTEM  +SG_DG/sgcmsqa/datafile/system.856.686595019
2 OFFLINE +SG_DG/sgcmsqa/datafile/sysaux.857.686595021
3 OFFLINE +SG_DG/sgcmsqa/datafile/undotbs1.858.686595021
4 ONLINE  +SG_DG/sgcmsqa/datafile/users.859.686595021
5 ONLINE  +SG_DG/sgcmsqa/datafile/example.867.686595235
6 ONLINE  +SG_DG/sgcmsqa/datafile/undotbs2.871.686595689
7 ONLINE  +SG_DG/sgcmsqa/datafile/sgcms_tbs.886.686598679

2. Turn the tablespace online

SQL> alter tablespace sysaux online;

Tablespace altered.

SQL> alter tablespace undotbs1 online;

Tablespace altered.

Advertisements
Categories: TroubleShooting
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: