ORA-01589: must use RESETLOGS or NORESETLOGS option for
database open
- 3 Answers
- 20173 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 |
IMG-00833: boundary queue size exceeds expected size
ORA-12993: tablespace 'string' is offline, cannot drop column
ORA-23430: argument "string" cannot be NULL or empty string
LFI-01002: Unable to read line from file.
ORA-07468: spwat: mset error, unable to set semaphore.
SQL*Loader-00501: Unable to read file (string)
ORA-30436: unable to open named pipe 'string'
TNS-01201: Listener cannot find executable string for SID string
ORA-01555: snapshot too old: rollback segment number string with name "string" too small
ORA-07219: slspool: unable to allocate spooler argument buffer.
ORA-02368: file string is not valid for this load operation
RMAN-06517: KEEP option is not supported for archive log backups
Oracle Errors 
