利用RMAN将数据库从文件系统迁移到ASMOracle认证考试

文章作者 100test 发表时间 2009:12:11 18:09:50
来源 100Test.Com百考试题网

"tbbnc">

　　一、打开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

　　Connected to an idle instance.

　　SQL>. startup

　　ASM instance started

　　Total System Global Area 79691776 bytes

　　Fixed Size 1217812 bytes

　　Variable Size 53308140 bytes

　　ASM Cache 25165824 bytes

　　ASM diskgroups mounted

　　SQL>. 0select name,state from v$asm_diskgroup.

　　NAME STATE

　　------------------------------ -----------

　　DATA MOUNTED

　　DGROUP1 MOUNTED

　　二、修改目标数据库(TOASM)的SPFILE

　　SQL>. ALTER SYSTEM SET CONTROL_FILES= DGROUP1 SCOPE=SPFILE.

　　System altered.

　　SQL>. ALTER SYSTEM SET DB_CREATE_FILE_DEST= DGROUP1 SCOPE=SPFILE.

　　System altered.

　　三、关闭目标数据库

　　SQL>. SHUTDOWN IMMEDIATE

　　Database closed.

　　Database dismounted.

　　ORACLE instance shut down.

　　四、通过RMAN连接到目标数据库，并启动到NOMOUNT状态

　　[oracle@ASM admin]$ rman target /

　　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)

　　RMAN>. startup nomount

　　Oracle instance started

　　Total System Global Area 230686720 bytes

　　Fixed Size 1218676 bytes

　　Variable Size 75499404 bytes

　　Database Buffers 150994944 bytes

　　Redo Buffers 2973696 bytes

　　RMAN>.

　　五、还原控制文件到ASM磁盘组,并将数据库启动到MOUNT状态

　　RMAN>. RESTORE CONTROLFILE FROM /u01/oradata/TOASM/control01.ctl.

　　Starting restore at 06-APR-09

　　using target database control file instead of recovery catalog

　　allocated channel: ORA_DISK_1

　　channel ORA_DISK_1: sid=155 devtype=DISK

　　channel ORA_DISK_1: copied control file copy

　　output filename= DGROUP1/toasm/controlfile/backup.269.683428107

　　Finished restore at 06-APR-09

　　RMAN>. ALTER DATABASE MOUNT.

　　database mounted

　　released channel: ORA_DISK_1

　　RMAN>.