首页 > 数据库技术 > 详细

oracle 11g修改归档日志目录及大小

时间:2020-07-26 14:12:07      阅读:125      评论:0      收藏:0      [点我收藏+]

1.查看当前归档日志目录

SQL> show parameter recovery

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string      /u01/app/oracle/fast_recovery_
                                                 area
db_recovery_file_dest_size           big integer 4182M
recovery_parallelism                 integer     0

  

2.更改归档日志目录

SQL> alter system set db_recovery_file_dest=‘/u01/app/oracle/archivelog‘ scope=spfile;

System altered.

  

3.更改归档日志目录大小

SQL> alter system set db_recovery_file_dest_size=4096m scope=spfile;

System altered.

  

4.重启数据库并查看归档日志目录及大小

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area  759943168 bytes
Fixed Size                  2257112 bytes
Variable Size             499126056 bytes
Database Buffers          255852544 bytes
Redo Buffers                2707456 bytes
Database mounted.
Database opened.
SQL> show parameter recovery

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string      /u01/app/oracle/archivelog
db_recovery_file_dest_size           big integer 4G
recovery_parallelism                 integer     0

  

 

oracle 11g修改归档日志目录及大小

原文:https://www.cnblogs.com/orcl-2018/p/13379637.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!