Oracle 10g RAC Add a log Group and Member, and delete a log Member

Source: Internet
Author: User

SQL> alter database add logfile thread 1 group5 ('+ Data/myrac/onlinelog/myrac1_redolog_group5_01') size 100 m;

SQL> alter database add logfile member '+ Data/myrac/onlinelog/myrackets redolog_group5_02' to group 5;

SQL> alter database add logfile thread 2 group 6 ('+ Data/myrac/onlinelog/myrac1_redolog_group6_01') size 100 m;

Incorrect name added by mistake

Add members first

SQL> alter database add logfile member '+ Data/myrac/onlinelog/myrackets redolog_group6_02' to group 6;

SQL> alter database add logfile member '+ Data/myrac/onlinelog/myrackets redolog_group6_01' to group 6;

Cannot be deleted

SQL> alter database drop logfile member '+ Data/myrac/onlinelog/myrackets redolog_group6_01 ';

Alter database drop logfile member '+ Data/myrac/onlinelog/myrac1_redolog_group6_01'

*

Row 3 has an error:

ORA-00362: requires that a member be input to form a valid log file in group 6

ORA-01517: log Member: '+ DATA/myrac/onlinelog/myracw.redolog_group6_01'

 

The log status is not in use!

SQL> select group #, archived, status from v $ log;

 

GROUP # ARC STATUS

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

1 NO ACTIVE

2 NO INACTIVE

3 NO CURRENT

4 NO INACTIVE

5 NO CURRENT

6 YES UNUSED

 

You have selected 6 rows.

 

Switch logs on node 2 instance 2 database instance

SQL> alter system switch logfile;

 

??????

SQL>/

 

GROUP # THREAD # SEQUENCE # bytes members arc status FIRST_CHANGE # FIRST_TIME

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

1 1 87 52428800 1 no inactive 4427645 25-9 month-12

2 1 86 52428800 1 no inactive 4356268 25-9 month-12

3 2 43 52428800 1 no active 4402972 25-9 month-12

4 2 42 52428800 1 no inactive 4206757 24-9 month-12

5 1 88 104857600 2 no current 4495802 26-9 month-12

6 2 44 104857600 3 no current 4497190 26-9 month-12

 

You have selected 6 rows.

 

SQL> alter system switch logfile;

 

??????

SQL>/

 

GROUP # THREAD # SEQUENCE # bytes members arc status FIRST_CHANGE # FIRST_TIME

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

1 1 87 52428800 1 No inactive 4427645 25-9 month-12

2 1 86 52428800 1 No inactive 435626825-9 month-12

3 2 43 52428800 1 no active 4402972 25-9 month-12

4 2 45 52428800 1 no current 4497215 26-9 month-12

5 1 88 104857600 2 no current 4495802 26-9 month-12

6 2 44 104857600 3 no active 4497190 26-9 month-12

 

You have selected 6 rows.

 

SQL> alter system switch logfile;

??????

 

SQL>/

 

GROUP # THREAD # SEQUENCE # bytes members arc status FIRST_CHANGE # FIRST_TIME

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

1 1 87 52428800 1 no inactive 4427645 25-9 month-12

2 1 86 52428800 1 no inactive 4356268 25-9 month-12

3 2 46 52428800 1 no current 4497279 26-9 month-12

4 2 45 52428800 1 No inactive 449721526-9 month-12

5 1 88 104857600 2 no current 4495802 26-9 month-12

6 2 44 104857600 3 No inactive 4497190 26-9 month-12

 

You have selected 6 rows.

 

SQL> alter database droplogfile member '+ Data/myrac/onlinelog/myrackets redolog_group6_01 ';

 

The database has been changed.

SQL> select group #, member from V $ logfile where group # = 6;

Group # Member

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

6 + Data/myrac/onlinelog/myrac2_redolog_group6_02

6 + DATA/myrac/onlinelog/myrac2_redolog_group6_01

 

Deleted successfully

Next, go to ASMCMD to delete the physical file.

ASMCMD> ls

Group_1.257.772910379

Group_2.258.772910389

Group_3.265.772919275

Group_4.266.772919281

Group_5.268.795028735

Group_5.269.795029891

Group_6.270.795030293

Group_6.271.795030355

Group_6.272.795030429

Myrac1_redolog_group5_01

Myrac1_redolog_group5_02

Myrac1_redolog_group6_01

Myrac2_redolog_group6_01

Myrac2_redolog_group6_02

 

Ls-ls can see alias Association

ASMCMD> pp

Commands:

--------

Cd

Du

Find

Help

Ls

Lsct

Lsdg

Mkalias

Mkdir

Pwd

Rm

Rmalias

ASMCMD> rm myracw.redolog_group6_01

ASMCMD> ls

Group_1.257.772910379

Group_2.258.772910389

Group_3.265.772919275

Group_4.266.772919281

Group_5.268.795028735

Group_5.269.795029891

Group_6.271.795030355

Group_6.272.795030429

Myrac1_redolog_group5_01

Myrac1_redolog_group5_02

Myrac2_redolog_group6_01

Myrac2_redolog_group6_02

ASMCMD>

The following describes some log principles:

Principles: The following principles must be observed before deletion. Each instance must have at least two log groups. When a group is ACTIVE or CURRENT, it cannot be deleted; deleting a log GROUP only changes the database, and the operating system files have not been deleted. When the drop logfile group n statement is applied to the deletion, all members in group n will be deleted.

Alter database drop logfile group n;

Principles for deleting log members: When you delete the last member in the group, you cannot delete the Member. When the group's turntable is in the current status, you cannot delete the member; in archive mode, files must be archived before they can be deleted. to delete a member of a log group, only the database is changed, and files of the operating system are not deleted.

Alter database drop logfile member '/LOCATION_DUST/REDO0N_N.LOG ';

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.