Server Replication

[cch]

Hi,<br>
<br>
I have a question regarding Oracle Backup:<br>
<br>
Is server replication (OS level with the help of a third party tool) a reliable form of doing Oracle<br>
database backup? I am wondering if we could recover the Oracle Database from this replicated server<br>
without ever encountering any problems? By the way, we are running Oracle on Windows NT 4.0.<br>
<br>
Thanks in advance and best regards,<br>
<br>
Clement <br>
<br>
<br>

 

[MikeLacey]

Which 3rd part tool?<br>
<br>
Mike<br>
---<br>
Mike_Lacey@Cargill.Com<br>

 

[TimG]

Clement,<br>
<br>
Remember to treat it like either a &quot;cold&quot; or &quot;hot&quot; backup. If you are not in ARCHIVELOG mode, you'd have to make sure that the database is shutdown cleanly and completely first. If the database is in ARCHIVELOG mode, you can go either way: &quot;cold&quot; or &quot;hot&quot;. Again, if you choose &quot;cold&quot;, shut the database down cleanly and completely. If you choose &quot;hot&quot;, make sure that the tablespaces are in BEGIN BACKUP mode prior to &quot;replicating&quot; and END BACKUP afterwards completion. You didn't mention which &quot;3rd party tool&quot;, but you did mention &quot;OS-level&quot;, so I'm guessing that it might be prudent to put all tablespaces into BEGIN BACKUP first, take the backup, and then END BACKUP all the tablespaces together afterward. This will be OK if your database is not too busy transactionally. If it is, I think you'll find some problems with this scheme, as the volume of redo logging will increase dramatically.<br>
<br>
Hope this helps...<br>
<br>
Tim