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修改归档日志目录及大小
标签：ast open val des system pfile data startup string
本文系统来源：https://www.cnblogs.com/orcl-2018/p/13379637.html
【说明】：本文章由站长整理发布，文章内容不代表本站观点，如文中有侵权行为，请与本站客服联系(QQ:254677821)！