Home » RDBMS Server » Server Administration » Purpose of creating standby control file (Oracle 10.2.0.4.0,SunOS)
Purpose of creating standby control file [message #555087] Mon, 21 May 2012 05:37 Go to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Hi,

Can somebody explain the process of creating standby database control file in primary database using below command.

ALTER DATABASE CREATE STANDBY CONTROLFILE AS 'D:\oracle\oradata\stby\control_sb01.ctl';
.
Regards,
Jack
Re: Purpose of creating standby control file [message #555089 is a reply to message #555087] Mon, 21 May 2012 05:45 Go to previous messageGo to next message
Michel Cadot
Messages: 67810
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Can you explain your question.

Regards
Michel
Re: Purpose of creating standby control file [message #555091 is a reply to message #555089] Mon, 21 May 2012 05:47 Go to previous messageGo to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Can somebody explain the purpose of creating below command of standby database control file in primary database ?

I hope my question is clear for you this time.

Note: This step is part of create standby database.

Re: Purpose of creating standby control file [message #555095 is a reply to message #555091] Mon, 21 May 2012 06:14 Go to previous messageGo to next message
Michel Cadot
Messages: 67810
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Can somebody explain the purpose of creating below command of standby database control file in primary database ?


To be able to create a standby database.

Regards
Michel
Re: Purpose of creating standby control file [message #555106 is a reply to message #555095] Mon, 21 May 2012 07:24 Go to previous messageGo to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Michel,

your answer is unclear
Re: Purpose of creating standby control file [message #555110 is a reply to message #555106] Mon, 21 May 2012 07:53 Go to previous messageGo to next message
Michel Cadot
Messages: 67810
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What is unclear?
You create a standby control file to be able to create a standby database.

Regards
Michel
Re: Purpose of creating standby control file [message #555129 is a reply to message #555110] Mon, 21 May 2012 10:50 Go to previous messageGo to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Quote:
You create a standby control file to be able to create a standby database.

Ok i understood your point.My actual question was why are we creating standby control file in primary database and why not in standby database?

Regards,
Jack.

[Updated on: Mon, 21 May 2012 10:51]

Report message to a moderator

Re: Purpose of creating standby control file [message #555130 is a reply to message #555129] Mon, 21 May 2012 10:54 Go to previous messageGo to next message
BlackSwan
Messages: 26763
Registered: January 2009
Location: SoCal
Senior Member
>My actual question was why are we creating standby control file in primary database ?
If you don't use the primary DB to make the standby control file, what do you use?
What is viable alternative to make the control file?

Re: Purpose of creating standby control file [message #555131 is a reply to message #555129] Mon, 21 May 2012 10:58 Go to previous messageGo to next message
Michel Cadot
Messages: 67810
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Jack14 wrote on Mon, 21 May 2012 17:50
Quote:
You create a standby control file to be able to create a standby database.

Ok i understood your point.My actual question was why are we creating standby control file in primary database and why not in standby database?

Regards,
Jack.


Because before creating a standby database you have no control file of this standby database and the purpose of standby database is... (third tiùe) to be able to create this standby database.
Do you understand what you read and write: "Note: This step is part of create standby database"?

Regards
Michel

Re: Purpose of creating standby control file [message #555176 is a reply to message #555131] Tue, 22 May 2012 00:08 Go to previous messageGo to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Quote:
(third tiùe)


Michel,

Can you tell me what is this word about ?
Re: Purpose of creating standby control file [message #555178 is a reply to message #555176] Tue, 22 May 2012 00:13 Go to previous messageGo to next message
Littlefoot
Messages: 21664
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Typo, I presume. "Third time" might be the word (i.e. for the third time he said the same - "to be able to create the standby database").
Re: Purpose of creating standby control file [message #555181 is a reply to message #555178] Tue, 22 May 2012 00:55 Go to previous message
Michel Cadot
Messages: 67810
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And you're right, the 2 characters are closed on my keyboard.

Regards
Michel
Previous Topic: Ora-04030
Next Topic: listener issue
Goto Forum:
  


Current Time: Wed Apr 14 18:55:12 CDT 2021