Oracle Solution for Error ora-38783

ORA-38783: Instance recovery required.

What triggered the Error:

An attempt was made to create a restore point when the database is in mount mode but it was not shutdown cleanly before it was mounted. In order to create a restore point when the database is mounted, the database must be shutdown cleanly before it is mounted.

What should we do to fix it:

Consider one of the following: *1. Create the restore point after opening the database. *2. Open the database, shut it down cleanly, mount the database, and retry creating the restore point.