oracle dg修改联机日志logfile路径以及大小
来源:互联网 发布:android登录注册源码 编辑:程序博客网 时间:2024/06/07 17:16
SQL> alter database clear logfile group 4;
alter database clear logfile group 4
*
ERROR at line 1:
ORA-01156: recovery or flashback in progress may need access to files
SQL> alter database recover managed standby database cancel;
Database altered.
SQL> alter database clear logfile group 4;
Database altered.
SQL> alter database drop logfile group 4;
alter database drop logfile group 4
*
ERROR at line 1:
ORA-01275: Operation DROP LOGFILE is not allowed if standby file management is
automatic.
SQL> alter system set standby_file_management=manual;
System altered.
SQL> alter database drop logfile group 4;
Database altered.
--创建新的logfile,指定路径以及大小
alter system set LOG_FILE_NAME_CONVERT='/u01/','/u01/' scope=spfile;
alter database clear logfile group 1;
alter database clear logfile group 2;
alter database clear logfile group 3;
alter database clear logfile group 4;
alter system reset LOG_FILE_NAME_CONVERT;
shutdown immediate;
startup;
alter system set standby_file_management=auto;
alter database recover managed standby database using current logfile disconnect from session;
alter database clear logfile group 4
*
ERROR at line 1:
ORA-01156: recovery or flashback in progress may need access to files
SQL> alter database recover managed standby database cancel;
Database altered.
SQL> alter database clear logfile group 4;
Database altered.
SQL> alter database drop logfile group 4;
alter database drop logfile group 4
*
ERROR at line 1:
ORA-01275: Operation DROP LOGFILE is not allowed if standby file management is
automatic.
SQL> alter system set standby_file_management=manual;
System altered.
SQL> alter database drop logfile group 4;
Database altered.
--创建新的logfile,指定路径以及大小
SQL> alter database add logfile group4
(
/log/qxdb/redo01,
/log/qxdb/redo02
) size 800M;
alter system set LOG_FILE_NAME_CONVERT='/u01/','/u01/' scope=spfile;
alter database clear logfile group 1;
alter database clear logfile group 2;
alter database clear logfile group 3;
alter database clear logfile group 4;
alter system reset LOG_FILE_NAME_CONVERT;
shutdown immediate;
startup;
alter system set standby_file_management=auto;
alter database recover managed standby database using current logfile disconnect from session;
0 0
- oracle dg修改联机日志logfile路径以及大小
- oracle dg坏境主库redolog修改大小
- 如何调整Oracle Redo Logfile日志文件的大小?
- 在联机状态改变redo logfile大小的方法
- ORACLE 联机日志损坏
- oracle联机日志
- oracle 联机日志 恢复
- oracle联机日志
- DG保护模式与备用联机日志文件
- Oracle 日志记录(联机日志/非联机日志)
- Oracle联机日志文件归档
- Oracle管理联机日志文件
- Oracle联机日志恢复案例
- Oracle联机重做日志文件
- ORACLE联机日志损坏修复
- 修改redo log 大小【rac+dg】
- dg环境下修改redo大小
- Oracle 日志之联机重做日志
- Android探索之旅(第十三篇)Android开发人员不得不知道的小工具(持续收录中......)
- DAOFactory复用代码
- NO.96 Hudson+Sonar+Sonarrunner JVM配置点
- linux expect详解(ssh自动登录)
- jquery和Js的区别和基础操作
- oracle dg修改联机日志logfile路径以及大小
- URAL-1584-Pharaohs’ Secrets【二分图最佳匹配】【好题】
- estIntraPredLumaQT函数
- bzoj 4805: 欧拉函数求和 杜教筛
- 再拾android开发问题总结
- ajax与springmvc交互
- Dubbo+Zookeeper简介
- DNS协议
- listview黏性标题