[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