RMAN backups - EBS database 19c
Posted by satish on Feb 07, 2023; 3:43am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/RMAN-backups-EBS-database-19c-tp11562.html
Dear Erman,
We have upgraded EBS database to 19c which is CDB with single PDB. We followed below approach to take backups.
Is sourcing . ./prodcdb1_erpproddb1.env correct before taking EBS database backups ? Can we source the same env for archivelog backups as well? Please correct
[oraprod@erpproddb1 ~]$ cd /u02/PRODDB/19cdbhome/
[oraprod@erpproddb1 19cdbhome]$ . ./prodcdb1_erpproddb1.env
[oraprod@erpproddb1 19cdbhome]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Tue Feb 7 08:38:16 2023
Version 19.17.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: PRODCDB (DBID=3126013017)
RMAN>backup database plus arhivelog
Output truncates..
RMAN> list backup;
using target database control file instead of recovery catalog
List of Backup Sets
===================
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
1 32.05M DISK 00:00:03 06-FEB-23
BP Key: 1 Status: EXPIRED Compressed: YES Tag: DBI_BACKUP19C
Piece Name: /ERP_BACKUP/rman/19c/database_021jq3n3_2_1_1
List of Archived Logs in backup set 1
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 75 5997122489117 06-FEB-23 5997124010033 06-FEB-23
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
2 35.69M DISK 00:00:03 06-FEB-23
BP Key: 2 Status: EXPIRED Compressed: YES Tag: DBI_BACKUP19C
Piece Name: /ERP_BACKUP/rman/19c/database_011jq3n3_1_1_1
List of Archived Logs in backup set 2
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
2 132 5997122440472 06-FEB-23 5997124010036 06-FEB-23
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
3 32.05M DISK 00:00:02 06-FEB-23
BP Key: 3 Status: EXPIRED Compressed: YES Tag: DBI_BACKUP19C
Piece Name: /ERP_BACKUP/rman/19c/database_091jq595_9_1_1
List of Archived Logs in backup set 3
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 75 5997122489117 06-FEB-23 5997124010033 06-FEB-23
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
4 35.69M DISK 00:00:03 06-FEB-23
BP Key: 4 Status: EXPIRED Compressed: YES Tag: DBI_BACKUP19C
Piece Name: /ERP_BACKUP/rman/19c/database_081jq595_8_1_1
List of Archived Logs in backup set 4
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
2 132 5997122440472 06-FEB-23 5997124010036 06-FEB-23
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
5 33.71M DISK 00:00:03 06-FEB-23
BP Key: 5 Status: EXPIRED Compressed: YES Tag: DBI_BACKUP19C
Piece Name: /ERP_BACKUP/rman/19c/database_0a1jq595_10_1_1
List of Archived Logs in backup set 5
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
2 133 5997124010036 06-FEB-23 5997125745295 06-FEB-23
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
6 54.47M DISK 00:00:05 06-FEB-23
BP Key: 6 Status: EXPIRED Compressed: YES Tag: DBI_BACKUP19C
Piece Name: /ERP_BACKUP/rman/19c/database_071jq595_7_1_1
List of Archived Logs in backup set 6
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 76 5997124010033 06-FEB-23 5997125746273 06-FEB-23
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
7 12.42M DISK 00:00:02 06-FEB-23
BP Key: 7 Status: AVAILABLE Compressed: YES Tag: DBI_BACKUP19C
Piece Name: /ERP_BACKUP/rman/19c/database_0h1jq5hr_17_1_1
List of Archived Logs in backup set 7
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 77 5997125746273 06-FEB-23 5997126242499 06-FEB-23
2 134 5997125745295 06-FEB-23 5997126236952 06-FEB-23
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
8 67.03M DISK 00:00:06 06-FEB-23
BP Key: 8 Status: AVAILABLE Compressed: YES Tag: DBI_BACKUP19C
Piece Name: /ERP_BACKUP/rman/19c/database_0g1jq5hr_16_1_1
List of Archived Logs in backup set 8
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 75 5997122489117 06-FEB-23 5997124010033 06-FEB-23
2 132 5997122440472 06-FEB-23 5997124010036 06-FEB-23
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
9 87.44M DISK 00:00:08 06-FEB-23
BP Key: 9 Status: AVAILABLE Compressed: YES Tag: DBI_BACKUP19C
Piece Name: /ERP_BACKUP/rman/19c/database_0f1jq5hr_15_1_1
List of Archived Logs in backup set 9
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 76 5997124010033 06-FEB-23 5997125746273 06-FEB-23
2 133 5997124010036 06-FEB-23 5997125745295 06-FEB-23
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
10 Full 18.89M DISK 00:00:01 06-FEB-23
BP Key: 10 Status: AVAILABLE Compressed: NO Tag: TAG20230206T114647
Piece Name: +FRADG/PRODCDB/AUTOBACKUP/2023_02_06/s_1128080807.599.1128080809
SPFILE Included: Modification time: 06-FEB-23
SPFILE db_unique_name: PRODCDB
Control File Included: Ckp SCN: 5997131232146 Ckp time: 06-FEB-23
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
11 Incr 0 37.63G DISK 01:33:40 06-FEB-23
BP Key: 11 Status: AVAILABLE Compressed: YES Tag: DBI_BACKUP19C
Piece Name: /ERP_BACKUP/rman/19c/database_0j1jq5id_19_1_1
List of Datafiles in backup set 11
Container ID: 3, PDB Name: PRODDB
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- --------- ----------- ------ ----
13 0 Incr 5997126286405 06-FEB-23 5997129732820 NO +DATADG/PRODDB/DATAFILE/system.259.943823905
15 0 Incr 5997126286405 06-FEB-23 5997129709386 NO +DATADG/PRODDB/DATAFILE/system.267.943823967
18 0 Incr 5997126286405 06-FEB-23 5997129411820 NO +DATADG/PRODDB/DATAFILE/system.276.943824083
22 0 Incr 5997126286405 06-FEB-23 5997128589996 NO +DATADG/PRODDB/DATAFILE/system.280.943824179
26 0 Incr 5997126286405 06-FEB-23 5997128588540 NO +DATADG/PRODDB/DATAFILE/system.284.943824285
29 0 Incr 5997126286405 06-FEB-23 5997129707295 NO +DATADG/PRODDB/DATAFILE/system.299.943824387
37 0 Incr 5997126286405 06-FEB-23 NO +DATADG/PRODDB/DATAFILE/owapub.262.943823961
39 0 Incr 5997126286405 06-FEB-23 5997129229402 NO +DATADG/PRODDB/DATAFILE/apps_undots1.290.943824367
42 0 Incr 5997126286405 06-FEB-23 5997132735249 NO +DATADG/PRODDB/DATAFILE/apps_ts_tx_data.298.943824387
45 0 Incr 5997126286405 06-FEB-23 5997132693756 NO +DATADG/PRODDB/DATAFILE/apps_ts_tx_data.317.943824615
50 0 Incr 5997126286405 06-FEB-23 5997127205332 NO +DATADG/PRODDB/DATAFILE/apps_ts_tx_data.353.1119871265
55 0 Incr 5997126286405 06-FEB-23 5997129329544 NO +DATADG/PRODDB/DATAFILE/apps_ts_tx_idx.320.943824671
59 0 Incr 5997126286405 06-FEB-23 5997129900792 NO +DATADG/PRODDB/DATAFILE/apps_ts_seed.271.943824001
61 0 Incr 5997126286405 06-FEB-23 5997129279196 NO +DATADG/PRODDB/DATAFILE/apps_ts_seed.288.943824347
67 0 Incr 5997126286405 06-FEB-23 5997128730724 NO +DATADG/PRODDB/DATAFILE/apps_ts_summary.311.943824543
73 0 Incr 5997126286405 06-FEB-23 5997132191417 NO +DATADG/PRODDB/DATAFILE/apps_ts_media.297.943824387
77 0 Incr 5997126286405 06-FEB-23 5997127751040 NO +DATADG/PRODDB/DATAFILE/apps_ts_media.354.1125060289
78 0 Incr 5997126286405 06-FEB-23 NO +DATADG/PRODDB/DATAFILE/odm.264.943823961
82 0 Incr 5997126286405 06-FEB-23 5997126765262 NO +DATADG/PRODDB/DATAFILE/sysaux.326.951393017
83 0 Incr 5997126286405 06-FEB-23 5997128032637 NO +DATADG/PRODDB/DATAFILE/sysaux.338.963320641
86 0 Incr 5997126286405 06-FEB-23 5997129272721 NO +DATADG/PRODDB/DATAFILE/xxttd_data.291.943824381
91 0 Incr 5997126286405 06-FEB-23 NO +DATADG/PRODDB/DATAFILE/xxttd_idx.292.943824381
95 0 Incr 5997126286405 06-FEB-23 NO +DATADG/PRODDB/DATAFILE/xxadm_data.343.1002228909
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
12 Incr 0 163.94M DISK 00:00:25 06-FEB-23
BP Key: 12 Status: AVAILABLE Compressed: YES Tag: DBI_BACKUP19C
Piece Name: /ERP_BACKUP/rman/19c/database_0n1jqb29_23_1_1
List of Datafiles in backup set 12
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- --------- ----------- ------ ----
3 0 Incr 5997133286848 06-FEB-23 5997133325712 NO +DATADG/PRODCDB/DATAFILE/sysaux.359.1127938843
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
13 Incr 0 351.57M DISK 00:00:51 06-FEB-23
BP Key: 13 Status: AVAILABLE Compressed: YES Tag: DBI_BACKUP19C
Piece Name: /ERP_BACKUP/rman/19c/database_0o1jqb32_24_1_1
List of Datafiles in backup set 13
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- --------- ----------- ------ ----
1 0 Incr 5997133341198 06-FEB-23 NO +DATADG/PRODCDB/DATAFILE/system.358.1127938809
7 0 Incr 5997133341198 06-FEB-23 NO +DATADG/PRODCDB/DATAFILE/users.361.1127938861
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
14 Incr 0 1.33M DISK 00:00:00 06-FEB-23
BP Key: 14 Status: AVAILABLE Compressed: YES Tag: DBI_BACKUP19C
Piece Name: /ERP_BACKUP/rman/19c/database_0p1jqb4p_25_1_1
List of Datafiles in backup set 14
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- --------- ----------- ------ ----
4 0 Incr 5997133443545 06-FEB-23 NO +DATADG/PRODCDB/DATAFILE/undotbs1.360.1127938859
9 0 Incr 5997133443545 06-FEB-23 NO +DATADG/PRODCDB/DATAFILE/undotbs2.370.1127939865
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
15 Incr 0 61.16M DISK 00:00:08 06-FEB-23
BP Key: 15 Status: AVAILABLE Compressed: YES Tag: DBI_BACKUP19C
Piece Name: /ERP_BACKUP/rman/19c/database_0q1jqb4q_26_1_1
List of Datafiles in backup set 15
Container ID: 2, PDB Name: PDB$SEED
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- --------- ----------- ------ ----
6 0 Incr 2427267 04-FEB-23 NO +DATADG/PRODCDB/86B637B62FE07A65E053F706E80A27CA/DATAFILE/sysaux.367.1127939657
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
16 Incr 0 167.94M DISK 00:00:27 06-FEB-23
BP Key: 16 Status: AVAILABLE Compressed: YES Tag: DBI_BACKUP19C
Piece Name: /ERP_BACKUP/rman/19c/database_0r1jqb59_27_1_1
List of Datafiles in backup set 16
Container ID: 2, PDB Name: PDB$SEED
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- --------- ----------- ------ ----
5 0 Incr 2427267 04-FEB-23 NO +DATADG/PRODCDB/86B637B62FE07A65E053F706E80A27CA/DATAFILE/system.366.1127939657
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
17 Incr 0 67.35M DISK 00:00:08 06-FEB-23
BP Key: 17 Status: AVAILABLE Compressed: YES Tag: DBI_BACKUP19C
Piece Name: /ERP_BACKUP/rman/19c/database_0s1jqb6d_28_1_1
List of Datafiles in backup set 17
Container ID: 2, PDB Name: PDB$SEED
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- --------- ----------- ------ ----
8 0 Incr 2427267 04-FEB-23 NO +DATADG/PRODCDB/86B637B62FE07A65E053F706E80A27CA/DATAFILE/undotbs1.368.1127939657
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
18 Incr 0 45.07G DISK 01:53:06 06-FEB-23
BP Key: 18 Status: AVAILABLE Compressed: YES Tag: DBI_BACKUP19C
Piece Name: /ERP_BACKUP/rman/19c/database_0k1jq5id_20_1_1
List of Datafiles in backup set 18
Container ID: 3, PDB Name: PRODDB
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- --------- ----------- ------ ----
12 0 Incr 5997126286569 06-FEB-23 5997133411674 NO +DATADG/PRODDB/DATAFILE/system.258.943823903
17 0 Incr 5997126286569 06-FEB-23 5997132628123 NO +DATADG/PRODDB/DATAFILE/system.275.943824075
21 0 Incr 5997126286569 06-FEB-23 5997131923647 NO +DATADG/PRODDB/DATAFILE/system.279.943824177
25 0 Incr 5997126286569 06-FEB-23 5997133411674 NO +DATADG/PRODDB/DATAFILE/system.283.943824257
33 0 Incr 5997126286569 06-FEB-23 5997133527886 NO +DATADG/PRODDB/DATAFILE/system.304.943824437
36 0 Incr 5997126286569 06-FEB-23 5997132933391 NO +DATADG/PRODDB/DATAFILE/ctxd.336.952789259
43 0 Incr 5997126286569 06-FEB-23 5997134407026 NO +DATADG/PRODDB/DATAFILE/apps_ts_tx_data.307.943824447
47 0 Incr 5997126286569 06-FEB-23 5997134068528 NO +DATADG/PRODDB/DATAFILE/apps_ts_tx_data.348.1100864783
51 0 Incr 5997126286569 06-FEB-23 5997129774878 NO +DATADG/PRODDB/DATAFILE/apps_ts_tx_idx.270.943823997
53 0 Incr 5997126286569 06-FEB-23 5997132296724 NO +DATADG/PRODDB/DATAFILE/apps_ts_tx_idx.318.943824619
60 0 Incr 5997126286569 06-FEB-23 5997132500450 NO +DATADG/PRODDB/DATAFILE/apps_ts_seed.287.943824329
65 0 Incr 5997126286569 06-FEB-23 5997133443223 NO +DATADG/PRODDB/DATAFILE/apps_ts_interface.272.943824031
66 0 Incr 5997126286569 06-FEB-23 5997129716244 NO +DATADG/PRODDB/DATAFILE/apps_ts_interface.310.943824523
68 0 Incr 5997126286569 06-FEB-23 NO +DATADG/PRODDB/DATAFILE/apps_ts_nologging.312.943824579
69 0 Incr 5997126286569 06-FEB-23 NO +DATADG/PRODDB/DATAFILE/apps_ts_nologging.345.1009121465
74 0 Incr 5997126286569 06-FEB-23 5997132190696 NO +DATADG/PRODDB/DATAFILE/apps_ts_media.315.943824585
80 0 Incr 5997126286569 06-FEB-23 5997126610549 NO +DATADG/PRODDB/DATAFILE/sysaux.266.943823963
81 0 Incr 5997126286569 06-FEB-23 5997127128839 NO +DATADG/PRODDB/DATAFILE/sysaux.273.943824035
85 0 Incr 5997126286569 06-FEB-23 NO +DATADG/PRODDB/DATAFILE/apps_ts_tools.269.943823987
88 0 Incr 5997126286569 06-FEB-23 5997129082913 NO +DATADG/PRODDB/DATAFILE/xxttd_data.294.943824385
93 0 Incr 5997126286569 06-FEB-23 5997129831084 NO +DATADG/PRODDB/DATAFILE/xxtbr_data.340.973182957
98 0 Incr 5997126286569 06-FEB-23 NO +DATADG/PRODDB/DATAFILE/xxdpbackup.352.1115382891
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
19 Incr 0 46.70G DISK 01:55:49 06-FEB-23
BP Key: 19 Status: AVAILABLE Compressed: YES Tag: DBI_BACKUP19C
Piece Name: /ERP_BACKUP/rman/19c/database_0i1jq5id_18_1_1
List of Datafiles in backup set 19
Container ID: 3, PDB Name: PRODDB
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- --------- ----------- ------ ----
14 0 Incr 5997126286269 06-FEB-23 5997133729450 NO +DATADG/PRODDB/DATAFILE/system.260.943823907
16 0 Incr 5997126286269 06-FEB-23 5997133510260 NO +DATADG/PRODDB/DATAFILE/system.274.943824047
20 0 Incr 5997126286269 06-FEB-23 5997133095750 NO +DATADG/PRODDB/DATAFILE/system.278.943824159
24 0 Incr 5997126286269 06-FEB-23 5997133512252 NO +DATADG/PRODDB/DATAFILE/system.282.943824219
28 0 Incr 5997126286269 06-FEB-23 5997133089893 NO +DATADG/PRODDB/DATAFILE/system.286.943824289
31 0 Incr 5997126286269 06-FEB-23 5997134014093 NO +DATADG/PRODDB/DATAFILE/system.302.943824401
35 0 Incr 5997126286269 06-FEB-23 5997132670342 NO +DATADG/PRODDB/DATAFILE/ctxd.261.943823961
41 0 Incr 5997126286269 06-FEB-23 5997134915566 NO +DATADG/PRODDB/DATAFILE/apps_ts_tx_data.268.943823969
44 0 Incr 5997126286269 06-FEB-23 5997134292022 NO +DATADG/PRODDB/DATAFILE/apps_ts_tx_data.316.943824589
49 0 Incr 5997126286269 06-FEB-23 5997130640543 NO +DATADG/PRODDB/DATAFILE/apps_ts_tx_data.351.1113565063
56 0 Incr 5997126286269 06-FEB-23 5997129915055 NO +DATADG/PRODDB/DATAFILE/apps_ts_tx_idx.321.943824675
58 0 Incr 5997126286269 06-FEB-23 5997134574153 NO +DATADG/PRODDB/DATAFILE/apps_ts_tx_idx.337.959972713
63 0 Incr 5997126286269 06-FEB-23 5997133566637 NO +DATADG/PRODDB/DATAFILE/apps_ts_seed.309.943824507
70 0 Incr 5997126286269 06-FEB-23 5997131123431 NO +DATADG/PRODDB/DATAFILE/apps_ts_archive.313.943824581
71 0 Incr 5997126286269 06-FEB-23 5997132609925 NO +DATADG/PRODDB/DATAFILE/apps_ts_queues.263.943823961
76 0 Incr 5997126286269 06-FEB-23 5997132933391 NO +DATADG/PRODDB/DATAFILE/apps_ts_media.349.1106654179
87 0 Incr 5997126286269 06-FEB-23 5997129407307 NO +DATADG/PRODDB/DATAFILE/xxttd_data.293.943824381
90 0 Incr 5997126286269 06-FEB-23 5997134074344 NO +DATADG/PRODDB/DATAFILE/xxttd_data.296.943824385
92 0 Incr 5997126286269 06-FEB-23 5997133357975 NO +DATADG/PRODDB/DATAFILE/apps_undots2.333.943825103
94 0 Incr 5997126286269 06-FEB-23 NO +DATADG/PRODDB/DATAFILE/xxtbr_idx.341.973182967
96 0 Incr 5997126286269 06-FEB-23 NO +DATADG/PRODDB/DATAFILE/xxadm_idx.344.1002229009
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
20 Incr 0 57.06G DISK 02:17:20 06-FEB-23
BP Key: 20 Status: AVAILABLE Compressed: YES Tag: DBI_BACKUP19C
Piece Name: /ERP_BACKUP/rman/19c/database_0l1jq5id_21_1_1
List of Datafiles in backup set 20
Container ID: 3, PDB Name: PRODDB
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- --------- ----------- ------ ----
10 0 Incr 5997126286812 06-FEB-23 5997126610533 NO +DATADG/PRODDB/DATAFILE/system.332.943823901
11 0 Incr 5997126286812 06-FEB-23 5997136069224 NO +DATADG/PRODDB/DATAFILE/system.327.943823901
19 0 Incr 5997126286812 06-FEB-23 5997134239436 NO +DATADG/PRODDB/DATAFILE/system.277.943824123
23 0 Incr 5997126286812 06-FEB-23 5997134212914 NO +DATADG/PRODDB/DATAFILE/system.281.943824181
27 0 Incr 5997126286812 06-FEB-23 5997134240366 NO +DATADG/PRODDB/DATAFILE/system.285.943824287
30 0 Incr 5997126286812 06-FEB-23 5997136062634 NO +DATADG/PRODDB/DATAFILE/system.300.943824389
32 0 Incr 5997126286812 06-FEB-23 5997135600019 NO +DATADG/PRODDB/DATAFILE/system.303.943824419
34 0 Incr 5997126286812 06-FEB-23 5997135612539 NO +DATADG/PRODDB/DATAFILE/system.305.943824441
38 0 Incr 5997126286812 06-FEB-23 NO +DATADG/PRODDB/DATAFILE/portal.301.943824391
40 0 Incr 5997126286812 06-FEB-23 5997134123380 NO +DATADG/PRODDB/DATAFILE/apps_undots1.306.943824445
46 0 Incr 5997126286812 06-FEB-23 5997136594709 NO +DATADG/PRODDB/DATAFILE/apps_ts_tx_data.328.952789109
48 0 Incr 5997126286812 06-FEB-23 5997136410855 NO +DATADG/PRODDB/DATAFILE/apps_ts_tx_data.350.1113048591
52 0 Incr 5997126286812 06-FEB-23 5997134058578 NO +DATADG/PRODDB/DATAFILE/apps_ts_tx_idx.308.943824505
54 0 Incr 5997126286812 06-FEB-23 5997132288103 NO +DATADG/PRODDB/DATAFILE/apps_ts_tx_idx.319.943824623
57 0 Incr 5997126286812 06-FEB-23 5997132693501 NO +DATADG/PRODDB/DATAFILE/apps_ts_tx_idx.335.951393091
62 0 Incr 5997126286812 06-FEB-23 5997135331156 NO +DATADG/PRODDB/DATAFILE/apps_ts_seed.289.943824365
64 0 Incr 5997126286812 06-FEB-23 5997131138168 NO +DATADG/PRODDB/DATAFILE/apps_ts_seed.322.943824703
72 0 Incr 5997126286812 06-FEB-23 5997132854784 NO +DATADG/PRODDB/DATAFILE/apps_ts_queues.314.943824583
75 0 Incr 5997126286812 06-FEB-23 5997135097192 NO +DATADG/PRODDB/DATAFILE/apps_ts_media.342.984829959
79 0 Incr 5997126286812 06-FEB-23 NO +DATADG/PRODDB/DATAFILE/olap.265.943823961
84 0 Incr 5997126286812 06-FEB-23 5997128014835 NO +DATADG/PRODDB/DATAFILE/sysaux.339.966949299
89 0 Incr 5997126286812 06-FEB-23 5997136100110 NO +DATADG/PRODDB/DATAFILE/xxttd_data.295.943824385
97 0 Incr 5997126286812 06-FEB-23 5997131076011 NO +DATADG/PRODDB/DATAFILE/xxapex_embook.346.1088246425
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
21 15.51M DISK 00:00:02 06-FEB-23
BP Key: 21 Status: AVAILABLE Compressed: YES Tag: DBI_BACKUP19C
Piece Name: /ERP_BACKUP/rman/19c/database_101jqdk5_32_1_1
List of Archived Logs in backup set 21
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 81 5997136694814 06-FEB-23 5997137083422 06-FEB-23
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
22 126.88M DISK 00:00:13 06-FEB-23
BP Key: 22 Status: AVAILABLE Compressed: YES Tag: DBI_BACKUP19C
Piece Name: /ERP_BACKUP/rman/19c/database_0v1jqdk5_31_1_1
List of Archived Logs in backup set 22
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 80 5997134152265 06-FEB-23 5997136694814 06-FEB-23
2 137 5997136652845 06-FEB-23 5997137083208 06-FEB-23
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
23 215.96M DISK 00:00:24 06-FEB-23
BP Key: 23 Status: AVAILABLE Compressed: YES Tag: DBI_BACKUP19C
Piece Name: /ERP_BACKUP/rman/19c/database_0t1jqdk5_29_1_1
List of Archived Logs in backup set 23
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 79 5997129824092 06-FEB-23 5997134152265 06-FEB-23
2 136 5997131440953 06-FEB-23 5997136652845 06-FEB-23
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
24 235.92M DISK 00:00:26 06-FEB-23
BP Key: 24 Status: AVAILABLE Compressed: YES Tag: DBI_BACKUP19C
Piece Name: /ERP_BACKUP/rman/19c/database_0u1jqdk5_30_1_1
List of Archived Logs in backup set 24
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 78 5997126242499 06-FEB-23 5997129824092 06-FEB-23
2 135 5997126236952 06-FEB-23 5997131440953 06-FEB-23
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
25 Full 18.86M DISK 00:00:01 06-FEB-23
BP Key: 25 Status: AVAILABLE Compressed: NO Tag: DBI_BACKUP19C
Piece Name: /ERP_BACKUP/rman/19c/control_111jqdl9_33_1_1
Control File Included: Ckp SCN: 5997137123761 Ckp time: 06-FEB-23
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
26 Full 96.00K DISK 00:00:00 06-FEB-23
BP Key: 26 Status: AVAILABLE Compressed: NO Tag: DBI_BACKUP19C
Piece Name: /ERP_BACKUP/rman/19c/spfile_121jqdlb_34_1_1
SPFILE Included: Modification time: 06-FEB-23
SPFILE db_unique_name: PRODCDB
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27 Full 18.89M DISK 00:00:00 06-FEB-23
BP Key: 27 Status: AVAILABLE Compressed: NO Tag: TAG20230206T125924
Piece Name: +FRADG/PRODCDB/AUTOBACKUP/2023_02_06/s_1128085164.876.1128085165
SPFILE Included: Modification time: 06-FEB-23
SPFILE db_unique_name: PRODCDB
Control File Included: Ckp SCN: 5997137135406 Ckp time: 06-FEB-23
RMAN>
Thanks,
Satish