修改备库日志（redo、standby redo）.docx

西瓜你个吧啦

200

10页

6次

2024-05-27

免费下载

修改备库日志（redo、standby redo）

2022.01.06 湛康颖

备库删除 redo 步骤

备库重建 redo

备库重建 redo 操作日志记录

备库重建 standby redo

备库重建 standby redo 操作日志记录

报错记录

redo 报错

备库删除 redo 步骤

1、关闭 DG 应用

2、开启手动管理文件

3、确认不是 CURRENT 状态（如果是就在主库切换归档）

4、清理 redo

5、删除 redo

6、开启自动管理文件

7、开启 DG 应用

备库重建 redo

set linesize 200

set pagesize 200

col MEMBER format a100

alter database recover managed standby database cancel;

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

select * from v$log;

select * from v$logfile order by GROUP#,MEMBER;

alter database add logfile group 1 ('/u01/app/oracle/oradata/branch/redo01a.log',

'/u01/app/oracle/oradata/branch/redo01b.log') size 500m reuse;

alter database add logfile group 2 ('/u01/app/oracle/oradata/branch/redo02a.log',

'/u01/app/oracle/oradata/branch/redo02b.log') size 500m reuse;

alter database add logfile group 3 ('/u01/app/oracle/oradata/branch/redo03a.log',

'/u01/app/oracle/oradata/branch/redo03b.log') size 500m reuse;

alter database clear logfile group 5;

alter database drop logfile group 5;

alter database clear logfile group 6;

alter database drop logfile group 6;

alter database clear logfile group 7;

alter database drop logfile group 7;

主库 alter system switch logfile;

select * from v$log;

alter database clear logfile group 4;

alter database drop logfile group 4;

alter database add logfile group 4 ('/u01/app/oracle/oradata/branch/redo04a.log',

'/u01/app/oracle/oradata/branch/redo04b.log') size 500m reuse;

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

alter database recover managed standby database using current logfile disconnect from

session;

alter database disable thread 2;

备库重建 redo 操作日志记录

SQL> alter database recover managed standby database cancel;

Database altered.

SQL> alter system set standby_file_management='MANUAL' scope=both;

System altered.

SQL> select * from v$log;

GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC

STATUS FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME

---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ---------

------------ ---------

4 1 850528 524288000 512 1 YES CLEARING

1.7316E+13 06-JAN-22 1.7316E+13 06-JAN-22

7 1 850242 524288000 512 1 YES CLEARING

1.7316E+13 05-JAN-22 1.7316E+13 05-JAN-22

6 1 850241 524288000 512 1 YES CLEARING

1.7316E+13 05-JAN-22 1.7316E+13 05-JAN-22

5 1 850244 524288000 512 1 YES CLEARING

1.7316E+13 05-JAN-22 1.7316E+13 05-JAN-22

SQL> select * from v$logfile;

GROUP# STATUS TYPE MEMBER

IS_RECOVERY_DEST_FILE

---------- ------- ------- --------------------------------------------------------------------

---------------------

4 ONLINE /data/oradata/branch/redo4.log NO

5 ONLINE /data/oradata/branch/redo5.LOG

of 10

免费下载

数据库

关注

评论