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 member and a size of 100 MB. We should create at least five standby redo log groups.

2. Add the standby redo logfiles as shown in the following example:

   SQL> alter database add standby logfile...