Redo Log
EVISWANG
这个作者很懒,什么都没留下…
展开
-
ORA-16014: ORA-00312: not archived, no available destinations
Errors in file /export/home/oracle/admin/eip/bdump/eip4_arc0_6845.trc: ORA-16014: log 6 sequence# 22895 not archived, no available destinations ORA-00312: online log 6 thread 1: '/export/home/oracle原创 2015-11-20 10:47:42 · 664 阅读 · 0 评论 -
扩大online redo增加日志组
现在的大小为50M,改为300M 切换也比较频繁 添加比较简单: alter database add logfile group 4 '/u01/oracle/oradata/appserv/redo04.log' size 300m alter database add logfile group 5 '/u01/oracle/oradata/appserv/redo0原创 2015-12-16 09:07:31 · 694 阅读 · 0 评论 -
自动清理归档
[ccb@zbdb ~]$ crontab -l 00 05 * * * /home/ccb/clean_arch.sh>/dev/null 2>&1 [ccb@zbdb ~]$ [ccb@zbdb ~]$ cat /home/ccb/clean_arch.sh #!/bin/bash if [ -f ~/.bash_profile ]; then . ~/.bas原创 2015-12-02 14:10:09 · 448 阅读 · 0 评论 -
oracle 11.2.0.4 归档满了之后 用户限制连接, awr快照停止生成
AWR Snapshots Are Not Being Created Because MMON Is Not Being Respawned (Doc ID 2023652.1) To BottomTo Bottom APPLIES TO: Oracle Database - Enterprise Edition - Version 11.2.0.4 to 11.2.0.4 [Rel原创 2018-01-22 11:25:44 · 458 阅读 · 0 评论