AIX ORACLE 迁移到ASM

1.准备2块磁盘:hdisk1、hdisk2

2.创建一个vg,加入2块磁盘:smitty mkvg

3.划分2个lv：

# mklv -t jfs2 -y asmlv softvg 200

asmlv

# mklv -t jfs2 -y recoverylv softvg 100;

recoverylv

4.创建asm的pfile. $ORACLE_HOME/dbs/init+ASM.ora

*.background_dump_dest='/u01/oracle/admin/+ASM/bdump' *.core_dump_dest='/u01//oracle/admin/+ASM/cdump' *.user_dump_dest='/u01/oracle/admin/+ASM/udump' *.asm_diskstring='/dev/rasmlv','/dev/rrecoverylv' *.instance_type='asm' *.large_pool_size=12M *.remote_login_passwordfile='exclusive'

5.修改lv所属权限

# chown oracle:dba /dev/rasmlv # chown oracle:dba /dev/rrecoverylv

6.创建密码文件

orapwd file=orapw+ASM password=oracle

7.创建admin目录

oracle@database$mkdir -p /u01/oracle/admin/+ASM/udump oracle@database$mkdir -p /u01/oracle/admin/+ASM/bdump oracle@database$mkdir -p /u01/oracle/admin/+ASM/cdump

8.启动css进程

SQL> startup

ORA-29701: unable to connect to Cluster Manager

# /u01/oracle/product/10.2.0.1/db_1/bin/localconfig add /etc/oracle does not exist. Creating it now. Successfully accumulated necessary OCR keys. Creating OCR keys for user 'root', privgrp 'system'.. Operation successful. Configuration for local CSS has been initialized   Adding to inittab Startup will be queued to init within 30 seconds. Checking the status of new Oracle init process... Expecting the CRS daemons to be up within 600 seconds. CSS is active on these nodes.         database CSS is active on all nodes. Oracle CSS service is installed and running under init(1M) #

9.启动ASM .startup

SQL> startup ASM instance started   Total System Global Area  130023424 bytes Fixed Size                  2019136 bytes Variable Size             102838464 bytes ASM Cache                  25165824 bytes ORA-15110: no diskgroups mounted

10.创建asm diskgroup :DATA、RECOVERY

SQL> create diskgroup DATA external redundancy disk '/dev/rasmlv'; Diskgroup created. SQL> create diskgroup RECOVERY external redundancy disk '/dev/rrecoverylv'; Diskgroup created. SQL> select name,state from v$asm_diskgroup;   NAME       STATE ---------- ---------------------- DATA       MOUNTED RECOVERY   MOUNTED

 

已经挂载了。就不用再挂载了

11.测试asm

SQL> create tablespace test datafile '+DATA' size 10m; Tablespace created. ASMCMD [+data/gs/datafile] > ls -l Type      Redund  Striped  Time             Sys  Name DATAFILE  UNPROT  COARSE   DEC 09 14:00:00  Y    TEST.256.769442671 ASMCMD [+data/gs/datafile] > SQL> drop tablespace test including contents and datafiles; Tablespace dropped.

 

12.更改controlfiles、归档 等参数

SQL> alter system set control_files='+DATA' scope=spfile; System altered. SQL> alter system set db_recovery_file_dest='+RECOVERY';  System altered. SQL> alter system set db_create_file_dest='+DATA'; System altered.

13. 复制database到 +DATA

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

14.启动到mount切换asm

RMAN> switch database to copy;   datafile 1 switched to datafile copy "+DATA/gs/datafile/system.260.769444077" datafile 2 switched to datafile copy "+DATA/gs/datafile/undotbs1.266.769444157" datafile 3 switched to datafile copy "+DATA/gs/datafile/sysaux.261.769444103" datafile 4 switched to datafile copy "+DATA/gs/datafile/users.267.769444165" datafile 5 switched to datafile copy "+DATA/gs/datafile/aomeidb.262.769444129" datafile 6 switched to datafile copy "+DATA/gs/datafile/tbivr.263.769444135" datafile 7 switched to datafile copy "+DATA/gs/datafile/dlbshop.264.769444143" datafile 8 switched to datafile copy "+DATA/gs/datafile/gsdlb.259.769444013" datafile 9 switched to datafile copy "+DATA/gs/datafile/mcdb.265.769444149" RMAN> recover database; Starting recover at 09-DEC-11 allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=152 devtype=DISK starting media recovery media recovery complete, elapsed time: 00:00:05 Finished recover at 09-DEC-11 RMAN> alter database open; database opened

15.切换temp

SQL> select name ,status from v$tempfile; NAME                                STATUS ----------------------------------- ------- /u01/oracle/oradata/gs/temp.dbf     ONLINE SQL> alter tablespace temp add tempfile '+DATA' size 512m; Tablespace altered. SQL> alter tablespace temp drop tempfile '/u01/oracle/oradata/gs/temp.dbf'; Tablespace altered.

16.切换redo log

SQL> select member from v$logfile; MEMBER ---------------------------------------- /u01/oracle/oradata/gs/redo03.log /u01/oracle/oradata/gs/redo02.log /u01/oracle/oradata/gs/redo01.log   SQL> alter database add logfile '+DATA' size 100m; Database altered. SQL> alter database add logfile '+DATA' size 100m; Database altered. SQL> alter database add logfile '+DATA' size 100m; Database altered.   SQL> alter system switch logfile; System altered. SQL> select group#,status from v$log;       GROUP# STATUS ---------- ----------------          1 CURRENT          2 INACTIVE          3 INACTIVE          4 UNUSED          5 UNUSED          6 UNUSED --等group＃ 1、2、3变为INACTIVE就删除   SQL> alter database drop logfile '/u01/oracle/oradata/gs/redo02.log'; Database altered. SQL>  alter database drop logfile '/u01/oracle/oradata/gs/redo03.log'; Database altered. SQL> alter database drop logfile '/u01/oracle/oradata/gs/redo01.log'; Database altered.

再删除/u01/oracle/oradata下面文件就ok

转载于:https://www.cnblogs.com/huangjingzhou/articles/2282028.html