| ora-01194 file 1 needs more recovery to be consistentora-110 [message #554666] |
Wed, 16 May 2012 06:10  |
 |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
