Remote DataBase Server Stop / Start

[Vijayakumar S]

Dear All,

I would like to stop / start the DB in a remote server for few minutes. Because I have to take cold Backup by flashing the image to Shadow SAN and from there it will go to tape .

what are the possibility.

1. No cron Job. ( as per policy it has been desisabled )
2. No Control M - Automated tool is running.

3. But every week operator is stoping / starting

4. My tought , is there any possibility of running a cmd from Batch server to DB
server to stop / start. No rsh / rlogin all disabled. But sftp is there. Is it possible to connect and run any script at the
DB server.

Thanks in Advance.

Regards
Vijayakumar

[A. Clay Stephenson · Accepted solution]

Ssh would be a good secure option but perhaps the best would be using Data Protector with a pre-exec script. It would easily do this kind of backup. In fact, I have been doing something quite like this for many years.

[Vijayakumar S]

Hi Stephenson,

Thanks for the quick response.

Could you give me more tips how it will be
with some example of this.

Regards
Vijay S

[A. Clay Stephenson]

Since you didn't point out which it "it refers to, I'll assume that you meant the DP "it".

It's really quite simple. Any script or program that can be executed locally on the remote host, is simply added to the data specification as a "pre-exec" which are run on the remote host before the actual backup agents on the remote host start. There are also "post-exec" options which can run after the remote backup agent finishes.

Look for some of the Data Protector documentation. There are many examples.

[Vijayakumar S]

Hi Stephen,

I am not using Data Protector.

As per you suggestion i would like to ssh to the db server and trigger the stop / start
script only.

The DC will in the mean time ( 10 minutes ) flash the disk image to Shadow SAN.

There are asking only to stop the db and
restart the db for 10 minutes.

How exactly to go about that.

Regards
Vijay S