[Flashback] ORA-38760 Error Resolution

When the database is startup, it prompts Ora-38760:this database instance failed to turn on flashback database error, which presumably means that the database enabled Flashback database feature failed. This is caused by the fact that the Flash back database feature was turned on before the database, but the backup files for the flashback database were deleted, so the database could not be found when it was opened, causing the database to open.

The workaround is simple: the database flash back to the database feature is deactivated and then enabled for

Sql> Startup
ORACLE instance started.

Total System Global area  784998400 bytes
Fixed Size                  2257352 bytes
Variable Size             478154296 bytes
database buffers          301989888 bytes
Redo buffers 2596864
database bytes.
Ora-38760:this database instance failed to turn on flashback database


sql> ALTER DATABASE flashback off;

Database altered.

Sql> ALTER DATABASE flashback on;

Database altered.

sql> ALTER DATABASE open;

Database altered.