Re: Backup on NT

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 Thu Feb 26 1998 - 00:00:00 CST