ORA-01194: file 1 needs more recovery to be consistent [message #275329] |
Fri, 19 October 2007 08:42 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
poratips
Messages: 345 Registered: April 2005 Location: IL
|
Senior Member |
|
|
Hi,
I am getting following erorr during backup/recovery from my prod DB to test DB.
I tried to run again with recover command but it's the same problem.
I also shutdown the DB and try again but no luck.
I have build the control file from trace file.
Errors
--------
SQL> recover database until cancel using backup controlfile;
ORA-00279: change 492813519 generated at 10/18/2007 18:22:32 needed for thread
1
ORA-00289: suggestion :
/u01/app/oracle/product/9.2.0/admin/tst/arch/_0000000001.arc
ORA-00280: change 492813519 for thread 1 is in sequence #1
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
ORA-00308: cannot open archived log
'/u01/app/oracle/product/9.2.0/admin/tst/arch/_0000000001.arc'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
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: '/u03/oradata/tst/system01.dbf'
I also followed following steps.
[1] Recover DATABASE
recover DATABASE until cancel USING backup controlfile;
[2] Cancel the recovery
CANCEL
[3] Open WITH resetlogs
ALTER DATABASE open resetlogs;-- Should get ORA-01195
[4] Stop db.
shutdown;
[5]Now ADD this TO init file
_allow_resetlogs_corruption = true
_allow_read_only_corruption = true
[6]
startup mount
[7] Do resetlogs again ALTER DATABASE open resetlogs;
then got the following error:
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
|
|
|
|
|
Re: ORA-01194: file 1 needs more recovery to be consistent [message #275522 is a reply to message #275506] |
Sun, 21 October 2007 01:05 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68676 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
ORA-03113 is much more than what oerr says.
It is a generic error that comes when you encounter a bug.
And encountering a bug is more likely when you use hidden parameters above all ones that remove the database consistency features.
Regards
Michel
|
|
|