Home » RDBMS Server » Backup & Recovery » resetlogs or noresetlogs (oracle 11g, windows 7)
resetlogs or noresetlogs [message #623388] Tue, 09 September 2014 14:06 Go to next message
HIMUAHMED86
Messages: 1
Registered: September 2014
Location: Dhaka, Bangladesh
Junior Member
SQL> STARTUP
ORACLE instance started.

Total System Global Area 1071333376 bytes
Fixed Size 1375792 bytes
Variable Size 662700496 bytes
Database Buffers 402653184 bytes
Redo Buffers 4603904 bytes
Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open


SQL> recover database until cancel using backup controlfile;
ORA-00279: change 4285949 generated at 09/08/2014 16:08:16 needed for thread 1
ORA-00289: suggestion :
G:\APP\ADMINISTRATOR\FLASH_RECOVERY_AREA\IOBS\ARCHIVELOG\2014_09_10\O1_MF_1_194_

%U_.ARC
ORA-00280: change 4285949 for thread 1 is in sequence #194


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
'G:\APP\ADMINISTRATOR\ORADATA\IOBS\SYSTEM01.DBF'
ORA-00317: file type 0 in header is not log file
ORA-00334: archived log: 'G:\APP\ADMINISTRATOR\ORADATA\IOBS\SYSTEM01.DBF'


ORA-10879: error signaled in parallel recovery slave
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: 'G:\APP\ADMINISTRATOR\ORADATA\IOBS\SYSTEM01.DBF'

how do i solve this? please help me... step by step solution
Re: resetlogs or noresetlogs [message #623389 is a reply to message #623388] Tue, 09 September 2014 14:13 Go to previous messageGo to next message
BlackSwan
Messages: 26207
Registered: January 2009
Location: SoCal
Senior Member
When was last time the database was OK?
What changed since then?
Re: resetlogs or noresetlogs [message #623392 is a reply to message #623388] Tue, 09 September 2014 14:30 Go to previous message
Michel Cadot
Messages: 65850
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

RA-01589: must use RESETLOGS or NORESETLOGS option for database open
*Cause:  Either incomplete or backup control file recovery has been
         performed. After these types of recovery you must specify either
         the RESETLOGS option or the NORESETLOGS option to open your
         database.
*Action: Specify the appropriate option.

So try ALTER DATABASE OPEN RESETLOGS;
Previous Topic: Flashback DB question
Next Topic: ORA-19554: error allocating device, device type: SBT_TAPE, device name
Goto Forum:
  


Current Time: Tue Oct 23 03:37:58 CDT 2018