Delphix Products

Expand all | Collapse all

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

Jump to Best Answer
  • 1.  How to know from source and target database server that delphix is implemented for this database

    Posted 02-24-2016 08:11:00 AM
    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.


  • 2.  RE: How to know from source and target database server that delphix is implemented for this database

    Posted 02-24-2016 08:28:00 AM

    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....




  • 3.  RE: How to know from source and target database server that delphix is implemented for this database
    Best Answer

    Posted 02-24-2016 08:30:00 AM
    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.




  • 4.  RE: How to know from source and target database server that delphix is implemented for this database

    Posted 02-24-2016 08:30:00 AM
    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..?


  • 5.  RE: How to know from source and target database server that delphix is implemented for this database

    Posted 02-24-2016 08:35:00 AM

    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.




  • 6.  RE: How to know from source and target database server that delphix is implemented for this database

    Posted 02-24-2016 08:38:00 AM
    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..


  • 7.  RE: How to know from source and target database server that delphix is implemented for this database

    Posted 02-24-2016 08:45:00 AM

    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 ..




  • 8.  RE: How to know from source and target database server that delphix is implemented for this database

    Posted 02-24-2016 08:49:00 AM
    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.


  • 9.  RE: How to know from source and target database server that delphix is implemented for this database

    Posted 03-22-2017 07:32:00 AM
    Hi Everyone, I have one query, VDB will use target server recourse or delphix engine resource at the time of processing the transaction