Re: Standby database question

To be honest I cant remember the specifics but any good DBA book will tell you, anyhow:

1. Standby DB is running in recovery mode
2. Archive logs from primary DB are applies, at intervals via scripts etc to the standby DB keeping in relatively in sync.
3. Both database have the same SID
4. Upon failure, copy over online redo's (if possible) and apply outstanding archive logs.
5. Open the DB

The standby now becomes your PRIMARY DB, you dont (usually) switch back over when things are Ok but that is an operational issue.

Annick van den Broek wrote in message
<01bdd1bc$469f8c40$c12017ac_at_sherekahn>...
>Hello,
>
>I have a question about a standby database. I have two servers (simple NT
>machines). One server is the production server and the other server is the
>test-server. I want the test-server to also contain a standby database (of
>the production server) in case the production server has hardware problems.
>How do I go about realizing this. If I understand correctly I have to
>create a database with the same initSID.ora file as the production database
>and start it up in Mount mode. But then what do I do? I hope somebody can
>help me.
>
>Awaiting an answer
>Annick
>
Received on Mon Aug 31 1998 - 08:39:30 CDT