N control02.ctl => +DG1/ASMDB/CONTROLFILE/Current.257.772306557
N control03.ctl => +DG1/ASMDB/CONTROLFILE/Current.258.772306561
N redo01.log => +DG1/ASMDB/ONLINELOG/group_1.259.772306567
N redo02.log => +DG1/ASMDB/ONLINELOG/group_2.260.772306579
N redo03.log => +DG1/ASMDB/ONLINELOG/group_3.261.772306591
N spfileASMDB.ora => +DG1/ASMDB/PARAMETERFILE/spfile.267.772307483
上面看到的就是数据库文件的结构,下面的是数据文件.
ASMCMD> cd datafile
ASMCMD> ls -l
Type Redund Striped Time Sys Name
DATAFILE MIRROR COARSE JAN 11 21:00:00 Y SYSAUX.264.772306671
DATAFILE MIRROR COARSE JAN 11 21:00:00 Y SYSTEM.262.772306615
DATAFILE MIRROR COARSE JAN 11 21:00:00 Y UNDOTBS1.263.772306657
DATAFILE MIRROR COARSE JAN 11 21:00:00 Y USERS.266.772306717
上面第一部分配置的CSS(Cluster Synchronization Services)服务,是为ASM实例(+asm)和ASMDB数据库实例提供服务的.
负责同步数据库的信息到+asm管理的磁盘上.
ASMCMD> lsct
DB_Name Status Software_Version Compatible_version Instance_Name
+ASM CONNECTED 10.2.0.1.0 10.2.0.0.0 +asm
ASMDB CONNECTED 10.2.0.1.0 10.2.0.1.0 asmdb
ASMCMD> find + cont*
+DG1/ASMDB/CONTROLFILE/
+DG1/ASMDB/control01.ctl
+DG1/ASMDB/control02.ctl
+DG1/ASMDB/control03.ctl
mkalias可以为文件创建别名,该成我们在文件系统下熟悉的文件名,如 SYSTEM.262.772306615看起来不像system01.dbf那样熟悉,可以改完后将数据文件指向alias.
ASMCMD> mkalias SYSTEM.262.772306615 system01.dbf
SQL> startup mount
修改数据库
SQL> alter database rename file '+DG1/asmdb/datafile/system.262.772306615' to '+DG1/asmdb/datafile/system01.dbf';
SQL> alter database open;
SQL> select file_name from dba_data_files;
FILE_NAME
-------------------------------------------
+DG1/asmdb/datafile/system01.dbf
+DG1/asmdb/datafile/undotbs1.263.772306657
+DG1/asmdb/datafile/sysaux.264.772306671
+DG1/asmdb/datafile/users.266.772306717
第四部分:为磁盘组增加磁盘
1,创建两个ASM磁盘
D:\>asmtool -create D:\oracle\asmdisk\disk4 200
D:\>asmtool -create D:\oracle\asmdisk\disk5 200
2,连接到ASM实例,
SQL> col path format a30;
SQL> col name format a20
SQL> col failgroup format a20;
SQL> select group_number,mount_status,name,failgroup,path from v$asm_disk;
GROUP_NUMBER MOUNT_S NAME FAILGROUP PATH
------------ ------- -------------------- -------------------- ---------------------------
0 CLOSED D:\ORACLE\ASMDISK\DISK4
0 CLOSED D:\ORACLE\ASMDISK\DISK5
1 CACHED DG1_0000 DG1_0000 D:\ORACLE\ASMDISK\DISK1
1 CACHED DG1_0001 DG1_0001 D:\ORACLE\ASMDISK\DISK2
2 CACHED DG2_0000 DG2_0000 D:\ORACLE\ASMDISK\DISK3
可以看到新建的两块磁盘已经识别
3,添加磁盘disk4到DG1_0000
SQL> ALTER DISKGROUP dg1 ADD failgroup DG1_0000 disk 'D:\oracle\as