共计 7462 个字符，预计需要花费 19 分钟才能阅读完成。
丸趣 TV 小编给大家分享一下如何利用 rman copy 的方法实现存储上裸设备数据文件的迁移 ITPUB，希望大家阅读完这篇文章之后都有所收获，下面让我们一起去探讨吧！
利用 rman copy 的方法实现存储上裸设备数据文件的迁移 ITPUB
背景: 有时为了应用的需要，不得不把一些裸设备数据文件迁移到新的存储上或者更快的存储上来满足应用的要求。
下面就是实验来测试控制文件，数据文件，临时数据文件，redo 文件迁移到新的存储方法
[oracle@single ~]$ sqlplus /as sysdba
SQL*Plus: Release 10.2.0.3.0 – Production on 星期三 5 月 6 02:56:14 2009
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
SQL select name from v$controlfile;
NAMEITPUB
——————————————————————————–
/dev/raw/raw2
/dev/raw/raw3
SQL select name from v$datafile;
NAME
——————————————————————————–
/dev/raw/raw7
/dev/raw/raw11
/dev/raw/raw10
/dev/raw/raw9
SQL select name from v$tempfile;
NAME
——————————————————————————-
/dev/raw/raw8
SQL select member from v$logfile;
MEMBER
——————————————————————————–
/dev/raw/raw4
/dev/raw/raw5
1. 建好和原来裸设备一样大小的 lv，建议比原来 lv 大一些 配制好权限 属性为 oracle:dba
1.1 原来存储的控制文件 新存储的控制文件
/dev/raw/raw2 /dev/raw/raw22
/dev/raw/raw3 /dev/raw/raw23
1.2 原来存储的数据文件 新存储的数据文件
/dev/raw/raw7 /dev/raw/raw27
/dev/raw/raw11 /dev/raw/raw31
/dev/raw/raw10 /dev/raw/raw30
/dev/raw/raw9 /dev/raw/raw29
1.3 原来存储的日志文件 新存储的日志文件
/dev/raw/raw4 /dev/raw/raw24
/dev/raw/raw5 /dev/raw/raw25
1.4 原来存储的临时文件 新存储的临时文件
/dev/raw/raw8 /dev/raw/raw28
2. 迁移数据文件到新的存储上
2.1 启动数据库到 mount 状态
SQL startup mount
ORACLE instance started.
Total System Global Area 192937984 bytes
Fixed Size 1260840 bytes
Variable Size 67109592 bytes
Database Buffers 121634816 bytes
Redo Buffers 2932736 bytes
Database mounted.
SQL exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 – Production
With the Partitioning, OLAP and Data Mining options
2.2 用 rman target / 方式进入
[oracle@single ~]$ rman target /
Recovery Manager: Release 10.2.0.3.0 – Production on 星期三 5 月 6 03:24:27 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: ORCL (DBID=1213870770, not open)
RMAN copy datafile /dev/raw/raw7 to /dev/raw/raw27
Starting backup at 06- 5 月 -09
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1I
channel ORA_DISK_1: sid=156 devtype=DISK
channel ORA_DISK_1: starting datafile copy
input datafile fno=00001 name=/dev/raw/raw7
output filename=/dev/raw/raw27 tag=TAG20090506T032607 recid=1 stamp=686114794
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:35
Finished backup at 06- 5 月 -09
RMAN copy datafile /dev/raw/raw9 to /dev/raw/raw29
Starting backup at 06- 5 月 -09
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile fno=00004 name=/dev/raw/raw9
output filename=/dev/raw/raw29 tag=TAG20090506T032716 recid=2 stamp=686114837
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:02
Finished backup at 06- 5 月 -09
RMAN copy datafile /dev/raw/raw10 to /dev/raw/raw30
Starting backup at 06- 5 月 -09
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile fno=00003 name=/dev/raw/raw10
output filename=/dev/raw/raw30 tag=TAG20090506T032746 recid=3 stamp=686114875
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:16
Finished backup at 06- 5 月 -09
RMAN copy datafile /dev/raw/raw11 to /dev/raw/raw31
Starting backup at 06- 5 月 -09
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile fno=00002 name=/dev/raw/raw11
output filename=/dev/raw/raw31 tag=TAG20090506T032822 recid=4 stamp=686114915
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
Finished backup at 06- 5 月 -09
RMAN 2.3 进入 sqlplus, 更改文件名写入到控制文件中
[oracle@single ~]$ sqlplus /as sysdba
SQL*Plus: Release 10.2.0.3.0 – Production on 星期三 5 月 6 03:29:28 2009
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 – Production
With the Partitioning, OLAP and Data Mining options
SQL alter database rename file /dev/raw/raw7 to /dev/raw/raw27
Database altered.
SQL alter database rename file /dev/raw/raw9 to /dev/raw/raw29
Database altered.
SQL alter database rename file /dev/raw/raw10 to /dev/raw/raw30
Database altered.
SQL alter database rename file /dev/raw/raw11 to /dev/raw/raw31
Database altered.
SQL select name from v$datafile;
NAME
——————————————————————————–
/dev/raw/raw27
/dev/raw/raw31
/dev/raw/raw30
/dev/raw/raw29
SQL alter database open;
Database altered.
SQL
迁移数据文件到新的存储上成功
3. 迁移控制文件到新的存储上
3.1. 备份控制文件
startup mount
RMAN backup current controlfile format /home/oracle/crontrol.bak
Starting backup at 06- 5 月 -09
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=156 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
channel ORA_DISK_1: starting piece 1 at 06- 5 月 -09
channel ORA_DISK_1: finished piece 1 at 06- 5 月 -09
piece handle=/home/oracle/crontrol.bak tag=TAG20090506T033405 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:05
Finished backup at 06- 5 月 -09
3.2. 关闭库修改控制文件参数文件
sqlplus /as sysdba
shutdown immediate
create pfile from spfile;
[oracle@single dbs]$ vi initorcl.ora
###########################################
control_files=(/dev/raw/raw22 , /dev/raw/raw23)
指向新的参数文件 lv, 并且保存
create spfile from pfile;
QL startup nomount;
ORACLE instance started.
Total System Global Area 192937984 bytes
Fixed Size 1260840 bytes
Variable Size 67109592 bytes
Database Buffers 121634816 bytes
Redo Buffers 2932736 bytes
SQL show parameter cont
NAME TYPE
———————————— ———————-
VALUE
——————————
control_file_record_keep_time integer
#A2I4_6K F07
control_files string
/dev/raw/raw22, /dev/raw/raw23
global_context_pool_size string
3.3 恢复控制文件到新的存储上, 并且 mount 和用 resetlogs 方式打开数据库
[oracle@single dbs]$ rman target /
Recovery Manager: Release 10.2.0.3.0 – Production on 星期三 5 月 6 03:38:47 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: orcl (not mounted)
RMAN restore controlfile from /home/oracle/crontrol.bak
Starting restore at 06- 5 月 -09
using channel ORA_DISK_1
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:04
output filename=/dev/raw/raw22
output filename=/dev/raw/raw23
Finished restore at 06- 5 月 -09
RMAN alter database mount;
database mounted
released channel: ORA_DISK_1
RMAN alter database open resetlogs;
database opened
[oracle@single dbs]$ sqlplus /as sysdba
SQL*Plus: Release 10.2.0.3.0 – Production on 星期三 5 月 6 03:42:02 2009
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 – Production
With the Partitioning, OLAP and Data Mining options
SQL select name from v$controlfile;
NAME
——————————————————————————–
/dev/raw/raw22
/dev/raw/raw23
可以看到控制文件迁移到新的存储上已经成功
4. 迁移 redo 文件到新的存储上
SQL alter database add logfile /dev/raw/raw24 size 50m;
Database altered.
SQL alter database add logfile /dev/raw/raw25 size 50m;
Database altered
QL alter database drop logfile group 1;
Database altered.
SQL alter system switch logfile;
System altered.
SQL alter system switch logfile;
System altered.
SQL alter database drop logfile group 2;
Database altered.
SQL select member from v$logfile;
MEMBER
——————————————————————————–
/dev/raw/raw24
/dev/raw/raw25
SQL
可以看到 redo 已经迁移到新的存储上
5. 迁移临时数据文件
SQL create TEMPORARY TABLESPACE temp1 tempfile /oradata/temp01.dbf size 50m;
Tablespace created.
alter database default temporary tablespace TEMP1;
drop TABLESPACE TEMP;
CREATE TEMPORARY TABLESPACE TEMP TEMPFILE
/dev/raw/raw28 SIZE 500M AUTOEXTEND OFF
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
BLOCKSIZE 8K;
SQL alter database default temporary tablespace TEMP;
Database altered.
SQL drop tablespace temp1;
Tablespace dropped.
SQL select name from v$tempfile;
NAME
——————————————————————————–
/dev/raw/raw28
SQL
看完了这篇文章，相信你对“如何利用 rman copy 的方法实现存储上裸设备数据文件的迁移 ITPUB”有了一定的了解，如果想了解更多相关知识，欢迎关注丸趣 TV 行业资讯频道，感谢各位的阅读！
