Adding Redo Log members to Standby database

Checking Redo log files

col member for a90

set linesize 200

select * from v$logfile order by 1;

Adding Redo Logs

alter system set standby_file_management=manual;

ALTER DATABASE ADD LOGFILE MEMBER '&arq' to group &x;

check v$logfile if redo status INVALID

check which redo is not current

select * from v$log;

alter database clear logfile group &X;

If  you want to drop a member

ALTER DATABASE DROP LOGFILE MEMBER '&member';

If broker get failed, disable and enable configuration

Adding Standby Redo Logs

alter system set standby_file_management=manual;

to check if standby redo logs are being used check:

select * from v$standby_log;

alter system set standby_file_management=manual;

alter database recover managed standby database cancel;

To add a member:

ALTER DATABASE ADD STANDBY LOGFILE MEMBER '&arq' to group &x;

To Drop a member

alter database clear logfile group &X;

ALTER DATABASE DROP LOGFILE MEMBER '&arq';

Or to add standby redo log groups

ALTER DATABASE ADD STANDBY LOGFILE THREAD 1 GROUP 101

('/oracle/db1/XXXX/DATA/standby101a_XXXX.log', '/oracle/db2/XXXXX/DATA/standby101b_XXXX.log') SIZE 50M REUSE;

ALTER DATABASE ADD STANDBY LOGFILE THREAD 1 GROUP 102

('/oracle/db1/XXXX/DATA/standby102a_XXXX.log', '/oracle/db2/XXXXX/DATA/standby102b_XXXX.log') SIZE 50M REUSE;

ALTER DATABASE ADD STANDBY LOGFILE THREAD 1 GROUP 103

('/oracle/db2/XXXX/DATA/standby103b_XXXX.log', '/oracle/db1/XXXX/DATA/standby103a_XXXX.log') SIZE 50M REUSE;

ALTER DATABASE ADD STANDBY LOGFILE THREAD 1 GROUP 104

('/oracle/db2/XXXX/DATA/standby104b_XXXX.log', '/oracle/db1/XXXX/DATA/standby104a_XXXX.log') SIZE 50M REUSE;

To drop a group

ALTER DATABASE DROP LOGFILE GROUP &x;

alter system set standby_file_management=auto;

alter database recover managed standby database   through all switchover disconnect nodelay;

If broker get failed, disable and enable configuration

to check if standby redo logs are being used check:
select * from v$standby_log;