Modify oracle redo log file size
Create 3 new log groups
SQL > ALTER DATABASE ADD LOGFILE GROUP 4 ('/ u01ax SIZE SIZE 500m)
SQL > ALTER DATABASE ADD LOGFILE GROUP 5 ('/ u01ax SIZE SIZE 500m)
SQL > ALTER DATABASE ADD LOGFILE GROUP 6 ('/ u01ax SIZE SIZE 500m)
View log group
SQL > select * from v$logfile
two。 Switch the current log to a new log group
SQL > alter system switch logfile
SQL > alter system switch logfile
SQL > alter system switch logfile
Cut to delete as INCACTIVE.
SQL > select group#,sequence#,bytes,members,status from v$log
GROUP# SEQUENCE# BYTES MEMBERS STATUS
--
1 139 52428800 1 INACTIVE
2 137 52428800 1 INACTIVE
3 138 52428800 1 INACTIVE
4 140 524288000 1 ACTIVE
5 141 524288000 1 CURRENT
6 136 524288000 1 INACTIVE
3. Delete the old log group
SQL > alter database drop logfile group 1
Database altered.
SQL > alter database drop logfile group 2
Database altered.
SQL > alter database drop logfile group 3
Check to see if the log group is deleted
SQL > select group#,sequence#,bytes,members,status from v$log
GROUP# SEQUENCE# BYTES MEMBERS STATUS
--
4 140 524288000 1 INACTIVE
5 141 524288000 1 CURRENT
6 136 524288000 1 INACTIVE
4. The operating system deletes files in original log groups 1, 2, and 3
[oracle@oracle122 log] $cd / u01/app/oracle/oradata/orcl
[oracle@oracle122 orcl] $
[oracle@oracle122 orcl] $pwd
/ u01/app/oracle/oradata/orcl
[oracle@oracle122 orcl] $ls
Control01.ctl example01.dbf redo01.log redo02.log redo03.log redo04.log redo05.log redo06.log sysaux01.dbf system01.dbf temp01.dbf undotbs01.dbf users01.dbf
[oracle@oracle122 orcl] $rm-rf redo01.log
[oracle@oracle122 orcl] $rm-rf redo02.log
[oracle@oracle122 orcl] $rm-rf redo03.log
5. Rebuild log group 1, 2, 3
SQL > ALTER DATABASE ADD LOGFILE GROUP 1 ('/ u01ax SIZE SIZE 500m)
SQL > ALTER DATABASE ADD LOGFILE GROUP 2 ('/ u01ax SIZE SIZE 500m)
SQL > ALTER DATABASE ADD LOGFILE GROUP 3 ('/ u01ax SIZE SIZE 500m)
7. Delete log groups 4, 5 and 6 for intermediate transition, and query select group#,sequence#,bytes,members,status from vault log when deleting; delete whether the group is INACTIVE, and execute alter system switch logfile if it is not INACTIVE
Check it out.
SQL > select group#,sequence#,bytes,members,status from v$log
GROUP# SEQUENCE# BYTES MEMBERS STATUS
--
1 148 524288000 1 CURRENT
2 143 524288000 1 INACTIVE
3 144 524288000 1 INACTIVE
4 146 524288000 1 INACTIVE
5 147 524288000 1 INACTIVE
6 145 524288000 1 INACTIVE
SQL > alter database drop logfile group 4
Database altered.
SQL > alter database drop logfile group 5
Database altered.
SQL > alter database drop logfile group 6
Database altered.
8. Delete groups 4, 5, 6 to the operating system
[oracle@oracle122 orcl] $rm-rf redo04.log
[oracle@oracle122 orcl] $rm-rf redo05.log
[oracle@oracle122 orcl] $rm-rf redo06.log
9. Back up the latest control files
SQL > alter database backup controlfile to trace resetlogs
