Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-01589: must use RESETLOGS or NORESETLOGS option for
database open
- 3 Answers
- 21093 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 |
ORA-01864: the date is out of range for the current calendar
ORA-26507: null master connection
PLS-00375: illegal GOTO statement; this GOTO cannot branch to label 'string'
ORA-00077: dump string is not valid
ORA-23368: name string cannot be null or the empty string
ORA-31027: Path name or handle string does not point to a resource
SQL*Loader-00112: Invalid maximum bind array size
TNS-00125: Failed to get number of Interchanges in TNSNET.ORA
ORA-06554: package DBMS_STANDARD must be created before using PL/SQL
ORA-19550: cannot use backup/restore functions while using dispatcher
ORA-00345: redo log write error block string count string
ORA-14313: Value string does not exist in partition string
Oracle Errors 
