Home » Server Options » Data Guard » Standbydatabase error
Standbydatabase error [message #294649] Fri, 18 January 2008 05:27 Go to next message
navaneethdba
Messages: 71
Registered: July 2007
Location: chennai
Member
Hi,

Oracle:10.2.0
Windows2000server

I am trying to create a standby database in same machine for practice.When creating using RMAN it gives error

RMAN> run
2>  {
3>  allocate auxiliary channel c1 type disk;
4>  set newname for datafile 1 to 'C:\stdby_db\file\SYSTEM01.DBF';
5>  set newname for datafile 2 to 'C:\stdby_db\file\UNDOTBS01.DBF';
6>  set newname for datafile 3 to 'C:\stdby_db\file\SYSAUX01.DBF';
7>  set newname for datafile 4 to 'C:\stdby_db\file\USERS01.DBF';
8>  set newname for tempfile 1 to 'C:\stdby_db\file\TEMP01.DBF';
9>  duplicate target database to stdby
10>  logfile group 1 ('C:\stdby_db\file\log01.log') size 50m reuse,
11>  group 2 ('C:\stdby_db\file\log02.log') size 50m reuse,
12>  group 3 ('C:\stdby_db\file\log03.log') size 50m reuse;
13>  }

using target database control file instead of recovery catalog
allocated channel: c1
channel c1: sid=156 devtype=DISK

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting Duplicate Db at 18-JAN-08
released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 01/18/2008 16:53:21
RMAN-05520: database name mismatch, auxiliary instance has ORCL, command specified STDBY


My primary database pfile additional parameters

DB_NAME=orcl
DB_UNIQUE_NAME=orcl
LOG_ARCHIVE_CONFIG='DG_CONFIG=(orcl,stdby)'
log_archive_dest_1='location=e:\oracle\product\10.2.0\Logarchive
  VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
  DB_UNIQUE_NAME=orcl'
LOG_ARCHIVE_DEST_2=
 'SERVICE=stdby LGWR ASYNC
  VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) 
  DB_UNIQUE_NAME=stdby'
LOG_ARCHIVE_DEST_STATE_1=ENABLE
LOG_ARCHIVE_DEST_STATE_2=ENABLE
LOG_ARCHIVE_FORMAT=%t_%s_%r.arc
LOG_ARCHIVE_MAX_PROCESSES=30

FAL_SERVER=stdby
FAL_CLIENT=orcl
STANDBY_FILE_MANAGEMENT=AUTO


This is my standby database pfile
stdby.__db_cache_size=184549376
stdby.__java_pool_size=4194304
stdby.__large_pool_size=4194304
stdby.__shared_pool_size=88080384
stdby.__streams_pool_size=0
*.audit_file_dest='E:\oracle\product\10.2.0/admin/stdby/adump'
*.background_dump_dest='E:\oracle\product\10.2.0/admin/stdby/bdump'
*.compatible='10.2.0.1.0'
*.control_files='C:\stdby_db\file\control01.ctl','C:\stdby_db\file\control02.ctl','C:\stdby_db\file\control03.ctl'
*.core_dump_dest='E:\oracle\product\10.2.0/admin/stdby/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.DB_NAME='orcl'
 lock_name_space=stdby
*.db_recovery_file_dest='C:\stdby_db\flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.DB_UNIQUE_NAME='stdby'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=stdbyXDB)'
*.FAL_CLIENT='stdby'
*.FAL_SERVER='orcl'
*.job_queue_processes=10
*.log_archive_dest_1='location=C:\stdby_db\Logarchive
  VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
  DB_UNIQUE_NAME=stdby'
*.LOG_ARCHIVE_DEST_2='SERVICE=orcl LGWR ASYNC
  VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) 
  DB_UNIQUE_NAME=orcl'
*.LOG_ARCHIVE_DEST_STATE_1='ENABLE'
*.LOG_ARCHIVE_DEST_STATE_2='ENABLE'
*.LOG_ARCHIVE_FORMAT='%t_%s_%r.arc'
*.LOG_ARCHIVE_MAX_PROCESSES=30
*.open_cursors=300
*.pga_aggregate_target=95420416
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=287309824
*.STANDBY_FILE_MANAGEMENT='AUTO'
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='E:\oracle\product\10.2.0/admin/stdby/udump'

plz guide me ....

TIA,

[Updated on: Fri, 18 January 2008 07:08] by Moderator

Report message to a moderator

Re: Standbydatabase error [message #294674 is a reply to message #294649] Fri, 18 January 2008 07:09 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use code tags and not quote ones to post code.

Have a look at these lines:
*.DB_NAME='orcl'
duplicate target database to stdby

So:
"database name mismatch, auxiliary instance has ORCL, command specified STDBY"

Regards
Michel


[Updated on: Fri, 18 January 2008 07:09]

Report message to a moderator

Previous Topic: Using DGMGRL on Sun Cluster 3.1
Next Topic: urgent need help since tommarow is last day
Goto Forum:
  


Current Time: Thu Mar 28 07:56:10 CDT 2024