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

Back it up before modification to prevent accidents.

Create pfile='/home/oracle/0144CISD.ora' from spfile

Select group#,thread#,bytes/1024/1024,status from v$log

Alter database add logfile thread 1 group 11'+ DATA' size 1G

Alter database add logfile thread 1 group 12'+ DATA' size 1G

Alter database add logfile thread 1 group 13'+ DATA' size 1G

Alter database add logfile thread 1 group 14'+ DATA' size 1G

Alter database add logfile thread 1 group 15'+ DATA' size 1G

Alter database add logfile thread 2 group 16'+ DATA' size 1G

Alter database add logfile thread 2 group 17'+ DATA' size 1G

Alter database add logfile thread 2 group 18'+ DATA' size 1G

Alter database add logfile thread 2 group 19'+ DATA' size 1G

Alter database add logfile thread 2 group 20'+ DATA' size 1G

Alter system switch logfile

Alter database drop logfile group 1

Alter database drop logfile group 2

Alter database drop logfile group 3

Alter database drop logfile group 4

Alter database drop logfile group 5

Alter database drop logfile group 6

Alter database drop logfile group 7

Alter database drop logfile group 8

Alter database drop logfile group 9

Alter database drop logfile group 10

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.