Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: DBSERVER (DBID=66428446)
connected to auxiliary database: DBSERVER (not mounted)
RMAN> run{
2> allocate auxiliary channel c1 type disk;
3> duplicate target database for standby nofilenamecheck;
4> release channel c1;
5> }
using target database control file instead of recovery catalog
allocated channel: c1
channel c1: sid=540 devtype=DISK
Starting Duplicate Db at 13-FEB-14
contents of Memory Script:
{
restore clone standby controlfile;
sql clone 'alter database mount standby database';
}
executing Memory Script
Starting restore at 13-FEB-14
channel c1: restoring control file
channel c1: copied control file copy
input filename=/u01/app/oracle/standby.ctl
output filename=/u01/app/oracle/standby.ctl
Finished restore at 13-FEB-14
sql statement: alter database mount standby database
contents of Memory Script:
{
set newname for tempfile 2 to
"/u01/app/oracle/oradata/standby/temptbs01.dbf";
switch clone tempfile all;
set newname for datafile 1 to
"/u01/app/oracle/oradata/standby/system01.dbf";
set newname for datafile 2 to
"/u01/app/oracle/oradata/standby/undotbs01.dbf";
set newname for datafile 3 to
"/u01/app/oracle/oradata/standby/sysaux01.dbf";
set newname for datafile 4 to
"/u01/app/oracle/oradata/standby/users01.dbf";
set newname for datafile 5 to
"/u01/app/oracle/oradata/standby/example01.dbf";
set newname for datafile 6 to
"/u01/app/oracle/oradata/standby/zwc.dbf";
restore
clone database
;
}
executing Memory Script
executing command: SET NEWNAME
renamed temporary file 2 to /u01/app/oracle/oradata/standby/temptbs01.dbf in control file
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 13-FEB-14
channel c1: starting datafile backupset restore
channel c1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /u01/app/oracle/oradata/standby/system01.dbf
restoring datafile 00002 to /u01/app/oracle/oradata/standby/undotbs01.dbf
restoring datafile 00003 to /u01/app/oracle/oradata/standby/sysaux01.dbf
restoring datafile 00004 to /u01/app/oracle/oradata/standby/users01.dbf
restoring datafile 00005 to /u01/app/oracle/oradata/standby/example01.dbf
restoring datafile 00006 to /u01/app/oracle/oradata/standby/zwc.dbf
channel c1: reading from backup piece /bak/0lp0i94b_1_1
channel c1: restored backup piece 1
piece handle=/bak/0lp0i94b_1_1 tag=TAG20140213T231939
channel c1: restore complete, elapsed time: 00:00:35
Finished restore at 13-FEB-14
contents of Memory Script:
{
switch clone datafile all;
}
executing Memory Script
datafile 1 switched to datafile copy
input datafile copy recid=32 stamp=839460770 filename=/u01/app/oracle/oradata/standby/system01.dbf
datafile 2 switched to datafile copy
input datafile copy recid=33 stamp=839460770 filename=/u01/app/oracle/oradata/standby/undotbs01.dbf
datafile 3 switched to datafile copy
input datafile copy recid=34 stamp=839460770 filename=/u01/app/oracle/oradata/standby/sysaux01.dbf
datafile 4 switched to datafile copy
input datafile