ora 38706 ora 38714 (flashback on)

For these error the database must be shutdown cleanly and then startup mount..

STEPS:

[oracle@localhost ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Dec 23 09:02:00 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup mount

ORACLE instance started.

Total System Global Area  188743680 bytes

Fixed Size                  1218436 bytes

Variable Size              79693948 bytes

Database Buffers          104857600 bytes

Redo Buffers                2973696 bytes

Database mounted.

SQL> alter database archivelog;

Database altered.

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.

SQL> shutdown immediate

ORA-01109: database not open

Database dismounted.

ORACLE instance shut down.

SQL> startup mount

ORACLE instance started.

Total System Global Area  188743680 bytes

Fixed Size                  1218436 bytes

Variable Size              79693948 bytes

Database Buffers          104857600 bytes

Redo Buffers                2973696 bytes

Database mounted.

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.

SQL> shutdown

ORA-01109: database not open

Database dismounted.

ORACLE instance shut down.

SQL> startup mount

ORACLE instance started.

Total System Global Area  188743680 bytes

Fixed Size                  1218436 bytes

Variable Size              79693948 bytes

Database Buffers          104857600 bytes

Redo Buffers                2973696 bytes

Database mounted.

SQL> alter database open;

Database altered.

SQL> shutdown

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup mount

ORACLE instance started.

Total System Global Area  188743680 bytes

Fixed Size                  1218436 bytes

Variable Size              79693948 bytes

Database Buffers          104857600 bytes

Redo Buffers                2973696 bytes

Database mounted.

SQL> alter database flashback on;

Database altered.

SQL>