Thursday, May 15, 2008

Flashback ON fails with ORA-38706 and ORA-38714

Problem Description:
-------------------------

Whenever you tried to enable your database flashback feature it failed with errors.

SQL> alter database flashback on;

alter database flashback on
*
ERROR at line 1:
ORA-38706: Cannot turn on FLASHBACK DATABASE logging.
ORA-38714: Instance recovery required.

Cause of the problem:
-------------------------

The database is abnormally terminated. In Order to Enable the Flashback option the database need to be cleaned shutdown. Enabling flashback database after crash or shutdown abort will lead to this error.

Solution of The Problem:
------------------------------


1.Cleanly Shutdown of your database.

SHUTDOWN
or SHUTDOWN IMMEDIATE
or, SHUTDOWN TRANSACTIONAL


2.Mount the database.

SQL>ALTER DATABASE MOUNT;


3.Enable flashback.
SQL>Alter database flashback on;

4.Open the database.
SQL>ALTER DATABASE OPEN;

1 comment:

  1. Thanks Anonymous! That was my problem, and after opening the database, then cleanly shutting down it worked! Thanks for posting your comment!

    ReplyDelete