Re: Automatic backup of Oracle 7.3.4 on NT

From: <mallengold_at_my-deja.com>
Date: Mon, 19 Jul 1999 18:40:18 GMT
Message-ID: <7mvreg$4ae$1@nnrp1.deja.com>

The easiest thing to do is to write a script that runs the ORADIM and NTBACKUP utilities at times speicified by the NT schedule service. Sample scripts would look like the following.

Hope this helps, MAG

REM Database shutdown
REM nwln feeds a new line character to oradim

c:\backup\db_down.bat < c:\backup\local\nwln >> c:\backup\backup.log

@REM Batch file for MODI database shutdown
@REM Use oradim73 for both the instance and
service to be shut down
@REM If the service is not shut down then
ctl1<SID>.ora will not be backed up
@REM Created 1/20/99 MAG

@echo.

@time/t
@date/t
@echo on

oradim73 -SHUTDOWN -SID MODI -USRPWD
change_on_install -SHUTTYPE srvc,inst -SHUTMODE i

REM Batch file for scheduled normal backups; run every Tuesday.
REM Created 1/20/99 MAG
REM *****
REM Audit trail
REM Normal backups take 3.5 hours to complete (including verify) 2/12/99 MAG

echo.
time/t > c:\backup\backup.log
date/t >> c:\backup\backup.log

ntbackup backup c:\ d:\ /e/b/v/t
Normal /d "Normal Backup" /hc:on /l
c:\backup\backup.log

REM Database startup
REM nwln feeds a new line character to oradim

c:\backup\db_up.bat < c:\backup\local\nwln >> c:\backup\backup.log

@REM Batch file for MODI database startup
@REM Use oradim73 for both the instance and
service to be started
@REM This utility will only start a local database
@REM Created 1/20/99 MAG

@echo.

@time/t
@date/t
@echo on

oradim73 -STARTUP -SID MODI -USRPWD
change_on_install -STARTTYPE srvc,inst -PFILE c:\orant\database\initMODI.ora

In article <378dab39.0_at_news.webfactory.co.uk>,   "Janzeb" <jahanzeb_khan_at_nospam.gardiner- caldwell.com> wrote:

> Hi,
>
> How do you automatically back up Oracle DBs on

NT box, so that at some

> predetermined time (12:00am) this happens.
>
> Cheers
>
> JK
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Mon Jul 19 1999 - 13:40:18 CDT