备份与恢复

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

时间:2014-7-9 21:51:39  作者:solgle  来源:www.solgle.com  查看:799  评论:0
内容摘要:今天dataguard主库因FRA满了无法归档,再删除闪回日志后重启报错:ORA-38760: This database instance failed to turn on flashback database下面将如何来解决该问题呢?C:\Users\user>sqlplu...
今天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>

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

solgle.com 版权所有,欢迎分享!!!

相关评论
   Copyright © 2013-2020 solgle.com,All rights reserved.[solgle.com] 公安机关备案号:51010802000219
Email:solgle@solgle.com; weixin:cd1008610000 ICP:蜀ICP备14011070号-1