[oracle@db-server dbs]$ rman target / auxiliary sys/oracle@testdb_stby;
Recovery Manager: Release 11.2.0.1.0 - Production on Sun Oct 28 17:11:39 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: TESTDB (DBID=2580410479)
connected to auxiliary database: TESTDB (not mounted)
RMAN> DUPLICATE TARGET DATABASE FOR STANDBY FROM ACTIVE DATABASE
NOFILENAMECHECK
DORECOVER SPFILE
SET DB_UNIQUE_NAME="TESTDB_STBY"
SET LOG_ARCHIVE_DEST_2="service=TESTDB_LIVE LGWR SYNC REGISTER VALID_FOR=(online_logfile,primary_role)"
SET CONTROL_FILES='/oracle/product/11.2.0/oradata/testdb/control01.ctl';
Starting Duplicate Db at 28-OCT-12
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=18 device type=DISK
contents of Memory Script:
{
backup as copy reuse
targetfile '/oracle/product/11.2.0/db_1/dbs/orapwtestdb' auxiliary format
'/oracle/product/11.2.0/db_1/dbs/orapwtestdb' targetfile
'/oracle/product/11.2.0/db_1/dbs/spfiletestdb.ora' auxiliary format
'/oracle/product/11.2.0/db_1/dbs/spfiletestdb.ora' ;
sql clone "alter system set spfile= ''/oracle/product/11.2.0/db_1/dbs/spfiletestdb.ora''";
}
executing Memory Script
Starting backup at 28-OCT-12
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=40 device type=DISK
Finished backup at 28-OCT-12
sql statement: alter system set spfile= ''/oracle/product/11.2.0/db_1/dbs/spfiletestdb.ora''
contents of Memory Script:
{
sql clone "alter system set db_unique_name =
''TESTDB_STBY'' comment=
'''' scope=spfile";
sql clone "alter system set LOG_ARCHIVE_DEST_2 =
''service=TESTDB_LIVE LGWR SYNC REGISTER VALID_FOR=(online_logfile,primary_role)'' comment=
'''' scope=spfile";
sql clone "alter system set CONTROL_FILES =
''/oracle/product/11.2.0/oradata/testdb/control01.ctl'' comment=
'''' scope=spfile";
shutdown clone immediate;
startup clone nomount;
}
executing Memory Script
sql statement: alter system set db_unique_name = ''TESTDB_STBY'' comment= '''' scope=spfile
sql statement: alter system set LOG_ARCHIVE_DEST_2 = ''service=TESTDB_LIVE LGWR SYNC REGISTER VALID_FOR=(online_logfile,primary_role)'' comment= '''' scope=spfile
sql statement: alter system set CONTROL_FILES = ''/oracle/product/11.2.0/oradata/testdb/control01.ctl'' comment= '''' scope=spfile
Oracle instance shut down
connected to auxiliary database (not started)
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 10/28/2012 17:12:32
RMAN-03015: error occurred in stored script Memory Script
RMAN-04014: startup failed: ORA-16184: DB_UNIQUE_NAME testdb hashes to the same value as DB_UNIQUE_NAME testdb
RMAN-04017: startup error description: ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
Deatil of solution provided by Metalink guide : Metalink : [ID 1331986.1]
References
No comments:
Post a Comment