Oracle如何进行日志切换和初始化文件创建

2014-10-19 15:57:29 · 作者: · 浏览: 43











3)数据库置于 MOUNT状态


4)执行命令 alter database rename file ‘/directory_name/redo_name1.log ‘ to


/directory_name/redo_name2.log ‘;


5)数据库置于 OPEN状态



b、增加一个新成员,删除旧成员


alter database add logfile member ‘/directory_name/redo_name.log’ to group 2;


alter database drop logfile member ‘/directory_name/redo_name.log’;


alter system switch logfile;