Oracle辅导：数据库从文件系统迁移到ASM（1）

会计考友

一、打开ASM实例 　　[oracle@ASM ~]$ echo $ORACLE_SID
　　+ASM
　　[oracle@ASM ~]$ sqlplus /nolog
　　SQL*Plus: Release 10.2.0.1.0 - Production on Mon Apr 6 01:01:28 2009
　　Copyright (c) 1982, 2005, Oracle.  All rights reserved.
　　SQL> conn / as sysdba
; c# _1 \) \7 A7 X. Y　　Connected to an idle instance.
7 R1 X! F7 s3 k2 V1 t! G　　SQL> startup
& y- Q  a  j5 B" u1 u. k" i　　ASM instance started
　　Total System Global Area   79691776 bytes
　　Fixed Size                  1217812 bytes
0 a. l( I/ }3 g$ S( ]# H$ P' E　　Variable Size              53308140 bytes
　　ASM Cache                  25165824 bytes
　　ASM diskgroups mounted
" G6 M- G! V4 ?6 a, Y! M　　SQL> select name,state from v$asm_diskgroup;
6 B2 D  q  M- y  q. U, A- e　　NAME                           STATE
　　------------------------------ -----------
( e- A5 }. K- p! m  v6 C　　DATA                           MOUNTED
9 P% q  O) T/ q5 q! y+ t3 z　　DGROUP1                       MOUNTED
- _8 G/ q2 E& N. a4 q; I　　二、修改目标数据库(TOASM)的SPFILE
( A6 t# V' g: n' ~　　SQL> ALTER SYSTEM SET CONTROL_FILES='+DGROUP1'  SCOPE=SPFILE;
0 b" ~# |% ]) z　　System altered.
- Y) h" {: y, _( ?1 w　　SQL> ALTER SYSTEM SET DB_CREATE_FILE_DEST='+DGROUP1' SCOPE=SPFILE;
　　System altered.
' Z3 ?* t8 F5 U6 N0 B# ~8 g$ H　　三、关闭目标数据库
　　SQL> SHUTDOWN IMMEDIATE
　　Database closed.
9 n% ?& b. Z) ^7 S, q　　Database dismounted.
　　ORACLE instance shut down.
0 O9 q) u9 P/ g8 f6 b. s　　四、通过RMAN连接到目标数据库，并启动到NOMOUNT状态
　　[oracle@ASM admin]$ rman target /
5 v; P8 e% y1 v: C: ?　　Recovery Manager: Release 10.2.0.1.0 - Production on Mon Apr 6 01:06:39 2009
　　Copyright (c) 1982, 2005, Oracle.  All rights reserved.
　　connected to target database (not started)
- z4 r" Z0 u. M3 c　　RMAN> startup nomount
6 G! g2 |( B8 F　　Oracle instance started
　　Total System Global Area     230686720 bytes
　　Fixed Size                     1218676 bytes
) ]4 h$ W) s  |( W4 ^　　Variable Size                 75499404 bytes
# Q# C( }# _) k' e( v% P$ X　　Database Buffers             150994944 bytes
　　Redo Buffers                   2973696 bytes

( o3 m  \6 y7 z" n4 k　　RMAN>

会计考友

</p>　　五、还原控制文件到ASM磁盘组,并将数据库启动到MOUNT状态
: D( w7 I2 T4 O　　RMAN> RESTORE CONTROLFILE FROM '/u01/oradata/TOASM/control01.ctl';
; \. Q8 c$ ^& {5 F　　Starting restore at 06-APR-09
　　using target database control file instead of recovery catalog
% O) N1 x: t4 B" g, h+ s" n　　allocated channel: ORA_DISK_1
* S, m6 o7 y- G) U5 W　　channel ORA_DISK_1: sid=155 devtype=DISK
! I1 H; \9 i# e# M) ?7 B　　channel ORA_DISK_1: copied control file copy
　　output filename=+DGROUP1/toasm/controlfile/backup.269.683428107
7 W8 h1 }! Z& S  `3 P+ @' g　　Finished restore at 06-APR-09
, o, f+ E) j0 ~( s* S9 Q　　RMAN> ALTER DATABASE MOUNT;
　　database mounted
9 c' j) A7 D5 S- ?( m　　released channel: ORA_DISK_1
: D  s1 _6 s1 L/ d) k1 |4 x% z5 f! z　　RMAN>
* H, }  ?2 d2 ^8 Q" k/ {; T( F. ^4 F- n　　六、利用RMAN复制数据文件到ASM磁盘组
! L. I4 f6 U; g2 I0 ], X　　RMAN > BACKUP AS COPY DATABASE FORMAT '+DGROUP1';
7 R- b6 j* f' Y# I) y. W7 n+ Q9 Q　　Starting backup at 06-APR-09
6 [! u0 a- x& P3 V, \% s9 a8 `　　allocated channel: ORA_DISK_1
! I4 g2 g' z+ d, |  p; H. e- A　　channel ORA_DISK_1: sid=155 devtype=DISK
　　channel ORA_DISK_1: starting datafile copy
4 r3 w  d+ T4 p/ i% x- @4 v　　input datafile fno=00001 name=/u01/oradata/TOASM/system01.dbf
　　output filename=+DGROUP1/toasm/datafile/system.258.683428337 tag=TAG20090406T011215 recid=2 stamp=683428412
　　channel ORA_DISK_1: datafile copy complete, elapsed time: 00:01:25
　　channel ORA_DISK_1: starting datafile copy
　　input datafile fno=00003 name=/u01/oradata/TOASM/sysaux01.dbf
　　output filename=+DGROUP1/toasm/datafile/sysaux.259.683428421 tag=TAG20090406T011215 recid=3 stamp=683428457
　　channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:45
- t7 X& h& e' |- K6 Z, `& b　　channel ORA_DISK_1: starting datafile copy
　　input datafile fno=00005 name=/u01/oradata/TOASM/example01.dbf
8 p9 p7 t! t4 T+ i% |　　output filename=+DGROUP1/toasm/datafile/example.261.683428467 tag=TAG20090406T011215 recid=4 stamp=683428481
3 O' f1 ?/ D7 x( B& M  G0 l" r. e  l　　channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
9 u) T0 c7 f1 G2 M0 i　　channel ORA_DISK_1: starting datafile copy
　　input datafile fno=00002 name=/u01/oradata/TOASM/undotbs01.dbf
　　output filename=+DGROUP1/toasm/datafile/undotbs1.260.683428483 tag=TAG20090406T011215 recid=5 stamp=683428486
　　channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
　　channel ORA_DISK_1: starting datafile copy
　　input datafile fno=00004 name=/u01/oradata/TOASM/users01.dbf
　　output filename=+DGROUP1/toasm/datafile/users.262.683428489 tag=TAG20090406T011215 recid=6 stamp=683428491
　　channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
　　channel ORA_DISK_1: starting datafile copy
　　copying current control file
　　output filename=+DGROUP1/toasm/controlfile/backup.278.683428493 tag=TAG20090406T011215 recid=7 stamp=683428495
　　channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
　　channel ORA_DISK_1: starting full datafile backupset
　　channel ORA_DISK_1: specifying datafile(s) in backupset
- E3 E" ?4 f' b" p& d& R: q2 L　　including current SPFILE in backupset
　　channel ORA_DISK_1: starting piece 1 at 06-APR-09
6 u9 E; u" v6 X' d　　channel ORA_DISK_1: finished piece 1 at 06-APR-09
' l2 M# ?7 c% E9 j, W" W9 K( s2 V) R6 a$ L　　piece handle=+DGROUP1/toasm/backupset/2009_04_06/nnsnf0_tag20090406t011215_0.277.683428497 tag=TAG20090406T011215 comment=NONE
* G4 {, C2 ~: `/ U. K: ]* C　　channel ORA_DISK_1: backup set complete, elapsed time: 00:00:05
　　Finished backup at 06-APR-09
　　RMAN>
　　七、利用RMAN的SWITCH 命令修改控制文件内数据文件的指针，使其指向新位置。
5 V* P* n8 R" R　　RMAN> SWITCH DATABASE TO COPY;
7 Z+ p1 E# k! y　　datafile 1 switched to datafile copy "+DGROUP1/toasm/datafile/system.258.683428337"
/ h; s! E' l# i# i+ o  G1 d9 s　　datafile 2 switched to datafile copy "+DGROUP1/toasm/datafile/undotbs1.260.683428483"
% G6 y+ n( t' U7 P& y8 v9 c* k　　datafile 3 switched to datafile copy "+DGROUP1/toasm/datafile/sysaux.259.683428421"
9 ^) L& b1 e; S2 E4 l( b　　datafile 4 switched to datafile copy "+DGROUP1/toasm/datafile/users.262.683428489"
　　datafile 5 switched to datafile copy "+DGROUP1/toasm/datafile/example.261.683428467"
; X) J, f0 I' a' J* K2 |　　RMAN> RECOVER DATABASE;
　　Starting recover at 06-APR-09
8 _1 g2 `% }$ C1 S! B( R: Q- L2 D0 |+ D; R　　using channel ORA_DISK_1
　　starting media recovery
/ I) |# w! `) P% O8 M; P" e　　media recovery complete, elapsed time: 00:00:00
# {* h& M" _  d& v. {, Y9 M3 M　　Finished recover at 06-APR-09
　　RMAN>