Re: Oracle 7.3 Backup on NT

Hi Mike,

Apart from the issue which kind of NT server will be capable of running 8 instances, you only have to make sure every SID will have it's own directory. Usually I did something like d:\rdbmsorcl, d:\rdbmsbis etc. I always moved the files out of the ORANT\RDBMS<whatever version>, to make sure I wouldn't have to move files with every upgrade. If you don't have different directories now, shutdown each sid, make an NT backup, move the file containing the system tablespace and any other files, mount each database and start renaming datafiles. The doc will tell you how.

Hth,

Sybrand Bakker, Oracle DBA

Mike Bradicich wrote:

> I have a number of Oracle 7.3 databases running on separate NT
> machines. Currently I am backing up each server using NT backup of
> all of the drives to a 4mm tape.
>
> The recovery plan is to then load these tapes on to another PC.
>
> The problem is that if I have a disaster, I want to recover all my
> databases, currently on 8 separate servers, to one server. I am
> concerned that as I pull the database files off each tape, the system
> tables will be over-written, and the databases will be corrupted.
>
> Is there a way to recover the database files from tapes off multiple
> machines, to a single machine? Should I consider another backup
> strategy (if so, what)?
>
> Any and all comments are appreciated,
> Mike Bradicich
>
> mike_at_generalsystems.com
>
> Bradicich Consulting
> 8504 Ewing Dr.
> Bethesda, MD 20817
Received on Fri Aug 14 1998 - 15:25:41 CDT