Re: Shutdown from OS Batch File (NT40), and Backup

Svein-Egil,

I use ArcServe on NT to shutdown and startup Oracle databases for a cold backup using the before and after backup tasks. Here's how I do it.

The ArcServe before task routine calls an NT command file named dbshut_all_local.cmd which contains the single line.... svrmgr23 command=@j:\oracle\adm\dbshut_all_local.sql

dbshut_all_local.sql contains the commands ... spool j:\oracle\adm\dbshut_all_local.log connect /@tst as sysdba
shutdown immediate
spool off
exit

The operating system administrator account (which in reality is named something other than "administrator" for security purposes) under which ArcServe runs, is a member of the NT Local Group named ORA_DBA which allows it to connect to Oracle as SYSDBA. Within Oracle an account named OPS$administrator exists which allows the server manager command file to use a slash instead of embedding an Oracle username and password (a potential security risk). Also the OPS$administrator account has been granted the role DBA so that it may startup and shutdown the database and perform other tasks not related to a server manager login.

For additional security the OS NT administrator account under which ArcServe runs is the only account in the database set up to use the OPS$ logon prefix and under NT's user manager for domains, that account is restricted to logging into the domain from only the Oracle server which is locked securely away in the computer room.

Relevant init.ora parameters for this approach are; remote_login_passwordfile = EXCLUSIVE
 os_authent_prefix = OPS$

After the backup of the entire server is complete the after task routine calls an NT command file named
dbstart_all_local.cmd which contains the single line.... svrmgr23 command=@j:\oracle\adm\dbstart_all_local.sql

dbstart_all_local.sql contains...
spool j:\oracle\adm\dbstart_all_local.log connect /@tst as sysdba
startup pfile=j:\oracle\tst\ora\inittst.ora spool off
exit

Regards,

Craig M. Wall Sr. Oracle DBA / Manager of Oracle Technology - C.I.S.A.

Svein-Egil Pettersen wrote in message ...
>Hello!
>Does anyone know how to make an OS Batchjob to shutdown
>the DB before backup, and then start the DB after
>Backup. I am using Cheyenne Arcserve backup SW. Cheyenne
>has the possibility to do 'Before backup job' and
>'After Backup job' in the backup task.
>This shutdown and startup has to go without any
>user action. This is a fullvolum backup job of all
>partitions and all disks.
>Perhaps even an export before backup starts.
>
>Any tips/Ideas
>Config: Oracle 7.3.3 (NT)
> Enterprise Manager 1.4
> Win NT 4.0 Server
> 12 GB Disks
>
>Regards
>
>Svein-Egil Pettersen Email #1: svpett_at_online.no
>Joh-Data AS Email #2: svpett_at_ibm.net
>Oslo, Norway Email #3: 100445,1527(Compuserve)
Received on Tue Dec 16 1997 - 00:00:00 CST