Page 1 of 1

How to check database availability after shutdown services

Posted: 12 Dec 2011 7:06
by saipun
Hi,

Please help me with this.
as per title.i run a job that shutdown services on particular database for backup purpose(on control-m/em).
the question is, how can i check the database is really down ?
what command can i use to list the status for the current database?
i try to create a job that can do the trick.

thank you in advance.

Posted: 13 Dec 2011 3:36
by fafa1975
the command depends from database and os.
The best check is to log on database, but you must have a user on database.
If you don't have a user you could check if database process is up.
If you define your environment (DB/OS) I could send you a script that returns database status.

Posted: 12 Jun 2012 7:06
by jenna
IT companies can troubleshoot problems remotely or one of their clients can visit the office to carry the work in a timely manner. IT companies operates for 24 hours a day.

it support watford