11g r2 data guard setup

All posts relating to Oracle database administration.

Moderator: Tim...

11g r2 data guard setup

Postby jackb » Thu Mar 15, 2012 8:52 am

Hi,

Could you please explain why in this article http://www.oracle-base.com/articles/11g ... _11gR2.php you create Standby Redo Logs on Primary Server. I am not getting it :(

Is it so that you don't have to create them in the standby? Why did you create 4 of them? What rule do you follow? The same number as the primary?

Thank you.
jackb
Member
 
Posts: 8
Joined: Wed May 28, 2008 12:17 pm

Re: 11g r2 data guard setup

Postby Tim... » Thu Mar 15, 2012 9:22 am

Hi.

Standby redo logs on the primary, ready for a switchover, where the primary becomes the standby.

There should always be 1 more standby redo log group than there are online redo log groups. I had three online redo log groups, so 4 standby. This is explained in the article:

http://www.oracle-base.com/articles/11g ... o_logs_man

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17935
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: 11g r2 data guard setup

Postby jackb » Thu Mar 15, 2012 3:39 pm

Yes, thank you, it is now clear.

But if I have a RAC like that?

Code: Select all
SQL> select max (bytes)/1024/1024 MB, count (1) from v$log;

        MB   COUNT(1)
---------- ----------
      1024          4

SQL> select GROUP#, THREAD#, MEMBERS, ARCHIVED, STATUS from v$log;

    GROUP#    THREAD#    MEMBERS ARC STATUS
---------- ---------- ---------- --- ----------------
         1          1          2 YES INACTIVE
         2          1          2 NO  CURRENT
         3          2          2 YES INACTIVE
         4          2          2 NO  CURRENT


I should do that?

alter database add standby logfile thread 1 group 6 '+dgfraelo/el_stby/standbylog/standby_group_06.log' size 1024M;
alter database add standby logfile thread 1 group 7 '+dgfraelo/el_stby/standbylog/standby_group_07.log' size 1024M;
alter database add standby logfile thread 1 group 8 '+dgfraelo/el_stby/standbylog/standby_group_08.log' size 1024M;
alter database add standby logfile thread 2 group 9 '+dgfraelo/el_stby/standbylog/standby_group_09.log' size 1024M;
alter database add standby logfile thread 2 group 10 '+dgfraelo/el_stby/standbylog/standby_group_10.log' size 1024M;
alter database add standby logfile thread 2 group 11 '+dgfraelo/el_stby/standbylog/standby_group_11.log' size 1024M;


Is it right?
jackb
Member
 
Posts: 8
Joined: Wed May 28, 2008 12:17 pm

Re: 11g r2 data guard setup

Postby Tim... » Thu Mar 15, 2012 4:11 pm

Hi.

The number of standby redo logs is:

((number of online redo logs per thread) + 1) * (number of threads)

So in your case you have 2 redo logs per thread and 2 threads, so (2+1)*2=6.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17935
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: 11g r2 data guard setup

Postby jackb » Thu Mar 15, 2012 4:14 pm

So what I did is correct?
jackb
Member
 
Posts: 8
Joined: Wed May 28, 2008 12:17 pm

Re: 11g r2 data guard setup

Postby Tim... » Thu Mar 15, 2012 4:18 pm

Yes. I thought was pretty obvious based on what I answered. Obviously not. :(
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17935
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: 11g r2 data guard setup

Postby jackb » Thu Mar 15, 2012 4:21 pm

Thank you Tim.
jackb
Member
 
Posts: 8
Joined: Wed May 28, 2008 12:17 pm

Re: 11g r2 data guard setup

Postby Tim... » Thu Mar 15, 2012 4:28 pm

:)
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17935
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: 11g r2 data guard setup

Postby jackb » Thu Mar 15, 2012 4:41 pm

It gets a bit complicated creating a data guard with 2 RACs :(
jackb
Member
 
Posts: 8
Joined: Wed May 28, 2008 12:17 pm

Re: 11g r2 data guard setup

Postby Tim... » Thu Mar 15, 2012 5:42 pm

Hi.

The extra steps necessary should be documented in the manuals.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17935
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK


Return to Oracle Database Administration

Who is online

Users browsing this forum: No registered users and 9 guests