oracle 歸檔/非歸檔

標籤：

1、查看oralce是歸檔模式還是非歸檔模式

SQL> select name,log_mode from v$database;

NAME LOG_MODE
---------------------------------------- ------------------------------------
YOON ARCHIVELOG

 

SQL> select name,log_mode from v$database;

NAME LOG_MODE
---------------------------------------- ------------------------------------
YOON ARCHIVELOG

SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 326
Next log sequence to archive 328
Current log sequence 328

 

2、查看歸檔存放路徑

SQL> show parameter db_recovery;

NAME TYPE VALUE
------------------------------------ --------------------------------- ------------------------------
db_recovery_file_dest string /u01/oracle/fast_recovery_area
db_recovery_file_dest_size big integer 4122M

 

3、修改歸檔路徑大小

SQL> alter system set db_recovery_file_dest_size=5G;

 

4、查看歸檔路徑

SQL> select name,SPACE_LIMIT,SPACE_USED from v$recovery_file_dest;

NAME SPACE_LIMIT SPACE_USED
---------------------------------------- ----------- ----------
/u01/oracle/fast_recovery_area 5368709120 2539942912

 

5、修改歸檔路徑

SQL> alter system set db_recovery_file_dest=‘/u01/archivelog‘;

 

6、刪除歸檔日誌

①查看歸檔路徑狀態

②到系統目錄下刪除歸檔日誌

③crosscheck archivelog all;

④delete expired archivelog all;

 

7、刪除7天前

DELETE ARCHIVELOG ALL COMPLETED BEFORE ‘SYSDATE-7‘;

 

8、7天前到現在

DELETE ARCHIVELOG FROM TIME ‘SYSDATE-7‘;

 

9、修改歸檔格式

修改歸檔格式alter system set log_archive_format = "archive_%t_%s_%r.log" scope=spfile;
還可以設定一個參數alter system set log_archive_max_processes = 2; //作業系統為oracle歸檔開啟多少個歸檔進程；重新啟動資料庫。
SQL> alter system set log_archive_dest_1=‘location=/u01/archivelog‘ scope =both;

oracle 歸檔/非歸檔