I have to recover an Oracle database from a backup with a controlfile. I want to avoid that archivelogs written after the backup are taken for a recovery. I want to a avoid resetlogs.

I have to switch from rman to sqlplus to issue this statement.


Is there a way to do this from rman and to avoid resetlogs?

  • you want to recover database from RMAN. Mar 8, 2017 at 8:37
  • Yes, if possible. I don't want to switch to sqlplus.
    – r0tt
    Mar 8, 2017 at 8:40
  • 2
    What type of backup do you have consistent(cold) or inconsistent(hot)? If you perform incomplete recovery then you need to reset log.
    – atokpas
    Mar 8, 2017 at 8:43
  • 2
    @r0tt in the case of a consistent backup just RESTORE, no need to RECOVER, and the database will be in the state it was at the time of the backup — no later logs will be applied. Mar 8, 2017 at 9:15
  • 1
    Why do you want to avoid reset logs?
    – miracle173
    May 26, 2017 at 13:45

2 Answers 2


If you want to cancel, you have no way of using noresetlogs. You have create a new incarnation of your database. Ps: I don't know what your problem was with switching to sqlplus, but you can execute sql statements (alter database.....) in rman .


I think the issue is related to Oracle Doc: How to RESTORE / RECOVER COLD RMAN backup without OPEN RESETLOGS(Doc ID 1077022.1).

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.