ORA-01153 an Incompatible Media Recovery is Active

The Problem

When running the command ALTER DATABASE OPEN RESETLOGS from an RMAN prompt, I got the error:

                 ORA-01153: an incompatible media recovery is active

I then tried from SQL Plus but got the same message.

The Solution

The solution was to close the RMAN session that I had open and then run the command in SQLPlus. So, the idea is to make sure that all RMAN connections have been closed before running these commands.

Like it, share it...

Category: Database Config

Related Posts

Leave a Reply

Your email address will not be published. Required fields are marked *