Shulou(Shulou.com)06/01 Report--

Because the current redo configuration of the database is 1G, from the log point of view, the redo switch is too frequent and cannot be archived in time. This representation will greatly affect database performance, so make the following tuning

1:sqlplus / as sysdba

Add the following 8 groups of redo

Alter database add logfile thread 1 group9 ('+ DATA1/xxzxdb/NLINELOG/group9a','+DATA1/xxzxdb/NLINELOG/group9b') size 2000m

Alter database add logfile thread 2 group10 ('+ DATA1/xxzxdb/NLINELOG/group10a','+DATA1/xxzxdb/NLINELOG/group10b') size 2000m

Alter database add logfile thread 1 group11 ('+ DATA1/xxzxdb/NLINELOG/group11a','+DATA1/xxzxdb/NLINELOG/group11b') size 2000m

Alter database add logfile thread 2 group12 ('+ DATA1/xxzxdb/NLINELOG/group12a','+DATA1/xxzxdb/NLINELOG/group12b') size 2000m

Alter database add logfile thread 1 group13 ('+ DATA1/xxzxdb/NLINELOG/group13a','+DATA1/xxzxdb/NLINELOG/group13b') size 2000m

Alter database add logfile thread 2 group14 ('+ DATA1/xxzxdb/NLINELOG/group14a','+DATA1/xxzxdb/NLINELOG/group14b') size 2000m

Alter database add logfile thread 1 group15 ('+ DATA1/xxzxdb/NLINELOG/group15a','+DATA1/xxzxdb/NLINELOG/group15b') size 2000m

Alter database add logfile thread 2 group16 ('+ DATA1/xxzxdb/NLINELOG/group16a','+DATA1/xxzxdb/NLINELOG/group16b') size 2000m

2: after adding, execute alter system switch logfile;-- several times more. Switch redo, all the way to the newly added 9, and make 9 become current

Select a.members

A.thread#

A.status

A.bytes / 1024 / 1024

B.type

B.member

B.group#

From v$log a, v$logfile b

Where a.group# = b.group#

3: when the status of redo group 1-8 becomes "INACTIVE", it can be deleted.

SQL > alter database drop logfile group 1

Database altered

4: when 1-8 groups of logs are still in active status and the archive is not completed, they cannot be deleted at this time.

Execute sql > alter system checkpoint

This will delete the logs of groups 1-8 one by one.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.