Oracle dSource and SnapSync backups in RMAN repository

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
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 ?
Photo of Marcin

Marcin

  • 544 Points 500 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of Jaclyn Schoof

Jaclyn Schoof, Community Manager

  • 5,092 Points 5k badge 2x thumb
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. 
Photo of Marcin

Marcin

  • 544 Points 500 badge 2x thumb
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