oracle日志、数据文件操作命令

1、增加日志组
alter database add logfile group 1 ('/u01/app/oracle/oradata/redo1.log','/u02/oradata/redo1.log') size 100m；
rac环境下要加上thread
alter database add logfile thread 1 group 1 ('/u01/app/oracle/oradata/redo1.log','/u02/oradata/redo1.log') size 100m；
2、增加日志组成员
alter database add logfile member '/u02/oradata/redo1.log' to group 1；
rac环境 alter database add logfile member '/u02/oradata/redo1.log' to group 1；
3、删除日志组
alter database drop logfile group 1;
4、删除日志组成员
alter database drop logfile member '/u02/oradata/redo1.log' ;
5、表空间增加数据文件并设置自动扩展
alter tablespace tname add datafile '/u01/app/oracle/oradata/users02.dbf' size 1G autoextend on next 100M;
6、清除损坏日志并重建
alter database clear logfile group 1;
7、获取控制文件的创建脚本
alter database backup controlfile to trace;