Oracle 11.2.0.4.0 RAC Using RMAN Recovery to Single Instance Database(七)
4.0 - Production on Fri Sep 20 05:21:15 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: ZWC (DBID=582474828, not open)
RMAN> run
2> {
3> set newname for datafile 1 to '/u01/app/oracle/oradata/zwc/system01.dbf';
4> set newname for datafile 2 to '/u01/app/oracle/oradata/zwc/sysaux01.dbf';
5> set newname for datafile 3 to '/u01/app/oracle/oradata/zwc/undotbs1.dbf';
6> set newname for datafile 4 to '/u01/app/oracle/oradata/zwc/users01.dbf';
7> set newname for datafile 5 to '/u01/app/oracle/oradata/zwc/example01.dbf';
8> set newname for datafile 6 to '/u01/app/oracle/oradata/zwc/undotbs2.dbf';
9> set newname for tempfile 1 to '/u01/app/oracle/oradate/zwc/temp01.dbf';
10> restore database;
11> switch datafile all;
12> switch tempfile all;
13> }
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting restore at 20-SEP-2013 05:26:11
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=20 device type=DISK
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to /u01/app/oracle/oradata/zwc/system01.dbf
channel ORA_DISK_1: restoring datafile 00002 to /u01/app/oracle/oradata/zwc/sysaux01.dbf
channel ORA_DISK_1: restoring datafile 00003 to /u01/app/oracle/oradata/zwc/undotbs1.dbf
channel ORA_DISK_1: restoring datafile 00004 to /u01/app/oracle/oradata/zwc/users01.dbf
channel ORA_DISK_1: restoring datafile 00005 to /u01/app/oracle/oradata/zwc/example01.dbf
channel ORA_DISK_1: restoring datafile 00006 to /u01/app/oracle/oradata/zwc/undotbs2.dbf
channel ORA_DISK_1: reading from backup piece /u01/app/oracle/bak/20130920_2_1_DAT
channel ORA_DISK_1: piece handle=/u01/app/oracle/bak/20130920_2_1_DAT tag=TAG20130920T124810
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:01:05
Finished restore at 20-SEP-2013 05:27:17
datafile 1 switched to datafile copy
input datafile copy RECID=8 STAMP=826608437 file name=/u01/app/oracle/oradata/zwc/system01.dbf
datafile 2 switched to datafile copy
input datafile copy RECID=9 STAMP=826608437 file name=/u01/app/oracle/oradata/zwc/sysaux01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=10 STAMP=826608437 file name=/u01/app/oracle/oradata/zwc/undotbs1.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=11 STAMP=826608437 file name=/u01/app/oracle/oradata/zwc/users01.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=12 STAMP=826608437 file name=/u01/app/oracle/oradata/zwc/example01.dbf
datafile 6 switched to datafile copy
input datafile copy RECID=13 STAMP=826608437 file name=/u01/app/oracle/oradata/zwc/undotbs2.dbf
renamed tempfile 1 to /u01/app/oracle/oradate/zwc/temp01.dbf in control file
RMAN>
[oracle@rmanrec ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Fri Sep 20 05:28:31 2013
Copyright (c) 1982