(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = jadl11g)
)
)
SJADL11G =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.184)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = jadl11g)
)
)
PJADL11G =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.188)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = jadl11g)
)
)
http://xxf-home.net/?p=139
http://blog.csdn.net/wyzxg/article/details/7280223
备库执行如下操作：
[oracle@localhost ~]$ rman target sys/123456@pjadl11g auxiliarysys/123456@sjadl11g
Recovery Manager: Release 11.2.0.3.0 -Production on Fri Nov 7 13:55:28 2014
Copyright (c) 1982, 2011, Oracle and/or itsaffiliates. All rights reserved.
connected to target database: JADL11G(DBID=2088752907)
connected to auxiliary database: JADL11G(not mounted)
RMAN> duplicate target database for standbynofilenamecheck from active database; --clone
Starting Duplicate Db at 07-NOV-14
using target database control file insteadof recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=1 devicetype=DISK
contents of Memory Script:
{
backup as copy reuse
targetfile '/u01/oracle/11g/dbs/orapwjadl11g' auxiliary format
'/u01/oracle/11g/dbs/orapwjadl11g' ;
}
executing Memory Script
Starting backup at 07-NOV-14
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=31 device type=DISK
Finished backup at 07-NOV-14
contents of Memory Script:
{
backup as copy current controlfile for standby auxiliary format '/u01/oracle/oradata/jadl11g/control01.ctl';
restore clone controlfile to '/u01/oracle/fast_recovery_area/jadl11g/control02.ctl' from
'/u01/oracle/oradata/jadl11g/control01.ctl';
}
executing Memory Script
Starting backup at 07-NOV-14
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
copying standby control file
output filename=/u01/oracle/11g/dbs/snapcf_jadl11g.f tag=TAG20141107T135544 RECID=8STAMP=863013345
channel ORA_DISK_1: datafile copy complete,elapsed time: 00:00:01
Finished backup at 07-NOV-14
Starting restore at 07-NOV-14
using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: copied control filecopy
Finished restore at 07-NOV-14
contents of Memory Script:
{
sql clone 'alter database mount standby database';
}
executing Memory Script
sql statement: alter database mount standbydatabase
contents of Memory Script:
{
set newname for tempfile 1 to
"/u01/oracle/oradata/jadl11g/temp01.dbf";
switch clone tempfile all;
set newname for datafile 1 to
"/u01/oracle/oradata/jadl11g/system01.dbf";
set newname for datafile 2 to
"/u01/oracle/oradata/jadl11g/sysaux01.dbf";
set newname for datafile 3 to
"/u01/oracle/oradata/jadl11g/undotbs01.dbf";
set newname for datafile 4 to
"/u01/oracle/oradata/jadl11g/users01.dbf";
set newname for datafile 5 to
"/u01/oracle/oradata/jadl11g/example01.dbf";
backup as copy reuse
datafile 1 auxiliary format
"/u01/oracle/oradata/jadl11g/system01.dbf" datafile
2auxiliary format
"/u01/oracle/oradata/jadl11g/sysaux01.dbf" datafile
3auxiliary format
"/u01/oracle/oradata/jadl11g/undotbs01.dbf" datafile
4auxiliary format
"/u01/oracle/oradata/jadl11g/users01.dbf" datafile
5auxiliary format
"/u01/oracle/oradata/jadl11g/example01.dbf" ;
sql 'alter system archive log current';
}
exe