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.
Hello;1 person found this helpful
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.1 person found this helpful
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;
somebody else has set up the database - and the names of the standby redo logs are generated by OMF. I just wanted to keep this and don't change anything (I myself would not user OMF for those files).
I've created the files as you suggested - and everything is fine...
It is not needed to set DB_FILE_NAME_CONVERT and LOG_FILE_NAME_CONVERT for environment with different file structure and OMF enabled - benefit of using OMF.