ITPub博客

首页 > Linux操作系统 > Linux操作系统 > flashback database

flashback database

原创 Linux操作系统 作者:mambo_shen 时间:2010-01-18 20:53:02 0 删除 编辑

SQL> select trans_id,store_id from trans where trans_id=1085;

 

  TRANS_ID   STORE_ID

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

      1085         85

 

SQL> select flashback_on from V$database;

 

FLASHBACK_ON

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

RESTORE POINT ONLY

 

SQL> flashback database  TO RESTORE POINT good_data_75;

flashback database  TO RESTORE POINT good_data_75

*

ERROR at line 1:

ORA-01031: insufficient privileges

 

$ sqlplus  "/as sysdba"

 

SQL> startup force mount;

 

SQL> flashback database  TO RESTORE POINT good_data_75;

 

SQL> alter database open resetlogs;

 

SQL> select trans_id,store_id from mambo.trans where trans_id=1085;

 

  TRANS_ID   STORE_ID

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

      1085         75

 

SQL> startup force mount;

 

SQL> flashback database  TO RESTORE POINT good_data_65;

flashback database  TO RESTORE POINT good_data_65

*

ERROR at line 1:

ORA-38782: cannot flashback database to non-guaranteed restore point 'GOOD_DATA_65'

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

上一篇: flashback table
下一篇: Normal EM user add job
请登录后发表评论 登录
全部评论

注册时间:2008-10-09

  • 博文量
    86
  • 访问量
    74051