Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01110: data file 1: 'F:\ORACLE\ORADATA\SAUGATA\SYSTEM01.DBF'

601989May 21 2009 — edited May 21 2009
Hi,

I am facing problem in logging into my Database:

Error showing:

ALTER DATABASE OPEN RESETLOGS
*
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'F:\ORACLE\ORADATA\SAUGATA\SYSTEM01.DBF'

I have made a script and logged in as:conn / as sysdba
Then I have run the script where it contains:
startup nomunt;
CREATE CONTROLFILE REUSE DATABASE "SAUGATA" RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 'F:\ORACLE\ORADATA\SAUGATA\REDO01.LOG' SIZE 50M,
GROUP 2 'F:\ORACLE\ORADATA\SAUGATA\REDO02.LOG' SIZE 50M,
GROUP 3 'F:\ORACLE\ORADATA\SAUGATA\REDO03.LOG' SIZE 50M
-- STANDBY LOGFILE
DATAFILE
'F:\ORACLE\ORADATA\SAUGATA\SYSTEM01.DBF',
'F:\ORACLE\ORADATA\SAUGATA\UNDOTBS01.DBF',
'F:\ORACLE\ORADATA\SAUGATA\SYSAUX01.DBF',
'F:\ORACLE\ORADATA\SAUGATA\USERS01.DBF',
'F:\ORACLE\ORADATA\SAUGATA\EXAMPLE01.DBF',
'F:\ORADATATEMP\ORV5_UDM_DIM_PREPOP.DBF',
CHARACTER SET WE8MSWIN1252
;
-- Commands to re-create incarnation table
-- Below log names MUST be changed to existing filenames on
-- disk. Any one log file from each branch can be used to
-- re-create incarnation records.
-- ALTER DATABASE REGISTER LOGFILE 'F:\ORACLE\FLASH_RECOVERY_AREA\SAUGATA\ARCHIVELOG\2009_05_21\O1_MF_1_1_%U_.ARC';
-- ALTER DATABASE REGISTER LOGFILE 'F:\ORACLE\FLASH_RECOVERY_AREA\SAUGATA\ARCHIVELOG\2009_05_21\O1_MF_1_1_%U_.ARC';
-- Recovery is required if any of the datafiles are restored backups,
-- or if the last shutdown was not normal or immediate.
--RECOVER DATABASE USING BACKUP CONTROLFILE
-- Database can now be opened zeroing the online logs.
ALTER DATABASE OPEN RESETLOGS;

After that I am getting this Error:

Any help will be needful for me

Thanks and Regards
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 18 2009
Added on May 21 2009
25 comments
78,450 views