Re: Backup on NT

It is worth noting that with 7.3.4 you can use the Enterprise Manager / EBU / Legato combination to perform just about every sort of backup. Importantly it allows backups to TAPE.

Regards
David

Greg Parsons wrote in message <34F5DD8E.7133C768_at_intermetrics.com>...
>Hi,
> Your backups currently are not likely to work if people are using the
>database while your going through your copy/backup procedure (esp. once
>the files get large - sys*.ora won't contain consistent data with the
>headers on the other files). Since you can turn them off once a day -
>I'd advise doing so. If you need to stay up 24x7, you probably want to
>investigate ARCHive log mode.
> For cold backups, BackupExec or Arcserve allow daily job scheduling,
>shutdown/startup procedure done through a prejob and postjob feature.
>Both packages (I think) allow drive and directory specification.
>
>Greg
>
>
>Ana Neto wrote:
>>
>> Hi everyone!
>>
>> I would like to know what is the best way to backup an Oracle database
>> on a Windows NT machine.
>>
>> I have Oracle Server 7.3 on Windows NT Server 4.0 machine. I currently
>> have 3 small databases, but they are growing. I am using a batch file
>> that calls ocopy to copy all the database files (ctl*.ora, log*.ora,
>> rbs*.ora, sys*.ora, tmp*.ora, usr*.ora) to another hard disk location
>> (with the database up) and then use ntbackup to back them up to tape. I
>> schedule this batch file using the at command.
>>
>> I would (ideally) like to:
>> - Backup directly to tape
>> - Keep the backup scheduled/unattended
>> - Specify the database to backup and not each file of the database
>>
>> I can afford to shutdown the database at night and do cold backups, if
>> there is an unattended way to do the shutdown and startup of the
>> database.
>>
>> Any ideas/suggestion will be greatly appreaciated!
>> Oh, and could you please send them not only to the newsgroup but also to
>> my e-mail address?
>>
>> Thank you so much!
>>
>> Ana Neto
>> e-mail: ana.neto_at_pararede.pt
Received on Sat Feb 28 1998 - 00:00:00 CST