首页 > 资讯 > 数据库 >oracle中数据fs到asm迁移的示例分析

152

分享到

oracle中数据fs到asm迁移的示例分析

2024-04-02 19:04:59 152人浏览薄情痞子

摘要

小编给大家分享一下oracle中数据fs到asm迁移的示例分析，相信大部分人都还不怎么了解，因此分享这篇文章给大家参考一下，希望大家阅读完这篇文章后大有收获，下面让我们一起去了解一下吧！（RedHat&nb

小编给大家分享一下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