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

Oracle 10g RAC add log groups and members and delete log members 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; if you add a wrong name by mistake, add a member first and then add SQL> alter database add logfile member '+ Data/myrac/onlinelog/myracw.redolog_group6_02' to group 6; SQL> alter database add logfile member' + data/myrac/onlinelog/myracw.redolog_group6_01 'to group 6; cannot delete SQL> alter database drop logfile member '+ DATA/myrac/onlinelog/myrackets redolog_group6_01 '; alter database drop logfile member '+ DATA/myrac/onlinelog/myracw.redolog_group6_01' * www.2cto.com row 1st error: ORA-00362: requires that the input members form the ORA-01517 of valid log files in group 6: 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 6 rows have been selected. Switch the log 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 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 CURR ENT 4495802 26-9 month-12 6 2 44 104857600 3 no current 4497190 26-9 month-12 www.2cto.com has 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 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 CURREN T 4495802 26-9 month-12 6 2 44 104857600 3 no active 4497190 26-9 month-12 6 rows selected. SQL> alter system switch logfile ;?????? SQL>/GROUP # THREAD # SEQUENCE # BYTES MEMBERS ARC STATUS FIRST_CHANGE # FIRST_TIME ---------- -------------------- average 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 45 52428800 1 no inactive 449721526-9 month-12 5 1 88 10485 7600 2 no current 4495802 26-9 month-12 6 2 44 104857600 3 no inactive 4497190 26-9 month-12 6 rows selected. SQL> alter database droplogfile member '+ DATA/myrac/onlinelog/myrac1_redolog_group6_01'; the database has been changed. SQL> select group #, member from v $ logfile where group # = 6; GROUP # MEMBER ---------- deleted 6 + DATA/myrac/onlinelog/myrac2_redolog_group6_02 6 + DATA/myrac/onlinelog/myrac2_redolog_group6_01 has been deleted successfully.
Next, go to ASMCMD to delete the physical file ASMCMD> ls www.2cto.com ls-ls to see the alias Association ASMCMD> pp commands: -------- cd du find help ls lsct lsdg mkalias mkdir pwd rm rmaliasASMCMD> rm myrac1_redolog_group6_01ASMCMD> ls www.2cto.com success> www.2cto.com
The following describes some log principles: before deletion, you must follow the following principles. Each instance must have at least two log groups. When a group is in the ACTIVE or CURRENT status, 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 a log Member: You cannot delete a member when it is the last member in the GROUP; when the Group's turntable is in the current status, you cannot delete the Group members. In archive mode, you must archive the group before deleting the Group members. You can only change the database when deleting the group members, the operating system file has not been deleted alter database drop logfile member '/LOCATION_DUST/REDO0N_N.LOG ';