Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


ORA-01589: must use RESETLOGS or NORESETLOGS option for
database open

Answers were Sorted based on User's Feedback



ORA-01589: must use RESETLOGS or NORESETLOGS option for database open..

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

ORA-01589: must use RESETLOGS or NORESETLOGS option for database open..

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

ORA-01589: must use RESETLOGS or NORESETLOGS option for database open..

Answer / dmitry

try using backup controlfile as an option to recover clause

Is This Answer Correct ?    1 Yes 4 No

Post New Answer



More Oracle Errors Interview Questions

ORA-07274: spdcr: access error, access to oracle denied.

2 Answers  


NID-00315: Operation already in progress, continuing

1 Answers  


LPX-00653: Output attribute '~S' doesn't have a parent element.

1 Answers  


ORA-07754: slemcf: fwrite failure

1 Answers  


ORA-32839: property string is reserved, names with MGWPROP$_ prefix are not valid

1 Answers  






NID-00426: Database ID for database string restored to number.

1 Answers  


ORA-29868: cannot issue DDL on a domain index marked as LOADING

1 Answers  


RMAN-06459: BACKUP <VALIDATE|DURATION> is not supported with PROXY

1 Answers  


ORA-29532: Java call terminated by uncaught Java exception: string

1 Answers  


ORA-31620: file or device "string" cannot be specified for string operation

1 Answers  


TNS-00081: * trace_on - ask process name to turn tracing on

1 Answers  


ORA-15051: file 'string' contains string error(s)

1 Answers  






Categories