log online oracle_[转]Oracle的Online Redo Log 相关操作

手动更改日志组

ALTER SYSTEM SWITCH LOGFILE;

增加日志组

ALTER DATABASE ADD LOGFILE GROUP 5

('E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO04.LOG')

SIZE 8M;

删除日志组

alter database drop logfile group 4 ;

添加日志组成员

ALTER DATABASE ADD LOGFILE MEMBER

'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO21.LOG' TO GROUP 1,

'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO22.LOG' TO GROUP 2,

'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO23.LOG' TO GROUP 3;

删除日志组成员

alter database drop logfile member

'E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO04.LOG' ;

修改online redo log的文件名

– Shut down the database.

– Copy the online redo log files to the new location.

– Place the database in MOUNT mode.

– Execute the command.

alter database rename file

'E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO15.LOG' to

'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO55.LOG' ;

– Open database for normal operation.

alter database open ;