Re: Shutting Oracle Down for Backup

Mark Rogowski <m.rogowski_at_uwinnipeg.ca> schreef in berichtnieuws 39244D55.4EBA6E29_at_uwinnipeg.ca...
> Hi Everyone,
>
> We have a setup with Windows NT Server 4.0 (patched), Oracle 7.3.4, and
> ARCServe for NT 6.61. We would like to do a flat-file backup regularly
> with compare of the entire system. Problem is, even though we tell
> Oracle to let go of the databases for backup through scripting, the
> compare fails on the database files.
>
> This tells me that Oracle as a service, needs to to be shut down for a
> successful backup and compare. Can someone confirm this? Is there
> something else that should be done to get a successful backup/compare on
> this system?
>
> Which leads to the second issue/point/question. We were told by an
> Oracle guru that it would be unwise to shut the Oracle service down
> through a(n) NT 'net stop' command. Since our intention is to back this
> system up late at night, there would be noone around to shut it down
> manually.
>
> Does anyone have any experience with shutting Oracle down through
> scripts, and if so, how has Oracle reacted to this? Any problems??
>
> Thanks.
>
> Mark
>

In Oracle you have cold and hot backup. Your backup procedure assumes cold backup, though Arcserve is capable of (assuming the Oracle Agent is present) hot backup.
For cold backup the database needs to be down. A net stop command is equivalent to a shutdown abort, ie a crash of the database.
You'll need to use the oradim73 command to shutdown the database oradim73 -shutdown -sid <yoursid> -password <the internal password> -shutmode i -shuttype srvc,inst Can be used in any .bat or .cmd file, no problem, also runs using WinAT, so no unpaid overtime involved :)

Hth,

Sybrand Bakker, Oracle DBA Received on Thu May 18 2000 - 00:00:00 CDT