AS4 10g 单节点迁移到ASM RAC步骤总结

最新推荐文章于 2024-04-21 19:06:26 发布

tw214227

最新推荐文章于 2024-04-21 19:06:26 发布

阅读量404

点赞数

分类专栏： Oracle RAC 文章标签： oracle database disk system installer file

Oracle RAC 专栏收录该内容

7 篇文章 0 订阅

订阅专栏

AS4上迁移单实例节点到RAC

迁移过程大概记录：

1.准备sharedisk

准备两块共享磁盘，一块用于ocr vdisk，一块用于ASM

2.为ASM 建立vg lv raw

NODE 1:

a.建立分区（linux 因为LV 的raw 会覆盖cylinders 0 ，而分区默认是从cylinders 1开始，所以要用分区）:

fdisk ，主节点先分区，第二个节点直接fdisk w写入就行

b.绑定RAW:

绑定参数加入配置文件：

[root@pri ~]# vi /etc/sysc
sysconfig/ sysctl.conf
[root@pri ~]# vi /etc/sysconfig/rawdevices

# This file and interface are deprecated.
# Applications needing raw device access should open regular
# block devices with O_DIRECT.
# raw device bindings
# format: <rawdev> <major> <minor>
# <rawdev> <blockdev>
# example: /dev/raw/raw1 /dev/sda1
# /dev/raw/raw2 8 5
/dev/raw/raw1 253 2
/dev/raw/raw2 /dev/sdc1
/dev/raw/raw3 /dev/sdc3

"/etc/sysconfig/rawdevices" 11L, 347C written

c.重启服务生效
[root@pri ~]# service rawdevices restart
Assigning devices:
           /dev/raw/raw1 -->   253 2
/dev/raw/raw1: bound to major 253, minor 2
           /dev/raw/raw2 -->   /dev/sdc1
/dev/raw/raw2: bound to major 8, minor 33
           /dev/raw/raw3 -->   /dev/sdc3
/dev/raw/raw3: bound to major 8, minor 35

d.修改RAW权限：

[root@pri ~]# chown oracle:dba /dev/raw/raw*
[root@pri ~]# ll /dev/raw/raw*
crw-rw---- 1 oracle dba 162, 1 Jul 17 22:16 /dev/raw/raw1
crw-rw---- 1 oracle dba 162, 2 Jul 17 23:42 /dev/raw/raw2
crw-rw---- 1 oracle dba 162, 3 Jul 17 23:42 /dev/raw/raw3

e.用久修改权限文件，防止重启后失效：

[root@pri ~]# vi /etc/udev/permissions.d/50-udev.permissions
找到这一行，修改成：

