1、节点一（db01）检查情况： [oraprod@db01 archivelog ]$ lsvg -l sharevg1 | grep lv16_41 lv16_41 raw 128 128 1 closed/syncd N/A --查看格式和使用情况 应该是 raw类型，close状态，下同 [oraprod@db01 archivelog ]$ [oraprod@db01 archivelog ]$ ls -alt /dev/rlv16_41 crw-rw---- 1 oraprod dba 50, 34 Aug 28 13:30 /dev/rlv16_41 --查看权限，应该是数据库用户的，下同 [oraprod@db01 archivelog ]$ 2、 $ lsvg -l sharevg1 | grep lv16_41 lv16_41 raw 128 128 1 closed/syncd N/A $ ls -alt /dev/rlv16_41 crw-rw---- 1 oraprod dba 50, 34 Aug 28 13:31 /dev/rlv16_41 $ 验证结果是可以添加该文件。 3、在任意节点打开sqlplus 执行添加命令： SQL> ALTER TABLESPACE APPS_TS_MEDIA ADD DATAFILE '/dev/rlv16_41' SIZE 16000M AUTOEXTEND OFF; Tablespace altered. SQL> 提示成功 4、观看告警日志信息： Fri Aug 29 09:09:23 2014 ALTER TABLESPACE APPS_TS_MEDIA ADD DATAFILE '/dev/rlv16_41' SIZE 16000M AUTOEXTEND OFF WARNING: You are creating datafile /dev/rlv16_41. WARNING: Oracle recommends creating new datafiles on devices with zero offset. The command "/usr/sbin/mklv -y LVname -T O -w n -s n -r n VGname NumPPs" can be used. Please contact Oracle customer support for more details. Fri Aug 29 09:10:44 2014 WARNING: You are creating/reusing datafile /dev/rlv16_41. WARNING: Oracle recommends creating new datafiles on devices with zero offset. The command "/usr/sbin/mklv -y LVname -T O -w n -s n -r n VGname NumPPs" can be used. Please contact Oracle customer support for more details. Completed: ALTER TABLESPACE APPS_TS_MEDIA ADD DATAFILE '/dev/rlv16_41' SIZE 16000M AUTOEXTEND OFF 最后一行提示添加成功 5、校验结果 5.1节点1登如sqlplus SQL>show parameter name NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_file_name_convert string db_name string PROD db_unique_name string PROD global_names boolean FALSE instance_name string PROD1 lock_name_space string log_file_name_convert string service_names string SQL> col file_name for a20 SQL> select file_id,file_name from dba_data_files where file_name like '%rlv16_41%'; FILE_ID FILE_NAME ---------- -------------------- 252 /dev/rlv16_41 SQL> 5.2节点2登入sqlplus SQL> show parameter name; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_file_name_convert string db_name string PROD db_unique_name string PROD global_names boolean FALSE instance_name string PROD2 lock_name_space string log_file_name_convert string service_names string PROD SQL> col file_name for a20 SQL> select file_id,file_name from dba_data_files where file_name like '%rlv16_41%'; FILE_ID FILE_NAME ---------- -------------------- 252 /dev/rlv16_41 SQL> 6 确认成功添加。