利用backup as copy将数据库迁移到其他文件系统

利用backup as copy将数据库迁移到其他文件系统或者asm环境

oracle@pri ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Sat Dec 10 02:55:25 2016

Copyright © 1982, 2013, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup mount
ORACLE instance started.

Total System Global Area 304807936 bytes
Fixed Size 2252744 bytes
Variable Size 167772216 bytes
Database Buffers 130023424 bytes
Redo Buffers 4759552 bytes
Database mounted.

[oracle@pri ~]$ rman target /

Recovery Manager: Release 11.2.0.4.0 - Production on Sat Dec 10 03:02:13 2016

Copyright © 1982, 2011, Oracle and/or its affiliates. All rights reserved.

connected to target database: PRODPRI (DBID=2010738349, not open)

RMAN> backup as copy database format ‘/oracle/oradata/oradata_%u.dbf’; // backup as copy database format '+data‘

Starting backup at 10-DEC-16
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=19 device type=DISK
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001 name=/u01/app/oradata/prodpri/system01.dbf
output file name=/oracle/oradata/oradata_05rn37ts.dbf tag=TAG20161210T030220 RECID=5 STAMP=930193347
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile copy
input datafile file number=00002 name=/u01/app/oradata/prodpri/sysaux01.dbf
output file name=/oracle/oradata/oradata_06rn37ub.dbf tag=TAG20161210T030220 RECID=6 STAMP=930193360
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting datafile copy
input datafile file number=00005 name=/u01/app/oradata/prodpri/example01.dbf
output file name=/oracle/oradata/oradata_07rn37ui.dbf tag=TAG20161210T030220 RECID=7 STAMP=930193365
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting datafile copy
input datafile file number=00003 name=/u01/app/oradata/prodpri/undotbs01.dbf
output file name=/oracle/oradata/oradata_08rn37ul.dbf tag=TAG20161210T030220 RECID=8 STAMP=930193366
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting datafile copy
copying current control file
output file name=/oracle/oradata/oradata_09rn37um.dbf tag=TAG20161210T030220 RECID=9 STAMP=930193367
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting datafile copy
input datafile file number=00004 name=/u01/app/oradata/prodpri/users01.dbf
output file name=/oracle/oradata/oradata_0arn37up.dbf tag=TAG20161210T030220 RECID=10 STAMP=930193369
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 10-DEC-16
channel ORA_DISK_1: finished piece 1 at 10-DEC-16
piece handle=/oracle/oradata/oradata_0brn37ur.dbf tag=TAG20161210T030220 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 10-DEC-16

RMAN> switch database to copy; (单独的数据文件switch：switch datafile 1 to copy)

datafile 1 switched to datafile copy “/oracle/oradata/oradata_05rn37ts.dbf”
datafile 2 switched to datafile copy “/oracle/oradata/oradata_06rn37ub.dbf”
datafile 3 switched to datafile copy “/oracle/oradata/oradata_08rn37ul.dbf”
datafile 4 switched to datafile copy “/oracle/oradata/oradata_0arn37up.dbf”
datafile 5 switched to datafile copy “/oracle/oradata/oradata_07rn37ui.dbf”

RMAN> alter database open;

database opened

[oracle@pri ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Sat Dec 10 03:04:26 2016

Copyright © 1982, 2013, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select name from v$datafile;

NAME

/oracle/oradata/oradata_05rn37ts.dbf
/oracle/oradata/oradata_06rn37ub.dbf
/oracle/oradata/oradata_08rn37ul.dbf
/oracle/oradata/oradata_0arn37up.dbf
/oracle/oradata/oradata_07rn37ui.dbf