oracle dg修改联机日志logfile路径以及大小

最新推荐文章于 2025-03-11 17:47:54 发布

原创最新推荐文章于 2025-03-11 17:47:54 发布 · 3.3k 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

收录于

oracle dg 专栏收录该内容

5 篇文章

订阅专栏

本文介绍了在Oracle数据库中如何进行日志文件组的清理、删除及新建操作，并详细展示了在不同状态下的具体命令及其执行结果。

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，指定路径以及大小

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;