Exadata数据库DG环境的Redolog日志文件瘦身提高传送效率

最新推荐文章于 2024-08-31 23:36:42 发布
最新推荐文章于 2024-08-31 23:36:42 发布
阅读量118 收藏
点赞数
文章标签： 数据库
原文链接：http://www.cnblogs.com/kelemeng/p/4417854.html
版权

局域网内的Exadata一体机数据库DG也放在同一机房内的虚拟机上，项目时把PRD的redolog大小设置为4G，传输到DG备机上也的archivelog归档日志过大，网络传送花时间长，因此需要重新设置redolog大小

查询日志情况

col group# format 99
col member format a60
col status format a7
col TYPE format a7
col IS_RECOVERY_DEST_FILE format a3

--REDO ONLINE LOG STANDBY LOG
select group#,member,type from v$logfile where type='STANDBY';

09:05:50 SQL> select group#,member,type from v$logfile where type='STANDBY';

GROUP# MEMBER TYPE
------ ------------------------------------------------------------ -------
15 /oracle/PRD/sapdata1/STDBY/onlinelog/group_15.2333.869677413 STANDBY
16 /oracle/PRD/sapdata1/STDBY/onlinelog/group_16.2332.869677415 STANDBY
17 /oracle/PRD/sapdata1/STDBY/onlinelog/group_17.2331.869677417 STANDBY
18 /oracle/PRD/sapdata1/STDBY/onlinelog/group_18.2330.869677419 STANDBY
19 /oracle/PRD/sapdata1/STDBY/onlinelog/group_19.2329.869677421 STANDBY
25 /oracle/PRD/sapdata1/STDBY/onlinelog/group_25.1862.869677441 STANDBY
26 /oracle/PRD/sapdata1/STDBY/onlinelog/group_26.1861.869677445 STANDBY
27 /oracle/PRD/sapdata1/STDBY/onlinelog/group_27.1860.869677447 STANDBY
28 /oracle/PRD/sapdata1/STDBY/onlinelog/group_28.1859.869677449 STANDBY
29 /oracle/PRD/sapdata1/STDBY/onlinelog/group_29.1857.869677451 STANDBY

10 rows selected.

09:06:59 SQL>

--select * from v$logfile where type='STANDBY';
--＃查询为standby log　10组

select group#,member,type from v$logfile where type<>'STANDBY';

09:07:59 SQL> select group#,member,type from v$logfile where type<>'STANDBY';

GROUP# MEMBER TYPE
------ ------------------------------------------------------------ -------
11 /oracle/PRD/sapdata1/STDBY/onlinelog/group_11.2478.867924049 ONLINE
12 /oracle/PRD/sapdata1/STDBY/onlinelog/group_12.2477.867924053 ONLINE
13 /oracle/PRD/sapdata1/STDBY/onlinelog/group_13.2476.867924055 ONLINE
14 /oracle/PRD/sapdata1/STDBY/onlinelog/group_14.2410.867924057 ONLINE
21 /oracle/PRD/sapdata1/STDBY/onlinelog/group_21.2416.867924605 ONLINE
22 /oracle/PRD/sapdata1/STDBY/onlinelog/group_22.2415.867924607 ONLINE
23 /oracle/PRD/sapdata1/STDBY/onlinelog/group_23.2413.867924611 ONLINE
24 /oracle/PRD/sapdata1/STDBY/onlinelog/group_24.2412.867924613 ONLINE

8 rows selected.

09:08:00 SQL>

--select * from v$logfile where type<>'STANDBY';
--#查询ONLINE LOG 为8组

PRD

09:12:12 SQL> select group#,member,type from v$logfile where type='STANDBY';

GROUP# MEMBER                                             TYPE
    15 +DATA/prd/onlinelog/group_15.2333.869677413        STANDBY
    16 +DATA/prd/onlinelog/group_16.2332.869677415        STANDBY
    17 +DATA/prd/onlinelog/group_17.2331.869677417        STANDBY
    18 +DATA/prd/onlinelog/group_18.2330.869677419        STANDBY
    19 +DATA/prd/onlinelog/group_19.2329.869677421        STANDBY
    25 +DATA/prd/onlinelog/group_25.1862.869677441        STANDBY
    26 +DATA/prd/onlinelog/group_26.1861.869677445        STANDBY
    27 +DATA/prd/onlinelog/group_27.1860.869677447        STANDBY
    28 +DATA/prd/onlinelog/group_28.1859.869677449        STANDBY
    29 +DATA/prd/onlinelog/group_29.1857.869677451        STANDBY

10 rows selected.

09:12:37 SQL>

09:12:37 SQL> select group#,member,type from v$logfile where type<>'STANDBY';

