ORA-01219: database not open: queries allowed on fixed tables/views only

Error : ORA-01219: database not open: queries allowed on fixed tables/views only

I got this error when I tried to startup the database.

Possibilities : System files might be corrupted or lost.

Resolution :

1. SQL> recover datafile 1;

2.SQL> alter database open;

2.SQL> select * from tab;