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. – Md Haidar Ali Khan Mar 8 '17 at 8:37
  • Yes, if possible. I don't want to switch to sqlplus. – r0tt Mar 8 '17 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. – JSapkota Mar 8 '17 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. – Jack Douglas Mar 8 '17 at 9:15
  • 1
    Why do you want to avoid reset logs? – miracle173 May 26 '17 at 13:45

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 .

| improve this answer | |

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

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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