GROUP# MEMBER                                             TYPE
    11 +DATA/prd/onlinelog/group_11.2478.867924049        ONLINE
    12 +DATA/prd/onlinelog/group_12.2477.867924053        ONLINE
    13 +DATA/prd/onlinelog/group_13.2476.867924055        ONLINE
    14 +DATA/prd/onlinelog/group_14.2410.867924057        ONLINE
    21 +DATA/prd/onlinelog/group_21.2416.867924605        ONLINE
    22 +DATA/prd/onlinelog/group_22.2415.867924607        ONLINE
    23 +DATA/prd/onlinelog/group_23.2413.867924611        ONLINE
    24 +DATA/prd/onlinelog/group_24.2412.867924613        ONLINE

8 rows selected.

09:13:14 SQL>

1.在备库添加新的10组 standby log
alter database recover managed standby database cancel;
--#先取消APPLIED
alter database add standby logfile group 31 ('/oracle/PRD/sapdata1/STDBY/onlinelog/group_31_redo.log') size 500M;
alter database add standby logfile group 32 ('/oracle/PRD/sapdata1/STDBY/onlinelog/group_32_redo.log') size 500M;
alter database add standby logfile group 33 ('/oracle/PRD/sapdata1/STDBY/onlinelog/group_33_redo.log') size 500M;
alter database add standby logfile group 34 ('/oracle/PRD/sapdata1/STDBY/onlinelog/group_34_redo.log') size 500M;
alter database add standby logfile group 35 ('/oracle/PRD/sapdata1/STDBY/onlinelog/group_35_redo.log') size 500M;
alter database add standby logfile group 36 ('/oracle/PRD/sapdata1/STDBY/onlinelog/group_36_redo.log') size 500M;
alter database add standby logfile group 37 ('/oracle/PRD/sapdata1/STDBY/onlinelog/group_37_redo.log') size 500M;
alter database add standby logfile group 38 ('/oracle/PRD/sapdata1/STDBY/onlinelog/group_38_redo.log') size 500M;
alter database add standby logfile group 39 ('/oracle/PRD/sapdata1/STDBY/onlinelog/group_39_redo.log') size 500M;
alter database add standby logfile group 40 ('/oracle/PRD/sapdata1/STDBY/onlinelog/group_40_redo.log') size 500M;

09:28:16 SQL> select group#,member,type from v$logfile where type='STANDBY';

GROUP# MEMBER TYPE
------ ------------------------------------------------------------ -------
15 /oracle/PRD/sapdata1/STDBY/onlinelog/group_15.2333.869677413 STANDBY
16 /oracle/PRD/sapdata1/STDBY/onlinelog/group_16.2332.869677415 STANDBY
17 /oracle/PRD/sapdata1/STDBY/onlinelog/group_17.2331.869677417 STANDBY
18 /oracle/PRD/sapdata1/STDBY/onlinelog/group_18.2330.869677419 STANDBY
19 /oracle/PRD/sapdata1/STDBY/onlinelog/group_19.2329.869677421 STANDBY
25 /oracle/PRD/sapdata1/STDBY/onlinelog/group_25.1862.869677441 STANDBY
26 /oracle/PRD/sapdata1/STDBY/onlinelog/group_26.1861.869677445 STANDBY
27 /oracle/PRD/sapdata1/STDBY/onlinelog/group_27.1860.869677447 STANDBY
28 /oracle/PRD/sapdata1/STDBY/onlinelog/group_28.1859.869677449 STANDBY
29 /oracle/PRD/sapdata1/STDBY/onlinelog/group_29.1857.869677451 STANDBY
31 /oracle/PRD/sapdata1/STDBY/onlinelog/group_31_redo.log STANDBY

GROUP# MEMBER TYPE
------ ------------------------------------------------------------ -------
32 /oracle/PRD/sapdata1/STDBY/onlinelog/group_32_redo.log STANDBY
33 /oracle/PRD/sapdata1/STDBY/onlinelog/group_33_redo.log STANDBY
34 /oracle/PRD/sapdata1/STDBY/onlinelog/group_34_redo.log STANDBY
35 /oracle/PRD/sapdata1/STDBY/onlinelog/group_35_redo.log STANDBY
36 /oracle/PRD/sapdata1/STDBY/onlinelog/group_36_redo.log STANDBY
37 /oracle/PRD/sapdata1/STDBY/onlinelog/group_37_redo.log STANDBY
38 /oracle/PRD/sapdata1/STDBY/onlinelog/group_38_redo.log STANDBY
39 /oracle/PRD/sapdata1/STDBY/onlinelog/group_39_redo.log STANDBY
40 /oracle/PRD/sapdata1/STDBY/onlinelog/group_40_redo.log STANDBY

