What if we just want to shutdown Oracle before backing up?

This Wiki is brought to you by Backup Central, where you can find the Mr. Backup Blog, Forums, and a mailing list for each forum!
Backup FAQs	Service Providers	Backup Software	Backup Hardware	Backup Book Wiki	Free Stuff	Miscellaneous

Submitted by ndres Rojas arojasm@ADEXUS.CL

Long time ago I sent a question regarding the use of savepnpc to shutdown an Oracle database before performing a cold backup. The customer requires to save Oracle as single files which easies the procedure.

Here is what I came with:

1.- Use "savepnpc" for your backup command in your client setup.

2.- Use the groupname.res template file NetWorker created for you or create a new one.

3.- Use the documented syntax.

For example:

type: savepnpc;
precmd: "C:\\Program Files\\nsr\\bin\\shutdown.bat";
pstcmd: "C:\\Program Files\\nsr\\bin\\startup.bat";
timeout: "05:00"

Don't forget to: Use quotes, use the NT pathname not the "PROGRA~1" form, use double backslash as directory separator.

Your shutdown.bat file would contain the Oracle services stop command in non dependency order so that no one of them request for confirmation ("Y?"). For example:

net stop "OracleFirstService"
net stop "OracleSecondService"
net stop "OracleThirdService".

Then your startup.bat file would contain the same services in reverse order but using start this time. For example:

net start "OracleThirdService".
net start "OracleSecondService"
net start "OracleFirstService"

This small procedure worked for me and hope serves as a template for others. You should also probably read the savepnpc section of the FAQ.