调整redo文件

查看大小和状态

select group#, bytes/1024/1024/1024 as GB,status,thread# from v$log order by thread#;

查看redo位置

select group#,member from v$logfile;

增加redo group

alter database add logfile thread 1 size 2G;

alter database add logfile thread 1 group 5 ('+DATADG1','+DATADG2') size 50m;

增加redo memeber

alter database add logfile member '/u01/app/oracle/Odata/redo16.log' to group 15;

删除日志组

alter system switch logfile; --当前实例
alter system archive log current; --RAC所有实例
alter system checkpoint;
alter database drop logfile group n;

• 日志组状态

删除redo memeber

SELECT GROUP# AS "Group Number", MEMBER AS "Member Path" FROM V$LOGFILE;

ALTER DATABASE DROP LOGFILE MEMBER 'path_to_member_file' [FROM GROUP group_number];