OraFAQ Forum: Server Administration » Creating physical Standby database

Home » RDBMS Server » Server Administration » Creating physical Standby database

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

Creating physical Standby database [message #250060]

Sat, 07 July 2007 09:14

anandkumar_hrg
Messages: 3
Registered: May 2007
Location: India

Junior Member

Dear Friend
Is here anybody to help out to create a physical stand by database using datafiles n control file of primary database ?

I know to create physical stand by database we need to copy primary database datafiles n control files. but i am confusing regarding how to use those primary database datafiles n control files to create physical stand by database.

Please help me aybody with step by step instruction. I will be greatful to you people.

Regards
--------------------------
Anandkumar S.M

Report message to a moderator

Re: Creating physical Standby database [message #250061 is a reply to message #250060]

Sat, 07 July 2007 09:17

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Note:67488.1
Standby Database Configuration, Case Study,

Report message to a moderator

Re: Creating physical Standby database [message #250065 is a reply to message #250060]

Sat, 07 July 2007 09:42

Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Data Guard Concepts and Administration
Chapter 3 Creating a Physical Standby Database

Regards
Michel

Report message to a moderator

Re: Creating physical Standby database [message #250066 is a reply to message #250065]

Sat, 07 July 2007 09:52

anandkumar_hrg
Messages: 3
Registered: May 2007
Location: India

Junior Member

but i want to create stand by database on another server not on the same server where the primary server is running. pls help me out i allready have that documentation downloaded from oracle website but confusing regarding how to use those datafiles n cntrol files for physical stand by databse on another new database server which one I am creating as stsnd by databse

Report message to a moderator

Re: Creating physical Standby database [message #250067 is a reply to message #250066]

Sat, 07 July 2007 09:56

Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

i want to create stand by database on another server not on the same server where the primary server is running

Same steps.
No difference except the way you copy the files.

Of course, you have installed Oracle on the other server, don't you?

Regards
Michel

Report message to a moderator

Re: Creating physical Standby database [message #250069 is a reply to message #250067]

Sat, 07 July 2007 10:06

anandkumar_hrg
Messages: 3
Registered: May 2007
Location: India

Junior Member

see my problem is that my primary server is allready running in one computer n i want to create physical stand by database in another computer.

Report message to a moderator

Re: Creating physical Standby database [message #250075 is a reply to message #250069]

Sat, 07 July 2007 11:05

Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

See the documentation, read it and try to understand it.
Your situation is a NORMAL situation.
Nothing special.

Regards
Michel

Report message to a moderator

Re: Creating physical Standby database [message #250096 is a reply to message #250069]

Sat, 07 July 2007 18:56

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

anandkumar_hrg wrote on Sat, 07 July 2007 09:06

see my problem is that my primary server is allready running in one computer n i want to create physical stand by database in another computer.

1:take backup either rman or cold
2:create standby controlfile
3:move all files to other machine
4:edit pfile only if directory structure is not same by using db_file_name_convert and log_file_name_convert parameter.
5:startup database mount
6:restore your backup
7:apply archivelogs.
8:alter database open.

Report message to a moderator

Re: Creating physical Standby database [message #250124 is a reply to message #250069]

Sun, 08 July 2007 03:54

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Go through below link
http://dbataj.blogspot.com/2007/03/standby-database.html
hope this helps

Regards
Taj

Report message to a moderator

Previous Topic:	Best way to duplicate a database / schema ? NOT urgent, never was, never will be.
Next Topic:	Oracle REDO log switching - query / help

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 22:34:46 CDT 2024