フレックスディスクグループ作成
割当制限グループ作成
PDB11用ファイルグループを作成
PDB11作成
CREATE DISKGROUP flex_data FLEX REDUNDANCY DISK '/dev/sdd','/dev/sde','/dev/sdf';
SELECT name, type FROM V$ASM_DISKGROUP;
select * from v$asm_diskgroup order by group_number;
select * from v$asm_disk order by group_number,disk_number;
select
NAME,
LABEL,
PATH,
GROUP_NUMBER,
DISK_NUMBER,
STATE,
OS_MB,
TOTAL_MB
from v$asm_disk order by group_number,disk_number;
lsfg
lsqg
ALTER DISKGROUP flex_data ADD QUOTAGROUP QG1
SET 'quota'= 100G;
ALTER DISKGROUP flex_data ADD FILEGROUP FileGroup_PDB11
DATABASE CRM_PDB11
SET 'quota_group' = 'QG1';
※PDBをFGに紐づける場合、<CDB名>_<PDB名> と指定する模様
alter session set db_create_file_dest='+FLEX_DATA';
CREATE PLUGGABLE DATABASE PDB11 ADMIN USER pdbadm IDENTIFIED BY oracle;