20 rows selected.

09:28:17 SQL>

2.在备库删除备库standby log 15-19,25-29
alter database drop logfile group 15;
alter database drop logfile group 16;
alter database drop logfile group 17;
alter database drop logfile group 18;
alter database drop logfile group 19;
alter database drop logfile group 25;
alter database drop logfile group 26;
alter database drop logfile group 27;
alter database drop logfile group 28;
alter database drop logfile group 29;

如果出现以下错误，在主库上切换一下日志
alter system switch logfile; --(切换)
--ALTER SYSTEM ARCHIVE LOG CURRENT;(无效)
09:29:39 SQL> alter database drop logfile group 16;
alter database drop logfile group 16

  • ERROR at line 1:
    ORA-00261: log 16 of thread 1 is being archived or modified
    ORA-00312: online log 16 thread 1:
    '/oracle/PRD/sapdata1/STDBY/onlinelog/group_16.2332.869677415'

09:30:50 SQL>

09:44:58 SQL> select group#,member,type from v$logfile where type='STANDBY';

GROUP# MEMBER TYPE
------ ------------------------------------------------------------ -------
31 /oracle/PRD/sapdata1/STDBY/onlinelog/group_31_redo.log STANDBY
32 /oracle/PRD/sapdata1/STDBY/onlinelog/group_32_redo.log STANDBY
33 /oracle/PRD/sapdata1/STDBY/onlinelog/group_33_redo.log STANDBY
34 /oracle/PRD/sapdata1/STDBY/onlinelog/group_34_redo.log STANDBY
35 /oracle/PRD/sapdata1/STDBY/onlinelog/group_35_redo.log STANDBY
36 /oracle/PRD/sapdata1/STDBY/onlinelog/group_36_redo.log STANDBY
37 /oracle/PRD/sapdata1/STDBY/onlinelog/group_37_redo.log STANDBY
38 /oracle/PRD/sapdata1/STDBY/onlinelog/group_38_redo.log STANDBY
39 /oracle/PRD/sapdata1/STDBY/onlinelog/group_39_redo.log STANDBY
40 /oracle/PRD/sapdata1/STDBY/onlinelog/group_40_redo.log STANDBY

10 rows selected.

09:44:59 SQL>

3.主库standbylog添加

alter database add standby logfile group 31 ('+DATA/prd/onlinelog/group_31_redo.log') size 500M;
alter database add standby logfile group 32 ('+DATA/prd/onlinelog/group_32_redo.log') size 500M;
alter database add standby logfile group 33 ('+DATA/prd/onlinelog/group_33_redo.log') size 500M;
alter database add standby logfile group 34 ('+DATA/prd/onlinelog/group_34_redo.log') size 500M;
alter database add standby logfile group 35 ('+DATA/prd/onlinelog/group_35_redo.log') size 500M;
alter database add standby logfile group 36 ('+DATA/prd/onlinelog/group_36_redo.log') size 500M;
alter database add standby logfile group 37 ('+DATA/prd/onlinelog/group_37_redo.log') size 500M;
alter database add standby logfile group 38 ('+DATA/prd/onlinelog/group_38_redo.log') size 500M;
alter database add standby logfile group 39 ('+DATA/prd/onlinelog/group_39_redo.log') size 500M;
alter database add standby logfile group 40 ('+DATA/prd/onlinelog/group_40_redo.log') size 500M;

09:52:24 SQL> select group#,member,type from v$logfile where type='STANDBY';

GROUP# MEMBER                                             TYPE
    15 +DATA/prd/onlinelog/group_15.2333.869677413        STANDBY
    16 +DATA/prd/onlinelog/group_16.2332.869677415        STANDBY
    17 +DATA/prd/onlinelog/group_17.2331.869677417        STANDBY
    18 +DATA/prd/onlinelog/group_18.2330.869677419        STANDBY
    19 +DATA/prd/onlinelog/group_19.2329.869677421        STANDBY
    25 +DATA/prd/onlinelog/group_25.1862.869677441        STANDBY
    26 +DATA/prd/onlinelog/group_26.1861.869677445        STANDBY
    27 +DATA/prd/onlinelog/group_27.1860.869677447        STANDBY
    28 +DATA/prd/onlinelog/group_28.1859.869677449        STANDBY
    29 +DATA/prd/onlinelog/group_29.1857.869677451        STANDBY
    31 +DATA/prd/onlinelog/group_31_redo.log              STANDBY
    32 +DATA/prd/onlinelog/group_32_redo.log              STANDBY
    33 +DATA/prd/onlinelog/group_33_redo.log              STANDBY
    34 +DATA/prd/onlinelog/group_34_redo.log              STANDBY
    35 +DATA/prd/onlinelog/group_35_redo.log              STANDBY
    36 +DATA/prd/onlinelog/group_36_redo.log              STANDBY
    37 +DATA/prd/onlinelog/group_37_redo.log              STANDBY
    38 +DATA/prd/onlinelog/group_38_redo.log              STANDBY
    39 +DATA/prd/onlinelog/group_39_redo.log              STANDBY
    40 +DATA/prd/onlinelog/group_40_redo.log              STANDBY

