1、查看oralce是归档模式还是非归档模式
SQL> select name,log_mode from v$database;
NAME
---------------------------------------- ------------------------------------
YOON
SQL> select name,log_mode from v$database;
NAME
---------------------------------------- ------------------------------------
YOON
SQL> archive log list;
Database log mode
Automatic archival
Archive destination
Oldest online log sequence
Next log sequence to archive
Current log sequence
2、查看归档存放路径
SQL> show parameter db_recovery;
NAME
------------------------------------ --------------------------------- ------------------------------
db_recovery_file_dest
db_recovery_file_dest_size
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
---------------------------------------- ----------- ----------
/u01/oracle/fast_recovery_area
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;
SQL> alter system set log_archive_dest_1='location=/u01/archivelog' scope =both;