secoug 发表于 2019-11-23 09:10:54

课程第24次

Notice: This blog is written by Bo Tang.

+ASM：

<div> alter diskgroup dataadd template template1 attribute (unprotected coarse) ;</div><div>Diskgroup altered.
</div><div>alter diskgroup dataadd template template2attribute (highfine) ;</div><div>Diskgroup altered。
</div>
   GROUP_NUMBERENTRY_NUMBERREDUNDANCYSTRIPESYSTEMNAMEPRIMARY_REGIONMIRROR_REGION
1160MIRRORCOARSEYPARAMETERFILECOLDCOLD
2161MIRRORCOARSEYASMPARAMETERFILECOLDCOLD
3163MIRRORCOARSEYDUMPSETCOLDCOLD
4164HIGHFINEYCONTROLFILECOLDCOLD
5165MIRRORCOARSEYFLASHFILECOLDCOLD
6166MIRRORCOARSEYARCHIVELOGCOLDCOLD
7167MIRRORCOARSEYONLINELOGCOLDCOLD
8168MIRRORCOARSEYDATAFILECOLDCOLD
9169MIRRORCOARSEYTEMPFILECOLDCOLD
101170MIRRORCOARSEYBACKUPSETCOLDCOLD
111171MIRRORCOARSEYXTRANSPORT BACKUPSETCOLDCOLD
121172MIRRORCOARSEYAUTOBACKUPCOLDCOLD
131173MIRRORCOARSEYXTRANSPORTCOLDCOLD
141174MIRRORCOARSEYCHANGETRACKINGCOLDCOLD
151175MIRRORCOARSEYFLASHBACKCOLDCOLD
161176MIRRORCOARSEYDATAGUARDCONFIGCOLDCOLD
171177MIRRORCOARSEYOCRFILECOLDCOLD
181280UNPROTCOARSENTEMPLATE1COLDCOLD
191281HIGHFINENTEMPLATE2COLDCOLD

DATABASE：
select * from dba_data_files;

create tablespace tbshighdata2datafile '+highdata/orcl/datadir/tbshighdata2.dbf' size 10M;

select * from v$asm_diskgroup;

select * from v$asm_alias where group_number=3;

select* from v$asm_template where group_number=1;


create tablespace tbs7 datafile '+data(template1)' size 5M ;

create tablespace tbs8 datafile '+data(template2)/orcl/datadir/tbs8.dbf'size 5M;

验证：

select* from v$asm_alias where lower(name)='tbs7.258.1022401035';

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

验证：

select * from dba_data_files where tablespace_name='TBS8';


select* from v$asm_alias where lower(name)='tbs8.dbf';


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



v$asm_operation：

SQL*Plus: Release 11.2.0.4.0 Production on Wed Oct 23 08:37:10 2019

Copyright (c) 1982, 2013, Oracle.All rights reserved.

SQL> conn / as sysasm
Connected.
SQL> alter diskgroup data undrop disks;

Diskgroup altered.

SQL> alter diskgroup data drop disk ASMDISK04 rebalance power 11;

Diskgroup altered.

SQL> ! ps aux |grep arb
oracle    1583 12.81.0 1364228 40732 ?       Ss   08:39   0:01 asm_arb0_+ASM
oracle    15960.00.0 1081761164 pts/0    S+   08:39   0:00 /bin/bash -cps aux |grep arb
oracle    15980.00.0 105380   852 pts/0    S+   08:39   0:00 grep arb
没有使用的磁盘，group_number=0:

select* from v$asm_disk;


调试快速镜像重同步：
SQL>alter diskgroup dataoffline disk ASMDISK04drop after 1h;
alter diskgroup dataoffline disk ASMDISK04drop after 1h
*
ERROR at line 1:
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';

Diskgroup altered.

SQL> alter diskgroup data set attribute 'compatible.rdbms'='10.1';
alter diskgroup data set attribute 'compatible.rdbms'='10.1'
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15242: could not set attribute compatible.rdbms
ORA-15244: new compatibility setting less than current


SQL>


-------

select * from v$asm_disk_stat;

select* from v$asm_disk_iostat;



SQL> alter diskgroup data online diskASMDISK04 ;

Diskgroup altered.

SQL> select* from v$asm_operation;

GROUP_NUMBER OPERATION       STATE             POWER   ACTUAL      SOFAR
------------ --------------- ------------ ---------- ---------- ----------
EST_WORK   EST_RATE EST_MINUTES
---------- ---------- -----------
ERROR_CODE
--------------------------------------------------------------------------------
         1 ONLIN         RUN                   1          0          0
         0          0         0



页: [1]
查看完整版本: 课程第24次