How to know from source and target database server that delphix is implemented for this database

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
How to know from source and target database server that delphix is implemented for this database, is there any process running on Server because database will seems like to be independent read/write database so how can we get to know weather this database is running for Delphix.
Photo of Nikhil Jain

Nikhil Jain

  • 494 Points 250 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of Prem Reddy

Prem Reddy

  • 170 Points 100 badge 2x thumb

Hi Nikhil.


I think the simple way to find the target database running on the target server , which shows the mount points related to your delphix engine server...

you can see the df-h | grep your delphix mount point/or db name....


Photo of Matt Watson

Matt Watson, Employee

  • 782 Points 500 badge 2x thumb
Official Response
Hi,

 On a target server, its pretty easy, there will be NFS mounts from the Delphix Engine mounted on the target server ( assuming a *nix target, windows with have iscsi devices from the engine ).

 On a source server its a little bit more difficult, a few things you can look for though, 
 1. There will be a Delphix toolkit directory somewhere on the host
 2. Assuming this is oracle, you can query the v$backup_files view to see if any backups have a tag like 'DLPX%', 
 3. Again, assuming oracle, you could look in v$session or dba_hist_active_sess_history for sessions coming from the Delphix Engine.
 4. You could look for network traffic/connections to the Delphix Engine.

In both cases though, the best way would just be to login to the Delphix Engine and look at the configuration.
Photo of Nikhil Jain

Nikhil Jain

  • 494 Points 250 badge 2x thumb
Hello,Thanks for the reply..so it means we don't need to install any software on target and source database server related to delphix, only installation need on delphix engine..?
Photo of Prem Reddy

Prem Reddy

  • 170 Points 100 badge 2x thumb

Hello,


No, Delphix won't install anything on source/or target only you need to copy the toolkit and check the prerequisites.. Like delphix user, read/write permission to mount point, sudo privilege to delphix user to mount, unmount the file system, read permission to /etc/oratab... etc.


Photo of Nikhil Jain

Nikhil Jain

  • 494 Points 250 badge 2x thumb
Hello Prem, Thanks for your response..so what exactly toolkit role...and how delphix engine get to know which is source and which is target server..
Photo of Prem Reddy

Prem Reddy

  • 170 Points 100 badge 2x thumb

Toolkit , is some of the delphix written   shell /rman scripts.. which do the rman level0/ level1 backup scripts... while you are configuring the Delphix  ---dSource which have the details of  Source server name, username, password/ dbname etc.. with that it connects from Delphix engine to SourceSever/dbname to get the db changes ( level 0 initially one time) after that it take level 1 or incremental backup/or archivelogs  backup to delphix engine..

Target also similar.. you need to configure in delphix engine where your vDB to be created -- like server name , osuser. dbname , mount point  etc.

When you are provisioning a vDB  all the above details are required ..


Photo of Nikhil Jain

Nikhil Jain

  • 494 Points 250 badge 2x thumb
Thanks a lot for this informative information , now I can understand the delphix configuration...actually I have not implemented it , just supporting so I am not clear about few concepts.
Photo of Nikhil Jain

Nikhil Jain

  • 494 Points 250 badge 2x thumb
Hi Everyone, I have one query, VDB will use target server recourse or delphix engine resource at the time of processing the transaction