[ The imperialist Japanese military must officially acknowledge and apologize for the coercion of young women into sexual slaves. / êꪤҳàõªòàõªÎÒ¿Ö˪˪·ª¿ð¨ÏÐñ«ëùìíÜâÏÚªÎ?ð¤àõªòÍëãÒªËìãªá¡¢Þóñªª·ªÊª±ªìªÐªÊªéªÊª¤. ]

»ç¿ëÀÚ

ID:
PW:

INDEX
01.°Ô½ÃÆÇ
°Ô½ÃÆÇ [72]
02.File Book
File ÀÚ·á½Ç [96]
Site Link [14]
°³ÀÎÆú´õ [201]
03.Field Book
Altibase [19]
Tibero [31]
MS-SQL [32]
MySQL [47]
DB2 [79]
ORACLE [3202]
PSQL [143]
CUBRID [5]
±âŸÁ¤º¸ [194]
¿î¿µÃ¼Á¦ [634]
04.Q/A Book
Q/A [53]
05.¹æ¸í·Ï
¹æ¸í·Ï [54]
·¹º§¾÷ [37]
±¸ÀÎ/±¸Á÷ [2]

±â³äÀÏ
Search
LINK
+ °¡Á· Hompy
+ DNSEver
IOTN :: Field Book :: ORACLE

 È¸¿ø°¡ÀÔ

ORA-15411 alter diskgroup data2 offline disks in failgroup fg1 / alter diskgroup data2 add failgroup fg1
ÃÖ±æÈ£ [LIST]   2021-09-29 01:01:34, Á¶È¸ : 1,174

create diskgroup data1 normal redundancy failgroup fg1 disk
http://iotn.co.kr/power/zboard.php?id=9_1_bbs&no=2949

Á¶°Ç: fail group fg2 Àå¾Ö½Ã Ãß°¡ °¡´É
alter diskgroup data add failgroup fg1 disk '/dev/sdk';
ORA-15411: Failure groups in disk group DATA have different number of disks.
Á¶Ä¡:
alter diskgroup data
add failgroup fg1 disk '/dev/sdk' size 1024M
add failgroup fg2 disk '/dev/sdl' size 1024M ;

alter diskgroup data drop disk 'DATA_0000','DATA_0016';

SQL> alter diskgroup data drop disk 'DATA_0023','DATA_0015';
ORA-15032: not all alterations performed
ORA-15084: ASM disk "DATA_0015" is offline and cannot be dropped.
SQL> alter diskgroup data drop disk 'DATA_0023','DATA_0015' force;
Diskgroup altered.

SQL> alter diskgroup data offline disk DATA_0016;
ORA-15032: not all alterations performed
ORA-15283: ASM operation requires compatible.rdbms of 11.1.0.0.0 or higher
SQL> ALTER DISKGROUP data SET ATTRIBUTE 'compatible.rdbms'='11.1.0.0.0'; --  offlineÀº Á¤»ó º¹±¸ ÇØ¾ß ÀÛ¾÷ °¡´É.
ORA-15032: not all alterations performed
ORA-15242: could not set attribute compatible.rdbms
ORA-15232: command requires all disks in diskgroup DATA to be online
SQL> ALTER DISKGROUP data drop DISK DATA_0016 force;                             -- drop force ¿É¼Ç °¡´É

-- FG1Àº Á¤»ó, FG1 disk Á¦°Å ÇÏ·ÁÇÒ¶§
SQL> ALTER DISKGROUP data drop DISK DATA_0000 force;
ORA-15066: offlining disk "DATA_0000" in group "DATA" may result in a data loss
-- Á¦°Å ºÒ°¡ [ Á¦°Å µÇ¸é µ¥ÀÌÅÍ ¼Õ½Ç ]



set lines 200 pages 200
col path for a10
col label for a10
col failgroup for a10
select name,path,LABEL,total_mb,failgroup,MOUNT_STATUS,HEADER_STATUS,STATE from v$asm_disk order by PATH;

NAME                           PATH       LABEL        TOTAL_MB FAILGROUP  MOUNT_S HEADER_STATU STATE
------------------------------ ---------- ---------- ---------- ---------- ------- ------------ --------
DATA2_0000                     /dev/sdj                    1024 FG1        CACHED  MEMBER       NORMAL
DATA2_0001                     /dev/sdk                    1024 FG1        CACHED  MEMBER       NORMAL
DATA2_0002                     /dev/sdl                    1024 FG1        CACHED  MEMBER       NORMAL
DATA2_0003                     /dev/sdm                    1024 FG1        CACHED  MEMBER       NORMAL
DATA2_0004                     /dev/sdn                    1024 FG2        CACHED  MEMBER       NORMAL
DATA2_0005                     /dev/sdo                    1024 FG2        CACHED  MEMBER       NORMAL
DATA2_0006                     /dev/sdp                    1024 FG2        CACHED  MEMBER       NORMAL
DATA2_0007                     /dev/sdq                    1024 FG2        CACHED  MEMBER       NORMAL

-- Àå¾Ö ¹ß»ý fg1 group ¸ðµç disk offline
alter diskgroup data2 offline disks in failgroup fg1;
ORA-15283: ASM operation requires compatible.rdbms of 11.1.0.0.0 or higher
ALTER DISKGROUP data2 SET ATTRIBUTE 'compatible.rdbms'='11.1.0.0.0';
alter diskgroup data2 offline disks in failgroup fg1;

NAME                           PATH       LABEL        TOTAL_MB FAILGROUP  MOUNT_S HEADER_STATU STATE
------------------------------ ---------- ---------- ---------- ---------- ------- ------------ --------
                               /dev/sdj                       0            CLOSED  MEMBER       NORMAL
                               /dev/sdk                       0            CLOSED  MEMBER       NORMAL
                               /dev/sdl                       0            CLOSED  MEMBER       NORMAL
                               /dev/sdm                       0            CLOSED  MEMBER       NORMAL
DATA2_0004                     /dev/sdn                    1024 FG2        CACHED  MEMBER       NORMAL
DATA2_0005                     /dev/sdo                    1024 FG2        CACHED  MEMBER       NORMAL
DATA2_0006                     /dev/sdp                    1024 FG2        CACHED  MEMBER       NORMAL
DATA2_0007                     /dev/sdq                    1024 FG2        CACHED  MEMBER       NORMAL
DATA2_0001                                                 1024 FG1        MISSING UNKNOWN      NORMAL
DATA2_0000                                                 1024 FG1        MISSING UNKNOWN      NORMAL
DATA2_0003                                                 1024 FG1        MISSING UNKNOWN      NORMAL
DATA2_0002                                                 1024 FG1        MISSING UNKNOWN      NORMAL

-- offline ±îÁö Çϰí drop ÇÏÁö´Â ¾Ê´Â´Ù. dropÀº ÇÊ¿ä ¾ø¾î º¸ÀδÙ.
-- alter diskgroup data2 drop disks in failgroup fg1;
-- ORA-15084: ASM disk "DATA2_0000" is offline and cannot be dropped.
-- ALTER DISKGROUP data2 DROP DISKS IN FAILGROUP fg1 FORCE;
-- drop disks ÇÏ¸é ¾Æ·¡ ó·³ º¯ÇÑ´Ù.
NAME                           PATH       LABEL        TOTAL_MB FAILGROUP  MOUNT_S HEADER_STATU STATE
------------------------------ ---------- ---------- ---------- ---------- ------- ------------ --------
_DROPPED_0001_DATA2                                        1024 FG1        MISSING UNKNOWN      FORCING
_DROPPED_0000_DATA2                                        1024 FG1        MISSING UNKNOWN      FORCING
_DROPPED_0003_DATA2                                        1024 FG1        MISSING UNKNOWN      FORCING
_DROPPED_0002_DATA2                                        1024 FG1        MISSING UNKNOWN      FORCING

