闪回点需要注意的问题

sys@newtestCDB> select * from v$recovery_file_dest;

成都创新互联专业成都做网站、成都网站制作，集网站策划、网站设计、网站制作于一体，网站seo、网站优化、网站营销、软文平台等专业人才根据搜索规律编程设计，让网站在运行后，在搜索中有好的表现，专业设计制作为您带来效益的网站！让网站建设为您创造效益。

NAME

SPACE_LIMIT SPACE_USED SPACE_RECLAIMABLE NUMBER_OF_FILES CON_ID

---

C:\app\Administrator\virtual\FlashRecovery
3145728000 3133800448 0 35 0

Elapsed: 00:00:00.06
sys@newtestCDB> SELECT * FROM V$RMAN_STATUS where STATUS LIKE 'RUNNING%'
2 ;

   SID      RECID      STAMP PARENT_RECID PARENT_STAMP SESSION_RECID SESSION_STAMP  ROW_LEVEL

---

ROW_TYPE COMMAND_ID OPERATION

---

STATUS MBYTES_PROCESSED START_TIME END_TIME INPUT_BYTES

---

OUTPUT_BYTES OPT OBJECT_TYPE OUTPUT_DEVICE_TYP OSB CON_ID

---

    26         49  966690363           48    966690330            48     966690330          1

COMMAND 2018-01-29T13:05:29 BACKUP
RUNNING 0 2018-01-29 13:06:03 2018-01-29 13:13:44 0
0 NO DB FULL NO 0

   SID      RECID      STAMP PARENT_RECID PARENT_STAMP SESSION_RECID SESSION_STAMP  ROW_LEVEL

---

ROW_TYPE COMMAND_ID OPERATION

---

STATUS MBYTES_PROCESSED START_TIME END_TIME INPUT_BYTES

---

OUTPUT_BYTES OPT OBJECT_TYPE OUTPUT_DEVICE_TYP OSB CON_ID

---

    76         47  966689991           46    966689985            46     966689985          1

COMMAND 2018-01-29T12:59:30 BACKUP
RUNNING 0 2018-01-29 12:59:51 2018-01-29 13:13:44 0
0 NO DB FULL NO 0

   SID      RECID      STAMP PARENT_RECID PARENT_STAMP SESSION_RECID SESSION_STAMP  ROW_LEVEL

---

ROW_TYPE COMMAND_ID OPERATION

---

STATUS MBYTES_PROCESSED START_TIME END_TIME INPUT_BYTES

---

OUTPUT_BYTES OPT OBJECT_TYPE OUTPUT_DEVICE_TYP OSB CON_ID

---

    76         46  966689985                                      46     966689985          0

SESSION 2018-01-29T12:59:30 RMAN
RUNNING 0 2018-01-29 12:59:45 2018-01-29 13:13:44 0
0 NO NO 0

   SID      RECID      STAMP PARENT_RECID PARENT_STAMP SESSION_RECID SESSION_STAMP  ROW_LEVEL

---

ROW_TYPE COMMAND_ID OPERATION

---

STATUS MBYTES_PROCESSED START_TIME END_TIME INPUT_BYTES

---

OUTPUT_BYTES OPT OBJECT_TYPE OUTPUT_DEVICE_TYP OSB CON_ID

---

    26         48  966690330                                      48     966690330          0

SESSION 2018-01-29T13:05:29 RMAN
RUNNING 0 2018-01-29 13:05:30 2018-01-29 13:13:44 0
0 NO NO 0

Elapsed: 00:00:00.13
查询闪回点
SQL> select * from v$restore_point;

   SCN DATABASE_INCARNATION# GUARANTEE_FLASHBACK_DATABASE STORAGE_SIZE TIME                                                                             RESTORE_POINT_TIME                                                               PRESERVED NAME                                                                             PDB_RESTORE_POINT CLEAN_PDB_RESTORE_POINT PDB_INCARNATION#     CON_ID

---

6737077 3 YES 3211624448 22-JAN-18 11.03.02.000000000 AM YES CLONEPDB_PLUG_20180122 YES NO 0 4
删除闪回点
sys@CLONEPDB_PLUGPDB> drop restore point CLONEPDB_PLUG_20180122;

还原点已删除。
然后alter database flashback off;
清除闪回目录
sys@newtestCDB> select flashback_on from v$database;

FLASHBACK_ON

NO

网站标题：闪回点需要注意的问题
本文来源：http://bzwzjz.com/article/jigoch.html