topic Re: standby database in Operating System - HP-UX

standby database

Tilak Gamalath — Thu, 19 Jun 2003 05:28:44 GMT

hi,

if I use rman to duplicate a database, in order to create a standby db, will the SCN of redo logs be the same. will i be able to apply the archivelogs?

Re: standby database

Massimo Bianchi — Thu, 19 Jun 2003 05:32:45 GMT

Hi,
as far as i know the answer is yes.

One of the main purpose of the standby database is to be able to recover the original DB, applying the archived redo-log.

HTH,
Massimo

Re: standby database

twang — Thu, 19 Jun 2003 05:52:29 GMT

After your standby database creation, the primary instance will archive a copy of archived log to the standby database server, if your standby database is in "recover managed standby database;" mode, the standby will auto-apply those archived logs to keep sync with your primary database.
If you open the standby database in read only mode, then you can use "recover standby database;"to manually apply those archived logs.

Re: standby database

Yogeeraj_1 — Thu, 19 Jun 2003 06:14:11 GMT

hi,

backup and restore and reinstantiate the standby at that point

this is the procedure.

hope this helps!

regards
Yogeeraj

Re: standby database

Yogeeraj_1 — Thu, 19 Jun 2003 06:27:33 GMT

hi again,

please find attached the oracle documentation page which describes in details how to manage the gap generated during the creation of the standby database.

hope this helps!

regards
Yogeeraj