--查看归档状态
--Enabled(开启)
--Disabled(关闭)
archive log list
shutdown immediate;
startup mount;
alter database archivelog;
--alter database noarchivelog;
alter database open;
2、切换日志
alter system switch logfile;
archive log list
3、修改归档路径
--创建归档目录
!mkdir /oradata/arch
--修改归档目录
alter system set log_archive_dest_1='location=/oradata/arch';
archive log list
alter system switch logfile;
archive log list
4、查看归档日志切换频率
set line 400 pagesize 500
col name for a80
alter session set nls_date_format = 'yyyy-mm-dd hh24:mi:ss';
select recid, name, first_time,next_time from v$archived_log;
RECID NAME FIRST_TIME NEXT_TIME
----- -------------------------------- ------------------- -------------------
1 /oradata/arch/1_1_1038682037.dbf 2020-04-25 18:47:17 2020-06-10 09:38:49