OraFAQ Forum: Backup & Recovery » resetlogs or noresetlogs

Home » RDBMS Server » Backup & Recovery » resetlogs or noresetlogs (oracle 11g, windows 7)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

resetlogs or noresetlogs [message #623388]

Tue, 09 September 2014 14:06

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

Report message to a moderator

Re: resetlogs or noresetlogs [message #623389 is a reply to message #623388]

Tue, 09 September 2014 14:13

BlackSwan
Messages: 26757
Registered: January 2009
Location: SoCal

Senior Member

When was last time the database was OK?
What changed since then?

Report message to a moderator

Re: resetlogs or noresetlogs [message #623392 is a reply to message #623388]

Tue, 09 September 2014 14:30

Michel Cadot
Messages: 67648
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;

Report message to a moderator

Previous Topic:	Flashback DB question
Next Topic:	ORA-19554: error allocating device, device type: SBT_TAPE, device name

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 21 03:19:08 CST 2021