20 rows selected.

09:52:30 SQL>

4.在主库上删除主库旧的standby log 15-19,25-29
alter database drop logfile group 15;
alter database drop logfile group 16;
alter database drop logfile group 17;
alter database drop logfile group 18;
alter database drop logfile group 19;
alter database drop logfile group 25;
alter database drop logfile group 26;
alter database drop logfile group 27;
alter database drop logfile group 28;
alter database drop logfile group 29;

09:53:55 SQL> alter database drop logfile group 15;

Database altered.

09:53:58 SQL> alter database drop logfile group 16;

Database altered.

09:54:08 SQL> alter database drop logfile group 17
09:54:11 2 ;

Database altered.

09:54:13 SQL> alter database drop logfile group 18;

Database altered.

09:54:16 SQL> alter database drop logfile group 19;

Database altered.

09:54:20 SQL> alter database drop logfile group 25;

Database altered.

09:54:26 SQL> alter database drop logfile group 26;

Database altered.

09:54:30 SQL> alter database drop logfile group 27;

Database altered.

09:54:34 SQL> alter database drop logfile group 28;

Database altered.

09:54:38 SQL> alter database drop logfile group 29;

Database altered.

09:54:41 SQL>
09:54:41 SQL> select group#,member,type from v$logfile where type='STANDBY';

GROUP# MEMBER                                             TYPE
    31 +DATA/prd/onlinelog/group_31_redo.log              STANDBY
    32 +DATA/prd/onlinelog/group_32_redo.log              STANDBY
    33 +DATA/prd/onlinelog/group_33_redo.log              STANDBY
    34 +DATA/prd/onlinelog/group_34_redo.log              STANDBY
    35 +DATA/prd/onlinelog/group_35_redo.log              STANDBY
    36 +DATA/prd/onlinelog/group_36_redo.log              STANDBY
    37 +DATA/prd/onlinelog/group_37_redo.log              STANDBY
    38 +DATA/prd/onlinelog/group_38_redo.log              STANDBY
    39 +DATA/prd/onlinelog/group_39_redo.log              STANDBY
    40 +DATA/prd/onlinelog/group_40_redo.log              STANDBY

10 rows selected.

09:55:04 SQL>
09:55:05 SQL>

5．在主库添加新的ONLINE REDO LOG
ALTER DATABASE ADD LOGFILE THREAD 1 group 41 ('+DATA/prd/onlinelog/group_41_redo.log') SIZE 500M;
ALTER DATABASE ADD LOGFILE THREAD 1 group 42 ('+DATA/prd/onlinelog/group_42_redo.log') SIZE 500M;
ALTER DATABASE ADD LOGFILE THREAD 1 group 43 ('+DATA/prd/onlinelog/group_43_redo.log') SIZE 500M;
ALTER DATABASE ADD LOGFILE THREAD 1 group 44 ('+DATA/prd/onlinelog/group_44_redo.log') SIZE 500M;
--ALTER DATABASE ADD LOGFILE THREAD 1 group 45 ('+DATA/prd/onlinelog/group_45_redo.log') SIZE 500M;

ALTER DATABASE ADD LOGFILE THREAD 2 group 51 ('+DATA/prd/onlinelog/group_51_redo.log') SIZE 500M;
ALTER DATABASE ADD LOGFILE THREAD 2 group 52 ('+DATA/prd/onlinelog/group_52_redo.log') SIZE 500M;
ALTER DATABASE ADD LOGFILE THREAD 2 group 53 ('+DATA/prd/onlinelog/group_53_redo.log') SIZE 500M;
ALTER DATABASE ADD LOGFILE THREAD 2 group 54 ('+DATA/prd/onlinelog/group_54_redo.log') SIZE 500M;
--ALTER DATABASE ADD LOGFILE THREAD 2 group 55 ('+DATA/prd/onlinelog/group_55_redo.log') SIZE 500M;

10:07:45 SQL> select group#,member,type from v$logfile where type<>'STANDBY';

