Re: NT Hot Backup

The NT bit makes no difference. Hot backups work the same whatever O/S you run on.

Basically, you take your database one tablespace at a time. Issue the command 'alter tablespace blah begin backup'. As quickly as you can, you now drop to the OS, and use good old copy commands to copy the relevant dbf's to somewhere safe. You then issue the command 'alter tablespace blah end backup' Caution suggests that you then issue the command 'alter system switch logfile'
Then you move on to tablespace blah2, and repeat all the above steps. And so ad infinitum until all tablespaces are backed up.

Finally, you issue either 'alter database backup controlfile to 'c:\wherever\controlfilebackup.bkp' or 'alter database backup controlfile to trace'.

The first produces a binary image of the controlfile (of limited use) in the specified directory. The second creates a trace (ie text) file sql script that will re-construct your controlfile from scratch (of great use) in whatever location your user_dump_dest parameter is pointing to.

Then you transfer the whole lot off to tape.

You don't even THINK of backing up the online redo logs.

Incidentally, the time a tablespace spends in hotbackup mode needs to be as short as possible because for the duration, every piece of DML affecting that tablespace, however miniscule, nevertheless generates entire *blocks* of redo, instead of just the usual before and after images of the records affected by the DML. In otherwords, the quantity of redo generated for that tablespace increases by a factor of hundreds or more.

You might want to check out the backup and recovery document I wrote a while back for the backup and recovery course at Oracle. It's at http://www.geocities.com/howardjr2000/backup_and_recovery.htm

...and I'm sorry that it doesn't appear to want to work with Navigator, only IE. God knows why.

Regards
HJR "Alb" <albert.p_at_rmt.com.au> wrote in message news:3b2ebaa1$1_at_news...
> Can anyone refer me to instructions/example scripts for backing up Oracle
 on
> NT online?
> Thanks
>
>
Received on Tue Jun 19 2001 - 04:23:42 CDT