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

今天dataguard主库因FRA满了无法归档，再删除闪回日志后重启报错：
ORA-38760: This database instance failed to turn on flashback database
下面将如何来解决该问题呢？
本文出自：http://www.solgle.com/news/?137.html

C:\Users\user>sqlplus sys/********@os_solgle as sysdba

 

SQL*Plus: Release 11.2.0.1.0 Production on Mon Sep 29 10:35:35 2014

 

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

 

Connected to an idle instance.

 

SQL> startup

ORACLE instance started.

 

Total System Global Area 1252663296 bytes

Fixed Size                  2252824 bytes

Variable Size             838864872 bytes

Database Buffers          402653184 bytes

Redo Buffers                8892416 bytes

Database mounted.

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

 

 

SQL> show paramter sga

SP2-0158: unknown SHOW option "paramter"

 

Total System Global Area 1252663296 bytes

Fixed Size                  2252824 bytes

Variable Size             838864872 bytes

Database Buffers          402653184 bytes

Redo Buffers                8892416 bytes

SQL> select open_mode from v$database;

 

OPEN_MODE

--------------------

MOUNTED

 

SQL> show parameter db_recovery

 

NAME                                 TYPE

------------------------------------ --------------------------------

VALUE

------------------------------

db_recovery_file_dest                string

/u01/data/bak_data

db_recovery_file_dest_size           big integer

15G

SQL> alter system set db_recovery_file_dest='/u01/data2' scope=both;

 

System altered.

 

SQL> alter database open;

alter database open

*

ERROR at line 1:

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

 

 

SQL> alter database off;

alter database off

                 *

ERROR at line 1:

ORA-02231: missing or invalid option to ALTER DATABASE

 

 

SQL> alter database flashback off;

 

Database altered.

 

SQL> alter database flashback on;

alter database flashback on

*

ERROR at line 1:

ORA-38706: Cannot turn on FLASHBACK DATABASE logging.

 

 

SQL> alter database open;

alter database open

*

ERROR at line 1:

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

 

---难道要同步删除曾创建的还原点

SQL> select name from v$restore_point;

 

NAME

--------------------------------------------------------------------------------

P1

 

SQL> drop restore point p1;

 

Restore point dropped.

 

SQL> alter database flashback on;

 

Database altered.

 

SQL> alter database open;

 

Database altered.

 

SQL>

 

 

主库倒是恢复了，但是备份库没有同步更新

下面启动服务

 

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

 

SQL> alter database start logical standby apply immediate;

 

Database altered.

 

SQL>