Re: Snapshot Logfile

Hi Sami,

You probably meant Standby Redo Log Files, ISO Snapshot Logfiles.

Acc. to documentation:

B10823-01, 10g, P 5-26

'Minimally the configuration should have one more redo log group than the number of online redo log file groups on the primary database.'

rule of thumb (from the same page) to calculate the number of standby redo log files:

'(max.nr.of logfiles for each thread +1 ) * maximum number of threads.'

the 9i documentation is less specific, see p. 5-8 (A96653-02).

'The minimum configuration should have one more standby redo log group than the primary database'

multiple threads are not menationed at all in this section.

BTW, you should check you cut&paste tool, or report a bug in SQL*Plus. Your first query reports 14 rows selected where 12 are shown ;-)

Best regards,

Carel-Jan Engel

===
If you think education is expensive, try ignorance. (Derek Bok) ===

On Sun, 2005-08-28 at 00:43 -0400, Sami Seerangan wrote:

> Can someone help me here to setup Data Guard in maximum availability
> mdoe?
>
> We have 2 Node RAC primary and want to setup 2 Node RAC standby
> database in Maximum Availability mode.
>
> My question is how many SNAPSHOT LOGFILEs I have to create on the
> standby database side. (went through the document however it is not
> clear to me).
>
>
> 1* select inst_id,GROUP#,THREAD#,sequence#,members from gV$log
> SQL> /
>
> INST_ID GROUP# THREAD# SEQUENCE# MEMBERS
> ---------- ---------- ---------- ---------- ----------
> 1 1 1 191 1
> 1 2 1 192 1
> 1 3 1 190 1
> 1 4 2 125 1
> 1 5 2 126 1
> 1 6 2 124 1
> 2 1 1 191 1
> 2 2 1 192 1
> 2 3 1 190 1
> 2 4 2 125 1
> 2 5 2 126 1
> 2 6 2 124 1
>
> 14 rows selected.
>
> SQL> l
> 1 select * from gv$logfile
> 2* where type='ONLINE'
> SQL> /
>
> INST_ID GROUP# STATUS TYPE MEMBER
> ---------- ---------- ------- -------
> -----------------------------------
> 1 1 ONLINE /u01/oradata/primary/redo11.log
> 1 2 ONLINE /u02/oradata/primary/redo12.log
> 1 3 ONLINE /u03/oradata/primary/redo13.log
> 1 4 ONLINE /u01/oradata/primary/redo21.log
> 1 5 ONLINE /u02/oradata/primary/redo22.log
> 1 6 ONLINE /u03/oradata/primary/redo23.log
> 2 1 ONLINE /u01/oradata/primary/redo11.log
> 2 2 ONLINE /u02/oradata/primary/redo12.log
> 2 3 ONLINE /u03/oradata/primary/redo13.log
> 2 4 ONLINE /u01/oradata/primary/redo21.log
> 2 5 ONLINE /u02/oradata/primary/redo22.log
> 2 6 ONLINE /u03/oradata/primary/redo23.log
>
> 12 rows selected.
>
> SQL>

--
http://www.freelists.org/webpage/oracle-l