Run the following procedures on the primary database to create standby redo logfiles:
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
Add the standby redo logfiles as shown in the following example:
SQL> alter database add standby logfile...