rac环境将误建立在本地目录的数据文件转移到ASM存储中。
来源:互联网 发布:大数据云平台建设方案 编辑:程序博客网 时间:2024/05/07 22:10
----------------------非系统表空间
SQL> set linesize 150
SQL> set pagesize 400
SQL> column file_name format a65
SQL> column tablespace_name format a25
SQL> select file_name,file_id,ONLINE_STATUS,tablespace_name from dba_data_files;
FILE_NAME FILE_ID ONLINE_ TABLESPACE_NAME
----------------------------------------------------------------- ---------- ------- -------------------------
+DATA/hyw/datafile/users.259.903803203 4 ONLINE USERS
+DATA/hyw/datafile/undotbs1.258.903803203 3 ONLINE UNDOTBS1
+DATA/hyw/datafile/sysaux.257.903803203 2 ONLINE SYSAUX
+DATA/hyw/datafile/system.256.903803201 1 SYSTEM SYSTEM
+DATA/hyw/datafile/undotbs2.265.903803821 5 ONLINE UNDOTBS2
SQL> create tablespace tdb datafile '/u02/app/oracle/datafile/tdb.dbf' size 10m autoextend off; //模拟添加数据文件
Tablespace created.
将数据文件offline
SQL> alter database datafile 6 offline;
Database altered.
使用RMAN移动本地文件到asm
RMAN> copy datafile '/u02/app/oracle/datafile/tdb.dbf' to '+DATA';
Starting backup at 03-FEB-16
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=35 instance=orcl1 device type=DISK
channel ORA_DISK_1: starting datafile copy
input datafile file number=00006 name=/u02/app/oracle/datafile/tdb.dbf
output file name=+DATA/orcl/datafile/tdb.268.902813699 tag=TAG20160203T053456 RECID=1 STAMP=902813699
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
Finished backup at 03-FEB-16
注册一下
RMAN> switch datafile '/u02/app/oracle/datafile/tdb.dbf' to copy;
将数据文件online
SQL> alter database datafile 6 online;
Database altered.
检查数据文件
select file_name,file_id,ONLINE_STATUS,tablespace_name from dba_data_files;
-------------------------系统表空间
alter tablespace system add datafile '/home/oracle/scripts/00.dbf' size 10m autoextend off; //模拟添加数据文件
SQL> alter database datafile 6 offline;
alter database datafile 6 offline
*
ERROR at line 1:
ORA-01541: system tablespace cannot be brought offline; shut down if necessary --这就是为什么需要停机时间
在一个节点执行:
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 /home/oracle/scripts/00.dbf +DATA
copying /home/oracle/scripts/00.dbf -> +DATA/hyw/datafile/00.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 '/home/oracle/scripts/00.dbf' to '+DATA/hyw/datafile/00.dbf';
Database altered.
8.启动数据库
SQL> alter database open;
Database altered.
9.检查数据文件状态
节点一:
FILE_NAME FILE_ID ONLINE_ TABLESPACE_NAME
----------------------------------------------------------------- ---------- ------- -------------------------
+DATA/hyw/datafile/users.259.903803203 4 ONLINE USERS
+DATA/hyw/datafile/undotbs1.258.903803203 3 ONLINE UNDOTBS1
+DATA/hyw/datafile/sysaux.257.903803203 2 ONLINE SYSAUX
+DATA/hyw/datafile/system.256.903803201 1 SYSTEM SYSTEM
+DATA/hyw/datafile/undotbs2.265.903803821 5 ONLINE UNDOTBS2
+DATA/hyw/datafile/00.dbf 6 SYSTEM SYSTEM
节点二:
SQL> select file_name,file_id,ONLINE_STATUS,tablespace_name from dba_data_files;
ERROR:
ORA-01157: cannot identify/lock data file 6 - see DBWR trace file
ORA-01110: data file 6: '+DATA/hyw/datafile/00.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/hyw/datafile/users.259.903803203 4 ONLINE USERS
+DATA/hyw/datafile/undotbs1.258.903803203 3 ONLINE UNDOTBS1
+DATA/hyw/datafile/sysaux.257.903803203 2 ONLINE SYSAUX
+DATA/hyw/datafile/system.256.903803201 1 SYSTEM SYSTEM
+DATA/hyw/datafile/undotbs2.265.903803821 5 ONLINE UNDOTBS2
+DATA/hyw/datafile/00.dbf 6 SYSTEM SYSTEM
SQL> set linesize 150
SQL> set pagesize 400
SQL> column file_name format a65
SQL> column tablespace_name format a25
SQL> select file_name,file_id,ONLINE_STATUS,tablespace_name from dba_data_files;
FILE_NAME FILE_ID ONLINE_ TABLESPACE_NAME
----------------------------------------------------------------- ---------- ------- -------------------------
+DATA/hyw/datafile/users.259.903803203 4 ONLINE USERS
+DATA/hyw/datafile/undotbs1.258.903803203 3 ONLINE UNDOTBS1
+DATA/hyw/datafile/sysaux.257.903803203 2 ONLINE SYSAUX
+DATA/hyw/datafile/system.256.903803201 1 SYSTEM SYSTEM
+DATA/hyw/datafile/undotbs2.265.903803821 5 ONLINE UNDOTBS2
SQL> create tablespace tdb datafile '/u02/app/oracle/datafile/tdb.dbf' size 10m autoextend off; //模拟添加数据文件
Tablespace created.
将数据文件offline
SQL> alter database datafile 6 offline;
Database altered.
使用RMAN移动本地文件到asm
RMAN> copy datafile '/u02/app/oracle/datafile/tdb.dbf' to '+DATA';
Starting backup at 03-FEB-16
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=35 instance=orcl1 device type=DISK
channel ORA_DISK_1: starting datafile copy
input datafile file number=00006 name=/u02/app/oracle/datafile/tdb.dbf
output file name=+DATA/orcl/datafile/tdb.268.902813699 tag=TAG20160203T053456 RECID=1 STAMP=902813699
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
Finished backup at 03-FEB-16
注册一下
RMAN> switch datafile '/u02/app/oracle/datafile/tdb.dbf' to copy;
将数据文件online
SQL> alter database datafile 6 online;
Database altered.
检查数据文件
select file_name,file_id,ONLINE_STATUS,tablespace_name from dba_data_files;
-------------------------系统表空间
alter tablespace system add datafile '/home/oracle/scripts/00.dbf' size 10m autoextend off; //模拟添加数据文件
SQL> alter database datafile 6 offline;
alter database datafile 6 offline
*
ERROR at line 1:
ORA-01541: system tablespace cannot be brought offline; shut down if necessary --这就是为什么需要停机时间
在一个节点执行:
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 /home/oracle/scripts/00.dbf +DATA
copying /home/oracle/scripts/00.dbf -> +DATA/hyw/datafile/00.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 '/home/oracle/scripts/00.dbf' to '+DATA/hyw/datafile/00.dbf';
Database altered.
8.启动数据库
SQL> alter database open;
Database altered.
9.检查数据文件状态
节点一:
FILE_NAME FILE_ID ONLINE_ TABLESPACE_NAME
----------------------------------------------------------------- ---------- ------- -------------------------
+DATA/hyw/datafile/users.259.903803203 4 ONLINE USERS
+DATA/hyw/datafile/undotbs1.258.903803203 3 ONLINE UNDOTBS1
+DATA/hyw/datafile/sysaux.257.903803203 2 ONLINE SYSAUX
+DATA/hyw/datafile/system.256.903803201 1 SYSTEM SYSTEM
+DATA/hyw/datafile/undotbs2.265.903803821 5 ONLINE UNDOTBS2
+DATA/hyw/datafile/00.dbf 6 SYSTEM SYSTEM
节点二:
SQL> select file_name,file_id,ONLINE_STATUS,tablespace_name from dba_data_files;
ERROR:
ORA-01157: cannot identify/lock data file 6 - see DBWR trace file
ORA-01110: data file 6: '+DATA/hyw/datafile/00.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/hyw/datafile/users.259.903803203 4 ONLINE USERS
+DATA/hyw/datafile/undotbs1.258.903803203 3 ONLINE UNDOTBS1
+DATA/hyw/datafile/sysaux.257.903803203 2 ONLINE SYSAUX
+DATA/hyw/datafile/system.256.903803201 1 SYSTEM SYSTEM
+DATA/hyw/datafile/undotbs2.265.903803821 5 ONLINE UNDOTBS2
+DATA/hyw/datafile/00.dbf 6 SYSTEM SYSTEM
0 0
- rac环境将误建立在本地目录的数据文件转移到ASM存储中。
- ORACLE RAC(11203)环境将误建立在本地目录的文件转移到ASM存储中
- 在RAC环境中,怎么样找到错误的数据文件
- 使用RAMN将本地的数据文件迁移到ASM磁盘组上
- 如何将ASM中的数据文件复制到操作系统中
- RAC中数据文件创建到了本地路径(非系统表空间) 使用rman转移
- 迁移本地数据文件、控制文件、日志文件到新的存储(挂载点目录与本地目录相同)
- oracle之 RAC本地数据文件迁移至ASM
- rac+asm:移动数据文件
- 将spfile存储在ASM中
- 在ASM中移动数据文件
- 使用rman迁移数据文件操作步骤(RAC-ASM环境)
- rac 环境数据文件误建到rac 节点本地处理
- ASM上的备份集如何转移到文件系统中
- 将rdd存储到本地的一个文件中
- 将rdd存储到本地的一个文件中
- RAC 下文件建立在本地的问题解决
- 在AIX中如何使用vg镜像的方法将数据转移到新存储设备(适合用户更换新盘阵时)
- 【opencv】获取图片某点像素值的两种方法
- 跳槽遇到背景调查,你可以这样做!
- Powershell工作流的限制
- linxu 中大量的close_wait 和 time_wait 处理
- 推荐系统实践--基于用户的协同过滤算法
- rac环境将误建立在本地目录的数据文件转移到ASM存储中。
- 文章标题
- JDK容器与并发—数据结构
- iOS 设计模式之建造者模式 (Builder)
- 抽象类&接口
- 协同过滤算法
- 模糊神经网络系统2
- hill descent algorithm
- DevExpress控件-ButtonEdit控件的使用(图文)