Hi,
OracleVersin:10.2.0.1
OperatingSystem:linux
When i restart my server and trying to start the database it is not starting .And it is throwing the following error.
SQL> startup
ORACLE instance started.
Total System Global Area 838860800 bytes
Fixed Size 1222144 bytes
Variable Size 213912064 bytes
Database Buffers 616562688 bytes
Redo Buffers 7163904 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 8 - see DBWR trace file
ORA-01110: data file 8: '/u06/oradata/QFUNDAPAYPROD_JUN09.dbf'
SQL> alter database archivelog;
alter database archivelog
*
ERROR at line 1:
ORA-00265: instance recovery required, cannot set ARCHIVELOG mode
SQL> shut immediate
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 838860800 bytes
Fixed Size 1222144 bytes
Variable Size 213912064 bytes
Database Buffers 616562688 bytes
Redo Buffers 7163904 bytes
Database mounted.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01157: cannot identify/lock data file 8 - see DBWR trace file
ORA-01110: data file 8: '/u06/oradata/QFUNDAPAYPROD_JUN09.dbf'
please help me