OraFAQ Forum: Data Guard » Starting DB with standby controlfile.

Home » Server Options » Data Guard » Starting DB with standby controlfile. (10g/Windows)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Starting DB with standby controlfile. [message #354128]

Thu, 16 October 2008 08:53

me_maddy
Messages: 31
Registered: April 2008

Member

Hello Everybody,

I am trying to prepare a stand by server, somehow i go stuck in the middle.

below is my case.

I have prepared my primary database (ORCL) and created the standby controlfile from the primary database, but when I try to startup the standby (Stand) database, i get the below error.

SQL> startup MOUNT pfile='D:\oracle\product\10.2.0\admin\stand\pfile\initstand.ora'
ORACLE instance started.

Total System Global Area  167772160 bytes
Fixed Size                  1247876 bytes
Variable Size              62915964 bytes
Database Buffers           96468992 bytes
Redo Buffers                7139328 bytes
ORA-01103: database name 'ORCL' in control file is not 'STAND'

How do I get my standby database started with the controlfile having different DB name.

Appreciate your suggestions!

Regards,
Maddy.

Report message to a moderator

Re: Starting DB with standby controlfile. [message #354178 is a reply to message #354128]

Thu, 16 October 2008 18:32

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Check Creating a Physical Standby Database for the appropriate parameters that need to be configured and all the details for creating a standby database.

Report message to a moderator

Re: Starting DB with standby controlfile. [message #355715 is a reply to message #354178]

Mon, 27 October 2008 03:51

trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam

Senior Member

I think the parameter db_name and db_unique_name in physical standby database's pfile were set wrong.

You should recheck them, and recheck the instance name which was created as "ORADIM" command!

Report message to a moderator

Previous Topic:	enable configuration in data guard borker (merged)
Next Topic:	fal server

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 11:50:21 CDT 2024