Re: Standby Feature

Michael Dimitriadis wrote:

> Is it true that i would lose all commited transactions whose changes were
> written to the active redologfile when switching to the standby database
> because of a breakdown of the original server?

Michael,

Yes if you don't move the redologs with the move of the arhive logs you would loose any transactions which have not been written/committed before a log checkpoint or switch. However, you can force an archive or log checkpoint /switch even with the database in a relatively sick state. This would help you to recover the transactions. Additionally, you can fool the database by using 'dd of=/new/file/redolog if=/old/file /redolog' even with raw devices. This must be done with the database down however or not mounted. So before applying the archive logs and bringing up the new instance just simply copy the redologs from the old destination to the new one. This will also require that the instance name and SCN be consistent between the two instances (e.g. you can't bring up the new instance and let it march forward prior to the copy).

-- 
||----------------------------------------------------------------------||
|| Marc Marchioli
|| The DataBase Group, Inc.                       voice:  214-528-9459
|| 4011 Travis St.                                fax:    214-528-9459
|| Dallas, TX 75204-7512
|| marcm_at_computek.net                         @
|| (Challenging ORACLE and UNIX every day)    |-}ORACLE,UNIX
||                                            /\-------------->