GROUP# MEMBER                                             TYPE
    11 +DATA/prd/onlinelog/group_11.2478.867924049        ONLINE
    12 +DATA/prd/onlinelog/group_12.2477.867924053        ONLINE
    13 +DATA/prd/onlinelog/group_13.2476.867924055        ONLINE
    14 +DATA/prd/onlinelog/group_14.2410.867924057        ONLINE
    21 +DATA/prd/onlinelog/group_21.2416.867924605        ONLINE
    22 +DATA/prd/onlinelog/group_22.2415.867924607        ONLINE
    23 +DATA/prd/onlinelog/group_23.2413.867924611        ONLINE
    24 +DATA/prd/onlinelog/group_24.2412.867924613        ONLINE
    41 +DATA/prd/onlinelog/group_41_redo.log              ONLINE
    42 +DATA/prd/onlinelog/group_42_redo.log              ONLINE
    43 +DATA/prd/onlinelog/group_43_redo.log              ONLINE
    44 +DATA/prd/onlinelog/group_44_redo.log              ONLINE
    51 +DATA/prd/onlinelog/group_51_redo.log              ONLINE
    52 +DATA/prd/onlinelog/group_52_redo.log              ONLINE
    53 +DATA/prd/onlinelog/group_53_redo.log              ONLINE
    54 +DATA/prd/onlinelog/group_54_redo.log              ONLINE

16 rows selected.

10:07:50 SQL>

6.在主库删除旧的ONLINE REDOLOG
删除之前切文档，首先查看是不是ACTIVE或者是INACTIVE
不是INACTIVE 多切几次归档
select * from v$log;
alter system switch logfile;
alter system checkpoint;

alter database drop logfile group 11;
alter database drop logfile group 12;
alter database drop logfile group 13;
alter database drop logfile group 14;
alter database drop logfile group 21;
alter database drop logfile group 22;
alter database drop logfile group 23;
alter database drop logfile group 24;

10:19:12 SQL> select * from v$log;

GROUP#    THREAD#  SEQUENCE#      BYTES  BLOCKSIZE    MEMBERS ARC STATUS           FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME
    14          1       1783 4294967296        512          1 YES INACTIVE            1.6112E+11 11-APR-15   1.6112E+11 11-APR-15
    21          2       1638 4294967296        512          1 YES INACTIVE            1.6112E+11 11-APR-15   1.6112E+11 11-APR-15
    22          2       1639 4294967296        512          1 YES INACTIVE            1.6112E+11 11-APR-15   1.6112E+11 11-APR-15
    23          2       1640 4294967296        512          1 YES INACTIVE            1.6112E+11 11-APR-15   1.6112E+11 11-APR-15
    24          2       1637 4294967296        512          1 YES INACTIVE            1.6112E+11 11-APR-15   1.6112E+11 11-APR-15
    41          1       1787  524288000        512          1 YES INACTIVE            1.6112E+11 11-APR-15   1.6112E+11 11-APR-15
    42          1       1788  524288000        512          1 YES INACTIVE            1.6112E+11 11-APR-15   1.6112E+11 11-APR-15
    43          1       1789  524288000        512          1 NO  CURRENT             1.6112E+11 11-APR-15   2.8147E+14
    44          1          0  524288000        512          1 YES UNUSED                       0                      0
    51          2       1641  524288000        512          1 NO  CURRENT             1.6112E+11 11-APR-15   2.8147E+14
    52          2          0  524288000        512          1 YES UNUSED                       0                      0
    53          2          0  524288000        512          1 YES UNUSED                       0                      0
    54          2          0  524288000        512          1 YES UNUSED                       0                      0

13 rows selected.

10:19:19 SQL> alter database drop logfile group 14;

Database altered.

10:19:40 SQL> alter database drop logfile group 21;

Database altered.

10:19:45 SQL> alter database drop logfile group 22;

Database altered.

10:19:51 SQL> alter database drop logfile group 23;

Database altered.

10:19:59 SQL> alter database drop logfile group 24;

Database altered.

10:19:59 SQL>

7.在备库添加新的ONLINE REDO LOG
alter system set standby_file_management='MANUAL';
--必须修改为手工处理
10:22:32 SQL> show parameter standby_file_management;

NAME TYPE VALUE
------------------------------------ ------- ------------------------------
standby_file_management string AUTO
10:23:35 SQL> alter system set standby_file_management='MANUAL';

System altered.

10:23:54 SQL> show parameter standby_file_management;

NAME TYPE VALUE
------------------------------------ ------- ------------------------------
standby_file_management string MANUAL
10:23:59 SQL>

