Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-01589: must use RESETLOGS or NORESETLOGS option for
database open
- 3 Answers
- 20977 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-09870: spini: failure initializing maximum number of open files.
ORA-24055: cannot delete propagation status rows that are in prepared state
ORA-27044: unable to write the header block of file
ORA-01566: file specified more than once in DROP LOGFILE
ORA-27453: %s is an invalid job or program argument name.
ORA-19816: WARNING: Files may exist in string that are not known to database.
QSM-02034: no joins are present in the HAVING clause
ORA-13633: The task string was interrupted and needs to be resumed.
RMAN-06116: cannot crosscheck unavailable object
NNL-01073: Administrative region description: string
ORA-29848: error occurred in the execution of ODCIINDEXMERGEPARTITION routine
ORA-01968: Only specify RESETLOGS or NORESETLOGS once
Oracle Errors 
