《利用RMAN将数据库从文件系统迁移到ASM》由会员分享,可在线阅读,更多相关《利用RMAN将数据库从文件系统迁移到ASM(9页珍藏版)》请在金锄头文库上搜索。
1、ASMoracleASM $ echo $ORACLE_SID+ASMoracleASM $ sqlplus /nologSQL*Plus: Release 10.2.0.1.0 - Production on Mon Apr 6 01:01:28 2009Copyright (c) 1982, 2005, Oracle. All rights reserved.SQL conn / as sysdbaConnected to an idle instance.SQL startupASM instance startedTotal System Global Area 79691776 by
2、tesFixed Size 1217812 bytesVariable Size 53308140 bytesASM Cache 25165824 bytesASM diskgroups mountedSQL select name,state from v$asm_diskgroup;NAME STATE- -DATA MOUNTEDDGROUP1 MOUNTED(TOASM)SPFILESQL ALTER SYSTEM SET CONTROL_FILES=+DGROUP1 SCOPE=SPFILE;System altered.SQL ALTER SYSTEM SET DB_CREATE_
3、FILE_DEST=+DGROUP1 SCOPE=SPFILE;System altered.SQL SHUTDOWN IMMEDIATEDatabase closed.Database dismounted.ORACLE instance shut down.RMANNOMOUNToracleASM admin$ rman target /Recovery Manager: Release 10.2.0.1.0 - Production on Mon Apr 6 01:06:39 2009Copyright (c) 1982, 2005, Oracle. All rights reserve
4、d.connected to target database (not started)RMAN startup nomountOracle instance startedTotal System Global Area 230686720 bytesFixed Size 1218676 bytesVariable Size 75499404 bytesDatabase Buffers 150994944 bytesRedo Buffers 2973696 bytesRMAN-ASM,MOUNTRMAN RESTORE CONTROLFILE FROM /u01/oradata/TOASM/
5、control01.ctl;Starting restore at 06-APR-09using target database control file instead of recovery catalogallocated channel: ORA_DISK_1channel ORA_DISK_1: sid=155 devtype=DISKchannel ORA_DISK_1: copied control file copyoutput filename=+DGROUP1/toasm/controlfile/backup.269.683428107Finished restore at
6、 06-APR-09RMAN ALTER DATABASE MOUNT;database mountedreleased channel: ORA_DISK_1RMANRMANASMRMAN BACKUP AS COPY DATABASE FORMAT +DGROUP1;Starting backup at 06-APR-09allocated channel: ORA_DISK_1channel ORA_DISK_1: sid=155 devtype=DISKchannel ORA_DISK_1: starting datafile copyinput datafile fno=00001
7、name=/u01/oradata/TOASM/system01.dbfoutput filename=+DGROUP1/toasm/datafile/system.258.683428337 tag=TAG20090406T011215 recid=2 stamp=683428412channel ORA_DISK_1: datafile copy complete, elapsed time: 00:01:25channel ORA_DISK_1: starting datafile copyinput datafile fno=00003 name=/u01/oradata/TOASM/
8、sysaux01.dbfoutput filename=+DGROUP1/toasm/datafile/sysaux.259.683428421 tag=TAG20090406T011215 recid=3 stamp=683428457channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:45channel ORA_DISK_1: starting datafile copyinput datafile fno=00005 name=/u01/oradata/TOASM/example01.dbfoutput file
9、name=+DGROUP1/toasm/datafile/example.261.683428467 tag=TAG20090406T011215 recid=4 stamp=683428481channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15channel ORA_DISK_1: starting datafile copyinput datafile fno=00002 name=/u01/oradata/TOASM/undotbs01.dbfoutput filename=+DGROUP1/toasm/da
10、tafile/undotbs1.260.683428483 tag=TAG20090406T011215 recid=5 stamp=683428486channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07channel ORA_DISK_1: starting datafile copyinput datafile fno=00004 name=/u01/oradata/TOASM/users01.dbfoutput filename=+DGROUP1/toasm/datafile/users.262.683428
11、489 tag=TAG20090406T011215 recid=6 stamp=683428491channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03channel ORA_DISK_1: starting datafile copycopying current control fileoutput filename=+DGROUP1/toasm/controlfile/backup.278.683428493 tag=TAG20090406T011215 recid=7 stamp=683428495chan
12、nel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03channel ORA_DISK_1: starting full datafile backupsetchannel ORA_DISK_1: specifying datafile(s) in backupsetincluding current SPFILE in backupsetchannel ORA_DISK_1: starting piece 1 at 06-APR-09channel ORA_DISK_1: finished piece 1 at 06-AP
13、R-09piece handle=+DGROUP1/toasm/backupset/2009_04_06/nnsnf0_tag20090406t011215_0.277.683428497 tag=TAG20090406T011215 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:05Finished backup at 06-APR-09RMANRMANSWITCH RMAN SWITCH DATABASE TO COPY;datafile 1 switched to datafile copy +DGROUP1/toasm/datafile/system.258.683428337datafile 2 switched to datafile copy +DGROUP1/toasm/datafile/undotbs1.260.683428483datafile 3 switched to datafile copy +DGROUP1/toasm/datafile/s