executing command: SET NEWNAME
renamed tempfile 1 to/u01/oracle/oradata/jadl11g/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
Starting backup at 07-NOV-14
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001name=/u01/oracle/oradata/jadl11g/system01.dbf
output filename=/u01/oracle/oradata/jadl11g/system01.dbf tag=TAG20141107T135552
channel ORA_DISK_1: datafile copy complete,elapsed time: 00:00:25
channel ORA_DISK_1: starting datafile copy
input datafile file number=00002name=/u01/oracle/oradata/jadl11g/sysaux01.dbf
output filename=/u01/oracle/oradata/jadl11g/sysaux01.dbf tag=TAG20141107T135552
channel ORA_DISK_1: datafile copy complete,elapsed time: 00:00:25
channel ORA_DISK_1: starting datafile copy
input datafile file number=00005name=/u01/oracle/oradata/jadl11g/example01.dbf
output filename=/u01/oracle/oradata/jadl11g/example01.dbf tag=TAG20141107T135552
channel ORA_DISK_1: datafile copy complete,elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile copy
input datafile file number=00003name=/u01/oracle/oradata/jadl11g/undotbs01.dbf
output filename=/u01/oracle/oradata/jadl11g/undotbs01.dbf tag=TAG20141107T135552
channel ORA_DISK_1: datafile copy complete,elapsed time: 00:00:08
channel ORA_DISK_1: starting datafile copy
input datafile file number=00004name=/u01/oracle/oradata/jadl11g/users01.dbf
output filename=/u01/oracle/oradata/jadl11g/users01.dbf tag=TAG20141107T135552
channel ORA_DISK_1: datafile copy complete,elapsed time: 00:00:01
Finished backup at 07-NOV-14
sql statement: alter system archive logcurrent
contents of Memory Script:
{
switch clone datafile all;
}
executing Memory Script
datafile 1 switched to datafile copy
input datafile copy RECID=8 STAMP=863013428file name=/u01/oracle/oradata/jadl11g/system01.dbf
datafile 2 switched to datafile copy
input datafile copy RECID=9 STAMP=863013428file name=/u01/oracle/oradata/jadl11g/sysaux01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=10STAMP=863013428 file name=/u01/oracle/oradata/jadl11g/undotbs01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=11STAMP=863013428 file name=/u01/oracle/oradata/jadl11g/users01.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=12STAMP=863013428 file name=/u01/oracle/oradata/jadl11g/example01.dbf
Finished Duplicate Db at 07-NOV-14
主备库同时执行如下操作
[oracle@localhost ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production onFri Nov 7 13:59:09 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise EditionRelease 11.2.0.3.0 - 64bit Production
With the Partitioning, Oracle LabelSecurity, OLAP, Data Mining,
Oracle Database Vault and Real ApplicationTesting options
SQL> show parameter dg_b
NAME TYPE VALUE
----------------------------------------------- ------------------------------
dg_broker_config_file1 string /u01/oracle/11g/dbs/dr1sjadl11g.dat
dg_broker_config_file2 string /u01/oracle/11g/dbs/dr2sjadl11g.dat
dg_broker_start boolean FALSE
SQL> alter system set dg_br