课程第24次

secoug

Notice: This blog is written by Bo Tang.

+ASM：

1. <div> alter diskgroup data  add template template1 attribute (unprotected coarse) ;</div><div>Diskgroup altered.
   
2. </div><div>alter diskgroup data  add template template2  attribute (high  fine) ;</div><div>Diskgroup altered。
   
3. </div>

复制代码

	GROUP_NUMBER	ENTRY_NUMBER	REDUNDANCY	STRIPE	SYSTEM	NAME	PRIMARY_REGION	MIRROR_REGION
1	1	60	MIRROR	COARSE	Y	PARAMETERFILE	COLD	COLD
2	1	61	MIRROR	COARSE	Y	ASMPARAMETERFILE	COLD	COLD
3	1	63	MIRROR	COARSE	Y	DUMPSET	COLD	COLD
4	1	64	HIGH	FINE	Y	CONTROLFILE	COLD	COLD
5	1	65	MIRROR	COARSE	Y	FLASHFILE	COLD	COLD
6	1	66	MIRROR	COARSE	Y	ARCHIVELOG	COLD	COLD
7	1	67	MIRROR	COARSE	Y	ONLINELOG	COLD	COLD
8	1	68	MIRROR	COARSE	Y	DATAFILE	COLD	COLD
9	1	69	MIRROR	COARSE	Y	TEMPFILE	COLD	COLD
10	1	170	MIRROR	COARSE	Y	BACKUPSET	COLD	COLD
11	1	171	MIRROR	COARSE	Y	XTRANSPORT BACKUPSET	COLD	COLD
12	1	172	MIRROR	COARSE	Y	AUTOBACKUP	COLD	COLD
13	1	173	MIRROR	COARSE	Y	XTRANSPORT	COLD	COLD
14	1	174	MIRROR	COARSE	Y	CHANGETRACKING	COLD	COLD
15	1	175	MIRROR	COARSE	Y	FLASHBACK	COLD	COLD
16	1	176	MIRROR	COARSE	Y	DATAGUARDCONFIG	COLD	COLD
17	1	177	MIRROR	COARSE	Y	OCRFILE	COLD	COLD
18	1	280	UNPROT	COARSE	N	TEMPLATE1	COLD	COLD
19	1	281	HIGH	FINE	N	TEMPLATE2	COLD	COLD

DATABASE：

1. select * from dba_data_files;
   
2. 
   
3. create tablespace tbshighdata2  datafile '+highdata/orcl/datadir/tbshighdata2.dbf' size 10M  ;
   
4. 
   
5. select * from v$asm_diskgroup;
   
6. 
   
7. select * from v$asm_alias where group_number=3;
   
8. 
   
9. select  * from v$asm_template where group_number=1;
   
10. 
    
11. 
    
12. create tablespace tbs7 datafile '+data(template1)' size 5M ;
    
13. 
    
14. create tablespace tbs8 datafile '+data(template2)/orcl/datadir/tbs8.dbf'  size 5M;
    

复制代码

验证：

1. 
   
2. select  * from v$asm_alias where lower(name)='tbs7.258.1022401035';
   
3. 
   
4. select  * from v$asm_file where group_number=1  and file_number=258;

复制代码

验证：

1. select * from dba_data_files where tablespace_name='TBS8';
   
2. 
   
3. 
   
4. select  * from v$asm_alias where lower(name)='tbs8.dbf';

复制代码

1. select  * from v$asm_file where group_number=1  and file_number=279;

复制代码

v$asm_operation：

1. SQL*Plus: Release 11.2.0.4.0 Production on Wed Oct 23 08:37:10 2019
   
2. 
   
3. Copyright (c) 1982, 2013, Oracle.  All rights reserved.
   
4. 
   
5. SQL> conn / as sysasm
   
6. Connected.
   
7. SQL> alter diskgroup data undrop disks;
   
8. 
   
9. Diskgroup altered.
   
10. 
    
11. SQL> alter diskgroup data drop disk ASMDISK04 rebalance power 11;
    
12. 
    
13. Diskgroup altered.
    
14. 
    
15. SQL> ! ps aux |grep arb
    
16. oracle    1583 12.8  1.0 1364228 40732 ?       Ss   08:39   0:01 asm_arb0_+ASM
    
17. oracle    1596  0.0  0.0 108176  1164 pts/0    S+   08:39   0:00 /bin/bash -c  ps aux |grep arb
    
18. oracle    1598  0.0  0.0 105380   852 pts/0    S+   08:39   0:00 grep arb
    

复制代码

没有使用的磁盘，group_number=0:

1. 
   
2. select  * from v$asm_disk;

复制代码

调试快速镜像重同步：

1. SQL>  alter diskgroup data  offline disk ASMDISK04  drop after 1h;
   
2. alter diskgroup data  offline disk ASMDISK04  drop after 1h
   
3. *
   
4. ERROR at line 1:
   
5. ORA-15032: not all alterations performed
   
6. ORA-15283: ASM operation requires compatible.rdbms of 11.1.0.0.0 or higher
   
7. 
   

复制代码

1. SQL> alter diskgroup data set attribute 'compatible.rdbms'='11.1.0.0.0';
   
2. 
   
3. Diskgroup altered.
   
4. 
   
5. SQL> alter diskgroup data set attribute 'compatible.rdbms'='10.1';
   
6. alter diskgroup data set attribute 'compatible.rdbms'='10.1'
   
7. *
   
8. ERROR at line 1:
   
9. ORA-15032: not all alterations performed
   
10. ORA-15242: could not set attribute compatible.rdbms
    
11. ORA-15244: new compatibility setting less than current [11.1.0.0.0]
    
12. 
    
13. 
    
14. SQL>

复制代码

-------

1. select * from v$asm_disk_stat;

复制代码

1. select  * from v$asm_disk_iostat;

复制代码

1. SQL> alter diskgroup data online disk  ASMDISK04 ;
   
2. 
   
3. Diskgroup altered.
   
4. 
   
5. SQL> select  * from v$asm_operation;
   
6. 
   
7. GROUP_NUMBER OPERATION       STATE             POWER     ACTUAL      SOFAR
   
8. ------------ --------------- ------------ ---------- ---------- ----------
   
9.   EST_WORK   EST_RATE EST_MINUTES
   
10. ---------- ---------- -----------
    
11. ERROR_CODE
    
12. --------------------------------------------------------------------------------
    
13.            1 ONLIN           RUN                   1          0          0
    
14.          0          0           0
    
15. 
    

复制代码