O'Reilly logo

Oracle Data Guard 11gR2 Administration Beginner's Guide by Nassyam Basha, Emre Baransel

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Time for action – configuring standby redo logs on primary

Run the following procedures on the primary database to create standby redo logfiles:

  1. Check the ORL's members and the sizes of each member as follows:
    SQL> select a.group#, a.status, a.bytes/1024/1024 SizeMB, b.member from v$log a, v$logfile b where a.group#=b.group# order by group#;
    
    GROUP# STATUS       SizeMB MEMBER
    ------ -------- ---------- --------------------------------------
         1 INACTIVE        100 /u01/app/oracle/oradata/orcl/redo01.log
         2 CURRENT         100 /u01/app/oracle/oradata/orcl/redo02.log
         3 INACTIVE        100 /u01/app/oracle/oradata/orcl/redo03.log
         4 INACTIVE        100 /u01/app/oracle/oradata/orcl/redo04.log
    

    Tip

    In this single instance of the primary database, we have four redo log groups, each with one ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required