Delphix Products

Expand all | Collapse all

Oracle dSource and SnapSync backups in RMAN repository

Jump to Best Answer
  • 1.  Oracle dSource and SnapSync backups in RMAN repository

    Posted 06-27-2016 07:12:00 PM
    Hi Community :)

    What about Delphix backups forced by dSource and SnapSync Policy which appears in RMAN repository?

    BS Key  Type LV Size       Device Type Elapsed Time Completion Time

    ------- ---- -- ---------- ----------- ------------ ---------------

    2475    Full    12.25M     SBT_TAPE    00:00:01     27-JUN-16      

            BP Key: 2475   Status: AVAILABLE  Compressed: NO  Tag: DLPX20160627142837AC2409593BA5

            Handle: dmr97sfn_1_1   Media: de5masking-SNL.1.9.VUGiPzaNwBp7qQu4jZzny1LS

      Control File Included: Ckp SCN: 54195757     Ckp time: 27-JUN-16



    How to erase them, and can we erase them from RMAN Catalog, or DB controlfile ?
    Any ideas ?


    #DemoEnvironment


  • 2.  RE: Oracle dSource and SnapSync backups in RMAN repository
    Best Answer

    Posted 06-28-2016 03:55:00 PM
    Hi Marcin
    This would only apply when using level-based backups, as per https://docs.delphix.com/display/DOCS50/Linking+Oracle+Physical+Standby+Databases.

    Delphix tags its RMAN backups with a 'dlpx' tag. The tag is marked as unavailable once the backup completes, via a 'CHANGE BACKUP TAG <tag> UNAVAILABLE' command.

    There is a known issue to be aware of which can affect non-Delphix backup records which is issue is fully resolved in Delphix Engine version 4.2.5.1, Delphix Engine 4.3.2.1, and later releases. 



  • 3.  RE: Oracle dSource and SnapSync backups in RMAN repository

    Posted 06-29-2016 08:58:00 AM
    HI Jaclyn,

    Thank you it really work for single backup:



    RMAN> change backup tag DLPX20160627142837AC2409593BA5 unavailable;

    changed backup piece unavailable

    backup piece handle=dkr97sdg_1_1 RECID=2472 STAMP=915665328

    changed backup piece unavailable

    backup piece handle=dlr97sej_1_1 RECID=2473 STAMP=915665363

    changed backup piece unavailable

    backup piece handle=djr97sdg_1_1 RECID=2474 STAMP=915665328

    changed backup piece unavailable

    backup piece handle=dmr97sfn_1_1 RECID=2475 STAMP=915665400

    changed backup piece unavailable

    backup piece handle=dpr98fqu_1_1 RECID=2477 STAMP=915685214

    changed backup piece unavailable

    backup piece handle=dor98fqu_1_1 RECID=2478 STAMP=915685214

    changed backup piece unavailable

    backup piece handle=dqr98fqv_1_1 RECID=2479 STAMP=915685215

    changed backup piece unavailable

    backup piece handle=drr98fqv_1_1 RECID=2480 STAMP=915685216

    changed backup piece unavailable

    backup piece handle=dsr98fr1_1_1 RECID=2481 STAMP=915685218

    Changed 9 objects to UNAVAILABLE status





    But what about whole list of DLPXnnnn TAGed backups? Is there any way to automate this from Delphix side?

    Regards
    Marcin