Oracle Error Message
ORA-38783: Instance recovery required.
Reason for 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.
Solution
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.