Modify the redolog size of the oracle dg bad environment master database, dgredolog

Modify the redolog size of the oracle dg bad environment master database, dgredolog

-- Standby database standby
The four redologs in the master database were previously 50 MB in size.

SQL>

Alter database recover managed standby database cancel;
 
Database altered.
 
SQL> alter database add standby logfile group 11 ('+ DATA/orcldg/onlinelog/standby_group_11.log') size 60 M;
Alter database add standby logfile group 12 ('+ DATA/orcldg/onlinelog/standby_group_12.log') size 60 M;
Alter database add standby logfile group 13 ('+ DATA/orcldg/onlinelog/standby_group_13.log') size 60 M;
Alter database add standby logfile group 14 ('+ DATA/orcldg/onlinelog/standby_group_14.log') size 60 M;
Alter database add standby logfile group 15 ('+ DATA/orcldg/onlinelog/standby_group_15.log') size 60 M;
Alter database add standby logfile group 16 ('+ DATA/orcldg/onlinelog/standby_group_16.log') size 60 M;


Standby database standby Deletion
Alter database drop logfile group 5;
Alter database drop logfile group 6;
Alter database drop logfile group 7;
Alter database drop logfile group 8;
Alter database drop logfile group 9;
Alter database drop logfile group 10;



Add primary database redo


Alter database add logfile thread 1 group 11 ('+ DATA/orcl/onlinelog/group_11.log') size 60 m;
Alter database add logfile thread 1 group 12 ('+ DATA/orcl/onlinelog/group_12.log') size 60 m;
Alter database add logfile thread 2 group 13 ('+ DATA/orcl/onlinelog/group_13.log') size 60 m;
Alter database add logfile thread 2 group 14 ('+ DATA/orcl/onlinelog/group_14.log') size 60 m;


Primary database redo Deletion
Alter database drop logfile group 1;
Alter database drop logfile group 2;
Alter database drop logfile group 3;
Alter database drop logfile group 4;

Add standby database redo

An error may be reported at the beginning of deletion. Run the following command:

Alter system set standby_file_management = 'manual ';

Then delete

Alter database add logfile group 5 ('+ DATA/orcldg/onlinelog/group_05.log') size 60 m;
Alter database add logfile group 6 ('+ DATA/orcldg/onlinelog/group_06.log') size 60 m;
Alter database add logfile thread 2 group 7 ('+ DATA/orcldg/onlinelog/group_07.log') size 60 m;
Alter database add logfile thread 2 group 8 ('+ DATA/orcldg/onlinelog/group_08.log') size 60 m;

Alter database clear logfile '+ DATA/orcldg/onlinelog/group_2.272.862167353'


Slave database redo Deletion
Alter database drop logfile group 1;
Alter database drop logfile group 2;
Alter database drop logfile group 3;
Alter database drop logfile group 4;
 
-- This is also possible.
Alter database add logfile member ('+ DATA/orcldg/onlinelog/group_2.273.862167353') size 60 M reuse;

Create spfile from pfile = '$ ORACLE_HOME/dbs/pfile_for_standby.txt'

If an error occurs, check whether log_file_name_convert and db_file_name_convert are faulty.
Alter system set log_file_name_convert = '+ DATA/orcl/onlinelog, + DATA/orcldg/onlinelog' scope = spfile;
Alter system set db_file_name_convert = '+ DATA/orcl/datafile, + DATA/orcldg/datafile' scope = spfile;



-- Delete the master database standby
Alter database drop logfile group 5;

Alter database drop logfile group 6;

Alter database drop logfile group 7;
Alter database drop logfile group 8;
Alter database drop logfile group 9;
Alter database drop logfile group 10;
Add master database standby

Alter database add standby logfile group 5 ('+ DATA/orcl/onlinelog/standby_group_05.log') size 60 M reuse;
Alter database add standby logfile group 6 ('+ DATA/orcl/onlinelog/standby_group_06.log') size 60 M reuse;

Alter database add standby logfile group 7 ('+ DATA/orcl/onlinelog/standby_group_07.log') size 60 M reuse;
Alter database add standby logfile group 8 ('+ DATA/orcl/onlinelog/standby_group_08.log') size 60 M reuse;

Alter database add standby logfile group 9 ('+ DATA/orcl/onlinelog/standby_group_9.log') size 60 M reuse;
Alter database add standby logfile group 10 ('+ DATA/orcl/onlinelog/standby_group_10.log') size 60 M reuse;


Then execute
Alter database recover managed standby database using current logfile disconnect;
Alter system set standby_file_management = 'auto ';


How to solve multiple master databases in the dg under oracle

I don't quite understand what you mean. Can you explain it again?
 
Oracle DG Problems

Standby database requires recovery, indicating that your slave database is not synchronized with the master database

Enough logs are required. recover the logs and try again.