Hello.
I am running Oracle 11.2 (on Solaris) and have a question regarding redo log members.
Unfortunately, I do not have a test database that mimics production to test what I need to do, otherwise I would just do it in test and not need to ask this. Anyway...
I found that the production database has 3 members in each redo log group. Knowing that there is no real valid reason for having more than 2 members per log group, I would like to drop one of the log group members. So, my question regards the standby log members. And if there are any additional steps I need to take for the standby database.
For example, I have 9 redo log groups. 4 for primary, and 5 for standby.
This is good. No problems with this. I just want to reduce the number of members in each group from 3 to 2.
It appears (from http://psoug.org/reference/log_files.html) that I just need to specify the "standby" parameter in my syntax for dealing with the standby log members.
ALTER DATABASE DROP [STANDBY] LOGFILE MEMBER <logfile_member_path_and_name>;
Will this same action also take place automatically on the standby database?
I assume it would, but just wanted to confirm.