Dataguard add and modify redolog size

DG online log group size change environment (single instance, centos 6.5x64, Oracle 10.2.0.5, filesystem storage) Redo online logselect * from V $ logfile where type = 'standby '; # The query is a standby log group of standby logselect * from V $ logfile where type <> 'standby'; # the query online log is set to four groups of 1. add alter database recover managed standby database Cancel to standby database standby log; # cancel appliedalter database add standby logfile group 8 ('/u01/APP/Oracle/oradata/netdata/st_redo08a.log ', '/u01/APP /Oracle/oradata/netdata/st_redo08b.log ') size 300 m; Alter database add standby logfile group 9 ('/u01/APP/Oracle/oradata/netdata/st_redo09a.log ', '/u01/APP/Oracle/oradata/netdata/st_redo09b.log') size 300 m; alter database add standby logfile group 10 ('/u01/APP/Oracle/oradata/netdata/st_redo10a.log', '/u01/APP/Oracle/oradata/netdata/st_redo10b.log ') size 300 m; Alter database add standby logfile Group 1 1 ('/u01/APP/Oracle/oradata/netdata/st_redo11a.log', '/u01/APP/Oracle/oradata/netdata/st_redo11b.log') size 300 m; 2. delete standby database standby logalter database drop logfile group 4; Alter database drop logfile group 5; Alter database drop logfile group 6; Alter database drop logfile group 7; if the following error occurs, switch the log error at line 1: ORA-00261: Log 4 of thread 1 is being archived or modifiedORA-00312: Online log 4 thread 1: '/U01/APP/Oracle/oradata/netdata/st_redo04b.log' 3. add alter database add standby logfile group 8 ('/u01/APP/Oracle/oradata/netdata/st_redo08a.log' to the master database standbylog ', '/u01/APP/Oracle/oradata/netdata/st_redo08b.log') size 300 m; alter database add standby logfile group 9 ('/u01/APP/Oracle/oradata/netdata/st_redo09a.log', '/u01/APP/Oracle/oradata/netdata/st_redo09b.log ') size 300 m; Alter database add standby log File Group 10 ('/u01/APP/Oracle/oradata/netdata/st_redo10a.log', '/u01/APP/Oracle/oradata/netdata/st_redo10b.log') size 300 m; alter database add standby logfile Group 11 ('/u01/APP/Oracle/oradata/netdata/st_redo11a.log', '/u01/APP/Oracle/oradata/netdata/st_redo11b.log ') size 300 m; 4. delete the old standby logalter database drop logfile group 4 of the master database; Alter database drop logfile group 5; Alter database drop logfile gro Up 6; Alter database drop logfile group 7; 5. add a new online redo logalter database add standby logfile group 12 ('/u01/APP/Oracle/oradata/netdata/st_redo12a.log ', '/u01/APP/Oracle/oradata/netdata/st_redo12b.log') size 300 m; alter database add standby logfile Group 13 ('/u01/APP/Oracle/oradata/netdata/st_redo13a.log', '/u01/APP/Oracle/oradata/netdata/st_redo13b.log ') size 300 m; Alter database add standby L Ogfile Group 14 ('/u01/APP/Oracle/oradata/netdata/st_redo14a.log', '/u01/APP/Oracle/oradata/netdata/st_redo14b.log') size 300 m; 6. the master database deletes the old online redolog before deleting the cut document. First, check whether it is active or inactive. If it is not inactive, multiple times archive alter system logfile switchalter system checkpointalter database drop logfile group 1; alter database drop logfile group 2; Alter database drop logfile group 3; 7. add a new online redo logalter system set stand to the standby Database By_file_management = 'manual'; Alter database add standby logfile group 12 ('/u01/APP/Oracle/oradata/netdata/st_redo12a.log ', '/u01/APP/Oracle/oradata/netdata/st_redo12b.log') size 300 m; alter database add standby logfile Group 13 ('/u01/APP/Oracle/oradata/netdata/st_redo13a.log', '/u01/APP/Oracle/oradata/netdata/st_redo13b.log ') size 300 m; Alter database add standby logfile Group 14 ('/u01/APP/Oracle/or AData/netdata/st_redo14a.log ','/u01/APP/Oracle/oradata/netdata/st_redo14b.log ') size 300 m; 8. delete the old online redo logsql> alter database drop logfile group 1; Alter database drop logfile group 1 * error at line 1: ORA-01624: log 1 needed for crash recovery of instance netdata (thread 1) ORA-00312: Online log 1 thread 1: '/u01/APP/Oracle/oradata/netdata/redo01.log' [email protected] ~] $ Oerr ora 0162401624,000 00, "log % s needed for crash recovery of instance % s (thread % s)" // * cause: A log cannot be dropped or cleared until the thread's checkpoint // has advanced out of the log. // * Action: if the database is not open, then open it. crash recovery will // advance the checkpoint. if the database is open force a global // checkpoint. if the log is too upted so that the database cannot // be opened, it may be necessary to do incomplete retil until // cancel at this log. try clean logfilealter database clear logfile group 1 * error at line 1: ORA-19527: Physical standby redo log must be renamedORA-00312: Online log 1 thread 1: '/u01/APP/Oracle/oradata/netdata/redo01.log' [[email protected] netdata] $ oerr ora 1952719527,000 00, "Physical standby redo log must be renamed" // * cause: the clear logfile command was used at a physical standby // database. this command cannot be used at a physical standby // database unless the log_file_name_convert initialization // parameter is set. this is required to avoid overwriting // The primary database's logfiles. // * Action set the log_file_name_convert initialization parameter. the log_file_name_convert parameter is not initialized. SQL> alter system set log_file_name_convert = '/u01/APP/Oracle/oradata/netdata /', '/u01/APP/Oracle/oradata/netdata/' scope = spfile; System altered. SQL> shutdown immediate; ORA-01109: Database not opendatabase dismounted. oracle instance shut down. SQL> startup nomount; Oracle instance started. total system global area 704643072 bytesfixed size 2098912 bytesvariable size 184551712 bytesdatabase buffers 511705088 bytesredo buffers 6287360 bytessql> alter database Mount standby database; database altered. SQL> alter database clear logfile group 1; database altered. SQL> alter database clear logfile group 2; database altered. SQL> alter database clear logfile group 3; database altered. SQL> alter database drop logfile group 1; database altered. SQL> alter database drop logfile group 2; database altered. SQL> alter database drop logfile group 3; database altered. SQL> alter system set standby_file_management = 'auto' scope = both; System altered. SQL> alter database recover managed standby database disconnect from session; database altered.

 

Dataguard add and modify redolog size