闪回点需要注意的问题-蓝色的天空-51CTO博客
source link: http://blog.51cto.com/shurk/2066381
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
闪回点需要注意的问题
sys@newtestCDB> select * from v$recovery_file_dest;
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
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK