oracle惜纷飞,Oracle 数据库修改数据文件

日志组内增加成员

SYS@testdb>

alter database add logfile member '/u01/app/oracle/oradata/testdb/

redo01_II.lo

g' to

group 1;

查看

SYS@testdb> select group#,member from v$logfile order by 1;

切换日志后才能删除

SYS@testdb>

alter system switch logfile;

删除成员

SYS@testdb>

alter database drop logfile member '/u01/app/oracle/oradata/testdb/redo03_II.log';

增加日志组

> alter database add logfile group (,) size ;

>

alter database add logfile group 4 ('/u01/app/oracle/oradata/VDEDU/redo04_a.log','/u01/app/oracle/oradata/VDEDU/redo04_b.log') size 50M;

查看状态

SYS@testdb> select group ,bytes/1024/1024 M,members,archived, status from v$log;

改变日至组大小

更改文件组的大小，先创建新组，大小不同于之前，在切换使用，等归档完之后就可以删除之前的组

> alter database add logfile group 11 ('/u01/app/oracle/oradata/testdb/redo11_a.log','/u01/app/oracle/oradata/testdb/redo11_b.log') size 100M;

> alter database add logfile group 12 ('/u01/app/oracle/oradata/testdb/redo12_a.log','/u01/app/oracle/oradata/testdb/redo12_b.log') size 100M;

> alter database add logfile group 13 ('/u01/app/oracle/oradata/testdb/redo13_a.log','/u01/app/oracle/oradata/testdb/redo13_b.log') size 100M;

SYS@testdb> select group#,bytes/1024/1024 M,members,archived,status from v$log;

SYS@testdb> alter system switch logfile;

SYS@testdb> alter database drop logfile group 1;

SYS@testdb> alter database drop logfile group 4;