利用RMAN转化非ASM数据文件为ASMOracle认证考试

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

"mkhgigh">

　　[oracle@ASM ~]$ rman target /

　　Recovery Manager: Release 10.2.0.1.0 - Production on Mon Apr 6 01:55:54 2009

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

　　connected to target database: TOASM (DBID=1511021326)

　　RMAN>. report schema.

　　using target database control file instead of recovery catalog

　　Report of database schema

　　List of Permanent Datafiles

　　===========================

　　File Size(MB) Tablespace RB segs Datafile Name

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

　　1 480 SYSTEM *** DGROUP1/toasm/datafile/system.258.683428337

　　2 25 UNDOTBS1 *** DGROUP1/toasm/datafile/undotbs1.260.683428483

　　3 230 SYSAUX *** DGROUP1/toasm/datafile/sysaux.259.683428421

　　4 5 USERS *** DGROUP1/toasm/datafile/users.262.683428489

　　5 100 EXAMPLE *** DGROUP1/toasm/datafile/example.261.683428467

　　6 10 USERS *** /u01/oradata/TOASM/users02.dbf

　　List of Temporary Files

　　=======================

　　File Size(MB) Tablespace Maxsize(MB) Tempfile Name

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

　　2 100 TEMP 32767 DGROUP1/toasm/tempfile/temp.263.683428909

　　RMAN>. SQL ALTER DATABASE DATAFILE 6 OFFLINE.

　　sql statement: ALTER DATABASE DATAFILE 6 OFFLINE

　　RMAN>. BACKUP AS COPY DATAFILE 6 FORMAT DGROUP1.

　　Starting backup at 06-APR-09

　　allocated channel: ORA_DISK_1

　　channel ORA_DISK_1: sid=138 devtype=DISK

　　channel ORA_DISK_1: starting datafile copy

　　input datafile fno=00006 name=/u01/oradata/TOASM/users02.dbf