Oracle归档日志管理-优快云博客

2019独角兽企业重金招聘Python工程师标准>>>

1、查看归档
select name,log_mode from v$database;或者archive log list
2、开启归档
1）shutdown immediate;
2)startup mount
2)alter database archivelog
3)alter database open
3、禁止归档
1）shutdown immediate
2)startup mount
3）alter database noarchivelog
4)alter database open
4、查看归档路径
show parameter db_recovery_file_dest
5、查看归档日志
show parameter log_archive_dest;或者select * from v$recovery_file_dest;
SELECT name FROM v$archived_log WHERE archived = 'YES' AND deleted = 'NO' AND name not like '+%' AND standby_dest = 'NO';
6、更改归档路径
alter database archivelog
7、更改归档路径大小
alter system set log_archive_dest_1='location=/archivelog' sco
pe=spfile;
alter system set db_recovery_file_dest_size=1400G;
show parameter db_recovery
8、查看归档日志信息
SQL> archive log list;
9、查看归档日志
SQL>select name,completion_time from v$archived_log;
10、查看归档日志占有率
select * from v$flash_recovery_area_usage;
11、手动归档
ALTER SYSTEM ARCHIVE LOG CURRENT;
12、删除归档日志
rman
connect target /;
crosscheck archivelog all;
DELETE ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-7;
delete expired archivelog all;
13、查看归档日志的利用情况
select name,SPACE_LIMIT,SPACE_USED from v$recovery_file_dest;