修改oracle為歸檔模式

標籤：

1、查看是否為歸檔模式

SQL> archive log list;Database log mode           No Archive ModeAutomatic archival           DisabledArchive destination           USE_DB_RECOVERY_FILE_DESTOldest online log sequence     16Current log sequence           18

2、關閉資料庫

SQL> archive log list;Database log mode           No Archive ModeAutomatic archival           DisabledArchive destination           USE_DB_RECOVERY_FILE_DESTOldest online log sequence     16Current log sequence           18

3、啟動資料庫到mount模式

SQL> startup  mount;ORACLE instance started.Total System Global Area 3290345472 bytesFixed Size            2217832 bytesVariable Size         1795164312 bytesDatabase Buffers     1476395008 bytesRedo Buffers           16568320 bytesDatabase mounted.

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

SQL>  alter database archivelog;Database altered.

5、開啟資料庫庫

SQL> alter database open;Database altered.

6、查看是否為歸檔模式

SQL> archive log list;Database log mode           Archive ModeAutomatic archival           EnabledArchive destination           USE_DB_RECOVERY_FILE_DESTOldest online log sequence     16Next log sequence to archive   18Current log sequence           18

7、查看歸檔日誌的路徑和目錄

SQL> show parameter db_recovery_file_dest;NAME                     TYPE     VALUE------------------------------------ ----------- ------------------------------db_recovery_file_dest             string     /usr/oracle/app/flash_recovery_areadb_recovery_file_dest_size         big integer 3882M

修改oracle為歸檔模式