sql statement: alter database mount standby database
released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 02/25/2008 14:02:58
RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of sql command on clone_default channel at 02/25/2008 14:02:58
RMAN-11003: failure during parse/execution of SQL statement: alter database mount standby database
ORA-01103: database name 'ORCL' in control file is not 'STDBY'

DGMGRL> add database orcl as
> connect identifier is stdby
> maintained as physical;
Error: ORA-16642: db_unique_name mismatch

Failed.
DGMGRL>

DGMGRL> add database orcl as
> connect identifier is stdby
> maintained as physical;
Error: ORA-16642: db_unique_name mismatch
Failed.
DGMGRL>

1.CHECK PRIMARY DATABASE IN ARCHIVELOG MODE.
2.ALTER DATABASE FORCE LOGGING.
3.BACKUP TARGET DATABASE. 
4.1 BACKUP TARGET DATABASE CONTROLFILE FOR STANDBY DATABASE.
4.2 Alter system archive log current.
5.1 alter database open;
5.2 CREATED PASSWORD FILE FOR STANDBY DATABASE
6.PRIMARY DATABASE INITIALIZATION PARAMETERS : 

DB_UNIQUE_NAME=orcl
LOG_ARCHIVE_CONFIG='DG_CONFIG=(orcl,stdby)'
log_archive_dest_1='location=e:\oracle\product\10.2.0\Logarchive'
LOG_ARCHIVE_DEST_2 ='SERVICE=stdby
DB_UNIQUE_NAME=stdby'
LOG_FILE_NAME_CONVERT='C:\stdby_db\file\REDO02.LOG','E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG','C:\stdby_db\file\REDO01.LOG','E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG'
LOG_ARCHIVE_DEST_STATE_1=ENABLE
LOG_ARCHIVE_DEST_STATE_2=ENABLE
FAL_SERVER=stdby
FAL_CLIENT=orcl
STANDBY_FILE_MANAGEMENT=AUTO

7.CREATE SPFILE FROM PFILE='PRIMARY DATABASE PFILE LOCATION'
8.CREATE PFILE=' STANDBY DATABASE PFILE LOCATION' FROM SPFILE;
some changed standby database parameters 

DB_NAME=orcl - same as primary database name
DB_UNIQUE_NAME=stdby - change
LOG_ARCHIVE_CONFIG='DG_CONFIG=(orcl,stdby)' - same
LOG_FILE_NAME_CONVERT='E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG','C:\stdby_db\file\REDO02.LOG','E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG','C:\stdby_db\file\REDO01.LOG'
LOG_ARCHIVE_DEST_1='LOCATION=C:\STDBY_DB\LOGARCHIVE'
LOG_ARCHIVE_DEST_2='SERVICE=ORCL DB_UNIQUE_NAME=orcl'
STANDBY_FILE_MANAGEMENT=AUTO
FAL_SERVER=orcl
FAL_CLIENT=stdby
*************************************************************

9.1CREATE INSTANCE OR SERVICE FOR STANDBY DATABASE
9.2 Listener and tns configuration
10.CONNECT PRIMARY DATABASE USING RMAN AND CONNECT STANDBY DATABASE USING "CONNECT AUXILIARY USERNAME/PASSWD@STDBYNAME".
11.run
{
 set newname ..
   .
   .
   .
  duplicate target database for standby dorecover;
 }
startup in mount

12.1 ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
			(or)
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE

12.2 ALTER DATABASE RECOVER MANAGED STANDBY DATABASE NODELAY;

13.RECOVER MANAGED STANDBY DATABASE CANCEL;
14.ALTER DATABASE OPEN READ ONLY;

SQL> alter system set DG_BROKER_START = true;  

System altered.

DGMGRL> connect username/Passwd@orcl
Connected.

DGMGRL> create configuration DGORCL as
> primary database is orcl
> connect identifier is orcl;
Configuration "dgorcl" created with primary database "orcl"

DGMGRL> show database orcl
Database
  Name:            orcl
  Role:            PRIMARY
  Enabled:         YES
  Intended State:  ONLINE
  Instance(s):
    orcl
Current status for "orcl":
SUCCESS

DGMGRL> add database orcl as
> connect identifier is stdby
> maintained as physical;
Error: ORA-16642: db_unique_name mismatch

Failed.