ORA-01589: must use RESETLOGS or NORESETLOGS option for
database open
- 3 Answers
- 19589 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ravish
After getting the error
"must use RESETLOGS or NORESETLOGS option for database to
open "
i wrote
Alter database open resetlogs
Still got error.
Error at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: 'D:TEST\DATA1\SYSTEM1.DBF'
| Is This Answer Correct ? | 33 Yes | 7 No |
Answer / guest
Cause: Either incomplete or backup controlfile 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.
Please add more information about this Error
| Is This Answer Correct ? | 8 Yes | 4 No |
Answer / dmitry
try using backup controlfile as an option to recover clause
| Is This Answer Correct ? | 1 Yes | 4 No |
PLS-00566: type name "string" cannot be constrained
DRG-11862: This Is Probaly A HTTP Server 0.9 Or Less
NID-00450: Succesfully changed database name and ID.
LFI-01521: fsync() failed(OSD return value = string) in string.
ORA-24417: Session pool size has exceeded the maximum limit
IMP-00052: Warning: Unable to set event for freelist communication with server
ORA-02082: a loopback database link must have a connection qualifier
ORA-16798: Unable to complete terminal recovery on the standby
ORA-38729: Not enough flashback database log data to do FLASHBACK.
ORA-16109: failed to apply log data from previous primary
ORA-28528: Heterogeneous Services datatype conversion error
ORA-30727: duplicate referential constraint for a REF column
Oracle Errors 
