没有合适的资源?快使用搜索试试~ 我知道了~
DG 添加修改redo日志组大小.txt
需积分: 5 4 下载量 132 浏览量
2021-04-09
11:21:05
上传
评论
收藏 7KB TXT 举报
温馨提示
Oracle DataGuard添加修改redo log日志大小
资源推荐
资源详情
资源评论
注意:log_file_name_convert如果不配置,将导致备库redo 文件不能被删除
1、检查主备库状态
主库:
SQL> select SEQUENCE#,first_time,next_time,APPLIED, THREAD# from v$archived_log order by SEQUENCE#,THREAD#;
SQL> set linesize 300
SQL> select LOG_MODE,CONTROLFILE_TYPE,OPEN_MODE,PROTECTION_MODE,DATABASE_ROLE,SWITCHOVER_STATUS from v$database;
LOG_MODE CONTROL OPEN_MODE PROTECTION_MODE DATABASE_ROLE SWITCHOVER_STATUS
------------ ------- -------------------- -------------------- ---------------- --------------------
ARCHIVELOG CURRENT READ WRITE MAXIMUM PERFORMANCE PRIMARY TO STANDBY
SQL> select GROUP#,BYTES/1024/1024 from v$log;
GROUP# BYTES/1024/1024
------ ---------------
1 50
2 50
3 50
SQL> select GROUP#,BYTES/1024/1024,STATUS from v$standby_log;
GROUP# BYTES/1024/1024 STATUS
------ --------------- ----------
4 50 UNASSIGNED
5 50 UNASSIGNED
6 50 UNASSIGNED
1、检查主备库状态
主库:
SQL> select SEQUENCE#,first_time,next_time,APPLIED, THREAD# from v$archived_log order by SEQUENCE#,THREAD#;
SQL> set linesize 300
SQL> select LOG_MODE,CONTROLFILE_TYPE,OPEN_MODE,PROTECTION_MODE,DATABASE_ROLE,SWITCHOVER_STATUS from v$database;
LOG_MODE CONTROL OPEN_MODE PROTECTION_MODE DATABASE_ROLE SWITCHOVER_STATUS
------------ ------- -------------------- -------------------- ---------------- --------------------
ARCHIVELOG CURRENT READ WRITE MAXIMUM PERFORMANCE PRIMARY TO STANDBY
SQL> select GROUP#,BYTES/1024/1024 from v$log;
GROUP# BYTES/1024/1024
------ ---------------
1 50
2 50
3 50
SQL> select GROUP#,BYTES/1024/1024,STATUS from v$standby_log;
GROUP# BYTES/1024/1024 STATUS
------ --------------- ----------
4 50 UNASSIGNED
5 50 UNASSIGNED
6 50 UNASSIGNED
SQL>
备库:
SQL> select SEQUENCE#,first_time,next_time,APPLIED, THREAD# from v$archived_log order by SEQUENCE#,THREAD#;
SQL> select LOG_MODE,CONTROLFILE_TYPE,OPEN_MODE,PROTECTION_MODE,DATABASE_ROLE,SWITCHOVER_STATUS from v$database;
LOG_MODE CONTROL OPEN_MODE PROTECTION_MODE DATABASE_ROLE SWITCHOVER_STATUS
------------ ------- -------------------- -------------------- ---------------- --------------------
ARCHIVELOG STANDBY MOUNTED MAXIMUM PERFORMANCE PHYSICAL STANDBY SWITCHOVER PENDING
SQL> select GROUP#,BYTES/1024/1024 from v$log;
GROUP# BYTES/1024/1024
---------- ---------------
1 50
3 50
2 50
SQL> select GROUP#,BYTES/1024/1024,STATUS from v$standby_log;
GROUP# BYTES/1024/1024 STATUS
---------- --------------- ----------
4 50 UNASSIGNED
5 50 UNASSIGNED
6 50 UNASSIGNED
查看redo 信息
SQL> col member for a60
SQL> select group#,type, member from v$logfile;
备库:
SQL> select SEQUENCE#,first_time,next_time,APPLIED, THREAD# from v$archived_log order by SEQUENCE#,THREAD#;
SQL> select LOG_MODE,CONTROLFILE_TYPE,OPEN_MODE,PROTECTION_MODE,DATABASE_ROLE,SWITCHOVER_STATUS from v$database;
LOG_MODE CONTROL OPEN_MODE PROTECTION_MODE DATABASE_ROLE SWITCHOVER_STATUS
------------ ------- -------------------- -------------------- ---------------- --------------------
ARCHIVELOG STANDBY MOUNTED MAXIMUM PERFORMANCE PHYSICAL STANDBY SWITCHOVER PENDING
SQL> select GROUP#,BYTES/1024/1024 from v$log;
GROUP# BYTES/1024/1024
---------- ---------------
1 50
3 50
2 50
SQL> select GROUP#,BYTES/1024/1024,STATUS from v$standby_log;
GROUP# BYTES/1024/1024 STATUS
---------- --------------- ----------
4 50 UNASSIGNED
5 50 UNASSIGNED
6 50 UNASSIGNED
查看redo 信息
SQL> col member for a60
SQL> select group#,type, member from v$logfile;
剩余6页未读,继续阅读
资源评论
J.P.August
- 粉丝: 900
- 资源: 57
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功