日志的操作

查看状态

select status from v$log;

强制执行日志切换

ALTER SYSTEM SWITCH LOGFILE;

Alter system checkpoint;???

添加联机重做日志文件组

Alter database add logfile group 4

('/u01/app/oracle/oradata/YANSHIBIN/onlinelog/yanshibin.log','/u01/app/oracle/flash_recovery_area/YANSHIBIN/onlinelog/yanshibin.log') size 4m;

添加联机重做日志文件成员

Alter database add logfile member

Alter database add logfile member

  2  '/u01/app/oracle/oradata/YANSHIBIN/onlinelog/o1_mf_3_8pv4b37n_1.log' to group 1,

  3  '/u01/app/oracle/oradata/YANSHIBIN/onlinelog/o1_mf_2_8pv49z7x_1.log' to group 2,

  4  '/u01/app/oracle/oradata/YANSHIBIN/onlinelog/o1_mf_1_8pv49v85_1.log' to group 3,

  5  '/u01/app/oracle/oradata/YANSHIBIN/onlinelog/yanshibin_1.log' to group 4;

删除联机重做日志文件组

Alter database drop logfile group 4;

删除联机重做日志成员

Alter database drop logfile member

重定位或重命名

联机重做日志文件

Cp……………………………….

状态下Startup mount

Alter database rename file ‘旧’ to ‘新’；

查看归档状态、、

archive log list;

启动归档在mount状态

Alter database archivelog;