select group#,thread#,sequence#,members,status from v$log;
ALTER DATABASE ADD LOGFILE THREAD 1 group 41 ('/oracle/PRD/sapdata1/STDBY/onlinelog/group_41_redo.log') SIZE 500M;
ALTER DATABASE ADD LOGFILE THREAD 1 group 42 ('/oracle/PRD/sapdata1/STDBY/onlinelog/group_42_redo.log') SIZE 500M;
ALTER DATABASE ADD LOGFILE THREAD 1 group 43 ('/oracle/PRD/sapdata1/STDBY/onlinelog/group_43_redo.log') SIZE 500M;
ALTER DATABASE ADD LOGFILE THREAD 1 group 44 ('/oracle/PRD/sapdata1/STDBY/onlinelog/group_44_redo.log') SIZE 500M;
--ALTER DATABASE ADD LOGFILE THREAD 1 group 45 ('/oracle/PRD/sapdata1/STDBY/onlinelog/group_45_redo.log') SIZE 500M;

ALTER DATABASE ADD LOGFILE THREAD 2 group 51 ('/oracle/PRD/sapdata1/STDBY/onlinelog/group_51_redo.log') SIZE 500M;
ALTER DATABASE ADD LOGFILE THREAD 2 group 52 ('/oracle/PRD/sapdata1/STDBY/onlinelog/group_52_redo.log') SIZE 500M;
ALTER DATABASE ADD LOGFILE THREAD 2 group 53 ('/oracle/PRD/sapdata1/STDBY/onlinelog/group_53_redo.log') SIZE 500M;
ALTER DATABASE ADD LOGFILE THREAD 2 group 54 ('/oracle/PRD/sapdata1/STDBY/onlinelog/group_54_redo.log') SIZE 500M;
--ALTER DATABASE ADD LOGFILE THREAD 2 group 55 ('/oracle/PRD/sapdata1/STDBY/onlinelog/group_55_redo.log') SIZE 500M;

10:18:14 SQL> select group#,thread#,sequence#,members,status from v$log;

GROUP# THREAD# SEQUENCE# MEMBERS STATUS
------ ---------- ---------- ---------- -------
11 1 1784 1 CLEARIN
G

12          1       1785          1 CLEARIN
                                    G

13          1       1786          1 CLEARIN
                                    G

14          1       1783          1 CLEARIN
                                    G

GROUP# THREAD# SEQUENCE# MEMBERS STATUS
------ ---------- ---------- ---------- -------

21          2       1638          1 CLEARIN
                                    G

22          2       1639          1 CLEARIN
                                    G

23          2       1640          1 CLEARIN
                                    G

24          2       1637          1 CLEARIN

GROUP# THREAD# SEQUENCE# MEMBERS STATUS
------ ---------- ---------- ---------- -------
G

8 rows selected.

10:19:47 SQL>

10:24:20 SQL> ALTER DATABASE ADD LOGFILE THREAD 1 group 41 ('/oracle/PRD/sapdata1/STDBY/onlinelog/group_41_redo.log') SIZE 500M;
ALTER DATABASE ADD LOGFILE THREAD 1 group 42 ('/oracle/PRD/sapdata1/STDBY/onlinelog/group_42_redo.log') SIZE 500M;
ALTER DATABASE ADD LOGFILE THREAD 1 group 43 ('/oracle/PRD/sapdata1/STDBY/onlinelog/group_43_redo.log') SIZE 500M;

Database altered.

10:24:24 SQL> ALTER DATABASE ADD LOGFILE THREAD 1 group 44 ('/oracle/PRD/sapdata1/STDBY/onlinelog/group_44_redo.log') SIZE 500M;

Database altered.

10:24:27 SQL>

Database altered.

10:24:30 SQL>

Database altered.

10:24:32 SQL> 10:24:32 SQL> 10:24:32 SQL>
10:24:33 SQL> ALTER DATABASE ADD LOGFILE THREAD 2 group 51 ('/oracle/PRD/sapdata1/STDBY/onlinelog/group_51_redo.log') SIZE 500M;

Database altered.

10:24:43 SQL> ALTER DATABASE ADD LOGFILE THREAD 2 group 52 ('/oracle/PRD/sapdata1/STDBY/onlinelog/group_52_redo.log') SIZE 500M;

Database altered.

10:24:49 SQL> ALTER DATABASE ADD LOGFILE THREAD 2 group 53 ('/oracle/PRD/sapdata1/STDBY/onlinelog/group_53_redo.log') SIZE 500M;

Database altered.

10:24:54 SQL> ALTER DATABASE ADD LOGFILE THREAD 2 group 54 ('/oracle/PRD/sapdata1/STDBY/onlinelog/group_54_redo.log') SIZE 500M;

Database altered.

10:24:59 SQL>
10:25:01 SQL>

8.在删除备库旧的ONLINE REDO LOG

