Snapshot Logfile

From: Sami Seerangan <dba.orcl_at_gmail.com>
Date: Sun, 28 Aug 2005 00:43:13 -0400
Message-ID: <f09dd62805082721434e07023a@mail.gmail.com>

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 Received on Sat Aug 27 2005 - 23:45:16 CDT