Modify the redolog size of the dead ledg bad environment master database
-- 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 ';