Adding Log Groups on Oracle DataGuard Database

When adding Redo logs to a database which has a DataGuard associated with it, the log files have to manually be added to the destination. Below are the steps on how to add them to both the source and the DataGuard databases.

Adding Log Groups on Oracle DataGuard Database

On the source first determine the log file size and path.

select * from V$log;
select * from v$logfile;



The add the logfile on the source database.

ALTER DATABASE ADD LOGFILE thread 1 GROUP 5 size 2g;
ALTER DATABASE ADD LOGFILE thread 1 GROUP 6 size 2g;
ALTER DATABASE ADD LOGFILE thread 1 GROUP 7 size 2g;
ALTER DATABASE ADD LOGFILE thread 1 GROUP 8 size 2g;


Next determine the existing logfile groups and their sizes on the DataGuard database.

select * from v$standby_log;


Then cancel the recovery process on the dataGuard and add the new log groups.

Alter database recover managed standby database cancel;

ALTER DATABASE ADD STANDBY LOGFILE THREAD 1 GROUP 9 SIZE 2G;
ALTER DATABASE ADD STANDBY LOGFILE THREAD 1 GROUP 10 SIZE 2G;


Re-enable back the Redo APPLY mode on the DataGuard database.

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE disconnect;


Verify that the Recovery process is progressing using the views below.

select thread#, sequence#, applied, registrar
from v$archived_log
order by 2;

select archived_thread#, archived_seq#, applied_thread#, applied_seq#
from v$archive_dest_status;

select process, sequence#, status
from v$managed_standby
order by 2 desc;

Leave a Reply

Your email address will not be published.