Archive destination /u01/oracle/10g/arch
Oldest online log sequence 160
Next log sequence to archive 162
Current log sequence 162
SQL> alter system archive log current;
System altered.
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u01/oracle/10g/arch
Oldest online log sequence 161
Next log sequence to archive 163
Current log sequence 163
--切换为非归档模式
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 1610612736 bytes
Fixed Size 2096632 bytes
Variable Size 469762568 bytes
Database Buffers 1124073472 bytes
Redo Buffers 14680064 bytes
Database mounted.
SQL> alter database noarchivelog;
Database altered.
SQL> alter database open;
www.2cto.com
Database altered.
SQL> archive log list;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination /u01/oracle/10g/arch
Oldest online log sequence 158
Current log sequence 160
4. 日志文件维护
4.1. 增加日志组
sys@GT9I> select group# from v$log;
GROUP#
----------
1
2
3
sys@GT9I> select group#,member from v$logfile order by 1;
GROUP# MEMBER
---------- --------------------------------------------------
1 /u01/oracle/9i/oradata/gt9i/redo01.log
2 /u01/oracle/9i/oradata/gt9i/redo02.log
3 /u01/oracle/9i/oradata/gt9i/redo03.log
现在增加一组包含2个成员的日志组：
sys@GT9I> alter database add logfile group 4 ('/u01/oracle/9i/oradata/gt9i/redo04a.log','/u01/oracle/9i/oradata/gt9i/redo04b.log') size 20M;
Database altered.
sys@GT9I> select group# from v$log;
GROUP#
----------
1
2
3
4
sys@GT9I> select group#,member from v$logfile order by 1;
GROUP# MEMBER
---------- --------------------------------------------------
1 /u01/oracle/9i/oradata/gt9i/redo01.log
2 /u01/oracle/9i/oradata/gt9i/redo02.log
3 /u01/oracle/9i/oradata/gt9i/redo03.log
4 /u01/oracle/9i/oradata/gt9i/redo04a.log
4 /u01/oracle/9i/oradata/gt9i/redo04b.log
4.2. 增加日志成员
sys@GT9I> alter database add logfile member '/u01/oracle/9i/oradata/gt9i/redo04c.log' to group 4;
Database altered.
sys@GT9I> select group#,member from v$logfile order by 1;
GROUP# MEMBER
---------- --------------------------------------------------
1 /u01/oracle/9i/oradata/gt9i/redo01.log
2 /u01/oracle/9i/oradata/gt9i/redo02.log
3 /u01/oracle/9i/oradata/gt9i/redo03.log
4 /u01/oracle/9i/oradata/gt9i/redo04a.log
4 /u01/oracle/9i/oradata/gt9i/redo04b.log
4 /u01/oracle/9i/oradata/gt9i/redo04c.log
www.2cto.com
可以看到在添加成员的时候没有使用文件大小的属性选项，这是因为同组内的成员应当保持大小一致。
4.3. 删除日志成员
sys@GT9I> alter database drop logfile member '/u01/oracle/9i/oradata/gt9i/redo04c.log';
Database altered.
sys@GT9I> select group#,member from v$logfile order by 1;
GROUP# MEMBER
---------- --------------------------------------------------