更改Oracle 10g/11g資料庫為歸檔模式

標籤：

一、oracle 10g/11g

在Oracle 11g，開啟archive log模式時，預設歸檔目錄為db_recovery_file_dest指定。此參數在pfile/spfile中可以指定：

db_recovery_file_dest=‘/u01/app/oracle/flash_recovery_area‘;

1.sqlplus / as sysdba;登陸進去；

2、關閉資料庫

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

3、啟動資料mount狀態：

SQL> startup mount;
ORACLE instance started.

Total System Global Area 285212672 bytes
Fixed Size 1218992 bytes
Variable Size 92276304 bytes
Database Buffers 188743680 bytes
Redo Buffers 2973696 bytes
Database mounted.

4、修改資料庫為歸檔模式：

SQL> alter database archivelog;(非歸檔模式為noarchivelog)

Database altered.

5、開啟資料庫，查詢：

SQL> alter database open;

Database altered.

SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /oracle/oracle10g/log/archive_log
Oldest online log sequence 0
Next log sequence to archive 1
Current log sequence 1

5、修改記錄檔命名格式：

SQL> alter system set log_archive_max_processes = 5;
SQL> alter system set log_archive_format = "archive_%t_%s_%r.log" scope=spfile;

System altered.

更改Oracle 10g/11g資料庫為歸檔模式