Re: NT Oracle Backups Help Request

Hi John,

Basic outline of code for a cold backup - use lsnrctl<xx> to shut the listener
- use oradim<xx> -shutdown -sid <yoursid> -shutmode i -shuttype srvc,inst -password xxxx
-use any NTbackup command
- use oradim<xx> -startup -sid <yoursid> -starttype srvc,inst -pfile %ORACLE_HOME%\database\init<yoursid>.ora -password xxxx lsnrctl<xx> start.

This should be all

Hth,
Sybrand Bakker, Oracle DBA

John Page <john_at_treesong.demon.co.uk> wrote in message news:WyXzgBAaLpd3Ew9B_at_treesong.demon.co.uk...
> Hi, We are moving from Oracle 7.1 On VAX/OpenVMS Servers to Oracle 7.3.4
> on Alpha NT 4 Servers.
>
> I currently have DCL scripts that shut down the databases on various
> nodes, starts an image backup of all the database files and when that
> finishes restarts the database or databases.
>
> Question
>
> How do I do this kind of thing on NT 4?
>
> Any tips on Backups and exports on NT 4 would be a godsend, as a partime
> DBA I have to try to fit it in with the rest of my job in a small IT
> section.
> --
> John Page
> john.page_at_sandwell.ac.uk
> john_at_treesong.demon.co.uk
Received on Sun Jun 27 1999 - 17:02:00 CDT