Oracle Database 联机日志管理
增加日志文件SQL> alter database add logfile member
'/u01/app/oracle/oradata/king/redo01c.log' to group 1,
'/u01/app/oracle/oradata/king/redo02c.log' to group 2,
'/u01/app/oracle/oradata/king/redo03c.log' to group 3;
SQL> select group#,status,type,member from v$logfile;
GROUP# Status TS Type MEMBER
---------- --------- --------------- --------------------------------------------------
3 ONLINE /u01/app/oracle/oradata/king/redo03a.log
2 ONLINE /u01/app/oracle/oradata/king/redo02a.log
1 ONLINE /u01/app/oracle/oradata/king/redo01a.log
1 ONLINE /u01/app/oracle/oradata/king/redo01b.log
2 ONLINE /u01/app/oracle/oradata/king/redo02b.log
3 ONLINE /u01/app/oracle/oradata/king/redo03b.log
1 INVALID ONLINE /u01/app/oracle/oradata/king/redo01c.log
2 INVALID ONLINE /u01/app/oracle/oradata/king/redo02c.log
3 INVALID ONLINE /u01/app/oracle/oradata/king/redo03c.log
GROUP#SEQUENCE# MEMBERS BYTES Status ARCHIVED
---------- ---------- ---------- ---------- --------- ---------
1 7 3 52428800 CURRENT NO
2 0 3 52428800 UNUSED YES
3 0 3 52428800 UNUSED YES
删除日志文件
SQL>alter database drop logfile member
'/u01/app/oracle/oradata/king/redo02c.log';
SQL> host rm -rf /u01/app/oracle/oradata/king/redo02c.log
SQL> alter database drop logfile member
'/u01/app/oracle/oradata/king/redo03c.log';
SQL> host rm -rf /u01/app/oracle/oradata/king/redo03c.log
SQL> alter system switch logfile;
SQL> alter system checkpoint;
SQL>alter database drop logfile member
'/u01/app/oracle/oradata/king/redo01c.log';
SQL> host rm -rf /u01/app/oracle/oradata/king/redo01c.log
页:
[1]