oracle集数据文件目录位置,RAC中数据文件创建到了本地路径（系统表空间）
oracle集数据⽂件⽬录位置,RAC中数据⽂件创建到了本地路
径（系统表空间）
参考⽂档： 1607292.1
如果是系统表空间的数据⽂件创建到了本地，那么是需要停机时间的。移动的时候，注意asm磁盘空间。
1.模拟创建
节点⼀：
SQL> alter tablespace system add datafile '/u02/app/oracle/datafile/tsys.dbf' size 10m autoextend off;
Tablespace altered.
2.检查数据⽂件
节点⼀：
SQL> /
FILE# NAME
---------- --------------------------------------------------
4 +DATA/orcl/datafile/users.257.901333687
3 +DATA/orcl/datafile/undotbs1.264.901333687
2 +DATA/orcl/datafile/sysaux.256.901333685
1 +DATA/orcl/datafile/system.265.901333685
5 +DATA/orcl/datafile/undotbs2.266.901333943
6 +DATA/orcl/datafile/tdb.dbf
7 /u02/app/oracle/datafile/tsys.dbf
节点⼆：
SQL> select file_name,file_id,ONLINE_STATUS,tablespace_name from dba_data_files;
ERROR:
ORA-01157: cannot identify/lock data file 7 - see DBWR trace file
ORA-01110: data file 7: '/u02/app/oracle/datafile/tsys.dbf'
1. 将数据⽂件offline
SQL> alter database datafile 7 offline;
alter database datafile 7 offline
*
ERROR at line 1:
ORA-01541: system tablespace cannot be brought offline; shut down if necessary --这就是为什么需要停机时间
4.在⼀个节点执⾏：
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
另⼀个节点：
SQL> select open_mode from gv$database;
OPEN_MODE
集成吊顶哪个牌子好--------------------
READ WRITE
5.使⽤asmcmd将本地⽂件移动到asm
ASMCMD [+data/orcl/datafile] > cp /u02/app/oracle/datafile/tsys.dbf .
copying /u02/app/oracle/datafile/tsys.dbf -> +data/orcl/datafile/tsys.dbf
6.启动数据库到mount状态
SQL> startup mount;
ORACLE instance started.
Total System Global Area 1336176640 bytes
Fixed Size 2213136 bytes
Variable Size 587205360 bytes
Database Buffers 738197504 bytes
Redo Buffers 8560640 bytes
Database mounted.
7.修改数据⽂件路径
中国高端女装品牌SQL> alter database rename file '/u02/app/oracle/datafile/tsys.dbf' to '+data/orcl/datafile/tsys.dbf' 2 ;
Database altered.
8.启动数据库
SQL> alter database open;
Database altered.
9.检查数据⽂件状态
节点⼀：
FILE_NAME FILE_ID ONLINE_ TABLESPACE_NAME
-------------------------------------------------- ---------- ------- ------------------------------
+DATA/orcl/datafile/users.257.901333687 4 ONLINE USERS
+DATA/orcl/datafile/undotbs1.264.901333687 3 ONLINE UNDOTBS1
+DATA/orcl/datafile/sysaux.256.901333685 2 ONLINE SYSAUX
跑跑卡丁车挑战者模式
+DATA/orcl/datafile/system.265.901333685 1 SYSTEM SYSTEM
+DATA/orcl/datafile/undotbs2.266.901333943 5 ONLINE UNDOTBS2
+DATA/orcl/datafile/tdb.dbf 6 ONLINE TDB
+DATA/orcl/datafile/tsys.dbf 7 SYSTEM SYSTEM
节点⼆：闰年有多少天
SQL> select file_name,file_id,ONLINE_STATUS,tablespace_name from dba_data_files; ERROR:
ORA-01157: cannot identify/lock data file 7 - see DBWR trace file
ORA-01110: data file 7: '+DATA/orcl/datafile/tsys.dbf'
10.所以最后⼀步，是要重启节点⼆
笔记本电脑保养SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 1336176640 bytes
Fixed Size 2213136 bytes
Variable Size 486542064 bytes
Database Buffers 838860800 bytes
Redo Buffers 8560640 bytes
Database mounted.
Database opened.
11.检查数据⽂件
FILE_NAME FILE_ID ONLINE_ TABLESPACE_NAME
------------------------------------------------------------ ---------- ------- ----------------------------------------+DATA/orcl/datafile/users.257.901333687 4 ONLINE USERS
+DATA/orcl/datafile/undotbs1.264.901333687 3 ONLINE UNDOTBS1
+DATA/orcl/datafile/sysaux.256.901333685 2 ONLINE SYSAUX
+DATA/orcl/datafile/system.265.901333685 1 SYSTEM SYSTEM
+DATA/orcl/datafile/undotbs2.266.901333943 5 ONLINE UNDOTBS2
+DATA/orcl/datafile/tdb.dbf 6 ONLINE TDB
+DATA/orcl/datafile/tsys.dbf 7 SYSTEM SYSTEM广州换驾驶证地址
7 rows selected.
OK！

版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。