oracle中數據fs到asm遷移的示例分析

132次閱讀

沒有評論

共計 10388 個字符，預計需要花費 26 分鐘才能閱讀完成。

丸趣 TV 小編給大家分享一下 oracle 中數據 fs 到 asm 遷移的示例分析，相信大部分人都還不怎么了解，因此分享這篇文章給大家參考一下，希望大家閱讀完這篇文章后大有收獲，下面讓我們一起去了解一下吧！

（RedHat 10g Oracle 環境）

1、配置 Oracle Cluster Synchronization（CSS）

要想使用 ASM，必須先配置并啟動 CSS

[root@redhat10g ~]# cd /u01/app/oracle/product/10.2.0/db_1/bin

[root@redhat10g bin]# ./localconfig add

2、配置 Automatic Storage Management（ASM）實例參數

[oracle@aix201 ~]$vi /u01/app/oracle/product/10.2.0/db_1/dbs/init+ASM.ora

instance_type= asm

asm_diskstring= /dev/mapper/asmvg-*

asm_diskgroups= DG1 , RCY1

large_pool_size=12m

background_dump_dest=/u01/app/oracle/product/10.2.0/db_1/admin/+ASM/bdump

core_dump_dest=/u01/app/oracle/product/10.2.0/db_1/admin/+ASM/cdump

user_dump_dest=/u01/app/oracle/product/10.2.0/db_1/admin/+ASM/udump

3、啟動 asm 實例

[oracle@redhat10g ~]$ export ORACLE_SID=+ASM

[oracle@redhat10g ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 – Production on Sun Jun 29 17:04:44 2014

Connected to an idle instance.

SQL startup

ASM instance started

Total System Global Area 83886080 bytes

Fixed Size 1217836 bytes

Variable Size 57502420 bytes

ASM Cache 25165824 bytes

4、創建裸設備，修改用戶和權限

1）添加磁盤；

2）為磁盤分區：

[root@redhat10g ~]# fdisk /dev/sdb

Device Boot Start End Blocks Id System

/dev/sdb1 1 2610 20964793+ 83 Linux

3）創建物理卷（pv）：

[root@redhat10g ~]# pvcreate /dev/sdb1

/dev/cdrom: open failed: Read-only file system

Attempt to close device /dev/cdrom which is not open.

Physical volume /dev/sdb1 successfully created

查看 pv 的信息：

4）創建卷組：

[root@redhat10g ~]# vgcreate asmvg /dev/sdb1

5）創建邏輯卷 lv：

[root@redhat10g ~]# lvcreate -n datalv1 -L 5gb asmvg

/dev/cdrom: open failed: Read-only file system

Logical volume datalv1 created

[root@redhat10g ~]# lvcreate -n datalv2 -L 5gb asmvg

/dev/cdrom: open failed: Read-only file system

Logical volume datalv2 created

[root@redhat10g ~]# lvcreate -n ocrdisklv1 -L 4.5gb asmvg

/dev/cdrom: open failed: Read-only file system

Logical volume ocrdisklv1 created

[root@redhat10g ~]# lvcreate -n ocrdisklv2 -L 4.5gb asmvg

/dev/cdrom: open failed: Read-only file system

Logical volume ocrdisklv2 created

6）綁定裸設備：

[root@redhat10g ~]# raw /dev/raw/raw1 /dev/mapper/asmvg-datalv1

/dev/raw/raw1: bound to major 253, minor 2

[root@redhat10g ~]# raw /dev/raw/raw2 /dev/mapper/asmvg-datalv2

/dev/raw/raw2: bound to major 253, minor 3

[root@redhat10g ~]# raw /dev/raw/raw3 /dev/mapper/asmvg-

asmvg-datalv1 asmvg-datalv2 asmvg-ocrdisklv1 asmvg-ocrdisklv2

[root@redhat10g ~]# raw /dev/raw/raw3 /dev/mapper/asmvg-ocrdisklv1

/dev/raw/raw3: bound to major 253, minor 4

[root@redhat10g ~]# raw /dev/raw/raw4 /dev/mapper/asmvg-ocrdisklv2

/dev/raw/raw4: bound to major 253, minor 5

服務器啟動自動掛載裸設備：

[root@redhat10g ~]# vi /etc/sysconfig/rawdevices

/dev/raw/raw1 /dev/mapper/asmvg-datalv1

/dev/raw/raw2 /dev/mapper/asmvg-datalv2

/dev/raw/raw3 /dev/mapper/asmvg-ocrdisk1

/dev/raw/raw4 /dev/mapper/asmvg-ocrdisk2

重啟服務驗證能否掛載：

[root@redhat10g ~]# service rawdevices restart

Assigning devices:

/dev/raw/raw1 — /dev/mapper/asmvg-datalv1

/dev/raw/raw1: bound to major 253, minor 2

/dev/raw/raw2 — /dev/mapper/asmvg-datalv2

/dev/raw/raw2: bound to major 253, minor 3

/dev/raw/raw3 — /dev/mapper/asmvg-ocrdisklv1

/dev/raw/raw3: bound to major 253, minor 4

/dev/raw/raw4 — /dev/mapper/asmvg-ocrdisklv2

/dev/raw/raw4: bound to major 253, minor 5

7）修改設備屬性：

[root@redhat10g raw]# chown -R oracle:oinstall /dev/raw/raw1

[root@redhat10g raw]# chown -R oracle:oinstall /dev/raw/raw2

[root@redhat10g raw]# chown -R oracle:oinstall /dev/raw/raw3

[root@redhat10g raw]# chown -R oracle:oinstall /dev/raw/raw4

[root@redhat10g ~]# chown -R oracle:oinstall /dev/mapper/asmvg-datalv1

[root@redhat10g ~]# chown -R oracle:oinstall /dev/mapper/asmvg-datalv2

[root@redhat10g ~]# chown -R oracle:oinstall /dev/mapper/asmvg-ocrdisklv1

[root@redhat10g ~]# chown -R oracle:oinstall /dev/mapper/asmvg-ocrdisklv2

5、創建 ASM 磁盤組

為了能使 ASM 啟動時，自動掛載磁盤和磁盤組，將下邊的參數添加到初始化文件中：

asm_diskstring= /dev/mapper/asmvg-*

asm_diskgroups= DG1 , RCY1

6、修改參數：

SQL alter system set db_create_file_dest= +dg1 scope=spfile;

System altered.

SQL alter system set control_files= +dg1 scope=spfile;

System altered.

7、轉儲控制文件

RMAN shutdown immediate;

using target database control file instead of recovery catalog

database closed

database dismounted

Oracle instance shut down

RMAN startup nomount;

connected to target database (not started)

Oracle instance started

Total System Global Area 1258291200 bytes

Fixed Size 1219160 bytes

Variable Size 318768552 bytes

Database Buffers 922746880 bytes

Redo Buffers 15556608 bytes

RMAN restore controlfile from /u01/app/oracle/oradata/prod/control01.ctl

Starting restore at 29-JUN-14

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=156 devtype=DISK

channel ORA_DISK_1: copied control file copy

output filename=+DG1/prod/controlfile/backup.256.851554395

Finished restore at 29-JUN-14

8、轉儲數據文件

RMAN alter database mount;

database mounted

released channel: ORA_DISK_1

RMAN backup as copy database format +dg1

Starting backup at 29-JUN-14

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=156 devtype=DISK