Does replacing the physical databases with Virtual database,creates any issues in maintaining data bases for longer run

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

Does replacing the physical databases with Virtual database,creates any issues in maintaining data bases for longer run

What all the maintenance activities we need to be prepared before migrating from physical to virtual databases ?

Please let me know the activities to maintain the virtual data bases for longer ran..

Could there be chances of crashing of Vdb's if  the calls are two high to the vdb's ?

What all the precautionary measure to be taken while migrating from physical to Virtual  ?



Photo of K J M RAO

K J M RAO

  • 440 Points 250 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Photo of Adam Bowen

Adam Bowen, Official Rep

  • 17,420 Points 10k badge 2x thumb
Official Response
Questions in order:

Q: Does replacing the physical databases with Virtual database,creates any issues in maintaining data bases for longer run?
A: No. It actually is far easier to manage virtual databases as Delphix has built-in functionality to automatically backup every transaction of the database. And the backup data can be set to a retention policy. Plus you can refresh and rewind with the click of a button. It doesn't get any easier than that.

Q: What all the maintenance activities we need to be prepared before migrating from physical to virtual databases?
A: No maintenance activities. There are simple prerequisites, which are listed in our documentation (http://docs.delphix.com) and vary slightly for eachdatabase type.

Q: Please let me know the activities to maintain the virtual data bases for longer run
A: Set a retention policy for how long you want to keep historical data. Delete databases you no longer want to keep or archive. That's pretty much it. 

Q: Could there be chances of crashing of Vdb's if  the calls are two high to the vdb's ?
A: Sure. The VDB's still leverage an RDBMS, like Oracle. So, if you could crash a physical DB on an 2CPU/8GB instance of Oracle, it would also crash on a virtual database.

Q: What all the precautionary measure to be taken while migrating from physical to Virtual?
A: None really. Delphix is non-intrusive and non-disruptive. You can create a copy of the physical database without interrupting the physical database and use the virtual copies. If you wanted to replace the physical copy with the virtual copy, then once you tested the virtual copy and you are satisfied, you can point your applications to the VDB.