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

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