Snapshot Logfile
- From: Sami Seerangan <dba.orcl@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Sun, 28 Aug 2005 00:43:13 -0400
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>
Other related posts:
