oracle数据库重做日志文件管理常用操作

1.查看日志视图
select * from v$log;
select * from v$logfile;

2.强制执行日志切换
alter system switch logfile;

3.强制执行检查点操作
ALTER SYSTEM CHECKPOINT;

4..添加联机重做日志文件组
ALTER DATABASE ADD LOGFILE GROUP 1
('D:\TEMP\REDO101.LOG',
'D:\TEMP\REDO0102.LOG')
SIZE 50M;

5.删除联机重做日志组
ALTER DATABASE DROP LOGFILE GROUP 1;

6.添加联机重做日志文件成员
ALTER DATABASE ADD LOGFILE MEMBER
'E:\APP\TEACHER\ORADATA\D124451\RD04A.RDO' TO GROUP 4;

7.删除重做日志文件成员
ALTER DATABASE DROP LOGFILE MEMBER
'E:\APP\TEACHER\ORADATA\D124451\RD04A.RDO';

8.重定位或重命名联机重做日志文件
ALTER DATABASE RENAME FILE
'E:\APP\TEACHER\ORADATA\D124451\RD10E.RDO' TO 'E:\APP\TEACHER\ORADATA\D124451\RD02A.RDO';


9.查看DB_CREATE_ONLINE_LOG_DEST
SHOW PARAMETER DB_CREATE_ONLINE_LOG_DEST

10.修改db_create_online_log_dest_2
ALTER SYSTEM SET db_create_online_log_dest_2='E:\HZH';

11.增加组（启用OMF）

ALTER DATABASE ADD LOGFILE GROUP 5;

12.修改例程恢复所用最长时间(fast_start_mttr_target)，单位为秒

alter system set fast_start_mttr_target=600;