1、切换当前日志
ALTER SYSTEM SWITCH LOGFILE;
2、归档除当前日志外所有未归档日志,并不做日志切换
ALTER SYSTEM ARCHIVE LOG ALL;
3、归档包括当前日志所有日志文件,并做日志切换
ALTER SYSTEM ARCHIVE LOG CURRENT;
4、增加在线日志文件组
ALTER DATABASE ADD LOGFILE GROUP 4
(
'F:\oracle\product\10.2.0\oradata\orcl\REDO0401.LOG',
'F:\oracle\product\10.2.0\oradata\orcl\REDO0402.LOG'
)
SIZE 50M;
5、给在线日志文件组增加成员
ALTER DATABASE ADD LOGFILE MEMBER
'F:\oracle\product\10.2.0\oradata\orcl\REDO0101.LOG' , 'F:\oracle\product\10.2.0\oradata\orcl\REDO0102.LOG' TO GROUP 1 ,
'F:\oracle\product\10.2.0\oradata\orcl\REDO0201.LOG' , 'F:\oracle\product\10.2.0\oradata\orcl\REDO0202.LOG' TO GROUP 2 ,
'F:\oracle\product\10.2.0\oradata\orcl\REDO0301.LOG' , 'F:\oracle\product\10.2.0\oradata\orcl\REDO0302.LOG' TO GROUP 3;
6、删除在线日志组
ALTER DATABSE DROP LOGFILE GROUP 4;
7、删除在线日志组成员
ALTER DATABASE DROP LOGFILE MEMBER 'F:\oracle\product\10.2.0\oradata\orcl\R
EDO01.LOG';