在线精品99_中国九九盗摄偷拍偷看_91免费版在线观看_91.app_91高清视频在线_99热最新网站

如何利用rman copy的方法实现存储上裸设备数据文件的迁移ITPUB

105次阅读
没有评论

共计 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 行业资讯频道，感谢各位的阅读！

正文完
发表至： 数据库
2023-07-24
 
丸趣
版权声明：本站原创文章，由 丸趣 2023-07-24发表，共计7462字。
转载说明：除特殊说明外本站除技术相关以外文章皆由网络搜集发布，转载请注明出处。
评论（没有评论）
主站蜘蛛池模板： 四虎影院最新网址 | 国产亚洲精品免费 | 免费特黄一级欧美大片在线看 | 男男羞羞视频网站国产 | 日韩亚洲综合精品国产 | 国产综合精品在线 | 字幕网在线 | 欧美大片aaa| 亚洲精品第一区二区三区 | 中文字幕日韩精品一区二区三区 | 久久久久亚洲精品美女 | 玩弄人妻少妇500系列网址 | av天堂午夜精品一区二区三区 | 成人h在线观看 | 日韩久久无码免费毛片软件 | 黄网久久| 日韩精品中文字幕久久 | 青青草原在线视频 | 国产精品视频yy9099 | 狠狠色噜噜狠狠狠狠av | 窝窝午夜看片七次郎青草视频 | 国产∨亚洲v天堂无码久久久 | 精品无码一区二区三区亚洲桃色 | 最近中文字幕在线视频 | 亚洲高清二区 | 边添小泬边狠狠躁视频 | 免费无码又爽又刺激网站 | 免费黄色国产视频 | 国产高清国产专区国产精品 | 老妇女人一级毛片 | 亚洲在线视频一区 | 午夜激爽毛片在线看 | 综合爱 | 欧美人与牲动交xxxx | 在线播放一区二区精品产 | 国产精品亚洲成在人线 | 日本a一级毛片免费观看 | 午夜视频在线免费 | 偷偷做久久久久网站 | 嫩草影院地址一地址二 | 我把护士日出水了视频90分钟 |