Home » RDBMS Server » Backup & Recovery » ORA-01194: file 1 needs more recovery to be consistent
ORA-01194: file 1 needs more recovery to be consistent [message #275329] Fri, 19 October 2007 08:42 Go to next message
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 #275429 is a reply to message #275329] Sat, 20 October 2007 00:48 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

ORA-03113: end-of-file on communication channel

Check your Alert<sid>log file for more information.
and
do you have last valid backup or all archivelog files.

Regards
Mohammed Taj
Re: ORA-01194: file 1 needs more recovery to be consistent [message #275506 is a reply to message #275329] Sat, 20 October 2007 22:30 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

ORA-03113: end-of-file on communication channel
Cause: The connection between Client and Server process was broken.
Action: There was a communication error that requires further
investigation. First, check for network problems and review the
SQL*Net setup. Also, look in the alert.log file for any errors.
Finally, test to see whether the server process is dead and
whether a trace file was generated at failure time.
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
Michel Cadot
Messages: 64132
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
Previous Topic: RMAN flash recovery
Next Topic: backup from oracle to tape under windows 2000 server
Goto Forum:
  


Current Time: Thu Dec 08 02:36:41 CST 2016

Total time taken to generate the page: 0.11669 seconds