Just a sample case about rebuilding the redo group

来源：互联网发布：淘宝助理怎么改主图编辑：程序博客网时间：2024/05/16 07:12

ORACLE_FileManage_Rebuild the redo group

Just a sample Case:

SQL> select * from v$log;

GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME

---------- -------------------- ---------- ---------- --- ---------------- ---------------------------

1 1 39967 52428800 1 NO INACTIVE 3688205413 30-1-12

2 1 39968 52428800 1 NO INACTIVE 3688311000 30-1-12

3 1 39969 52428800 1 NO CURRENT 3688413657 30-1-12

Solution:

1. NO-RAC

Case:

SQL> select * from v$log;

GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME

---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- --------------

1 1 39967 52428800 1 NO INACTIVE 3688205413 30-1-12

2 1 39968 52428800 1 NO INACTIVE 3688311000 30-1-12

3 1 39969 52428800 1 NO CURRENT 3688413657 30-1-12

Solution:

--- 1. Create a temp redo group 4

$ sqlplus '/as sysdba'

SQL> ALTER DATABASE ADD LOGFILE GROUP 4 ('/opt/oracle/oradata/redotmp01.ora') SIZE 1000M;

--- 2. Switch the logfile, make sure the group 4 is current

SQL> alter system switch logfile;

SQL> select * from v$log;

--- 3. Drop the old redo groups

SQL> alter database drop logfile group 1;

SQL> alter database drop logfile group 2;

SQL> alter database drop logfile group 3;

--- 4. Create the new redo groups. (Must make sure the LV size are enough.)

SQL> ALTER DATABASE ADD LOGFILE GROUP 1 ('/dev/raw/raw10') SIZE 1000M;

SQL> ALTER DATABASE ADD LOGFILE GROUP 2 ('/dev/raw/raw12') SIZE 1000M;

SQL> ALTER DATABASE ADD LOGFILE GROUP 3 ('/dev/raw/raw14') SIZE 1000M;

--- 5. Switch logfile and drop the group 4

SQL> set linesize 400

SQL> alter system switch logfile;

SQL> alter database drop logfile group 4;

2. RAC

Solution:

--- 1. Create a temp redo group 7 and group 8

$ sqlplus '/as sysdba'

SQL> ALTER DATABASE ADD LOGFILE THREAD 1 GROUP 7 ('/opt/oracle/oradata/redotmp07.ora') SIZE 1000M;

SQL> ALTER DATABASE ADD LOGFILE THREAD 2 GROUP 8 ('/opt/oracle/oradata/redotmp08.ora') SIZE 1000M;

--- 2. Switch the logfile in the instance 1, make sure the group 7 is current. Switch the logfile in the instance 2, make sure the group8 is current.

SQL> alter system switch logfile;

SQL> select * from v$log;

--- 3. Drop the old redo groups

SQL> alter database drop logfile group 1;

SQL> alter database drop logfile group 2;

SQL> alter database drop logfile group 3;

SQL> alter database drop logfile group 4;

SQL> alter database drop logfile group 5;

SQL> alter database drop logfile group 6;

--- 4. Create the new redo groups. (Must make sure the LV size are enough.)

SQL> ALTER DATABASE ADD LOGFILE THREAD 1 GROUP 1 ('/dev/raw/raw10') SIZE 1000M;

SQL> ALTER DATABASE ADD LOGFILE THREAD 1 GROUP 2 ('/dev/raw/raw12') SIZE 1000M;

SQL> ALTER DATABASE ADD LOGFILE THREAD 1 GROUP 3 ('/dev/raw/raw14') SIZE 1000M;

SQL> ALTER DATABASE ADD LOGFILE THREAD 2 GROUP 4 ('/dev/raw/raw15') SIZE 1000M;

SQL> ALTER DATABASE ADD LOGFILE THREAD 2 GROUP 5 ('/dev/raw/raw16') SIZE 1000M;

SQL> ALTER DATABASE ADD LOGFILE THREAD 2 GROUP 6 ('/dev/raw/raw17') SIZE 1000M;

--- 5. Switch logfile and drop the group 7 and group 8

SQL> set linesize 400

SQL> alter system switch logfile;

SQL> alter database drop logfile group 7;

SQL> alter database drop logfile group 8;