file 1 needs media recovery
682305Jul 8 2009 — edited Jul 9 2009i have some problem.
i use oracle XE
if i want to open database from mount state error message display:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: 'oraclexe/oradata/XE/system.dbf'
so i try to execute this statement :
sql> recover tablespace system
or
sql> recover datafile 'C:\oraclexe\oradata\XE\system.dbf'
some error display again
ORA-00283: recovery session canceled due to errors.
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done
so i execute :
sql>recover database using backup controlfile until cancle
ORA-00279: change 7516226638 generated at 05/05/2008 12:32:11
needed for thread 1
ORA-00289: suggestion :
C:\oraclexe\app\oracle\flash_recovery_area\ARCHIVELOG\u_a.ARC
ORA-00280: change 7516226638 for thread 1 is in sequence #1
Specify log: {ret=suggested | filename | AUTO | CANCEL}
CANCEL
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: ‘/oradata/oracle/ts/system01.dbf’
ORA-01112: media recovery not started
please help me. how to open my database.....
thanks alot