The question now is:Standby Redo Logs would not be used on primary database until you perform a switchover operation. So, I would say, you can create the 3 standby redo log groups on the primary database.
- would it be correct just to create 3 new standby redo log groups (group# 4, 5 and 6) on the primary site or would that cause
I would use the statement ALTER DATABASE ADD STANDBY LOGFILE GROUP 4 SIZE xxM. Would that create fa OMF file?The files are on OMF. So your above mentioned command would perfectly work out.
ALTER DATABASE ADD STANDBY LOGFILE GROUP 4 '/u01/app/oracle/oradata//redo04.log' SIZE 200M;
ALTER DATABASE ADD STANDBY LOGFILE GROUP 4 '/opt/oracle/oradata/DB/archfiles/flashback/DB/onlinelog/redo04.log' SIZE 200M; ALTER DATABASE ADD STANDBY LOGFILE GROUP 5 '/opt/oracle/oradata/DB/archfiles/flashback/DB/onlinelog/redo05.log' SIZE 200M; ALTER DATABASE ADD STANDBY LOGFILE GROUP 6 '/opt/oracle/oradata/DB/archfiles/flashback/DB/onlinelog/redo06.log' SIZE 200M;