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!

file 1 needs media recovery

682305Jul 8 2009 — edited Jul 9 2009
i 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 6 2009
Added on Jul 8 2009
5 comments
2,067 views