ORA-01110: data file 1: 'F:\ORACLE\ORADATA\SAUGATA\SYSTEM01.DBF'
601989May 21 2009 — edited May 21 2009Hi,
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