This content has been marked as final. Show 6 replies
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.
Just recreate them. This resize note should help :
ALTER DATABASE ADD STANDBY LOGFILE GROUP 4 '/u01/app/oracle/oradata//redo04.log' SIZE 200M;
*Unable To Drop And Recreate Standby Logfiles [ID 395146.1]*
since I haven't created the environment I wonder in which directory the standby redo log file would get created when issuing the command
ALTER DATABASE ADD STANDBY LOGFILE GROUP 4 SIZE xxM;
Is there any chance to figure out which directory would get used? The file should end up in
and the name of the file can get generated by Oracle's OMF...
What advantage does OMF give you? I don't see a word on this in the Data Guard documentation.
Just create them :
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;