oracle改成归档模式_修改oracle为归档模式

修改oracle为归档模式

1，查看是否为归档模式

SQL> archive log list;

Database log mode              No Archive Mode

Automatic archival             Disabled

Archive destination            USE_DB_RECOVERY_FILE_DEST

Oldest online log sequence     31

Current log sequence           33

2，关闭数据库

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

3，启动数据库到mount模式

SQL> startup mount;

ORACLE instance started.

Total System Global Area 1224736768 bytes

Fixed Size                  2020384 bytes

Variable Size             318770144 bytes

Database Buffers          889192448 bytes

Redo Buffers               14753792 bytes

Database mounted.

4，修改数据库为归档模式

SQL> alter database archivelog;

Database altered.

5，打开数据库库

SQL> alter database open;

SQL> SELECT NAME,created,log_mode FROM v$database;

NAME      CREATED   LOG_MODE

--------- --------- ------------

ORCL      04-JUN-12 ARCHIVELOG

Database altered.

6，查看归档日志的路径和目录

SQL> show parameter db_recovery_file_dest;

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

db_recovery_file_dest                string      /data/app/oracle/flash_recovery_area

db_recovery_file_dest_size           big integer 2G

修改方法：

SQL> alter system set db_recovery_file_dest_size=20g;

SQL> alter system set db_recovery_file_dest='/app/arc';