db_create_file_dest

来源：互联网发布：人工智能大立科技编辑：程序博客网时间：2024/05/17 20:35
<span><span>RAC中，将db_create_file_dest修改为本地路径，在创建表空间指定ASM磁盘组的时候还可以直接'+DATA'么？</span></span>1.查看参数设置db_create_file_dest                  string      +DATA2.修改并查看参数设置SQL> alter system set db_create_file_dest='/u02' scope=both;System altered.SQL> show parameter db_createNAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------db_create_file_dest                  string      /u023.模拟创建+data下的datafile们：ASMCMD [+data/orcl/datafile] > lsSYSAUX.256.901333685SYSTEM.265.901333685UNDOTBS1.264.901333687UNDOTBS2.266.901333943USERS.257.901333687tdb.dbftsys.dbf在+data创建datafileSQL> create tablespace dxmy datafile '+DATA' size 10m autoextend off;Tablespace created.+data下的datafile们：ASMCMD [+data/orcl/datafile] > lsDXMY.270.902737815     ---还是会自动创建SYSAUX.256.901333685SYSTEM.265.901333685UNDOTBS1.264.901333687UNDOTBS2.266.901333943USERS.257.901333687tdb.dbftsys.dbf看来，这个是ASM自动管理的，跟数据库的这个参数没有关系。那么，查了一下这个参数的作用：DB_CREATE_FILE_DEST specifies the default location for Oracle-managed datafiles. Thislocation is also used as the default location for Oracle-managed control files and onlineredo logs if none of the DB_CREATE_ONLINE_LOG_DEST_ n initialization parameters arespecifiedOK，那就是OMF的路径了。
0 0