Thursday, November 15, 2012

ORA-17628, ORA-19505 during RMAN DUPLICATE FROM ACTIVE Metalink : [ID 1331986.1]

When I tried to use Oracle 11g`s create active standby feature weeks ago I faced below error, but after research it on Metalink I found solution.


[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
BUG:12609412 - ORA-17628 ORA-19505 DURING DUPLICATE FROM ACTIVE

No comments:

Post a Comment

Cannot access dba_directories inside procedure

 Recently I faced one of familiar Oracle error ORA -00942 : table or view does not exist   I got it in while compiling procedure, becaus...