Shulou(Shulou.com)06/01 Report--

Sys@newtestCDB > select * from v$recovery_file_dest

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

Query flashback point

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

Delete flashback point

Sys@CLONEPDB_PLUGPDB > drop restore point CLONEPDB_PLUG_20180122

The restore point has been deleted.

And then alter database flashback off

Clear flashback directory

Sys@newtestCDB > select flashback_on from v$database

FLASHBACK_ON

NO

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.