久久精品人人爽,华人av在线,亚洲性视频网站,欧美专区一二三

如何利用rman copy的方法實(shí)現(xiàn)存儲上裸設(shè)備數(shù)據(jù)文件的遷移ITPUB

130次閱讀
沒有評論

共計(jì) 7462 個字符，預(yù)計(jì)需要花費(fèi) 19 分鐘才能閱讀完成。

丸趣 TV 小編給大家分享一下如何利用 rman copy 的方法實(shí)現(xiàn)存儲上裸設(shè)備數(shù)據(jù)文件的遷移 ITPUB，希望大家閱讀完這篇文章之后都有所收獲，下面讓我們一起去探討吧！

利用 rman copy 的方法實(shí)現(xiàn)存儲上裸設(shè)備數(shù)據(jù)文件的遷移 ITPUB
背景: 有時為了應(yīng)用的需要，不得不把一些裸設(shè)備數(shù)據(jù)文件遷移到新的存儲上或者更快的存儲上來滿足應(yīng)用的要求。
下面就是實(shí)驗(yàn)來測試控制文件，數(shù)據(jù)文件，臨時數(shù)據(jù)文件，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. 建好和原來裸設(shè)備一樣大小的 lv，建議比原來 lv 大一些 配制好權(quán)限 屬性為 oracle:dba
 1.1 原來存儲的控制文件   新存儲的控制文件  
/dev/raw/raw2  /dev/raw/raw22
/dev/raw/raw3  /dev/raw/raw23
1.2 原來存儲的數(shù)據(jù)文件   新存儲的數(shù)據(jù)文件
  /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. 遷移數(shù)據(jù)文件到新的存儲上

2.1 啟動數(shù)據(jù)庫到 mount 狀態(tài)
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 / 方式進(jìn)入
[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 進(jìn)入 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

遷移數(shù)據(jù)文件到新的存儲上成功

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. 關(guān)閉庫修改控制文件參數(shù)文件
sqlplus /as sysdba
shutdown immediate
create pfile from spfile;
[oracle@single dbs]$ vi initorcl.ora

###########################################
control_files=(/dev/raw/raw22 , /dev/raw/raw23)
指向新的參數(shù)文件 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 恢復(fù)控制文件到新的存儲上, 并且 mount 和用 resetlogs 方式打開數(shù)據(jù)庫
[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

可以看到控制文件遷移到新的存儲上已經(jīng)成功

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 已經(jīng)遷移到新的存儲上

 
5. 遷移臨時數(shù)據(jù)文件

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 的方法實(shí)現(xiàn)存儲上裸設(shè)備數(shù)據(jù)文件的遷移 ITPUB”有了一定的了解，如果想了解更多相關(guān)知識，歡迎關(guān)注丸趣 TV 行業(yè)資訊頻道，感謝各位的閱讀！

正文完
發(fā)表至： 數(shù)據(jù)庫
2023-07-24
 
丸趣
版權(quán)聲明：本站原創(chuàng)文章，由 丸趣 2023-07-24發(fā)表，共計(jì)7462字。
轉(zhuǎn)載說明：除特殊說明外本站除技術(shù)相關(guān)以外文章皆由網(wǎng)絡(luò)搜集發(fā)布，轉(zhuǎn)載請注明出處。
評論（沒有評論）
主站蜘蛛池模板： 永济市| 百色市| 阿尔山市| 横峰县| 芦山县| 宕昌县| 保德县| 朝阳县| 米泉市| 大足县| 珲春市| 绥棱县| 万山特区| 肇州县| 尼木县| 通化县| 雷州市| 克拉玛依市| 出国| 青州市| 天全县| 稻城县| 安龙县| 长阳| 松桃| 肃北| 固原市| 双江| 澄城县| 西充县| 隆昌县| 个旧市| 红安县| 闽侯县| 黄骅市| 香格里拉县| 台北市| 郴州市| 中阳县| 增城市| 漳浦县|