Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: URGENT: Hot StandBy database feature
You will not lose any data when the prod database
fails except transactions in online redo logs.
Standby database in 8i has automatic archival, the archived redo logs from primary site can be automatically shipped to the standby site and stored.
In case when primary fails you have to manually make standby database as your primary database. Once you make that YOU CAN NOT GO BACK once your primary database is up. Standby database will be your primary database.
Hope this helps..
Ashish
--- Balasubramanian M <sbala_at_hclinsys.com> wrote:
>
> Dear all,
>
> I did not get any response for my earlier mail which
> is given below.
> How standby database works ..in the sense when
> production database fails
> how the standby take over whether automatic or
> manual switch over.
> How the transaction is written to both the databases
> ?
> In case production database fails , whether there
> will be any loss of
> data.
>
> I hope some one on the list can help me.