Re: When is anything written to standby redo logs on standby database
Date: Tue, 16 Sep 2008 14:40:12 -0700 (PDT)
On Sep 15, 9:24 am, DA Morgan <damor..._at_psoug.org> wrote:
> zigzag..._at_yahoo.com wrote:
> > When is anything written to standby redo logs on standby database
> > I am on Oracle 10.2.0.4 on HP UNIX 11i. I have read Oracle 10.2
> > concepts guide on technet.oracle.com, have read may article on
> > metalink and internet, yet I am unable to verify when anything is
> > written to standby redo logs on stand by database.
> > I have a simple database reconfiguration: a primary database and one
> > standby database.
> > I created primary database and set up log_archive_dest_2 to use LGWR
> > SYNC AFFIRM
> > I have created standby redo logs on primary.
> > alter database add standby logfile GROUP
> > I create standby control file on primary.
> > I copied all the primary information to create standby database. I
> > have put standby database in managed recovery.
> > I did archive log switches, I created a table and inserted information
> > in table.
> > I never saw standby redo logs updated on standby database by looking
> > at timestamp of standby redo log files.
> > I then setup database in maximum availability mode by running
> > following on primary:
> > Alter database set standby database to maximize availability
> > When I do insert into my tables, I do see standby redo log files on
> > primary database being updated, but I have never seen standby redo
> > logs on standby database updated. Why?
> > I am still at loss when actually standby redo logs are updated on
> > standby database.
> > When I read Oracle 9i database documentation on data guard, it says
> > that you do not need standby redo logs on primary instead you need
> > them on standby. Only reason, you need them on primary is from primary
> > changes role to standby database, so standby redo logs on standby
> > database should be updated instead of standby redo logs on primary.
> When things are written depends on whether you are running in
> synchronous or asychronous mode. One is real-time the other when a
> log file switch takes place.
> Daniel A. Morgan
> Oracle Ace Director & Instructor
> University of Washington
> damor..._at_x.washington.edu (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org- Hide quoted text -
> - Show quoted text -
I found that size of stgandby redo logs have to be identical to redo logs, otherwise Oracle does nor write to standby redo irrespective of ysnc/async protection modes etc. Received on Tue Sep 16 2008 - 16:40:12 CDT