RMAN> list expired backup;
List of Backup Sets
===================
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
2297 40.10M DISK 00:00:06 04-JUN-18
BP Key: 2297 Status: EXPIRED Compressed: YES Tag: TAG20180604T060009
Piece Name: /u01/backup/rman/Archive_20180604_8mt4j1b9_1_1
List of Archived Logs in backup set 2297
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 6532 402175065 03-JUN-18 402182665 03-JUN-18
1 6533 402182665 03-JUN-18 402184602 03-JUN-18
1 6534 402184602 03-JUN-18 402209348 03-JUN-18
1 6535 402209348 03-JUN-18 402209356 03-JUN-18
1 6536 402209356 03-JUN-18 402226169 03-JUN-18
1 6537 402226169 03-JUN-18 402226177 03-JUN-18
1 6538 402226177 03-JUN-18 402267539 04-JUN-18
1 6539 402267539 04-JUN-18 402270657 04-JUN-18
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2298 Full 1.10G DISK 00:03:51 04-JUN-18
BP Key: 2298 Status: EXPIRED Compressed: YES Tag: TAG20180604T060016
Piece Name: /u01/backup/rman/Fullback_20180604_8nt4j1bh_1_1
List of Datafiles in backup set 2298
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 402270665 04-JUN-18 /u01/app/oracle/oradata/orcl/system01.dbf
2 Full 402270665 04-JUN-18 /u01/app/oracle/oradata/orcl/sysaux01.dbf
3 Full 402270665 04-JUN-18 /u01/app/oracle/oradata/orcl/undotbs01.dbf
4 Full 402270665 04-JUN-18 /u01/app/oracle/oradata/orcl/users01.dbf
5 Full 402270665 04-JUN-18 /u01/app/oracle/oradata/orcl/example01.dbf
6 Full 402270665 04-JUN-18 /u01/app/oracle/oradata/orcl/MX_DATA15X.dbf
7 Full 402270665 04-JUN-18 /u01/app/oracle/oradata/orcl/MX_INDEX15X.dbf
8 Full 402270665 04-JUN-18 /u01/app/oracle/oradata/orcl/dash_TS01.DBF
9 Full 402270665 04-JUN-18 /u01/app/oracle/oradata/orcl/dashadmin_TS01.DBF
10 Full 402270665 04-JUN-18 /u01/app/oracle/oradata/orcl/iam_TS01.DBF
11 Full 402270665 04-JUN-18 /u01/app/oracle/oradata/orcl/iam_admin_TS01.DBF
12 Full 402270665 04-JUN-18 /u01/app/oracle/oradata/orcl/cas_TS01.DBF
13 Full 402270665 04-JUN-18 /u01/app/oracle/oradata/orcl/users02.dbf
14 Full 402270665 04-JUN-18 /u01/app/oracle/oradata/orcl/dashadmin_TS02.DBF
15 Full 402270665 04-JUN-18 /u01/app/oracle/oradata/orcl/dash_TS02.dbf
16 Full 402270665 04-JUN-18 /u01/app/oracle/oradata/orcl/iam_TS02.dbf
17 Full 402270665 04-JUN-18 /u01/app/oracle/oradata/orcl/iam_TS03.dbf
18 Full 402270665 04-JUN-18 /u01/app/oracle/oradata/orcl/iam_admin_TS02.dbf
19 Full 402270665 04-JUN-18 /u01/app/oracle/oradata/orcl/MX_DATA15X1.dbf
20 Full 402270665 04-JUN-18 /u01/app/oracle/oradata/orcl/MX_INDEX15X1.dbf
21 Full 402270665 04-JUN-18 /u01/app/oracle/oradata/orcl/cas_TS02.dbf
22 Full 402270665 04-JUN-18 /u01/app/oracle/oradata/orcl/sysaux02.dbf
23 Full 402270665 04-JUN-18 /u01/app/oracle/oradata/orcl/system02.dbf
24 Full 402270665 04-JUN-18 /u01/app/oracle/oradata/R2015X/MX_DATA15X.dbf
25 Full 402270665 04-JUN-18 /u01/app/oracle/oradata/R2015X/MX_INDEX15X.dbf
26 Full 402270665 04-JUN-18 /u01/app/oracle/oradata/orcl/MX_V6DATA15X.dbf
27 Full 402270665 04-JUN-18 /u01/app/oracle/oradata/orcl/MX_V6INDEX15X.dbf
28 Full 402270665 04-JUN-18 /u01/app/oracle/oradata/orcl/system03.dbf
29 Full 402270665 04-JUN-18 /u01/app/oracle/oradata/orcl/sysaux03.dbf
30 Full 402270665 04-JUN-18 /u01/app/oracle/oradata/orcl/MX_INDEX15X02.dbf
31 Full 402270665 04-JUN-18 /u01/app/oracle/oradata/orcl/MX_DATA15X02.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2299 Full 1.14M DISK 00:00:01 04-JUN-18
BP Key: 2299 Status: EXPIRED Compressed: YES Tag: TAG20180604T060016
Piece Name: /u01/backup/rman/Fullback_20180604_8ot4j1it_1_1
SPFILE Included: Modification time: 21-MAR-18
SPFILE db_unique_name: ORCL
Control File Included: Ckp SCN: 402270979 Ckp time: 04-JUN-18
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
2300 379.00K DISK 00:00:00 04-JUN-18
BP Key: 2300 Status: EXPIRED Compressed: YES Tag: TAG20180604T060415
Piece Name: /u01/backup/rman/Archive_20180604_8pt4j1j0_1_1
List of Archived Logs in backup set 2300
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 6540 402270657 04-JUN-18 402270985 04-JUN-18
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2301 Full 9.70M DISK 00:00:01 04-JUN-18
BP Key: 2301 Status: EXPIRED Compressed: NO Tag: TAG20180604T060417
Piece Name: /u01/backup/rman/Controlback_20180604_8qt4j1j1_1_1
Control File Included: Ckp SCN: 402270994 Ckp time: 04-JUN-18
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
2302 5.79M DISK 00:00:00 04-JUN-18
BP Key: 2302 Status: EXPIRED Compressed: YES Tag: TAG20180604T133004
Piece Name: /u01/backup/rman/ORCL_20180604_2331_archive
List of Archived Logs in backup set 2302
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 6541 402270985 04-JUN-18 402292372 04-JUN-18
1 6542 402292372 04-JUN-18 402292380 04-JUN-18
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2303 Full 9.70M DISK 00:00:01 04-JUN-18
BP Key: 2303 Status: EXPIRED Compressed: NO Tag: TAG20180604T133009
Piece Name: /u01/backup/rman/ORCL_20180604_2332_controlback
Control File Included: Ckp SCN: 402292397 Ckp time: 04-JUN-18
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
2304 3.50M DISK 00:00:01 04-JUN-18
BP Key: 2304 Status: EXPIRED Compressed: YES Tag: TAG20180604T180005
Piece Name: /u01/backup/rman/ORCL_20180604_2333_archive
List of Archived Logs in backup set 2304
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 6543 402292380 04-JUN-18 402304444 04-JUN-18
1 6544 402304444 04-JUN-18 402304452 04-JUN-18
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2305 Full 9.70M DISK 00:00:01 04-JUN-18
BP Key: 2305 Status: EXPIRED Compressed: NO Tag: TAG20180604T180007
Piece Name: /u01/backup/rman/ORCL_20180604_2334_controlback
Control File Included: Ckp SCN: 402304468 Ckp time: 04-JUN-18
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
2306 41.27M DISK 00:00:07 05-JUN-18
BP Key: 2306 Status: EXPIRED Compressed: YES Tag: TAG20180605T060008
Piece Name: /u01/backup/rman/Archive_20180605_8vt4lln8_1_1
List of Archived Logs in backup set 2306
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 6539 402267539 04-JUN-18 402270657 04-JUN-18
1 6540 402270657 04-JUN-18 402270985 04-JUN-18
1 6541 402270985 04-JUN-18 402292372 04-JUN-18
1 6542 402292372 04-JUN-18 402292380 04-JUN-18
1 6543 402292380 04-JUN-18 402304444 04-JUN-18
1 6544 402304444 04-JUN-18 402304452 04-JUN-18
1 6545 402304452 04-JUN-18 402315665 04-JUN-18
1 6546 402315665 04-JUN-18 402343367 05-JUN-18
1 6547 402343367 05-JUN-18 402345893 05-JUN-18
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2307 Full 1.11G DISK 00:03:49 05-JUN-18
BP Key: 2307 Status: EXPIRED Compressed: YES Tag: TAG20180605T060024
Piece Name: /u01/backup/rman/Fullback_20180605_90t4llno_1_1
List of Datafiles in backup set 2307
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 402345904 05-JUN-18 /u01/app/oracle/oradata/orcl/system01.dbf
2 Full 402345904 05-JUN-18 /u01/app/oracle/oradata/orcl/sysaux01.dbf
3 Full 402345904 05-JUN-18 /u01/app/oracle/oradata/orcl/undotbs01.dbf
4 Full 402345904 05-JUN-18 /u01/app/oracle/oradata/orcl/users01.dbf
5 Full 402345904 05-JUN-18 /u01/app/oracle/oradata/orcl/example01.dbf
6 Full 402345904 05-JUN-18 /u01/app/oracle/oradata/orcl/MX_DATA15X.dbf
7 Full 402345904 05-JUN-18 /u01/app/oracle/oradata/orcl/MX_INDEX15X.dbf
8 Full 402345904 05-JUN-18 /u01/app/oracle/oradata/orcl/dash_TS01.DBF
9 Full 402345904 05-JUN-18 /u01/app/oracle/oradata/orcl/dashadmin_TS01.DBF
10 Full 402345904 05-JUN-18 /u01/app/oracle/oradata/orcl/iam_TS01.DBF
11 Full 402345904 05-JUN-18 /u01/app/oracle/oradata/orcl/iam_admin_TS01.DBF
12 Full 402345904 05-JUN-18 /u01/app/oracle/oradata/orcl/cas_TS01.DBF
13 Full 402345904 05-JUN-18 /u01/app/oracle/oradata/orcl/users02.dbf
14 Full 402345904 05-JUN-18 /u01/app/oracle/oradata/orcl/dashadmin_TS02.DBF
15 Full 402345904 05-JUN-18 /u01/app/oracle/oradata/orcl/dash_TS02.dbf
16 Full 402345904 05-JUN-18 /u01/app/oracle/oradata/orcl/iam_TS02.dbf
17 Full 402345904 05-JUN-18 /u01/app/oracle/oradata/orcl/iam_TS03.dbf
18 Full 402345904 05-JUN-18 /u01/app/oracle/oradata/orcl/iam_admin_TS02.dbf
19 Full 402345904 05-JUN-18 /u01/app/oracle/oradata/orcl/MX_DATA15X1.dbf
20 Full 402345904 05-JUN-18 /u01/app/oracle/oradata/orcl/MX_INDEX15X1.dbf
21 Full 402345904 05-JUN-18 /u01/app/oracle/oradata/orcl/cas_TS02.dbf
22 Full 402345904 05-JUN-18 /u01/app/oracle/oradata/orcl/sysaux02.dbf
23 Full 402345904 05-JUN-18 /u01/app/oracle/oradata/orcl/system02.dbf
24 Full 402345904 05-JUN-18 /u01/app/oracle/oradata/R2015X/MX_DATA15X.dbf
25 Full 402345904 05-JUN-18 /u01/app/oracle/oradata/R2015X/MX_INDEX15X.dbf
26 Full 402345904 05-JUN-18 /u01/app/oracle/oradata/orcl/MX_V6DATA15X.dbf
27 Full 402345904 05-JUN-18 /u01/app/oracle/oradata/orcl/MX_V6INDEX15X.dbf
28 Full 402345904 05-JUN-18 /u01/app/oracle/oradata/orcl/system03.dbf
29 Full 402345904 05-JUN-18 /u01/app/oracle/oradata/orcl/sysaux03.dbf
30 Full 402345904 05-JUN-18 /u01/app/oracle/oradata/orcl/MX_INDEX15X02.dbf
31 Full 402345904 05-JUN-18 /u01/app/oracle/oradata/orcl/MX_DATA15X02.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2308 Full 1.14M DISK 00:00:01 05-JUN-18
BP Key: 2308 Status: EXPIRED Compressed: YES Tag: TAG20180605T060024
Piece Name: /u01/backup/rman/Fullback_20180605_91t4llv4_1_1
SPFILE Included: Modification time: 21-MAR-18
SPFILE db_unique_name: ORCL
Control File Included: Ckp SCN: 402346242 Ckp time: 05-JUN-18
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
2309 399.50K DISK 00:00:00 05-JUN-18
BP Key: 2309 Status: EXPIRED Compressed: YES Tag: TAG20180605T060423
Piece Name: /u01/backup/rman/Archive_20180605_92t4llv7_1_1
List of Archived Logs in backup set 2309
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 6548 402345893 05-JUN-18 402346248 05-JUN-18
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2310 Full 9.70M DISK 00:00:02 05-JUN-18
BP Key: 2310 Status: EXPIRED Compressed: NO Tag: TAG20180605T060424
Piece Name: /u01/backup/rman/Controlback_20180605_93t4llv8_1_1
Control File Included: Ckp SCN: 402346257 Ckp time: 05-JUN-18
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
2311 5.80M DISK 00:00:00 05-JUN-18
BP Key: 2311 Status: EXPIRED Compressed: YES Tag: TAG20180605T133005
Piece Name: /u01/backup/rman/ORCL_20180605_2340_archive
List of Archived Logs in backup set 2311
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 6549 402346248 05-JUN-18 402367859 05-JUN-18
1 6550 402367859 05-JUN-18 402367867 05-JUN-18
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2312 Full 9.70M DISK 00:00:01 05-JUN-18
BP Key: 2312 Status: EXPIRED Compressed: NO Tag: TAG20180605T133010
Piece Name: /u01/backup/rman/ORCL_20180605_2341_controlback
Control File Included: Ckp SCN: 402367884 Ckp time: 05-JUN-18
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
2313 4.47M DISK 00:00:01 05-JUN-18
BP Key: 2313 Status: EXPIRED Compressed: YES Tag: TAG20180605T180004
Piece Name: /u01/backup/rman/ORCL_20180605_2342_archive
List of Archived Logs in backup set 2313
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 6551 402367867 05-JUN-18 402382542 05-JUN-18
1 6552 402382542 05-JUN-18 402382550 05-JUN-18
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2314 Full 9.70M DISK 00:00:01 05-JUN-18
BP Key: 2314 Status: EXPIRED Compressed: NO Tag: TAG20180605T180007
Piece Name: /u01/backup/rman/ORCL_20180605_2343_controlback
Control File Included: Ckp SCN: 402382566 Ckp time: 05-JUN-18
RMAN>
List of Backup Sets
===================
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
2297 40.10M DISK 00:00:06 04-JUN-18
BP Key: 2297 Status: EXPIRED Compressed: YES Tag: TAG20180604T060009
Piece Name: /u01/backup/rman/Archive_20180604_8mt4j1b9_1_1
List of Archived Logs in backup set 2297
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 6532 402175065 03-JUN-18 402182665 03-JUN-18
1 6533 402182665 03-JUN-18 402184602 03-JUN-18
1 6534 402184602 03-JUN-18 402209348 03-JUN-18
1 6535 402209348 03-JUN-18 402209356 03-JUN-18
1 6536 402209356 03-JUN-18 402226169 03-JUN-18
1 6537 402226169 03-JUN-18 402226177 03-JUN-18
1 6538 402226177 03-JUN-18 402267539 04-JUN-18
1 6539 402267539 04-JUN-18 402270657 04-JUN-18
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2298 Full 1.10G DISK 00:03:51 04-JUN-18
BP Key: 2298 Status: EXPIRED Compressed: YES Tag: TAG20180604T060016
Piece Name: /u01/backup/rman/Fullback_20180604_8nt4j1bh_1_1
List of Datafiles in backup set 2298
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 402270665 04-JUN-18 /u01/app/oracle/oradata/orcl/system01.dbf
2 Full 402270665 04-JUN-18 /u01/app/oracle/oradata/orcl/sysaux01.dbf
3 Full 402270665 04-JUN-18 /u01/app/oracle/oradata/orcl/undotbs01.dbf
4 Full 402270665 04-JUN-18 /u01/app/oracle/oradata/orcl/users01.dbf
5 Full 402270665 04-JUN-18 /u01/app/oracle/oradata/orcl/example01.dbf
6 Full 402270665 04-JUN-18 /u01/app/oracle/oradata/orcl/MX_DATA15X.dbf
7 Full 402270665 04-JUN-18 /u01/app/oracle/oradata/orcl/MX_INDEX15X.dbf
8 Full 402270665 04-JUN-18 /u01/app/oracle/oradata/orcl/dash_TS01.DBF
9 Full 402270665 04-JUN-18 /u01/app/oracle/oradata/orcl/dashadmin_TS01.DBF
10 Full 402270665 04-JUN-18 /u01/app/oracle/oradata/orcl/iam_TS01.DBF
11 Full 402270665 04-JUN-18 /u01/app/oracle/oradata/orcl/iam_admin_TS01.DBF
12 Full 402270665 04-JUN-18 /u01/app/oracle/oradata/orcl/cas_TS01.DBF
13 Full 402270665 04-JUN-18 /u01/app/oracle/oradata/orcl/users02.dbf
14 Full 402270665 04-JUN-18 /u01/app/oracle/oradata/orcl/dashadmin_TS02.DBF
15 Full 402270665 04-JUN-18 /u01/app/oracle/oradata/orcl/dash_TS02.dbf
16 Full 402270665 04-JUN-18 /u01/app/oracle/oradata/orcl/iam_TS02.dbf
17 Full 402270665 04-JUN-18 /u01/app/oracle/oradata/orcl/iam_TS03.dbf
18 Full 402270665 04-JUN-18 /u01/app/oracle/oradata/orcl/iam_admin_TS02.dbf
19 Full 402270665 04-JUN-18 /u01/app/oracle/oradata/orcl/MX_DATA15X1.dbf
20 Full 402270665 04-JUN-18 /u01/app/oracle/oradata/orcl/MX_INDEX15X1.dbf
21 Full 402270665 04-JUN-18 /u01/app/oracle/oradata/orcl/cas_TS02.dbf
22 Full 402270665 04-JUN-18 /u01/app/oracle/oradata/orcl/sysaux02.dbf
23 Full 402270665 04-JUN-18 /u01/app/oracle/oradata/orcl/system02.dbf
24 Full 402270665 04-JUN-18 /u01/app/oracle/oradata/R2015X/MX_DATA15X.dbf
25 Full 402270665 04-JUN-18 /u01/app/oracle/oradata/R2015X/MX_INDEX15X.dbf
26 Full 402270665 04-JUN-18 /u01/app/oracle/oradata/orcl/MX_V6DATA15X.dbf
27 Full 402270665 04-JUN-18 /u01/app/oracle/oradata/orcl/MX_V6INDEX15X.dbf
28 Full 402270665 04-JUN-18 /u01/app/oracle/oradata/orcl/system03.dbf
29 Full 402270665 04-JUN-18 /u01/app/oracle/oradata/orcl/sysaux03.dbf
30 Full 402270665 04-JUN-18 /u01/app/oracle/oradata/orcl/MX_INDEX15X02.dbf
31 Full 402270665 04-JUN-18 /u01/app/oracle/oradata/orcl/MX_DATA15X02.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2299 Full 1.14M DISK 00:00:01 04-JUN-18
BP Key: 2299 Status: EXPIRED Compressed: YES Tag: TAG20180604T060016
Piece Name: /u01/backup/rman/Fullback_20180604_8ot4j1it_1_1
SPFILE Included: Modification time: 21-MAR-18
SPFILE db_unique_name: ORCL
Control File Included: Ckp SCN: 402270979 Ckp time: 04-JUN-18
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
2300 379.00K DISK 00:00:00 04-JUN-18
BP Key: 2300 Status: EXPIRED Compressed: YES Tag: TAG20180604T060415
Piece Name: /u01/backup/rman/Archive_20180604_8pt4j1j0_1_1
List of Archived Logs in backup set 2300
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 6540 402270657 04-JUN-18 402270985 04-JUN-18
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2301 Full 9.70M DISK 00:00:01 04-JUN-18
BP Key: 2301 Status: EXPIRED Compressed: NO Tag: TAG20180604T060417
Piece Name: /u01/backup/rman/Controlback_20180604_8qt4j1j1_1_1
Control File Included: Ckp SCN: 402270994 Ckp time: 04-JUN-18
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
2302 5.79M DISK 00:00:00 04-JUN-18
BP Key: 2302 Status: EXPIRED Compressed: YES Tag: TAG20180604T133004
Piece Name: /u01/backup/rman/ORCL_20180604_2331_archive
List of Archived Logs in backup set 2302
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 6541 402270985 04-JUN-18 402292372 04-JUN-18
1 6542 402292372 04-JUN-18 402292380 04-JUN-18
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2303 Full 9.70M DISK 00:00:01 04-JUN-18
BP Key: 2303 Status: EXPIRED Compressed: NO Tag: TAG20180604T133009
Piece Name: /u01/backup/rman/ORCL_20180604_2332_controlback
Control File Included: Ckp SCN: 402292397 Ckp time: 04-JUN-18
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
2304 3.50M DISK 00:00:01 04-JUN-18
BP Key: 2304 Status: EXPIRED Compressed: YES Tag: TAG20180604T180005
Piece Name: /u01/backup/rman/ORCL_20180604_2333_archive
List of Archived Logs in backup set 2304
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 6543 402292380 04-JUN-18 402304444 04-JUN-18
1 6544 402304444 04-JUN-18 402304452 04-JUN-18
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2305 Full 9.70M DISK 00:00:01 04-JUN-18
BP Key: 2305 Status: EXPIRED Compressed: NO Tag: TAG20180604T180007
Piece Name: /u01/backup/rman/ORCL_20180604_2334_controlback
Control File Included: Ckp SCN: 402304468 Ckp time: 04-JUN-18
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
2306 41.27M DISK 00:00:07 05-JUN-18
BP Key: 2306 Status: EXPIRED Compressed: YES Tag: TAG20180605T060008
Piece Name: /u01/backup/rman/Archive_20180605_8vt4lln8_1_1
List of Archived Logs in backup set 2306
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 6539 402267539 04-JUN-18 402270657 04-JUN-18
1 6540 402270657 04-JUN-18 402270985 04-JUN-18
1 6541 402270985 04-JUN-18 402292372 04-JUN-18
1 6542 402292372 04-JUN-18 402292380 04-JUN-18
1 6543 402292380 04-JUN-18 402304444 04-JUN-18
1 6544 402304444 04-JUN-18 402304452 04-JUN-18
1 6545 402304452 04-JUN-18 402315665 04-JUN-18
1 6546 402315665 04-JUN-18 402343367 05-JUN-18
1 6547 402343367 05-JUN-18 402345893 05-JUN-18
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2307 Full 1.11G DISK 00:03:49 05-JUN-18
BP Key: 2307 Status: EXPIRED Compressed: YES Tag: TAG20180605T060024
Piece Name: /u01/backup/rman/Fullback_20180605_90t4llno_1_1
List of Datafiles in backup set 2307
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 402345904 05-JUN-18 /u01/app/oracle/oradata/orcl/system01.dbf
2 Full 402345904 05-JUN-18 /u01/app/oracle/oradata/orcl/sysaux01.dbf
3 Full 402345904 05-JUN-18 /u01/app/oracle/oradata/orcl/undotbs01.dbf
4 Full 402345904 05-JUN-18 /u01/app/oracle/oradata/orcl/users01.dbf
5 Full 402345904 05-JUN-18 /u01/app/oracle/oradata/orcl/example01.dbf
6 Full 402345904 05-JUN-18 /u01/app/oracle/oradata/orcl/MX_DATA15X.dbf
7 Full 402345904 05-JUN-18 /u01/app/oracle/oradata/orcl/MX_INDEX15X.dbf
8 Full 402345904 05-JUN-18 /u01/app/oracle/oradata/orcl/dash_TS01.DBF
9 Full 402345904 05-JUN-18 /u01/app/oracle/oradata/orcl/dashadmin_TS01.DBF
10 Full 402345904 05-JUN-18 /u01/app/oracle/oradata/orcl/iam_TS01.DBF
11 Full 402345904 05-JUN-18 /u01/app/oracle/oradata/orcl/iam_admin_TS01.DBF
12 Full 402345904 05-JUN-18 /u01/app/oracle/oradata/orcl/cas_TS01.DBF
13 Full 402345904 05-JUN-18 /u01/app/oracle/oradata/orcl/users02.dbf
14 Full 402345904 05-JUN-18 /u01/app/oracle/oradata/orcl/dashadmin_TS02.DBF
15 Full 402345904 05-JUN-18 /u01/app/oracle/oradata/orcl/dash_TS02.dbf
16 Full 402345904 05-JUN-18 /u01/app/oracle/oradata/orcl/iam_TS02.dbf
17 Full 402345904 05-JUN-18 /u01/app/oracle/oradata/orcl/iam_TS03.dbf
18 Full 402345904 05-JUN-18 /u01/app/oracle/oradata/orcl/iam_admin_TS02.dbf
19 Full 402345904 05-JUN-18 /u01/app/oracle/oradata/orcl/MX_DATA15X1.dbf
20 Full 402345904 05-JUN-18 /u01/app/oracle/oradata/orcl/MX_INDEX15X1.dbf
21 Full 402345904 05-JUN-18 /u01/app/oracle/oradata/orcl/cas_TS02.dbf
22 Full 402345904 05-JUN-18 /u01/app/oracle/oradata/orcl/sysaux02.dbf
23 Full 402345904 05-JUN-18 /u01/app/oracle/oradata/orcl/system02.dbf
24 Full 402345904 05-JUN-18 /u01/app/oracle/oradata/R2015X/MX_DATA15X.dbf
25 Full 402345904 05-JUN-18 /u01/app/oracle/oradata/R2015X/MX_INDEX15X.dbf
26 Full 402345904 05-JUN-18 /u01/app/oracle/oradata/orcl/MX_V6DATA15X.dbf
27 Full 402345904 05-JUN-18 /u01/app/oracle/oradata/orcl/MX_V6INDEX15X.dbf
28 Full 402345904 05-JUN-18 /u01/app/oracle/oradata/orcl/system03.dbf
29 Full 402345904 05-JUN-18 /u01/app/oracle/oradata/orcl/sysaux03.dbf
30 Full 402345904 05-JUN-18 /u01/app/oracle/oradata/orcl/MX_INDEX15X02.dbf
31 Full 402345904 05-JUN-18 /u01/app/oracle/oradata/orcl/MX_DATA15X02.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2308 Full 1.14M DISK 00:00:01 05-JUN-18
BP Key: 2308 Status: EXPIRED Compressed: YES Tag: TAG20180605T060024
Piece Name: /u01/backup/rman/Fullback_20180605_91t4llv4_1_1
SPFILE Included: Modification time: 21-MAR-18
SPFILE db_unique_name: ORCL
Control File Included: Ckp SCN: 402346242 Ckp time: 05-JUN-18
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
2309 399.50K DISK 00:00:00 05-JUN-18
BP Key: 2309 Status: EXPIRED Compressed: YES Tag: TAG20180605T060423
Piece Name: /u01/backup/rman/Archive_20180605_92t4llv7_1_1
List of Archived Logs in backup set 2309
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 6548 402345893 05-JUN-18 402346248 05-JUN-18
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2310 Full 9.70M DISK 00:00:02 05-JUN-18
BP Key: 2310 Status: EXPIRED Compressed: NO Tag: TAG20180605T060424
Piece Name: /u01/backup/rman/Controlback_20180605_93t4llv8_1_1
Control File Included: Ckp SCN: 402346257 Ckp time: 05-JUN-18
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
2311 5.80M DISK 00:00:00 05-JUN-18
BP Key: 2311 Status: EXPIRED Compressed: YES Tag: TAG20180605T133005
Piece Name: /u01/backup/rman/ORCL_20180605_2340_archive
List of Archived Logs in backup set 2311
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 6549 402346248 05-JUN-18 402367859 05-JUN-18
1 6550 402367859 05-JUN-18 402367867 05-JUN-18
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2312 Full 9.70M DISK 00:00:01 05-JUN-18
BP Key: 2312 Status: EXPIRED Compressed: NO Tag: TAG20180605T133010
Piece Name: /u01/backup/rman/ORCL_20180605_2341_controlback
Control File Included: Ckp SCN: 402367884 Ckp time: 05-JUN-18
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
2313 4.47M DISK 00:00:01 05-JUN-18
BP Key: 2313 Status: EXPIRED Compressed: YES Tag: TAG20180605T180004
Piece Name: /u01/backup/rman/ORCL_20180605_2342_archive
List of Archived Logs in backup set 2313
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 6551 402367867 05-JUN-18 402382542 05-JUN-18
1 6552 402382542 05-JUN-18 402382550 05-JUN-18
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2314 Full 9.70M DISK 00:00:01 05-JUN-18
BP Key: 2314 Status: EXPIRED Compressed: NO Tag: TAG20180605T180007
Piece Name: /u01/backup/rman/ORCL_20180605_2343_controlback
Control File Included: Ckp SCN: 402382566 Ckp time: 05-JUN-18
RMAN>
No comments:
Post a Comment