Home » RDBMS Server » Server Administration » Creating physical Standby database
Creating physical Standby database [message #250060] Sat, 07 July 2007 09:14 Go to next message
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
Re: Creating physical Standby database [message #250061 is a reply to message #250060] Sat, 07 July 2007 09:17 Go to previous messageGo to next message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
Note:67488.1
Standby Database Configuration, Case Study,
Re: Creating physical Standby database [message #250065 is a reply to message #250060] Sat, 07 July 2007 09:42 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
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
Re: Creating physical Standby database [message #250066 is a reply to message #250065] Sat, 07 July 2007 09:52 Go to previous messageGo to next message
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
Re: Creating physical Standby database [message #250067 is a reply to message #250066] Sat, 07 July 2007 09:56 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
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
Re: Creating physical Standby database [message #250069 is a reply to message #250067] Sat, 07 July 2007 10:06 Go to previous messageGo to next message
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.
Re: Creating physical Standby database [message #250075 is a reply to message #250069] Sat, 07 July 2007 11:05 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
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
Re: Creating physical Standby database [message #250096 is a reply to message #250069] Sat, 07 July 2007 18:56 Go to previous messageGo to next message
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.
Re: Creating physical Standby database [message #250124 is a reply to message #250069] Sun, 08 July 2007 03:54 Go to previous message
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
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:
  


Current Time: Mon Dec 05 21:05:17 CST 2016

Total time taken to generate the page: 0.14405 seconds