Applications

Expand all | Collapse all

EBS 12.1.3 with 19c database - CDB backups and pdbseed question

  • 1.  EBS 12.1.3 with 19c database - CDB backups and pdbseed question

    Posted 07-13-2021 01:59 PM
    On premise setup and we recently upgraded to 19c multitenant environment but it has generated a couple of questions related to the rman backups.

    My questions are:
    • since the pdbseed database is set to read only, it is not backed up in the weekly full backups. therefore the backup of the pdbseed database within the first full backup of the container database is not deleted when we run crosscheck delete, even though it is older than the retention period. This makes sense, but it appears that none of the archivelog backups are deleted either. Is this normal behavior? If so, what are other ebs clients doing to manage rman backup retention?
    • likley not recommended but could we just drop the pdbseed database?
    • would we delete the first backup every week, so we get a new one?
    • can we uncatalog the backup weekly, so we get a new backup every week?
    • did I miss something in the EBS upgrade guide with respect to the pdbseed?


    ------------------------------
    Mark Schlechte
    DBA
    City of Regina
    Regina SK
    ------------------------------


  • 2.  RE: EBS 12.1.3 with 19c database - CDB backups and pdbseed question

    Posted 07-14-2021 09:19 AM

    Mark,

     

    When performing your backup, are you connected to the CDB or the PDB?  I do my backups connected to the CDB and it automatically backs up all the PDB's including the PDB$SEED.  My backups are deleted normally based on the retention period or the keep until date.

     

     

    Thanks,

     

    Joe Thomas

    Director of Information Technology | Sinclair & Rush, Inc. | www.sinclair-rush.com

    T 636-282-6850 | 123 Manufacturers Dr, Arnold, MO 63010

    jthomas@sinclair-rush.com

     

    This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. Any review, retransmission, dissemination, or other uses of this information by persons or entities other than the intended recipient is prohibited. If you have received this in error, please contact the sender and delete the original message and all copies from your computer.

    WARNING: Although Sinclair & Rush has taken reasonable precautions to ensure no viruses are present in this email, we cannot accept responsibility for any loss or damage arising from the use of this email or attachments.






  • 3.  RE: EBS 12.1.3 with 19c database - CDB backups and pdbseed question

    Posted 07-14-2021 09:32 AM

    Same here. You have to backup the CDB not the PDB. Archive logs are only backed up with the CDB.

     






  • 4.  RE: EBS 12.1.3 with 19c database - CDB backups and pdbseed question

    Posted 07-14-2021 10:34 AM
    Interesting, definitely backing up at the CDB level so must be something we are doing or not doing I guess perhaps in our syntax?

    I imagine the PDB$SEED database is read only and does it get backed up with each full backup? Looks like ours only gets backed up again if the PDB$SEED backup is manually deleted or uncataloged.

    I doubt it makes a difference but what version of  19c and patch level?



    ------------------------------
    Mark Schlechte
    DBA
    City of Regina
    Regina SK
    ------------------------------



  • 5.  RE: EBS 12.1.3 with 19c database - CDB backups and pdbseed question

    Posted 07-14-2021 11:29 AM

    Mark,

     

    All of my PDB's get backed up with each 'Incremental Level 0' and 'Full' backups.  I started out on 19.8 and just recently patched up to 19.11.

     

    If it helps, here are my RMAN parameters:

    CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 15 DAYS;

    CONFIGURE BACKUP OPTIMIZATION ON;

    CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';

    CONFIGURE CONTROLFILE AUTOBACKUP ON; # default

    CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE 'SBT_TAPE' TO '%F';

    CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default

    CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 4 BACKUP TYPE TO COMPRESSED BACKUPSET;

    CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default

    CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE 'SBT_TAPE' TO 1;

    CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

    CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE 'SBT_TAPE' TO 1;

    CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

    CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS  'SBT_LIBRARY=/home/oracle/lib/libopc.so, SBT_PARMS=(OPC_PFILE=/home/oracle/config)';

    CONFIGURE MAXSETSIZE TO UNLIMITED; # default

    CONFIGURE ENCRYPTION FOR DATABASE ON;

    CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default

    CONFIGURE COMPRESSION ALGORITHM 'MEDIUM' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE;

    CONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; # default

    CONFIGURE ARCHIVELOG DELETION POLICY TO SHIPPED TO ALL STANDBY;

    CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+RECO/PRODCDB_IAD1P6/controlfile/snapcf_prodcdb_iad1p6.f';

     

    And here the commands I use for my monthly, weekly and daily backups

      RUN

      {

      CROSSCHECK BACKUP;

      DELETE NOPROMPT EXPIRED BACKUP;

      DELETE NOPROMPT OBSOLETE;

      CROSSCHECK ARCHIVELOG ALL;

      BACKUP FULL

       SPFILE FORMAT 'MONTHLY%T_spf_%d_%I_%t_%s_%p_%u' TAG='MONTHLY$YRNUM$MONNO' KEEP UNTIL TIME 'TRUNC(ADD_MONTHS(SYSDATE, 12))'

       DATABASE INCLUDE CURRENT CONTROLFILE FORMAT 'MONTHLY%T_df_%d_%I_%t_%s_%p_%u' TAG='MONTHLY$YRNUM$MONNO' KEEP UNTIL TIME 'TRUNC(ADD_MONTHS(SYSDATE, 12))'

       ARCHIVELOG ALL FORMAT 'MONTHLY%T_arc_%d_%I_%t_%s_%p_%u' TAG='MONTHLY$YRNUM$MONNO' KEEP UNTIL TIME 'TRUNC(ADD_MONTHS(SYSDATE, 12))' DELETE ALL INPUT;

      }

     

    RUN

    {

    CROSSCHECK BACKUP;

    DELETE NOPROMPT EXPIRED BACKUP;

    DELETE NOPROMPT OBSOLETE;

    CROSSCHECK ARCHIVELOG ALL;

    BACKUP INCREMENTAL LEVEL 0

      DATABASE FORMAT 'WEEKLY%T_df_%d_%I_%t_%s_%p_%u' TAG='DAILY'

      ARCHIVELOG ALL FORMAT 'WEEKLY%T_arc_%d_%I_%t_%s_%p_%u' TAG='DAILY' DELETE ALL INPUT;

    }

     

    RUN

    {

    CROSSCHECK BACKUP;

    DELETE NOPROMPT EXPIRED BACKUP;

    DELETE NOPROMPT OBSOLETE;

    CROSSCHECK ARCHIVELOG ALL;

    BACKUP INCREMENTAL LEVEL 1

      DATABASE FORMAT 'DAILY%T_df_%d_%I_%t_%s_%p_%u' TAG='DAILY'

      ARCHIVELOG ALL FORMAT 'DAILY%T_arc_%d_%I_%t_%s_%p_%u' TAG='DAILY' DELETE ALL INPUT;

    }

     

    Thanks,

     

    Joe Thomas

    Director of Information Technology | Sinclair & Rush, Inc. | www.sinclair-rush.com

    T 636-282-6850 | 123 Manufacturers Dr, Arnold, MO 63010

    jthomas@sinclair-rush.com

     

    This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. Any review, retransmission, dissemination, or other uses of this information by persons or entities other than the intended recipient is prohibited. If you have received this in error, please contact the sender and delete the original message and all copies from your computer.

    WARNING: Although Sinclair & Rush has taken reasonable precautions to ensure no viruses are present in this email, we cannot accept responsibility for any loss or damage arising from the use of this email or attachments.






  • 6.  RE: EBS 12.1.3 with 19c database - CDB backups and pdbseed question

    Posted 07-14-2021 12:20 PM
    Thanks Joe.  I'll pass this on to my fellow DBA who deals more with the rman stuff than I do and see if there is anything different from what we do so I do appreciate you sharing that.

    ------------------------------
    Mark Schlechte
    DBA
    City of Regina
    Regina SK
    ------------------------------



  • 7.  RE: EBS 12.1.3 with 19c database - CDB backups and pdbseed question

    Posted 07-15-2021 03:33 PM
    In terms of the ability to recover from data loss, separately backing up the root and all PDBs, including the CDB seed, is equivalent to backing up the whole CDB.


    Oracle Database Release 19 Backup and Recovery Users's Guide:

    https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/index.html


    9.4.2 Backing Up a Whole CDB

    4.2.5 Making RMAN Connections to CDBs and PDBs


    ------------------------------
    Patricia Turner
    Manager, Database Administration
    CDM Smith Inc.
    Boston MA
    -
    ------------------------------