【日常管理】Asm Diskgroup增加磁盘add disk
show parameter poweralter system set asm_power_limit=0
alter diskgroup MACLEAN add FAILGROUP FailgroupA disk '/asmdisks/asmdiskA28'
alter diskgroup MACLEAN add FAILGROUP FailgroupA disk '/asmdisks/asmdiskA27'
alter diskgroup MACLEAN add FAILGROUP FailgroupA disk '/asmdisks/asmdiskA26'
alter diskgroup MACLEAN add FAILGROUP FailgroupA disk '/asmdisks/asmdiskA25'
alter diskgroup MACLEAN add FAILGROUP FailgroupA disk '/asmdisks/asmdiskA24'
alter diskgroup MACLEAN add FAILGROUP 乱雀FailgroupA disk '/asmdisks/asmdiskA23'
alter diskgroup MACLEAN add FAILGROUP FailgroupA disk '/asmdisks/asmdiskA22'
alter diskgroup MACLEAN add FAILGROUP FailgroupB disk '/asmdisks/asmdiskB50'
alter diskgroup MACLEAN 拿陪衫add FAILGROUP FailgroupB disk '/asmdisks/asmdiskB49'
alter diskgroup MACLEAN add FAILGROUP FailgroupB disk '/asmdisks/asmdiskB48'
alter diskgroup MACLEAN add FAILGROUP FailgroupB disk '/asmdisks/asmdiskB45'
alter diskgroup MACLEAN add FAILGROUP FailgroupB disk '消腔/asmdisks/asmdiskB44'
alter diskgroup MACLEAN add FAILGROUP FailgroupB disk '/asmdisks/asmdiskB43'
alter diskgroup MACLEAN add FAILGROUP FailgroupB disk '/asmdisks/asmdiskB42'
alter diskgroup MACLEAN rebalance power 11
select * from v$asm_operation
--删除用户drop user zxksxt cascade
--删除表空间
drop tablespace zxksxt_data including contents
drop tablespace zxksxt_temp including contents
--执行前先确定表空间文件路径是否正确
select file_name,tablespace_name from dba_data_files
ALTER DISKGROUP DATA ADD DIRECTORY '+DATA/zxksxt/datafile'
--创建临时表空间
create temporary tablespace zxksxt_temp
tempfile '/+DATA/zxksxt/datafile/zxksxt_temp.dbf'
size 200m
autoextend on
next 100m maxsize unlimited
察搏extent management local
--创建表空间
create tablespace zxksxt_data
仿袭datafile '/+DATA/zxksxt/datafile/zxksxt.dbf'
size 200m
autoextend on
next 100m maxsize unlimited
extent management local
--创建用户
create user zxksxt identified by zxksxt
default tablespace zxksxt_data
temporary tablespace zxksxt_temp
--赋权限
败大祥 grant dba to zxksxt
--导入导出命令:
--导出:exp ksxt_yz/ksxt_yz file=name.dmp
--命令将文件导到用户默认文件夹下,也可以写绝对路径指定。
--导入:imp ksxt_yz/ksxt_yz file=name.dmp full=y
--将默认文件夹下边的文件导到数据库中
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)