# raw devices
ram*:oracle:disk:0660
raw/*:oracle:disk:0660

NODE 2:
root@standby ~]# vgscan
Reading all physical volumes. This may take a while...
Found volume group "oraclevg" using metadata type lvm2
Found volume group "VolGroup00" using metadata type lvm2
[root@standby ~]# vgdisplay -v oraclevg

激活scan到的VG
[root@standby ~]# vgchange -a y oraclevg

其余步骤参照NODE 1中的b.---e.

3.建立ASM 实例

On the first node, create an init+ASM1A.ora file in $ORACLE_HOME/dbs with the following parameters:

vi init+ASM1A.ora

asm_diskstring='/dev/raw/raw*'
background_dump_dest=/oracle/admin/+ASM/bdump
core_dump_dest=/oracle/admin/+ASM/cdump
user_dump_dest=/oracle/admin/+ASM/udump
instance_type=asm
large_pool_size=16M
remote_login_passwordfile=exclusive
+ASM1A.instance_number=1
+ASM1B.instance_number=2

4.Create ASM password file.
Using the orapwd utility, create an orapw+ASM1A file in $ORACLE_HOME/dbs on the first node.

[oracle@salmon1]$ cd $ORACLE_HOME/dbs
[oracle@salmon1]$ orapwd file=orapw+ASM1A password=sys entries=5

5.Create the first ASM instance.
Create the first ASM instance on the first node. The second ASM instance will be created in Post Installation after the CRS

software is installed on the second node.

[oracle@salmon1]$ export ORACLE_SID=+ASM1A
[oracle@salmon1]$ sqlplus / as sysdba

SQL*Plus: Release 10.1.0.3.0 - Production on Thu May 26 05:51:07 2005

Copyright (c) 1982, 2004, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 104857600 bytes
Fixed Size                777616 bytes
Variable Size             104079964 bytes
Database Buffers          0 bytes
Redo Buffers              0 bytes
ORA-15110: no diskgroups mounted

6. Create the ASM instance spfile.
Create a spfile immediately after the ASM instance starts. With spfile, any newly created disk groups are automatically

added to the spfile.

SQL> create spfile from pfile;

File created.

7. Create disk groups.

CREATE DISK GRROUP DATA EXTERNAL REDUNDANCY DISK '/dev/raw/raw1'

8.Migrate data files to ASM.

You must use RMAN to migrate the data files to ASM disk groups. All data files will be migrated to the newly created disk

group, DG1. The redo logs and control files are created in DG1 and DG2. In a production environment, you should store redo

logs on different set of disks and disk controllers from the rest of the Oracle data files.

[oracle@pri dbs]$export ORALCE_SID=test
[oracle@pri dbs]$sqlplus '/as sysdba'

SQL> alter system set db_create_file_dest=’+DG1’;

System altered.

SQL> alter system set control_files='+DG1/cf1.dbf' scope=spfile;

System altered.

SQL> shutdown immediate;

[oracle@pri dbs]$

[oracle@pri ~]$ rman target /

RMAN> startup nomount;

Oracle instance started

Total System Global Area 524288000 bytes

Fixed Size                     1268460 bytes
Variable Size                146801940 bytes
Database Buffers             373293056 bytes
Redo Buffers                   2924544 bytes

RMAN> restore controlfile from '/oracle/oradata/test/control01.ctl'

RMAN> restore controlfile from '/oracle/oradata/test/control01.ctl';

Starting restore at 17-7月 -09
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=321 devtype=DISK

channel ORA_DISK_1: copied control file copy
output filename=+DATA/control01.ctl
Finished restore at 17-7月 -09

RMAN>
RMAN>
RMAN> alter database mount;

database mounted
released channel: ORA_DISK_1

RMAN> backup as copy database format '+DATA';

Starting backup at 17-7月 -09
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=321 devtype=DISK
channel ORA_DISK_1: starting datafile copy
input datafile fno=00001 name=/oracle/oradata/test/system01.dbf
output filename=+DATA/test/datafile/system.257.692491979 tag=TAG20090717T225226 recid=4 stamp=692492102
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:02:37
channel ORA_DISK_1: starting datafile copy
input datafile fno=00003 name=/oracle/oradata/test/sysaux01.dbf
output filename=+DATA/test/datafile/sysaux.258.692492119 tag=TAG20090717T225226 recid=5 stamp=692492208
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:01:46
channel ORA_DISK_1: starting datafile copy
input datafile fno=00002 name=/oracle/oradata/test/undotbs01.dbf
output filename=+DATA/test/datafile/undotbs1.259.692492223 tag=TAG20090717T225226 recid=6 stamp=692492266
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:01:06
channel ORA_DISK_1: starting datafile copy
input datafile fno=00009 name=/oracle/oradata/usertmp01.dbf
output filename=+DATA/test/datafile/userstmp.260.692492289 tag=TAG20090717T225226 recid=7 stamp=692492300
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25
Finished backup at 17-7月 -09

RMAN> switch database to copy;

datafile 1 switched to datafile copy "+DATA/test/datafile/system.257.692491979"
datafile 2 switched to datafile copy "+DATA/test/datafile/undotbs1.259.692492223"
datafile 3 switched to datafile copy "+DATA/test/datafile/sysaux.258.692492119"
datafile 9 switched to datafile copy "+DATA/test/datafile/userstmp.260.692492289"

RMAN> alter database open;

database opened

RMAN> exit

[oracle@pri ~]$ sqlplus '/as sysdba'

SQL*Plus: Release 10.2.0.4.0 - Production on 星期五 7月 17 23:04:28 2009

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, Data Mining and Real Application Testing options

SQL>select tablespace_name, file_name from dba_data_files;

TABLESPACE_NAME FILE_NAME
--------------- --------------------------------------------------------------------------------
SYSAUX          +DATA/test/datafile/sysaux.258.692492119
UNDOTBS1        +DATA/test/datafile/undotbs1.259.692492223
SYSTEM          +DATA/test/datafile/system.257.692491979
USERSTMP        +DATA/test/datafile/userstmp.260.692492289

9.Migrate temp tablespace to ASM.

SQL> alter tablespace temp add tempfile size 100M;

Tablespace altered.

SQL> select file_name from dba_temp_files;

FILE_NAME
--------------------------------------------------------------------------------
+DATA/test/tempfile/temp.261.692493003
/oracle/oradata/test/temp01.dbf

10.Migrate redo logs to ASM.

Drop existing redo logs and recreate them in ASM disk groups

SQL> select group#, members,status from v$log;

    GROUP#    MEMBERS STATUS
---------- ---------- ----------------
         1          2 INACTIVE
         2          2 INACTIVE
         3          2 CURRENT

SQL> select group#, members,status from v$log;

    GROUP#    MEMBERS STATUS
---------- ---------- ----------------
         1          2 INACTIVE
         2          2 INACTIVE
         3          2 CURRENT

SQL> alter database drop logfile group 1;

Database altered.

SQL> alter database add logfile group 1 size 50m;

Database altered.

SQL> alter database drop logfile group 2;

Database altered.

SQL> alter database add logfile group 2 size 50m;

Database altered.

SQL> alter system switch logfile;

System altered.

SQL> alter system switch logfile;

System altered.

SQL> select group#, members,status from v$log;