Oracle Flashback Troubleshooting 10g

1- Oracle flashback troubleshooting
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 areaSolution:
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 databaseClause: 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;