Delphix Products

Expand all | Collapse all

Backup of virtual database by RMAN.

Jump to Best Answer
  • 1.  Backup of virtual database by RMAN.

    Posted 02-20-2015 03:00:00 AM
    We are planning to back up a VDB using RMAN on the Target environment and restore the backup sets to the same environment. Does Delphix support this operation?


  • 2.  RE: Backup of virtual database by RMAN.
    Best Answer

    Posted 02-20-2015 07:39:00 AM
    It is a nornal database, for all intents and purposes. If Oracle supports it, you should be able to do it with Delphix. Not certain what the goal is, but if you just want to export the data out of Delphix on to the filesystem of the target, you can leverage the V2P feature.

  • 3.  RE: Backup of virtual database by RMAN.
    Best Answer

    Posted 02-20-2015 11:11:00 AM
    Adding to what Adam said, RMAN backups of a VDB are supported, but it is comparatively heavy lifting which need not be done when a snapshot using the Delphix Engine interface would do basically the same job.

    If you intend on using RMAN the only advice would be to steer clear of partial recovery, e.g. say: RMAN> recover database until logseq 100;

    When you start the database you will need to follow on with: "alter database open resetlogs".

    This will change the database incarnation number making it different from the value we hold in the Delphix engine, effectively acting like a rewind, but not telling the Engine about it. This will break things because we won't know which snapshot is the parent; so partial recovery is not something we would support. (Rewinding the VDB prior to the restore would bring you back out of this scenario).

  • 4.  RE: Backup of virtual database by RMAN.

    Posted 04-06-2015 09:53:00 PM
    In general there is no need to backup VDBs with RMAN, export/datapump, or any other technique.  You also do not need Flashback Database for VDBs.  Delphix will capture regular snapshots with Snapsync, and has the archive logs.  Delphix Professional Services routinely recommends to customers to eliminate the pain and expense of backing up virtualized databases.  It's a major benefit of the product.

    You can rewind your VDB to a prior point in time, which will fix pretty much anything: lost data, lost datafiles, administrator mistakes.

    You can also create a VDB from a VDB at a prior point in time.  This replaces TSPITR operations, and allows you to recover lost data without rewinding the VDB.