ORA-01194 and ORA-01110

ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'C:\APP\GEET\ORADATA\TEST\SYSTEM01.DBF'

Steps to follow-


- Backup the controlfile to make the changes.
backup controlfile to trace;

- Make the necessary changes in the control file

CREATE CONTROLFILE REUSE DATABASE "TEST" RESETLOGS FORCE LOGGING ARCHIVELOG
    MAXLOGFILES 16
    MAXLOGMEMBERS 3
    MAXDATAFILES 100
    MAXINSTANCES 8
    MAXLOGHISTORY 292
LOGFILE
  GROUP 1 'C:\APP\GEET\ORADATA\TEST\REDO01.LOG'  SIZE 50M BLOCKSIZE 512,
  GROUP 2 'C:\APP\GEET\ORADATA\TEST\REDO02.LOG'  SIZE 50M BLOCKSIZE 512,
  GROUP 3 'C:\APP\GEET\ORADATA\TEST\REDO03.LOG'  SIZE 50M BLOCKSIZE 512
-- STANDBY LOGFILE
DATAFILE
  'C:\APP\GEET\ORADATA\TEST\SYSTEM01.DBF',
  'C:\APP\GEET\ORADATA\TEST\SYSAUX01.DBF',
  'C:\APP\GEET\ORADATA\TEST\UNDOTBS01.DBF',
  'C:\APP\GEET\ORADATA\TEST\USERS01.DBF',
  'C:\APP\GEET\ORADATA\TEST\EXAMPLE01.DBF'
CHARACTER SET WE8MSWIN1252
;

- copy the datafiles to the primary location
- startup database nomount;
- execute controlfile script
- alter database open resetlogs;