Erman Arslan's Oracle Forum › RAC

RMAN backups - EBS database 19c

classic Classic list List threaded Threaded
♦
♦
 3 messages Options
satish
Reply | Threaded
Open this post in threaded view
♦
♦
|

RMAN backups - EBS database 19c

satish
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
ErmanArslansOracleBlog
Reply | Threaded
Open this post in threaded view
♦
♦
|

Re: RMAN backups - EBS database 19c

ErmanArslansOracleBlog
Administrator
What do you mean "by output truncates?"
Did you check those database views to see if your rman backup was successful or not. ->  some examples:

SELECT SESSION_KEY, INPUT_TYPE, STATUS,
       TO_CHAR(START_TIME,'mm/dd/yy hh24:mi') start_time,
       TO_CHAR(END_TIME,'mm/dd/yy hh24:mi')   end_time,
       ELAPSED_SECONDS/3600                   hrs
FROM V$RMAN_BACKUP_JOB_DETAILS
ORDER BY SESSION_KEY;

SELECT SESSION_KEY,
       OPTIMIZED,
       COMPRESSION_RATIO,
       INPUT_BYTES_PER_SEC_DISPLAY in_sec,
       OUTPUT_BYTES_PER_SEC_DISPLAY out_sec,
       TIME_TAKEN_DISPLAY
FROM   V$RMAN_BACKUP_JOB_DETAILS
ORDER BY SESSION_KEY;

SELECT SESSION_KEY,
       INPUT_TYPE,
       COMPRESSION_RATIO,
       INPUT_BYTES_DISPLAY in_size,
       OUTPUT_BYTES_DISPLAY out_size
FROM   V$RMAN_BACKUP_JOB_DETAILS
ORDER BY SESSION_KEY;

Here is an example script for EBS 19C backup: (just an example.. Those delete and backup command depends on your environment's backup and retention (and storage) policies.

. /erp/oracle/R12ERMAN/db/tech_st/19.0.0/R12PRODC_erpr12db.env

rman target /
CROSSCHECK ARCHIVELOG ALL;
DELETE EXPIRED ARCHIVELOG ALL;
DELETE NOPROMPT ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE - 3';
BACKUP AS COMPRESSED BACKUPSET incremental level 0 section size 500g tag '$TAG_CTEXT' (database format '$BACKUP_FOLDER/%d_L0_%s_%U');
BACKUP AS COMPRESSED BACKUPSET ARCHIVELOG ALL NOT BACKED UP 1 TIMES FORMAT '$BACKUP_FOLDER/%d_ARC_BCK_%U_%s_%T' tag='$TAG_TEXT';
backup tag '$TAG_TEXT' (current controlfile format '$BACKUP_FOLDER/%d_ctl_%s_%U');
DELETE NOPROMPT FORCE OBSOLETE;
DELETE NOPROMPT OBSOLETE;
delete noprompt backup of ARCHIVELOG UNTIL TIME='sysdate-10' BACKED UP 1 TIMES TO DISK;
satish
Reply | Threaded
Open this post in threaded view
♦
♦
|

Re: RMAN backups - EBS database 19c

satish
Dear Erman,

Thanks for the update. Backup completed. Since,we recently upgraded from 12c to 19c. We have these questions on rman backups.

We are sourcing CDB environment in our RMAN backup scripts. I hope,this will take backup of both CDB and PDB which will be sufficient. Please correct me.

[oraprod@erpproddb1 ~]$ cd /u02/PRODDB/19cdbhome/
[oraprod@erpproddb1 19cdbhome]$ . ./prodcdb1_erpproddb1.env

prodcdb-->CDB
PRODDB-->PDB

Thanks,
Satish
Free forum by Nabble Edit this page