The Multifunctioning DBA

Oct 31 2012   8:30PM GMT

Another Delphix Bug

Colin Smith Colin Smith Profile: Colin Smith

To use Delphix for SQL Server, you must use ISCSI disk. This is not really an issue, but Delphix does not automatically set ISCSI up to automount as I think that it should. So the other day, I had to reboot my PPT server, that is the one with the databases in a recovering state and always applying the tlog backups from the source. well when it came back up, none of my databases were able to apply the logs. The issue ended up being that the disk where the database files were stored did not mount. Once I mounted the disk everything started to work. So just remember to set it up to automount. Also, if this happens then your sources will be disabled, and that means that the tlog backups are not being applied. You must enable them. you will be able to do this in the GUI eventually, but for now you will have to log into the CLI and enable it. This option is in Source — select source database — enable — commit. Then give it a bit of time, and if you have all the logs since it stopped, then it will start applying the logs. Just give it some time to catch up. If you have removed any of the tlog backup files from the share, then you have broken the recovery chain and you will need to sync the datasource, and that re-creates it, in order to back up and running.

 Comment on this Post

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when other members comment.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: