http://iotn.co.kr 연락처: gilho.kr@gmail.com [ The Japanese government should apologize to Japanese Military Sexual Slavery victim. / 日本政府は日本軍の性的奴隷?牲者に謝罪すべき. ]

사용자

ID:
PW:

INDEX
01.게시판
게시판 [69]
02.File Book
File 자료실 [95]
Site Link [18]
개인폴더 [194]
03.Field Book
Altibase [19]
Tibero [30]
MS-SQL [18]
MySQL [40]
DB2 [79]
ORACLE [2896]
PostgreSQL [103]
기타정보 [150]
운영체제 [583]
04.Q/A Book
Q/A [53]
05.방명록
방명록 [54]
레벨업 [37]
구인/구직 [2]

기념일
Search
LINK
+ 가족 Hompy
+ DNSEver
IOTN :: Field Book :: ORACLE

 회원가입

alter diskgroup data1 add failgroup fg1 DISK '/dev/sdb' name DATA1_0000 / drop disk
최길호 [LIST]   2021-09-28 22:39:43, 조회 : 3,969

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

추가
set lines 200
col name for a10
col COMPATIBILITY for a10
col DATABASE_COMPATIBILITY for a10
select name,trunc(total_mb/1024) "Disk Size (GB)",trunc(free_mb/1024) "Disk Free (GB)",
decode(type,'NORMAL',trunc(total_mb/1024)/2,trunc(total_mb/1024)) "Real Size (GB)",
trunc(usable_file_mb/1024) "Real Free (GB)",state,type,OFFLINE_DISKS OFF_DISKS,
COMPATIBILITY,DATABASE_COMPATIBILITY,VOTING_FILES from v$asm_diskgroup;

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;

alter diskgroup data drop disk  DATA_0015  ;
alter diskgroup data drop disk 'DATA_0015' ;
ORA-15411: Failure groups in disk group DATA have different number of disks.
-- failgroup 이중화 에러
-- fg1, fg2 failgroup Disk 개수 맞춰서 지워야 한다.

alter diskgroup data drop disk  DATA_0007, DATA_0015 ;
select * from v$asm_operation;

alter diskgroup data add
failgroup fg1 disk '/dev/sdi' name DATA_0007
failgroup fg2 disk '/dev/sdq' name DATA_0015;
select * from v$asm_operation;


DISK_REPAIR_TIME
이 속성은 디스크를 복구하고 다시 온라인 상태로 만드는 시간 간격을 지정합니다.
자동으로 select name v$asm_disk where MOUNT_STATUS = 'MISSING' // disk 제거 한다.
dd test 결과 자동 online 하지 않는다.

FAILGROUP_REPAIR_TIME
이 속성은 디스크 그룹의 실패 그룹에 대한 기본 복구 시간을 지정합니다.

ALTER DISKGROUP data1 SET ATTRIBUTE 'disk_repair_time' = '1h';
ORA-15283: ASM operation requires compatible.rdbms of 11.1.0.0.0 or higher
ALTER DISKGROUP data1 SET ATTRIBUTE 'FAILGROUP_REPAIR_TIME' = '1h';
ORA-15221: ASM operation requires compatible.asm of 12.1.0.0.0 or higher

ALTER DISKGROUP data1 SET ATTRIBUTE 'compatible.rdbms'='11.1.0.0.0';
ALTER DISKGROUP data1 SET ATTRIBUTE 'compatible.asm'='12.1.0.0.0';
ALTER DISKGROUP data1 SET ATTRIBUTE 'disk_repair_time' = '1m';
ALTER DISKGROUP data1 SET ATTRIBUTE 'FAILGROUP_REPAIR_TIME' = '1m'; -- 이건 테스트 안된다.

select path,name,mount_status,header_status
from v$asm_disk
where WRITE_ERRS > 0 or read_errs > 0;

select state,power,group_number,EST_MINUTES
from v$asm_operation;

dd if=/dev/zero of=/dev/sdb skip=2 count=10 bs=8k
10+0 records in
10+0 records out
81920 bytes (82 kB) copied, 0.000331694 s, 247 MB/s

SQL> ALTER DISKGROUP data1 CHECK ALL;
Diskgroup altered.
-- log
SQL> ALTER DISKGROUP data1 CHECK ALL
2021-09-28T22:06:26.235575+09:00
ERROR: Could not read the header of disk DATA1_0000 (0).
NOTE: process _user12057_+asm1 (12057) initiating offline of disk 0.4043004231 (DATA1_0000) with mask 0x7e in group 2 (DATA1) without client assisting
NOTE: initiating PST update: grp 2 (DATA1), dsk = 0/0xf0fb5947, mask = 0x6a, op = clear mandatory
2021-09-28T22:06:26.236629+09:00
GMON updating disk modes for group 2 at 158 for pid 39, osid 12057
2021-09-28T22:06:26.324472+09:00
NOTE: PST update grp = 2 completed successfully
NOTE: initiating PST update: grp 2 (DATA1), dsk = 0/0xf0fb5947, mask = 0x7e, op = clear mandatory
2021-09-28T22:06:26.325052+09:00
GMON updating disk modes for group 2 at 159 for pid 39, osid 12057
2021-09-28T22:06:26.335481+09:00
NOTE: cache closing disk 0 of grp 2: DATA1_0000
2021-09-28T22:06:26.338252+09:00
NOTE: cache closing disk 0 of grp 2: (not open) DATA1_0000
2021-09-28T22:06:26.391889+09:00
NOTE: PST update grp = 2 completed successfully
NOTE: starting check of diskgroup DATA1
NOTE: checking file consistency for diskgroup DATA1
NOTE: checking disk consistency for diskgroup DATA1
WARNING: disk DATA1_0000 (0) cannot be checked because it is offline
2021-09-28T22:06:26.396609+09:00
GMON querying group 2 at 160 for pid 39, osid 12057
2021-09-28T22:06:26.397940+09:00
NOTE: cache closing disk 0 of grp 2: (not open) DATA1_0000
GMON checking disk 1 for group 2 at 161 for pid 39, osid 12057
GMON querying group 2 at 162 for pid 39, osid 12057
2021-09-28T22:06:26.400575+09:00
NOTE: cache closing disk 0 of grp 2: (not open) DATA1_0000
GMON checking disk 2 for group 2 at 163 for pid 39, osid 12057
GMON querying group 2 at 164 for pid 39, osid 12057
2021-09-28T22:06:26.403077+09:00
NOTE: cache closing disk 0 of grp 2: (not open) DATA1_0000
GMON checking disk 3 for group 2 at 165 for pid 39, osid 12057
GMON querying group 2 at 166 for pid 39, osid 12057
2021-09-28T22:06:26.405294+09:00
NOTE: cache closing disk 0 of grp 2: (not open) DATA1_0000
GMON checking disk 4 for group 2 at 167 for pid 39, osid 12057
GMON querying group 2 at 168 for pid 39, osid 12057
2021-09-28T22:06:26.407715+09:00
NOTE: cache closing disk 0 of grp 2: (not open) DATA1_0000
GMON checking disk 5 for group 2 at 169 for pid 39, osid 12057
GMON querying group 2 at 170 for pid 39, osid 12057
2021-09-28T22:06:26.409878+09:00
NOTE: cache closing disk 0 of grp 2: (not open) DATA1_0000
GMON checking disk 6 for group 2 at 171 for pid 39, osid 12057
GMON querying group 2 at 172 for pid 39, osid 12057
2021-09-28T22:06:26.412249+09:00
NOTE: cache closing disk 0 of grp 2: (not open) DATA1_0000
GMON checking disk 7 for group 2 at 173 for pid 39, osid 12057
2021-09-28T22:06:26.416146+09:00
NOTE: checking alias consistency for diskgroup DATA1
NOTE: checking template consistency for diskgroup DATA1
NOTE: checking volume consistency for diskgroup DATA1
NOTE: checking file group consistency for diskgroup DATA1
SUCCESS: check of diskgroup DATA1 found no errors
2021-09-28T22:06:26.421497+09:00
SUCCESS: ALTER DISKGROUP data1 CHECK ALL
2021-09-28T22:06:27.511133+09:00
WARNING: Started Drop Disk Timeout for Disk 0 (DATA1_0000) in group 2 with a value 60 [ ====== 1분 ]
WARNING: Disk 0 (DATA1_0000) in group 2 will be dropped in: (60) secs on ASM inst 1
cluster guid (0e171bb4fd56df58bf164c5d2a287906) generated for PST Hbeat for instance 1
cluster guid (0e171bb4fd56df58bf164c5d2a287906) generated for PST Hbeat for instance 1
cluster guid (0e171bb4fd56df58bf164c5d2a287906) generated for PST Hbeat for instance 1
--
ERROR: Could not read the header of disk DATA1_0000 (0).
NOTE: process _user12057_+asm1 (12057) initiating offline of disk 0.4043004221 (DATA1_0000) with mask 0x7e in group 2 (DATA1) without client assisting
WARNING: Started Drop Disk Timeout for Disk 0 (DATA1_0000) in group 2 with a value 3600
WARNING: Disk 0 (DATA1_0000) in group 2 will be dropped in: (3600) secs on ASM inst 1
... 메세지 보여준다.
WARNING: Disk 0 (DATA1_0000) in group 2 will be dropped in: (3413) secs on ASM inst 1


-- 서비스는 정상, DATA1_0000 MISSING 확인, /dev/sdb CANDIDATE 상태
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
------------------------------ ---------- ---------- ---------- ---------- ------- ------------ --------
                               /dev/sdb                       0            CLOSED  CANDIDATE    NORMAL
DATA1_0000                                                 1024 FG1        MISSING UNKNOWN      NORMAL

-- DATA1_0000 disk_repair_time 시간 지나면 자동 제거 한다.
-- log: SQL> alter diskgroup DATA1 drop disk DATA1_0000 force /* ASM SERVER */
-- diskgroup fail이 아니라서 더이상 자동 진행 없다. 수동으로 /dev/sdb 추가 해서 조치 해야 한다.

-- dismount 한경우 mount 에러 발생
SQL> alter diskgroup data1 dismount
SQL> alter diskgroup data1 mount
ORA-15032: not all alterations performed
ORA-15017: diskgroup "DATA1" cannot be mounted
ORA-15040: diskgroup is incomplete
-- log
2021-09-28T21:19:35.272472+09:00
NOTE: cache registered group DATA1 2/0x9BBBA8C8
NOTE: cache began mount (first) of group DATA1 2/0x9BBBA8C8
NOTE: Assigning number (2,1) to disk (/dev/sdc)
NOTE: Assigning number (2,4) to disk (/dev/sdf)
NOTE: Assigning number (2,5) to disk (/dev/sdg)
NOTE: Assigning number (2,2) to disk (/dev/sdd)
NOTE: Assigning number (2,6) to disk (/dev/sdh)
NOTE: Assigning number (2,3) to disk (/dev/sde)
NOTE: Assigning number (2,7) to disk (/dev/sdi)
2021-09-28T21:19:35.871265+09:00
NOTE: cache dismounting (clean) group 2/0x9BBBA8C8 (DATA1)
NOTE: messaging CKPT to quiesce pins Unix process pid: 12057, image: oracle@node1 (TNS V1-V3)
NOTE: dbwr not being msg'd to dismount
NOTE: LGWR not being messaged to dismount
NOTE: cache dismounted group 2/0x9BBBA8C8 (DATA1)
NOTE: cache ending mount (fail) of group DATA1 number=2 incarn=0x9bbba8c8
NOTE: cache deleting context for group DATA1 2/0x9bbba8c8
2021-09-28T21:19:35.913987+09:00
GMON dismounting group 2 at 72 for pid 39, osid 12057
2021-09-28T21:19:35.914440+09:00
NOTE: Disk DATA1_0001 in mode 0x8 marked for de-assignment
NOTE: Disk DATA1_0002 in mode 0x8 marked for de-assignment
NOTE: Disk DATA1_0003 in mode 0x8 marked for de-assignment
NOTE: Disk DATA1_0004 in mode 0x8 marked for de-assignment
NOTE: Disk DATA1_0005 in mode 0x8 marked for de-assignment
NOTE: Disk DATA1_0006 in mode 0x8 marked for de-assignment
NOTE: Disk DATA1_0007 in mode 0x8 marked for de-assignment
ERROR: diskgroup DATA1 was not mounted
ORA-15032: not all alterations performed
ORA-15017: diskgroup "DATA1" cannot be mounted
ORA-15040: diskgroup is incomplete
2021-09-28T21:19:35.956880+09:00
ERROR: alter diskgroup data1 mount

ALTER DISKGROUP data1 add FAILGROUP fg1 DISK '/dev/sdb' REBALANCE POWER 5 WAIT;
ORA-15411: Failure groups in disk group DATA1 have different number of disks.

SQL> alter diskgroup data1 mount restricted force for recovery;
ORA-15067: command or option incompatible with diskgroup redundancy

SQL> alter diskgroup data1 mount restricted force ;
Diskgroup altered.

ALTER DISKGROUP data1 add disk '/dev/sdb' name DATA1_0000;
ORA-15020: discovered duplicate ASM disk "DATA1_0000"

ALTER DISKGROUP data1 drop DISK DATA1_0000 force;
Diskgroup altered.

ALTER DISKGROUP data1 add FAILGROUP fg1 DISK '/dev/sdb' name DATA1_0000 REBALANCE POWER 5 WAIT;
Diskgroup altered.

ALTER DISKGROUP data1 offline DISK DATA1_0000;
ALTER DISKGROUP data1 drop DISK DATA1_0000 force;
ALTER DISKGROUP data1 add FAILGROUP fg1 DISK '/dev/sdb' name DATA1_0000 ;
ORA-15033: disk '/dev/sdb' belongs to diskgroup "DATA1"
=> dd if=/dev/zero of=/dev/sdb skip=2 count=10 bs=8k # dd header clear // Doc ID 266078.1
ALTER DISKGROUP data1 add FAILGROUP fg1 DISK '/dev/sdb' name DATA1_0000 ;
Diskgroup altered.


-- node2
SQL> alter diskgroup data1 mount;
ORA-15235: diskgroup DATA1 mount mode conflicts with existing mount
-- node1
SQL> alter diskgroup data1 dismount;
Diskgroup altered.
SQL> alter diskgroup data1 mount;

18.207.157.152


  LIST

제목 작성자 작성일 조회
Install and Config  ASM Filter / asmcmd afd_label / asmcmd afd_lslbl / gridSetup.sh 설치전 asm disk    최길호 2021/10/07 288
Troubleshoot  sqlplus: /lib64/libc.so.6: version `GLIBC_2.14' not found    최길호 2021/10/06 692
Troubleshoot  19c _optimizer_cost_based_transformation off bug [ SR 확인 ] lv:9   최길호 2021/10/05 889
Troubleshoot  ORA-12609: TNS: Receive timeout occurred    최길호 2021/10/03 1009
Troubleshoot  EXP-00083: The previous problem occurred when calling SYS.DBMS_AUTO_TASK_EXPORT.system_info_exp    최길호 2021/10/02 796
Troubleshoot  grid 19c crsctl start has / CRS-41053 / Infrastructure has 재구축    최길호 2021/10/01 834
Troubleshoot  ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT    최길호 2021/09/30 277
Admin  alter table add column large table [ 11gR2 부터 빠르다 ]    최길호 2021/09/29 261
Troubleshoot  ORA-15411 alter diskgroup data2 offline disks in failgroup fg1 / alter diskgroup data2 add failgroup fg1    최길호 2021/09/29 486
Troubleshoot  alter diskgroup data1 add failgroup fg1 DISK '/dev/sdb' name DATA1_0000 / drop disk    최길호 2021/09/28 3969
Install and Config  create diskgroup data1 normal redundancy failgroup fg1 disk    최길호 2021/09/28 311
Troubleshoot  [INS-30525] Insufficient number of failure groups specified for Normal Redundancy level.    최길호 2021/09/28 292
Troubleshoot  PRVG-11095 : The TCP system call "connect" failed with error "113"    최길호 2021/09/28 342
Troubleshoot  ORA-00600: internal error code, arguments: [tsdrv1-Bug#24841100]    최길호 2021/09/25 346
Install and Config  ORA-24247: network access denied by access control list (ACL)    최길호 2021/09/24 315
Troubleshoot  ORA-12805 Parallel Query Server Died    최길호 2021/09/23 370

    목록보기   이전페이지   다음페이지 [1][2][3][4][5][6] 7 [8][9][10]..[145]   [다음 10개]
       

Copyright 1999-2022 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 최길호
최근 게시물
08/10
[운영체제]
mobaxterm Remote desktop (RDP,....
by 최길호
08/09
[ORACLE]
ORA-12521 listener does not cu....
by 최길호
08/08
[ORACLE]
ogg save table DML total count....
by 최길호