ORACLE调整归档日志大小
来源:互联网 发布:无主之地ol激活码淘宝 编辑:程序博客网 时间:2024/05/19 02:45
SQL> select GROUP# ,members,BYTES/1024/1024 size_M,STATUS,ARCHIVED from v$log;
GROUP# MEMBERS SIZE_M STATUS ARC
---------- ---------- ---------- ---------------- ---
1 2 50 INACTIVE YES
2 2 50 CURRENT NO
3 2 50 INACTIVE YES
4 2 50 INACTIVE YES
SQL> select MEMBER from v$logfile;
MEMBER
--------------------------------------------------------------------------------
/oracle/PRD/origlogA/log_g11m1.dbf
/oracle/PRD/mirrlogA/log_g11m2.dbf
/oracle/PRD/origlogB/log_g12m1.dbf
/oracle/PRD/mirrlogB/log_g12m2.dbf
/oracle/PRD/origlogA/log_g13m1.dbf
/oracle/PRD/mirrlogA/log_g13m2.dbf
/oracle/PRD/origlogB/log_g14m1.dbf
/oracle/PRD/mirrlogB/log_g14m2.dbf
切换当前日志到新的日志组:
alter system switch logfile;
alter system switch logfile;
alter system switch logfile;
alter system switch logfile;
直到旧的日志组 status为'INACTIVE'
删除Status为'INACTIVE'的旧日志组1,2,3,4,5,6,7,8:
alter database drop logfile group 1;
alter database drop logfile group 2;
alter database drop logfile group 3;
alter database drop logfile group 4;
alter database drop logfile group 5;
alter database drop logfile group 6;
alter database drop logfile group 7;
alter database drop logfile group 8;
在OS下删除旧的日志物理文件:
rm /oracle/SZP/origlogA/log_g11m1.dbf
rm /oracle/SZP/mirrlogA/log_g11m2.dbf
rm /oracle/SZP/origlogB/log_g12m1.dbf
rm /oracle/SZP/mirrlogB/log_g12m2.dbf
rm /oracle/SZP/origlogA/log_g13m1.dbf
rm /oracle/SZP/mirrlogA/log_g13m2.dbf
rm /oracle/SZP/origlogB/log_g14m1.dbf
rm /oracle/SZP/mirrlogB/log_g14m2.dbf
rm /oracle/SZP/origlogA/log_g15m1.dbf
rm /oracle/SZP/mirrlogA/log_g15m2.dbf
rm /oracle/SZP/origlogB/log_g16m1.dbf
rm /oracle/SZP/mirrlogB/log_g16m2.dbf
rm /oracle/SZP/origlogA/log_g17m1.dbf
rm /oracle/SZP/mirrlogA/log_g17m2.dbf
rm /oracle/SZP/origlogB/log_g18m1.dbf
rm /oracle/SZP/mirrlogB/log_g18m2.dbf
重建日志组1,2,3,4,5,6:
alter database add logfile group 1('/oracle/SZP/origlogA/log_g11m1.dbf','/oracle/SZP/mirrlogA/log_g11m2.dbf') size 150m;
alter database add logfile group 2('/oracle/SZP/origlogB/log_g12m1.dbf','/oracle/SZP/mirrlogB/log_g12m2.dbf') size 150m;
alter database add logfile group 3('/oracle/SZP/origlogA/log_g13m1.dbf','/oracle/SZP/mirrlogA/log_g13m2.dbf') size 150m;
alter database add logfile group 4('/oracle/SZP/origlogB/log_g14m1.dbf','/oracle/SZP/mirrlogB/log_g14m2.dbf') size 150m;
alter database add logfile group 5('/oracle/SZP/origlogA/log_g15m1.dbf','/oracle/SZP/mirrlogA/log_g15m2.dbf') size 150m;
alter database add logfile group 6('/oracle/SZP/origlogB/log_g16m1.dbf','/oracle/SZP/mirrlogB/log_g16m2.dbf') size 150m;
0 0
- ORACLE调整归档日志大小
- oracle检查归档日志大小和删除
- Oracle 调整重做日志(redo)大小
- Oracle数据库redolog日志调整大小
- 归档大小日志计算
- 如何调整Oracle Redo Logfile日志文件的大小?
- 增加归档日志的大小
- Oracle归档日志问题
- oracle 建立归档日志
- oracle归档日志管理
- 清理Oracle归档日志
- oracle 归档日志
- Oracle归档日志管理
- Oracle 归档日志
- oracle 日志归档
- Oracle归档日志删除
- Oracle归档日志删除
- Oracle归档日志删除
- IplImage 4通道转3通道
- HDU-1716()(全排列+重集排列)
- [代码分享]UIImage:获取图片主色调
- C语言构建WEB管理系统(四):CGI程序解析POST数据
- 冒泡排序和快速排序java实现
- ORACLE调整归档日志大小
- 157.View the Exhibit and examine the structure of the ORDERS and CUSTOMERS tables.
- CentOS下安装中文输入法、gcc、g++、gdb
- Java-异常
- 使用eclipse直接生成so文件
- Android 手机自动化测试工具
- TCP/IP详解:第一、二章读书笔记
- 欧几里得算法和Stein算法【数论】
- iOS 7及以上,随时改变UIStatusBar颜色