-- º¹±¸ ½Ãµµ
ALTER DISKGROUP data2 add FAILGROUP fg1 DISK
'/dev/sdj' name DATA2_0000 ,
'/dev/sdk' name DATA2_0001 ,
'/dev/sdl' name DATA2_0002 ,
'/dev/sdm' name DATA2_0003 ;
ORA-15033: disk '/dev/sd?' belongs to diskgroup "DATA2"
-- HEADER_STATUS [ MEMBER => CANDIDATE ]
dd if=/dev/zero of=/dev/sdj skip=2 count=10 bs=8k
dd if=/dev/zero of=/dev/sdk skip=2 count=10 bs=8k
dd if=/dev/zero of=/dev/sdl skip=2 count=10 bs=8k
dd if=/dev/zero of=/dev/sdm skip=2 count=10 bs=8k
NAME                           PATH       LABEL        TOTAL_MB FAILGROUP  MOUNT_S HEADER_STATU STATE
------------------------------ ---------- ---------- ---------- ---------- ------- ------------ --------
                               /dev/sdj                       0            CLOSED  CANDIDATE    NORMAL
                               /dev/sdk                       0            CLOSED  CANDIDATE    NORMAL
                               /dev/sdl                       0            CLOSED  CANDIDATE    NORMAL
                               /dev/sdm                       0            CLOSED  CANDIDATE    NORMAL
-- Àç½Ãµµ
ALTER DISKGROUP data2 add FAILGROUP fg1 DISK
'/dev/sdj' name DATA2_0000 ,
'/dev/sdk' name DATA2_0001 ,
'/dev/sdl' name DATA2_0002 ,
'/dev/sdm' name DATA2_0003 ;

NAME                           PATH       LABEL        TOTAL_MB FAILGROUP  MOUNT_S HEADER_STATU STATE
------------------------------ ---------- ---------- ---------- ---------- ------- ------------ --------
DATA2_0000                     /dev/sdj                    1024 FG1        CACHED  MEMBER       NORMAL
DATA2_0001                     /dev/sdk                    1024 FG1        CACHED  MEMBER       NORMAL
DATA2_0002                     /dev/sdl                    1024 FG1        CACHED  MEMBER       NORMAL
DATA2_0003                     /dev/sdm                    1024 FG1        CACHED  MEMBER       NORMAL
-- ½Ã°£ Áö³ª¸é »ç¶óÁø´Ù. SQL> select * from V$ASM_OPERATION;
_DROPPED_0008_DATA2                                        1024 FG1        MISSING UNKNOWN      FORCING
_DROPPED_0009_DATA2                                        1024 FG1        MISSING UNKNOWN      FORCING
_DROPPED_0011_DATA2                                        1024 FG1        MISSING UNKNOWN      FORCING
_DROPPED_0010_DATA2                                        1024 FG1        MISSING UNKNOWN      FORCING

Ãß°¡

º¹±¸ ¿Ï·áÈÄ ÀÚµ¿ dismount
SUCCESS: alter diskgroup DATA dismount force /* ASM SERVER:255235266 */
SQL> alter diskgroup data mount [ ¼öµ¿ mount ]

SQL> /
select * from V$ASM_OPERATION
*
ERROR at line 1:
ORA-15130: diskgroup "DATA" is being dismounted

SQL> /

no rows selected

SQL>

