查看状态
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;