flashback database

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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/16348200/viewspace-625402/