ORA-01194 file 1 needs more recovery to be consistent ORA-01110 data file 1
981878Mar 15 2013 — edited Mar 15 2013Hi all,
I am in trouble now and need your help urgently. I would appreciate if you can help me at the earliest.
All of sudden I'm facing database connection error and this has completely blocked access to application.
It's Oracle 11 g database on Sun Solaris sysetem.
The error now is
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/u02/oradata/sundb11g/system01.dbf'
Unfortunately we do not have any back up with us and also found that archive file is missing ..another error message
SQL> Recover database using backup controlfile;
ORA-00279: change 177477900 generated at 03/14/2013 11:48:14 needed for thread
1
ORA-00289: suggestion :
/u01/apps/oracle/product/ora11g/dbs/arch1_7115_754493575.dbf
ORA-00280: change 177477900 for thread 1 is in sequence #7115
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
ORA-00308: cannot open archived log
'/u01/apps/oracle/product/ora11g/dbs/arch1_7115_754493575.dbf'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
Thanks in Advance.
Thanks,
Santosh
Edited by: 978875 on Mar 15, 2013 2:57 AM