首先将数据库切换归档模式
查看日志状态(确认是否开启归档模式)
archive log list
No Archive Mode --> Archive Mode
修改日志模式
shut immediate
startup mount
alter database archivelog;
alter database open;
再次查看日志状态(确认状态)
archive log list
Archive destination-->USE_DB_RECOVERY_FILE_DEST
查看存档的位置及闪回区大小:
show parameter DB_RECOVERY_FILE_DEST
[闪回区]
NAME TYPE VALUE
----------------------------- ----------- ------------------------------
db_recovery_file_dest string
/u01/app/oracle/fast_recovery_
area
db_recovery_file_dest_size big integer
4182M
修改存档位置及大小
alter system db_recovery_file_dest='绝对路径' [scope=memory|spfile];
alter system db_recovery_file_dest_size=500m(大小);
进入闪回区查看归档树
[oracle@oracle5 fast_recovery_area]$ tree
.
|-- ORCL
| |-- archivelog
| | `-- 2017_06_12
| | |-- o1_mf_1_21_dmwbtjdh_.arc
| | |-- o1_mf_1_22_dmwcf12m_.arc
| | `-- o1_mf_1_8_dmw21o1g_.arc
| `-- onlinelog
`-- orcl
`-- control02.ctl
监控闪回区的空间使用情况:如果归档位置空间不足,数据库将不能正常工作
select NAME,SPACE_LIMIT/1048576,SPACE_USED/1048576 from v$recovery_file_dest;
数据修改不能完成;普通用户的登录被禁止
SYS@ orcl> conn scott/tiger
ERROR:
ORA-00257: archiver error. Connect internal only, until freed.
查看归档失败的原因:
select error from v$archive_dest;
查看存档
show parameter log_archive_dest
修改存档终点:
log_archive_dest_n [n=1~31]
mkdir /home/oracle/arc_orcl_dest1
alter system set log_archive_dest_1='location=/home/oracle/arc_orcl_dest1/';
修改log_archive_dest_n为备用状态
log_archive_dest _3='SERVICE=path1
NOREOPENALTERNATE=LOG_ARCHIVE_DEST_4
'
log_archive_dest _4='SERVICE=path2
NOREOPEN OPTIONAL
'
log_archive_dest_state_3=
ENABLE
log_archive_dest_state_4=
ALTERNATE
这里的log_archive_dest_4位备用地址,当3出现故障,自动切换为4.
归档文件不在闪回区,归档格式自动变化:
SYS> show parameter log_archive_format --> %t_%s_%r.dbf #%t ? %s ? %r
查看归档日志的信息:
select sequence#,name from v$archived_log;
sys@ORCL>select sequence#,name from v$archived_log;
SEQUENCE# NAME
------------ -----------------------
8 /u01/app/oracle/fast_recovery_area/ORCL/
archivelog/2017_06_12/o1_mf_1_8_dmw21o1g_.arc
10 /home/oracle/arc_orcl_dest1/1_10_888557606.dbf
9 /home/oracle/arc_orcl_dest1/1_9_888557606.dbf
-----mandatory关键字,表示归档必须都成功
alter system set log_archive_dest_2='location=/ mandatory';
alter system set log_archive_dest_1='location=+fla‘;
切日志,归档;
alter system archive log current ;
----opation默认选项,成功一个就好.不影响使用
alter system set log_archive_dest_1='location=/';
alter system set log_archive_dest_2='location=/home/oracle/';
alter system archive log current;
---archive -proce 归档进成数
!ps -ef |grep ora_arc
alter system set log_archive_max_processes=5;
----succeed_dest (成功数)
show parameter log_archive_min_succeed_dest
alter system set log_archive_min_succeed_dest=2
----stat(修改状态)
alter system set log_archive_dest_state_2='defer' ;
show parameter state;