ALTER DATABASE CLEAR LOGFILE GROUP 11;
alter database drop logfile group 11;
ALTER DATABASE CLEAR LOGFILE GROUP 12;
alter database drop logfile group 12;
ALTER DATABASE CLEAR LOGFILE GROUP 13;
alter database drop logfile group 13;
ALTER DATABASE CLEAR LOGFILE GROUP 14;
alter database drop logfile group 14;

ALTER DATABASE CLEAR LOGFILE GROUP 21;
alter database drop logfile group 21;
ALTER DATABASE CLEAR LOGFILE GROUP 22;
alter database drop logfile group 22;
ALTER DATABASE CLEAR LOGFILE GROUP 23;
alter database drop logfile group 23;
ALTER DATABASE CLEAR LOGFILE GROUP 24;
alter database drop logfile group 24;

10:29:57 SQL> select group#,thread#,sequence#,members,status from v$log;

GROUP# THREAD# SEQUENCE# MEMBERS STATUS
------ ---------- ---------- ---------- -------
13 1 1786 1 CLEARIN
G

12          1       1785          1 CLEARIN
                                    G

11          1          0          1 UNUSED
44          1       1790          1 CLEARIN
                                    G

43          1          0          1 UNUSED

GROUP# THREAD# SEQUENCE# MEMBERS STATUS
------ ---------- ---------- ---------- -------
42 1 0 1 UNUSED
41 1 1791 1 CURRENT
14 1 1783 1 CLEARIN
G

53          2          0          1 UNUSED
52          2          0          1 UNUSED
51          2       1641          1 CURRENT
54          2          0          1 UNUSED
23          2       1640          1 CLEARIN
                                    G

GROUP# THREAD# SEQUENCE# MEMBERS STATUS
------ ---------- ---------- ---------- -------

22          2       1639          1 CLEARIN
                                    G

21          2       1638          1 CLEARIN
                                    G

24          2       1637          1 CLEARIN
                                    G

16 rows selected.

alter system set standby_file_management='AUTO' scope=both;

alter database recover managed standby database disconnect from session;

转载于:https://www.cnblogs.com/kelemeng/p/4417854.html

