Oracle Flashback Troubleshooting

Oracle flashback troubleshooting

1.

SQL> alter database flashback on;

alter database flashback on

*

ERROR at line 1:

ORA-38706: Cannot turn on FLASHBACK DATABASE logging.

ORA-38709: Recovery Area is not enabled.

Cause: Flashback log file are created only in FLASH RECOVERY AREA then must be DB_RECOVERY_FILE_DEST parameter for flashback recovery area

Solution:

SQL> alter system set db_recovery_file_dest='location';
SQL> alter database flashback on;

2.

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.

Cluase: Database is not cleaning shutdown, database shutdown must be NORMAL, IMMEDIATE or TRANSACTIONAL;

Solution:

SQL> alter database open; (becuase currently database is in mount stage)

SQL> SHUTDOWN NORMAL

SQL> STARTUP MOUNT

SQL> ALTER DATABASE FLASHBACK ON;

SQL> ALTER DATABASE OPEN;

3.

SQL> startup

ORACLE instance started.
[output cut]

Database mounted.

ORA-38760: This database instance failed to turn on flashback database

Clause: Flashback file is not accessiable or missing or lost

NOTE: check alertlog file for more info

Solution:

SQL> alter database flashback off;

SQL> alter database flashback on;

SQL> alter database open;