dba_data_files

I  could not figure out the error.
SQL> select * from dba_data_files;
select * from dba_data_files
              *
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only


SQL> spool off
nobleitAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
Ok, the error mesage gives you the issue.  You need to recover your database.

From the sql prompt:
Recover database;

As mentioned in the message, you might need to restore before recover.

The backup and recovery online doc has the steps.  If this is a production database, I suggest you contact Support to assist you if you are unfamiliar with the recovery process.
0
 
slightwv (䄆 Netminder) Commented:
Your database isn't 'open'.
0
 
nobleitAuthor Commented:
I tried to open database like this..

still shows error

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01172: recovery of thread 1 stuck at block 57 of file 3
ORA-01151: use media recovery to recover block, restore backup if needed
0
 
nobleitAuthor Commented:
recover database;
Media recovery complete;
alter database open;

Data base is working perfectly fine;

Thanks a lot dear expert..
0
All Courses

From novice to tech pro — start learning today.