|
- select * from v$recovery_area_usage;
- select * from V$FLASH_RECOVERY_AREA_USAGE;
- select * from dict where table_name like '%USAGE%';
复制代码 RMAN> list backup;
List of Backup Sets
===================
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
21 105.50M SBT_TAPE 00:00:16 20-APR-18
BP Key: 21 Status: AVAILABLE Compressed: NO Tag: TAG20180420T194942
Handle: 0vt0r8mm_1_1 Media: station90-000008
List of Archived Logs in backup set 21
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 14 2226230 18-APR-18 2233678 18-APR-18
1 15 2233678 18-APR-18 2237170 18-APR-18
1 16 2237170 18-APR-18 2243200 19-APR-18
1 17 2243200 19-APR-18 2250742 19-APR-18
1 18 2250742 19-APR-18 2258342 19-APR-18
1 19 2258342 19-APR-18 2262931 19-APR-18
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
22 95.75M SBT_TAPE 00:00:24 20-APR-18
BP Key: 22 Status: AVAILABLE Compressed: NO Tag: TAG20180420T194942
Handle: 10t0r8mm_1_1 Media: station90-000009
List of Archived Logs in backup set 22
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 20 2262931 19-APR-18 2270112 19-APR-18
1 21 2270112 19-APR-18 2276656 19-APR-18
1 22 2276656 19-APR-18 2282001 19-APR-18
1 23 2282001 19-APR-18 2286285 20-APR-18
1 24 2286285 20-APR-18 2291990 20-APR-18
1 25 2291990 20-APR-18 2298312 20-APR-18
1 26 2298312 20-APR-18 2301181 20-APR-18
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
23 1.25M SBT_TAPE 00:00:16 20-APR-18
BP Key: 23 Status: AVAILABLE Compressed: NO Tag: TAG20180420T194942
Handle: 11t0r8ng_1_1 Media: station90-000008
List of Archived Logs in backup set 23
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 27 2301181 20-APR-18 2302111 20-APR-18
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
24 Full 9.75M SBT_TAPE 00:00:16 20-APR-18
BP Key: 24 Status: AVAILABLE Compressed: NO Tag: TAG20180420T195034
Handle: c-1343950367-20180420-00 Media: station90-000008
SPFILE Included: Modification time: 20-APR-18
SPFILE db_unique_name: ORCL
Control File Included: Ckp SCN: 2302191 Ckp time: 20-APR-18
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
25 256.00K SBT_TAPE 00:00:15 20-APR-18
BP Key: 25 Status: AVAILABLE Compressed: NO Tag: TAG20180420T195458
Handle: 14t0r90i_1_1 Media: station90-000008
List of Archived Logs in backup set 25
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 29 2302554 20-APR-18 2302561 20-APR-18
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
26 512.00K SBT_TAPE 00:00:16 20-APR-18
BP Key: 26 Status: AVAILABLE Compressed: NO Tag: TAG20180420T195458
Handle: 13t0r90i_1_1 Media: station90-000009
List of Archived Logs in backup set 26
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 28 2302111 20-APR-18 2302554 20-APR-18
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27 Full 9.75M SBT_TAPE 00:00:17 20-APR-18
BP Key: 27 Status: AVAILABLE Compressed: NO Tag: TAG20180420T195524
Handle: c-1343950367-20180420-01 Media: station90-000008
SPFILE Included: Modification time: 20-APR-18
SPFILE db_unique_name: ORCL
Control File Included: Ckp SCN: 2302588 Ckp time: 20-APR-18
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
28 Full 69.58M DISK 00:00:00 20-APR-18
BP Key: 28 Status: AVAILABLE Compressed: NO Tag: TAG20180420T200922
Piece Name: /home/oracle/example.bkp
List of Datafiles in backup set 28
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
5 Full 2303895 20-APR-18 +DATA/orcl/datafile/example.262.973682055
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
29 Full 9.67M DISK 00:00:01 20-APR-18
BP Key: 29 Status: AVAILABLE Compressed: NO Tag: TAG20180420T200923
Piece Name: +FRA/orcl/autobackup/2018_04_20/s_973973363.312.973973363
SPFILE Included: Modification time: 20-APR-18
SPFILE db_unique_name: ORCL
Control File Included: Ckp SCN: 2303901 Ckp time: 20-APR-18
RMAN> backup backupset 28 force delete input;
Starting backup at 20-APR-18
allocated channel: ORA_SBT_TAPE_1
channel ORA_SBT_TAPE_1: SID=80 device type=SBT_TAPE
channel ORA_SBT_TAPE_1: Oracle Secure Backup
allocated channel: ORA_SBT_TAPE_2
channel ORA_SBT_TAPE_2: SID=18 device type=SBT_TAPE
channel ORA_SBT_TAPE_2: Oracle Secure Backup
channel ORA_SBT_TAPE_1: input backup set: count=38, stamp=973973362, piece=1
channel ORA_SBT_TAPE_1: starting piece 1 at 20-APR-18
channel ORA_SBT_TAPE_1: backup piece /home/oracle/example.bkp
piece handle=16t0r9ri_1_2 comment=API Version 2.0,MMS Version 10.4.0.4
channel ORA_SBT_TAPE_1: finished piece 1 at 20-APR-18
channel ORA_SBT_TAPE_1: backup piece complete, elapsed time: 00:00:25
deleted backup piece
backup piece handle=/home/oracle/example.bkp RECID=28 STAMP=973973362
Finished backup at 20-APR-18
Starting Control File and SPFILE Autobackup at 20-APR-18
piece handle=c-1343950367-20180420-03 comment=API Version 2.0,MMS Version 10.4.0.4
Finished Control File and SPFILE Autobackup at 20-APR-18
RMAN> list backup;
List of Backup Sets
===================
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
21 105.50M SBT_TAPE 00:00:16 20-APR-18
BP Key: 21 Status: AVAILABLE Compressed: NO Tag: TAG20180420T194942
Handle: 0vt0r8mm_1_1 Media: station90-000008
List of Archived Logs in backup set 21
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 14 2226230 18-APR-18 2233678 18-APR-18
1 15 2233678 18-APR-18 2237170 18-APR-18
1 16 2237170 18-APR-18 2243200 19-APR-18
1 17 2243200 19-APR-18 2250742 19-APR-18
1 18 2250742 19-APR-18 2258342 19-APR-18
1 19 2258342 19-APR-18 2262931 19-APR-18
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
22 95.75M SBT_TAPE 00:00:24 20-APR-18
BP Key: 22 Status: AVAILABLE Compressed: NO Tag: TAG20180420T194942
Handle: 10t0r8mm_1_1 Media: station90-000009
List of Archived Logs in backup set 22
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 20 2262931 19-APR-18 2270112 19-APR-18
1 21 2270112 19-APR-18 2276656 19-APR-18
1 22 2276656 19-APR-18 2282001 19-APR-18
1 23 2282001 19-APR-18 2286285 20-APR-18
1 24 2286285 20-APR-18 2291990 20-APR-18
1 25 2291990 20-APR-18 2298312 20-APR-18
1 26 2298312 20-APR-18 2301181 20-APR-18
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
23 1.25M SBT_TAPE 00:00:16 20-APR-18
BP Key: 23 Status: AVAILABLE Compressed: NO Tag: TAG20180420T194942
Handle: 11t0r8ng_1_1 Media: station90-000008
List of Archived Logs in backup set 23
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 27 2301181 20-APR-18 2302111 20-APR-18
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
24 Full 9.75M SBT_TAPE 00:00:16 20-APR-18
BP Key: 24 Status: AVAILABLE Compressed: NO Tag: TAG20180420T195034
Handle: c-1343950367-20180420-00 Media: station90-000008
SPFILE Included: Modification time: 20-APR-18
SPFILE db_unique_name: ORCL
Control File Included: Ckp SCN: 2302191 Ckp time: 20-APR-18
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
25 256.00K SBT_TAPE 00:00:15 20-APR-18
BP Key: 25 Status: AVAILABLE Compressed: NO Tag: TAG20180420T195458
Handle: 14t0r90i_1_1 Media: station90-000008
List of Archived Logs in backup set 25
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 29 2302554 20-APR-18 2302561 20-APR-18
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
26 512.00K SBT_TAPE 00:00:16 20-APR-18
BP Key: 26 Status: AVAILABLE Compressed: NO Tag: TAG20180420T195458
Handle: 13t0r90i_1_1 Media: station90-000009
List of Archived Logs in backup set 26
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 28 2302111 20-APR-18 2302554 20-APR-18
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27 Full 9.75M SBT_TAPE 00:00:17 20-APR-18
BP Key: 27 Status: AVAILABLE Compressed: NO Tag: TAG20180420T195524
Handle: c-1343950367-20180420-01 Media: station90-000008
SPFILE Included: Modification time: 20-APR-18
SPFILE db_unique_name: ORCL
Control File Included: Ckp SCN: 2302588 Ckp time: 20-APR-18
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
28 Full 69.58M SBT_TAPE 00:00:00 20-APR-18
BP Key: 30 Status: AVAILABLE Compressed: NO Tag: TAG20180420T200922
Handle: 16t0r9ri_1_2 Media: station90-000008
List of Datafiles in backup set 28
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
5 Full 2303895 20-APR-18 +DATA/orcl/datafile/example.262.973682055
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
29 Full 9.67M DISK 00:00:01 20-APR-18
BP Key: 29 Status: AVAILABLE Compressed: NO Tag: TAG20180420T200923
Piece Name: +FRA/orcl/autobackup/2018_04_20/s_973973363.312.973973363
SPFILE Included: Modification time: 20-APR-18
SPFILE db_unique_name: ORCL
Control File Included: Ckp SCN: 2303901 Ckp time: 20-APR-18
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
30 Full 9.75M SBT_TAPE 00:00:15 20-APR-18
BP Key: 31 Status: AVAILABLE Compressed: NO Tag: TAG20180420T201104
Handle: c-1343950367-20180420-03 Media: station90-000008
SPFILE Included: Modification time: 20-APR-18
SPFILE db_unique_name: ORCL
Control File Included: Ckp SCN: 2304001 Ckp time: 20-APR-18
---------------------------------------------------
retention policy 为1 days:
T工作时间18:00PM(做了全库备份1)-->
T+1凌晨的T23:59-T+1的00:00(report need backup不需备份,不可能去研究report obsolete,因为只有一份的备份)-->
T+1工作时间9:00AM(做了全库备份2,report need backup不需备份,report obsolete没有输出)-->
T+1满24小时18:00PM(report obsolete还是没有输出,因为现在只能靠全库备份1; report need back也没有输出,这时候对备份2而言还不够24小时)-->
T+2凌晨T+1的23:59-T+2的00:00(report need backup 没有输出, 面对备份2而言只是过了半天)-->
T+2满24小时9:00AM(report obsolete备份1全部obsolete,面对备份2而言24小时)-->
T+3凌晨T+2的23:59-T+3的00:00(report need backup , 面对备份2而言过了24小时+半天,建议要做备份3)
----------------------------------------------------
retention policy 为1 days,对于备份优化而言:
T工作时间18:00PM只读users表空间,并做全库备份A
T另外一个工作时间19:00全库备份B会跳过users表空间。
T+1凌晨的T23:59-T+1的00:00全库备份C又会开始备份users表空间。
|
|