node1 DB instance down µÇÁö ¾Ê´Â´Ù.
SQL> select inst_id,to_char(startup_time,'yyyy/mm/dd hh24:mi:ss') from gv$instance;

   INST_ID TO_CHAR(STARTUP_TIM
---------- -------------------
         1 2021/10/04 10:58:14
         2 2021/10/04 10:58:03
216.73.216.248


  LIST

Á¦¸ñ ÀÛ¼ºÀÚ ÀÛ¼ºÀÏ Á¶È¸
Admin  KO16MSWIN949 to AL32UTF8 CLOB exp/imp ÇÑ±Û TEST    ÃÖ±æÈ£ 2024/06/30 131
Admin  IMP-00017: following statement failed with ORACLE error 2304:    ÃÖ±æÈ£ 2024/06/28 132
Admin  dba_audit_trail = sys.aud$ dba_fga_audit_trail = sys.fga_log$ delete where sysdate -(365*5)    ÃÖ±æÈ£ 2024/06/27 107
Oracle GoldenGate  OGG-00423 OGG-03533    ÃÖ±æÈ£ 2024/06/26 86
Oracle GoldenGate  logdump filter / x ls / count log    ÃÖ±æÈ£ 2024/06/26 102
Admin  sys_guid json_object json_array / indextype is ctxsys.context    ÃÖ±æÈ£ 2024/06/25 164
Admin  recover copy of database / change copy of database uncatalog; / list copy    ÃÖ±æÈ£ 2024/06/22 104
Admin  create blockchain table / 19.10 ÀÌ»ó ºÎÅÍ °¡´É / ORA-05715    ÃÖ±æÈ£ 2024/06/21 151
Admin  create proxy users    ÃÖ±æÈ£ 2024/06/21 97
Admin  remote_os_authent=true / create user ops$oracle identified externally ;    ÃÖ±æÈ£ 2024/06/21 113
Oracle GoldenGate  logdump reclen env sfet sfnt count filter save    ÃÖ±æÈ£ 2024/06/20 67
Oracle GoldenGate  OGG-15161    ÃÖ±æÈ£ 2024/06/20 127
Backup and Recovery  RMAN-06053: unable to perform media recovery because of missing log    ÃÖ±æÈ£ 2024/06/15 69
Oracle GoldenGate  Replicate data using Oracle Cloud Infrastructure GoldenGate [ Memo ]    ÃÖ±æÈ£ 2024/06/12 104
Pro*C  proc test.pc Syntax error at line 185, column 45, file /usr/include/sys/cdefs.h    ÃÖ±æÈ£ 2024/06/10 95
Oracle GoldenGate  Oracle GoldenGate matrix and lastest patch     ÃÖ±æÈ£ 2024/06/10 87
Backup and Recovery  ORA-01207    ÃÖ±æÈ£ 2024/06/10 72
Install and Config  Linux 9 Oracle 10.2 [ ¼³Ä¡ ºÒ°¡ / ÆÛ¿Í¼­ ¿î¿µ °¡´É / Àå¾Ö½Ã Ã¥ÀÓ ¾øÁö¸¸ º¸Åë ÀߵȴÙ. ]    ÃÖ±æÈ£ 2024/06/07 80

    ¸ñ·Ïº¸±â   ÀÌÀüÆäÀÌÁö   ´ÙÀ½ÆäÀÌÁö [1][2][3][4][5][6] 7 [8][9][10]..[161]   [´ÙÀ½ 10°³]
       

Copyright 1999-2025 Zeroboard / skin by ÃÖ±æÈ£(gilho.kr@gmail.com)
ÃÖ±Ù ´ñ±Û
2021/06/30
À©µµ¿ì ¼­¹ö¿¡¼­ sqlplus .... ORA-...
by ÃÖ±æÈ£
2021/06/30
ORA-28500: connection from O...
by ÃÖ±æÈ£
2019/05/02
pkg È®ÀÎ SELECT * FROM AL...
by ÃÖ±æÈ£
ÃÖ±Ù °Ô½Ã¹°
07/02
[¿î¿µÃ¼Á¦]
rsync -auv.
by ÃÖ±æÈ£
07/01
[±âŸÁ¤º¸]
shell for 001 ~ 100.
by ÃÖ±æÈ£
06/27
[ORACLE]
The clock on host node2 differ....
by ÃÖ±æÈ£