ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Unable To Turn Off Database Flashback(from metalink)

Unable To Turn Off Database Flashback(from metalink)

原创 Linux操作系统 作者:cqubityj 时间:2008-01-03 13:21:02 0 删除 编辑

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.2
This problem can occur on any platform.

Symptoms

there are problems with flashback database, however, unable to turn off flashback database so that
the database can be opened:
SQL> alter database flashback off;

Database altered.

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-38760: This database instance failed to turn on flashback database
.

Cause

there is a restore point in the database

checked v$restore_point
.

Solution

check whether restore points exist:
SQL> select flashback_on from v$database;
SQL> select name from v$restore_point;

If so, drop them:
SQL> drop restore point ;
SQL> alter database flashback off;
SQL> select flashback_on from v$database;
SQL> alter database open;

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/228190/viewspace-85548/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2007-12-19

  • 博文量
    133
  • 访问量
    427340