dengxunla7641
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
oracle物理DG管理-redo数据传输,应用与三种模式
treacle田 --love work and life......
03-09 2212
环境http://blog.csdn.net/sunziyue/article/details/50799648基础之上 1学习配置参数 下列参数为primary 角色相关 *.db_name='orcl'            //注意Guard Data中所有数据库DB_NAME应该一致; *.db_unique_name='orcldg'  //配置有效的db_unique_na
Exadata-数据库云一体机-2022优秀文档.ppt
11-14
"Exadata数据库云一体机的关键技术点" 一、云计算定义与特征 根据NIST的定义，云计算是一种模型，能够方便地按需从网络访问共享的可配置计算资源（如网络、服务器、存储、应用程序和服务）池，并且只需最少的管理...
DataGuard - ORA-00261错误的提出
Kamus' Oracle World
08-31 4426
以下是在作failover时standby端的alertlog内容，情况时拔掉Primary的网线，模拟Primary数据库网络环境突然损坏。--下行表示standby端的standby redo log已经启用RFS: Successfully opened standby logfile 4: /global/oradata/ctsdb/stdby_redo04.logTue Au
RAMAN正确删除归档日志方法
weixin_30467087的博客
12-24 419
如何正确地删除Archivelog： Archivelog并不能直接得从OS层直接物理删除，因为archivelog的相关信息是记录在controlfile中的，当物理删除后不会改变controlfile的设置。并且在查询相关的动态视图(例如v$archived_log)时，该部分日志仍然标注为存在。也就是说Oracle并不认为这些日志被删除了，所以在删除archivelog的时...
Exadata上的数据库备份
In-Memory Computing Technology
09-23 470
很多用户都问到这个问题，其实和普通服务器上的数据库备份没有区别。例如在NetBackup 8.0 - 8.x.x Database and Application Agent Compatibility List中提到： Database Appliances: 3rd party database hardware appliances are supported if the applian...
oracle exadata X8,ORACLEEXADATA数据库云服务器X8.PDF
weixin_29361879的博客
04-15 422
ORACLEEXADATA数据库云服务器X8ORACLE 数据表ORACLE EXADATA 数据库云服务器X3-8特性和事实特性• 160 个CPU 内核和4 TB 内存 Oracle Exadata 数据库云服务器 (简称为 Exadata )采用了集成设计，旨在用于数据库处理 成为提供最高性能和可用性的 Oracle 数据库运行平台。借助 Sun 的行业标...
Exadata X8M支持的数据库版本
In-Memory Computing Technology
07-13 236
从 Information Center: Oracle Exadata Database Machine (Doc ID 1306791.2) 中找到了 Exadata Database Machine and Exadata Storage Server Supported Versions (Doc ID 888828.1) 。 在Oracle Database部分，支持的数据库版本为： 11.2.0.4 12.1，12.2 18c，19c 当然对Exadata系统软件也有要求。 ...
Oracle Cloud Infrastructure：Operations Insights Oracle数据库和Exadata环境优化资源
BLOG域名:programb.blog.csdn.net
10-16 82
Operations Insights可以用于Oracle数据库和Exadata环境的资源优化。它能够提供深入的洞察力，帮助组织更好地理解其数据库和数据中心的性能，从而进行更有效的资源分配。Operations Insights可为Oracle数据库和Exadata环境优化资源、准确的容量规划和主动修复性能问题。Operations Insights支持数据驱动的决策，帮助客户预测未来的资源需求，防止停机，并最大限度地提高性能。Youngone户外公司首席信息官。
tb级别oracle数据库,记一次TB级别的Oracle Exadata数据库恢复
weixin_36244678的博客
04-14 397
现在它还提供了新的低成本1/8机架配置。 借助Oracle Exadata，客户可通过整合降低IT成本，使存储能力增加10倍，提升所有应用的性能，因消除系统集成的试错过程而加快上市速度，以及实时做出更好的业务决策某客户的exadata环境，由于大量硬件故障，导致数据库宕机。经过分析确认是由于某个cell节点的某个disk出现异常，导致部分cell节点的disk 离线后无法进行asm reblanc...
Exadata 数据库云服务器上的数据库整合最佳实践.pdf
08-16
Exadata数据库云服务器是Oracle公司推出的一款高性能数据库服务器，它整合了计算、存储和网络资源，提供了最佳的数据仓库和在线事务处理（OLTP）数据库性能。在使用Exadata进行数据库整合时，涉及到多个方面的最佳...
oracleExadata数据库一体机bootcamp配置英文文档合集
07-23
教程名称：oracle Exadata数据库一体机bootcamp配置英文文档合集课程目录：【】1.04 - Storage index【】1.07 - Flash Cache【】1.08 - Speeds and feeds【】1.09 - Exadata utilities【】2.01 - Exadata and HA【】...
修改Exadata数据库云平台的IP地址.pdf
04-23
这篇文章提供了修改exadata数据库云平台所有服务器的IP地址的方法。最常见的需要修改IP地址的例子是当exdata数据库云平台需要搬迁到新地址
新一代Exadata数据库一体机介绍
04-21
总的来说，新一代Exadata数据库一体机是Oracle公司在硬件与软件一体化方面的重要创新，它不仅提供了优越的性能和可扩展性，而且在简化管理、提高运维效率方面具有独特优势，尤其适合需要大规模数据处理和高并发事务...
Oracle 知识篇+11g数据库常用日志
ZZT_2009
03-21 2010
适用人群 Oracle DBA 环境说明 该文档是基于主流的Oracle 11gR2编写，其他版本的相关信息可能会有所差异 详情 redo日志 序号 名称 联机重做日志 重要性 非常重要 用途 存储数据库...
Redis基础命令和事务，redis持久化和主从复制
最新发布
baomingshu的博客
08-31 743
nosql数据库介绍：解释为 non-relational(非关系型数据库)。在NoSQL 数据库中数据之间是无联系的数据的结构是松散的，可变的。优势：大数据量，高性能，灵活的数据模型，高可用，低成本劣势：（1）无关系，数据之间是无联系的。
redis能正常访问，但是springboot编译报错
生而为人我很抱歉
08-27 664
因为你在自定义的 @Configuration 类中没有明确指定配置属性的绑定，或者这个类的加载顺序影响了 Spring Boot 的属性绑定过程。你可以尝试在 MyConf 类上加上 @Order 注解来调整加载顺序，或者确保 MyConf 类不会干扰到 Redis 配置的加载。你可以在 MyConf 类上使用 @ConditionalOnProperty 注解，确保在特定条件下才加载这个配置类，以避免在 Redis 配置加载之前进行不必要的初始化。
python12 中，No module named‘distutils‘错误
热门推荐
qq_43557600的博客
08-27 1万+
python12 “ No module named'distutils' ”,​ 安装 pip install setuptools ，解决 ​
优化11g Oracle Exadata数据库机器配置：环境评估与安装模板
这份E16099-09版本发布于2010年11月，旨在帮助用户在实际环境中定义Oracle Exadata数据库机器的配置参数，确保系统的高效运行和兼容性。 文档的主要目标是协助网络管理员和数据库管理员共同评估当前环境，包括网络...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值