RMAN> connect auxiliary sys/[email protected]
connected to auxiliary database: TEST (not mounted)
RMAN> duplicate target database for standby
nofilenamecheck;
Starting Duplicate Db at 2020-01-08 10:23:57
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=129 device type=DISK
contents of Memory Script:
{
restore clone standby
controlfile;
}
executing Memory Script
Starting restore at 2020-01-08 10:23:58
using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: starting datafile backup set
restore
channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: reading from backup piece
/home/oracle/ab/08ulf2q0_1_1
channel ORA_AUX_DISK_1: piece
handle=/home/oracle/ab/08ulf2q0_1_1 tag=TAG20200108T101308
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time:
00:00:03
output file name=/u01/oradata/test/control01.ctl
output file
name=/u01/flash_recovery_area/test/control02.ctl
Finished restore at 2020-01-08 10:24:03
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/oradata/test/temp01.dbf";
switch clone tempfile
all;
set newname for
datafile 1 to
"/u01/oradata/test/system01.dbf";
set newname for
datafile 2 to
"/u01/oradata/test/sysaux01.dbf";
set newname for
datafile 3 to
"/u01/oradata/test/undotbs01.dbf";
set newname for
datafile 4 to
"/u01/oradata/test/users01.dbf";
set newname for
datafile 5 to
"/u01/oradata/test/space02.dbf";
set newname for
datafile 6 to
"/u01/oradata/test/aaa01.dbf";
restore
clone database
;
}
executing Memory Script
executing command: SET NEWNAME
renamed tempfile 1 to /u01/oradata/test/temp01.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 2020-01-08 10:24:10
using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: starting datafile backup set
restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from
backup set
channel ORA_AUX_DISK_1: restoring datafile 00001 to
/u01/oradata/test/system01.dbf
channel ORA_AUX_DISK_1: restoring datafile 00002 to
/u01/oradata/test/sysaux01.dbf
channel ORA_AUX_DISK_1: restoring datafile 00003 to
/u01/oradata/test/undotbs01.dbf
channel ORA_AUX_DISK_1: restoring datafile 00004 to
/u01/oradata/test/users01.dbf
channel ORA_AUX_DISK_1: restoring datafile 00005 to
/u01/oradata/test/space02.dbf
channel ORA_AUX_DISK_1: restoring datafile 00006 to
/u01/oradata/test/aaa01.dbf
channel ORA_AUX_DISK_1: reading from backup piece
/home/oracle/ab/07ulf2hk_1_1
channel ORA_AUX_DISK_1: piece
handle=/home/oracle/ab/07ulf2hk_1_1 tag=TAG20200108T101308
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time:
00:10:03
Finished restore at 2020-01-08 10:34:14
contents of Memory Script:
{
switch clone datafile
all;
}
executing Memory Script
datafile 1 switched to datafile copy
input datafile copy RECID=7 STAMP=1029148455 file
name=/u01/oradata/test/system01.dbf
datafile 2 switched to datafile copy
input datafile copy RECID=8 STAMP=1029148455 file
name=/u01/oradata/test/sysaux01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=9 STAMP=1029148455 file
name=/u01/oradata/test/undotbs01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=10 STAMP=1029148455 file
name=/u01/oradata/test/users01.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=11 STAMP=1029148455 file
name=/u01/oradata/test/space02.dbf
datafile 6 switched to datafile copy
input datafile copy RECID=12 STAMP=1029148455 file
name=/u01/oradata/test/aaa01.dbf
Finished Duplicate Db at 2020-01-08 10:34:31