Home » RDBMS Server » Backup & Recovery » ora-01194 file 1 needs more recovery to be consistentora-110 (10.2.0.0)
ora-01194 file 1 needs more recovery to be consistentora-110 [message #554666] Wed, 16 May 2012 06:10 Go to next message
harshitaankur
Messages: 19
Registered: April 2012
Location: Delhi
Junior Member
Hello sir ,

I am tring to open the database bur gettinf following errors

ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSTEM01.DBF'


SQL> shutdown
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 289406976 bytes
Fixed Size 1248576 bytes
Variable Size 92275392 bytes
Database Buffers 188743680 bytes
Redo Buffers 7139328 bytes
Database mounted.
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSTEM01.DBF'


Please help me sir .

With regards
Harshita
Re: ora-01194 file 1 needs more recovery to be consistentora-110 [message #554667 is a reply to message #554666] Wed, 16 May 2012 06:17 Go to previous message
Michel Cadot
Messages: 58938
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
recover file 1;

(or better recover database;)

Regards
Michel
Previous Topic: how to hot backup files to other severs?
Next Topic: Restore Control File from Backup
Goto Forum:
  


Current Time: Sat Aug 30 18:06:44 CDT 2014

Total time taken to generate the page: 0.05637 seconds