REDOログメンバーの追加

軍鶏/ 7月 7, 2020/ 未分類

SQL> set lin300
col MEMBER for a60
select * from v$logfile;SQL> SQL>

■グループ１にメンバを追加
SQL> alter database add logfile member ‘/opt/oracle/product/10.2.0/oradata/orcl/redo01_2.log’ to group 1;

Database altered.

SQL> select * from v$logfile;

GROUP# STATUS TYPE MEMBER IS_
———- ——- ——- ———————————————————— —
3 ONLINE /opt/oracle/product/10.2.0/oradata/orcl/redo03.log NO
2 ONLINE /opt/oracle/product/10.2.0/oradata/orcl/redo02.log NO
1 ONLINE /opt/oracle/product/10.2.0/oradata/orcl/redo01.log NO
1 INVALID ONLINE /opt/oracle/product/10.2.0/oradata/orcl/redo01_2.log NO

■グループ１にメンバを追加
SQL> alter database add logfile member ‘/opt/oracle/product/10.2.0/oradata/orcl/redo02_2.log’ to group 2;

Database altered.

■グループ１にメンバを追加
SQL> alter database add logfile member ‘/opt/oracle/product/10.2.0/oradata/orcl/redo03_2.log’ to group 3;

Database altered.

SQL> select * from v$logfile;

6 rows selected.

■メンバ追加後はステータスがINVALIDになるので、ログ・スイッチの強制実行をおこなう。

SQL> alter system switch logfile;

System altered.

INVALIDになっているグループにスイッチするとSTATUSがONLINEになります。
SQL> select * from v$logfile;

GROUP# STATUS TYPE MEMBER IS_
———- ——- ——- ———————————————————— —
3 ONLINE /opt/oracle/product/10.2.0/oradata/orcl/redo03.log NO
2 ONLINE /opt/oracle/product/10.2.0/oradata/orcl/redo02.log NO
1 ONLINE /opt/oracle/product/10.2.0/oradata/orcl/redo01.log NO
1 ONLINE /opt/oracle/product/10.2.0/oradata/orcl/redo01_2.log NO
2 ONLINE /opt/oracle/product/10.2.0/oradata/orcl/redo02_2.log NO
3 ONLINE /opt/oracle/product/10.2.0/oradata/orcl/redo03_2.log NO

*********************************コマンド*********************************

REDOログステータス確認
select * from v$log;

REDOログ確認
set lin300
col MEMBER for a60
select * from v$logfile;

ログ・スイッチの強制実行
alter system switch logfile;
チェックポイントの強制実行
ALTER SYSTEM CHECKPOINT;

REDOログメンバーの追加
alter database add logfile member ‘/opt/oracle/product/10.2.0/oradata/orcl/redo01_2.log’ to group 1;
alter database add logfile member ‘/opt/oracle/product/10.2.0/oradata/orcl/redo02_2.log’ to group 2;
alter database add logfile member ‘/opt/oracle/product/10.2.0/oradata/orcl/redo03_2.log’ to group 3;

REDOログメンバーの削除
alter database drop logfile member ‘/opt/oracle/product/10.2.0/oradata/orcl/redo01_2.log’;