PDB Flashback Restore Point STORAGE
DEV2 6T DEV 2T 但是差不多一月 DEV2的 GRP 产生的 Flashback log 为0.
重新创建后就开始增长了。
730660427 DEV 2358
1132880776 DEV3 4148
2979909802 DEV2 6496
数据库Flashback Restore Point大小
INCARNA CREATED GUARANT GRPNAME STORAGE_SIZE_GB PDB CLE CON_NAME
---------- ---------- ------- -------------------- --------------- --- --- ---------------
2 2024-02-05 YES _20240205_DEV 15374 YES NO DEV
2 2024-02-05 YES _20240205_DEV2 0 YES NO DEV2
2 2024-02-05 YES _20240205_DEV3 0 YES NO DEV3
SYS@idev1> select * from v$restore_point;
TIME_SINCE
LAST_BACKUP
SCN DATABASE_INCARNATION# GUA STORAGE_SIZE (HOURS)
---------- --------------------- --- ------------ ---------------------------------------------------------------------------
RESTORE_POINT_TIME PRE NAME PDB CLE PDB_INCARNATION# REP
--------------------------------------------------------------------------- --- ------------------------------------ --- --- ---------------- ---
CON_ID
----------
8495061543 2 YES 0 05-FEB-24 12.54.01.000000000 AM
YES _20240205_DEV2 YES NO 0 NO
4
8494661050 2 YES 0 05-FEB-24 12.48.53.000000000 AM
YES _20240205_DEV3 YES NO 0 NO
12
8495640442 2 YES 2.1036E+13 05-FEB-24 12.55.17.000000000 AM
YES _20240205_DEV YES NO 0 NO
15
SYS@idev1> CREATE restore point DEV2_2024022814 for pluggable database DEV2 guarantee flashback database;
Restore point created.
SYS@idev1> select *from v$restore_point;
TIME_SINCE
LAST_BACKUP
SCN DATABASE_INCARNATION# GUA STORAGE_SIZE (HOURS)
---------- --------------------- --- ------------ ---------------------------------------------------------------------------
RESTORE_POINT_TIME PRE NAME PDB CLE PDB_INCARNATION# REP
--------------------------------------------------------------------------- --- ------------------------------------ --- --- ---------------- ---
CON_ID
----------
9698663949 2 YES 6291456000 28-FEB-24 02.54.47.000000000 PM
YES DEV2_2024022814 YES NO 0 NO
4
SYS@idev1> /
TIME_SINCE
LAST_BACKUP
SCN DATABASE_INCARNATION# GUA STORAGE_SIZE (HOURS)
---------- --------------------- --- ------------ ---------------------------------------------------------------------------
RESTORE_POINT_TIME PRE NAME PDB CLE PDB_INCARNATION# REP
--------------------------------------------------------------------------- --- ------------------------------------ --- --- ---------------- ---
CON_ID
----------
9698663949 2 YES 1.0486E+10 28-FEB-24 02.54.47.000000000 PM
YES DEV2_2024022814 YES NO 0 NO
4
1 row selected.
SYS@idev1> /
TIME_SINCE
LAST_BACKUP
SCN DATABASE_INCARNATION# GUA STORAGE_SIZE (HOURS)
---------- --------------------- --- ------------ ---------------------------------------------------------------------------
RESTORE_POINT_TIME PRE NAME PDB CLE PDB_INCARNATION# REP
--------------------------------------------------------------------------- --- ------------------------------------ --- --- ---------------- ---
CON_ID
----------
9698663949 2 YES 1.0486E+10 28-FEB-24 02.54.47.000000000 PM
YES DEV2_2024022814 YES NO 0 NO
4
1 row selected.
SYS@idev1> /
TIME_SINCE
LAST_BACKUP
SCN DATABASE_INCARNATION# GUA STORAGE_SIZE (HOURS)
---------- --------------------- --- ------------ ---------------------------------------------------------------------------
RESTORE_POINT_TIME PRE NAME PDB CLE PDB_INCARNATION# REP
--------------------------------------------------------------------------- --- ------------------------------------ --- --- ---------------- ---
CON_ID
----------
9698663949 2 YES 2.7263E+10 28-FEB-24 02.54.47.000000000 PM
YES DEV2_2024022814 YES NO 0 NO
4
1 row selected.
