oracle日志组调整

# oracle日志组调整

查看当前情况：

select group#,bytes/1024/1024,status from v$log;

select group#,type,member from v$logfile;

第一步：

backup database;

piece handle=/u01/app/oracle/fast\_recovery\_area/ORCL/backupset/2019\_09\_16/o1\_mf\_nnndf\_TAG20190916T162733\_gqykvp4h\_.bkp tag=TAG20190916T162733 comment=NONE

channel ORA\_DISK\_1: backup set complete, elapsed time: 00:06:47

Finished backup at 16-SEP-19

Starting Control File and SPFILE Autobackup at 16-SEP-19

piece handle=/u01/app/oracle/fast\_recovery\_area/ORCL/autobackup/2019\_09\_16/o1\_mf\_s\_1019147660\_gqyl8fcb\_.bkp comment=NONE

Finished Control File and SPFILE Autobackup at 16-SEP-19

第二步：

ALTER DATABASE orcl ADD LOGFILE GROUP 4 ('/tqls\_system/app/oracle/oradata/ecology/redo04.log') SIZE 1g;

ALTER DATABASE orcl ADD LOGFILE GROUP 5 ('/tqls\_system/app/oracle/oradata/ecology/redo05.log') SIZE 1g;

第三步：

alter system switch logfile;

alter system switch logfile;(if need)

alter system checkpoint;

第四步：

alter database drop logfile group 1;

alter database drop logfile group 2;

alter database drop logfile group 3;

第五步：

cd /u01/app/oracle/oradata/orcl/

rm -rf redo01.log

rm -rf redo02.log

rm -rf redo03.log

第六步：

ALTER DATABASE orcl ADD LOGFILE GROUP 1 ('/tqls\_system/app/oracle/oradata/ecology/redo01.log') SIZE 1g;

ALTER DATABASE orcl ADD LOGFILE GROUP 2 ('/tqls\_system/app/oracle/oradata/ecology/redo02.log') SIZE 1g;

ALTER DATABASE orcl ADD LOGFILE GROUP 3 ('/tqls\_system/app/oracle/oradata/ecology/redo03.log') SIZE 1g;