--Standby Library Standby
Four Redolog of the main library were previously 50M sizes
Sql>
ALTER DATABASE recover managed standby database cancel;
Database altered.
sql> ALTER DATABASE Add standby logfile Group One (' +data/orcldg/onlinelog/standby_group_11.log ') size 60M;
ALTER DATABASE ADD standby logfile Group (' +data/orcldg/onlinelog/standby_group_12.log ') size 60M;
ALTER DATABASE ADD standby logfile Group (' +data/orcldg/onlinelog/standby_group_13.log ') size 60M;
ALTER DATABASE ADD standby logfile Group (' +data/orcldg/onlinelog/standby_group_14.log ') size 60M;
ALTER DATABASE ADD standby logfile Group (' +data/orcldg/onlinelog/standby_group_15.log ') size 60M;
ALTER DATABASE ADD standby logfile Group (' +data/orcldg/onlinelog/standby_group_16.log ') size 60M;
Repository Standby Delete
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;
Main Library Redo Add
ALTER DATABASE Add logfile Thread 1 Group One (' +data/orcl/onlinelog/group_11.log ') size 60m;
ALTER DATABASE Add logfile Thread 1 group (' +data/orcl/onlinelog/group_12.log ') size 60m;
ALTER DATABASE add logfile Thread 2 group (' +data/orcl/onlinelog/group_13.log ') size 60m;
ALTER DATABASE add logfile Thread 2 group (' +data/orcl/onlinelog/group_14.log ') size 60m;
Main Library Redo Delete
ALTER DATABASE drop logfile Group 1;
ALTER DATABASE drop logfile Group 2;
ALTER DATABASE drop logfile Group 3;
ALTER DATABASE drop logfile Group 4;
Repository Redo Add
You may get an error when you first delete, execute the following command:
Alter system set standby_file_management= ' manual ';
and then delete
ALTER DATABASE Add logfile Group 5 (' +data/orcldg/onlinelog/group_05.log ') size 60m;
ALTER DATABASE Add logfile Group 6 (' +data/orcldg/onlinelog/group_06.log ') size 60m;
ALTER DATABASE add logfile Thread 2 Group 7 (' +data/orcldg/onlinelog/group_07.log ') size 60m;
ALTER DATABASE add logfile Thread 2 Group 8 (' +data/orcldg/onlinelog/group_08.log ') size 60m;
ALTER DATABASE clear logfile ' +data/orcldg/onlinelog/group_2.272.862167353 '
Repository Redo Delete
ALTER DATABASE drop logfile Group 1;
ALTER DATABASE drop logfile Group 2;
ALTER DATABASE drop logfile Group 3;
ALTER DATABASE drop logfile Group 4;
--it's also possible.
ALTER DATABASE Add LogFile member (' +data/orcldg/onlinelog/group_2.273.862167353 ') size 60M reuse;
Create SPFile from pfile= ' $ORACLE _home/dbs/pfile_for_standby.txt '
If you encounter an error, see if there is a problem with Log_file_name_convert and Db_file_name_convert
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;
--Main Library standby Delete
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;
Main Library Standby add
ALTER DATABASE ADD standby logfile Group 5 (' +data/orcl/onlinelog/standby_group_05.log ') size 60M reuse;
ALTER DATABASE ADD standby logfile Group 6 (' +data/orcl/onlinelog/standby_group_06.log ') size 60M reuse;
ALTER DATABASE ADD standby logfile Group 7 (' +data/orcl/onlinelog/standby_group_07.log ') size 60M reuse;
ALTER DATABASE ADD standby logfile Group 8 (' +data/orcl/onlinelog/standby_group_08.log ') size 60M reuse;
ALTER DATABASE ADD standby logfile Group 9 (' +data/orcl/onlinelog/standby_group_9.log ') size 60M reuse;
ALTER DATABASE ADD standby logfile Group (' +data/orcl/onlinelog/standby_group_10.log ') size 60M reuse;
And then execute it in the standby library.
ALTER DATABASE recover managed standby database using current logfile disconnect;
Alter system set standby_file_management= ' auto ';
Oracle DG BAD Environment Main Library Redolog modified size