[oracle@dg2 ~]$ rman target sys/123456@dg1 auxiliary sys/123456@dg2
recovery manager: release 11.2.0.3.0 - production on sun apr 22 13:38:33 2012
copyright (c) 1982, 2011, oracle and/or its affiliates. all rights reserved.
connected to target database: dg (dbid=1694605607)
connected to auxiliary database: dg (not mounted)
rman> duplicate target database for standby nofilenamecheck from active database;
starting duplicate db at 2012-04-22-13:39:25
using target database control file instead of recovery catalog
allocated channel: ora_aux_disk_1
channel ora_aux_disk_1: sid=134 device type=disk
contents of memory script:
{
backup as copy reuse
targetfile '/u01/app/oracle/product/11.2.0/db1/dbs/orapwdg' auxiliary format
'/u01/app/oracle/product/11.2.0/db1/dbs/orapwdg' ;
}
executing memory script
starting backup at 2012-04-22-13:39:26
allocated channel: ora_disk_1
channel ora_disk_1: sid=19 device type=disk
finished backup at 2012-04-22-13:39:28
contents of memory script:
{
backup as copy current controlfile for standby auxiliary format
'/u01/app/oracle/oradata/dg/control01.ctl';
restore clone controlfile to '/u01/app/oracle/fast_recovery_area/dg/control02.ctl' from
'/u01/app/oracle/oradata/dg/control01.ctl';
}
executing memory script
starting backup at 2012-04-22-13:39:29
using channel ora_disk_1
channel ora_disk_1: starting datafile copy
copying standby control file
output file name=/u01/app/oracle/product/11.2.0/db1/dbs/snapcf_dg.f tag=tag20120422t133929 recid=1
stamp=781277970
channel ora_disk_1: datafile copy complete, elapsed time: 00:00:03
finished backup at 2012-04-22-13:39:32
starting restore at 2012-04-22-13:39:32
using channel ora_aux_disk_1
channel ora_aux_disk_1: copied control file copy
finished restore at 2012-04-22-13:39:34
contents of memory script:
{
sql clone 'alter database mount standby database';
}
executing memory script
sql statement: alter database mount standby database
contents of memory script:
{
set newname for tempfile 1 to
/u01/app/oracle/oradata/dg/temp01.dbf;
switch clone tempfile all;
set newname for datafile 1 to
/u01/app/oracle/oradata/dg/system01.dbf;
set newname for datafile 2 to
/u01/app/oracle/oradata/dg/sysaux01.dbf;
set newname for datafile 3 to
/u01/app/oracle/oradata/dg/undotbs01.dbf;
set newname for datafile 4 to
/u01/app/oracle/oradata/dg/users01.dbf;
backup as copy reuse
datafile 1 auxiliary format
/u01/app/oracle/oradata/dg/system01.dbf datafile
2 auxiliary format
/u01/app/oracle/oradata/dg/sysaux01.dbf datafile
3 auxiliary format
/u01/app/oracle/oradata/dg/undotbs01.dbf datafile
4 auxiliary format
/u01/app/oracle/oradata/dg/users01.dbf ;
sql 'alter system archive log current';
}
executing memory script
executing command: set newname
renamed tempfile 1 to /u01/app/oracle/oradata/dg/temp01.dbf in control file
executing command: set newname
executing command: set newname
executing command: set newname
executing command: set newname
starting backup at 2012-04-22-13:39:42
using channel ora_disk_1
channel ora_disk_1: starting datafile copy
input datafile file number=00001 name=/u01/app/oracle/oradata/dg/system01.dbf
output file name=/u01/app/oracle/oradata/dg/system01.dbf tag=tag20120422t133943
channel ora_disk_1: datafile copy complete, elapsed time: 00:03:06
channel ora_disk_1: starting datafile copy
input datafile file number=00002 name=/u01/app/oracle/oradata/dg/sysaux01.dbf
output file name=/u01/app/oracle/oradata/dg/sysaux01.dbf tag=tag20120422t133943
channel ora_disk_1: datafile copy complete, elapsed time: 00:01:55
channel ora_disk_1: starting datafile copy
input datafile file number=00003 name=/u01/app/oracle/oradata/dg/undotbs01.dbf
output file name=/u01/app/oracle/oradata/dg/undotbs01.dbf tag=tag20120422t133943
channel ora_disk_1: datafile copy complete, elapsed time: 00:00:15
channel ora_disk_1: starting datafile copy
input datafile file number=00004 name=/u01/app/oracle/oradata/dg/users01.dbf
output file name=/u01/app/oracle/oradata/dg/users01.dbf tag=tag20120422t133943
channel ora_disk_1: datafile copy complete, elapsed time: 00:00:03
finished backup at 2012-04-22-13:45:05
sql statement: alter system archive log current
contents of memory script:
{
switch clone datafile all;
}
executing memory script
datafile 1 switched to datafile copy
input datafile copy recid=1 stamp=781278308 file name=/u01/app/oracle/oradata/dg/system01.dbf
datafile 2 switched to datafile copy
input datafile copy recid=2 stamp=781278308 file name=/u01/app/oracle/oradata/dg/sysaux01.dbf
datafile 3 switched to datafile copy
input datafile copy recid=3 stamp=781278308 file name=/u01/app/oracle/oradata/dg/undotbs01.dbf
datafile 4 switched to datafile copy
input datafile copy recid=4 stamp=781278308 file name=/u01/app/oracle/oradata/dg/users01.dbf
finished duplicate db at 2012-04-22-13:45:29
rman> exit
recovery manager complete.