Backup of virtual database by RMAN.

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered
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?
Photo of An agent

An agent

  • 170 Points 100 badge 2x thumb

Posted 4 years ago

  • 0
  • 1
Photo of Adam Bowen

Adam Bowen, Official Rep

  • 21,126 Points 20k badge 2x thumb
Official Response
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.
Photo of mrT

mrT, Employee

  • 110 Points 100 badge 2x thumb
Official Response
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).