ORA-01589: must use RESETLOGS or NORESETLOGS option for
database open
- 3 Answers
- 19554 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 |
AMD-00145: error attaching Workspace "string" in mode "string"
TNS-00027: INTCTL: Could not resolve Navigator's name/address
ORA-24437: OCIStmtExecute called before OCIStmtPrepare2.
ORA-09762: sNeXT_instanceName: translation error.
ORA-13295: geometry objects are in different coordinate systems
ORA-38404: schema extension not allowed for the attribute set name
ORA-22857: cannot modify columns of object tables
ORA-12480: specified clearance labels not within the effective clearance
ORA-24097: Invalid value string, string should be non-negative
ORA-12681: Login failed: the SecurID card does not have a pincode yet
ORA-12805: parallel query server died unexpectedly
RMAN-08551: recovering datafilecopy fno=string name=string
Oracle Errors 
