|
|
|
|
|
|
|
Re: How to create Physical standby database and steps for dataguard [message #408912 is a reply to message #408760] |
Thu, 18 June 2009 05:09 |
Sahba1969
Messages: 14 Registered: March 2009 Location: Austria
|
Junior Member |
|
|
hi,
the oracle documentation (Oracle 10g Data Guard Concepts and Administration) is a perferct start, weather on Windows or on Lunix.
you didn't mention the Oracle version, but I assume it will be oracle 10.2.0.3.
you can set dataguard on one Server (for two instances), if you have reasonable amount of disks and memory, or on physically separated servers.
Important to note, that both version and release of Oracle SW and OS should be identical.
On oracle web page, you'll find a link to Oracle Online Documentation. You can also download the whole oracle documentation to your hard drive, for faster reference.
We can't send a rough list of steps to setup a dataguard, since we don't know anything about what type of dataguard your configuration is planning to have.
have fun with the setup.
regards
sahba
|
|
|
|
Re: How to create Physical standby database and steps for dataguard [message #408920 is a reply to message #408760] |
Thu, 18 June 2009 05:44 |
Sahba1969
Messages: 14 Registered: March 2009 Location: Austria
|
Junior Member |
|
|
hi brain,
I wanted to mention one of the most important prerequistes as a start point for Naren. Your comment is uninformational in this context.
For Oracle 10g, which I assumed to be the Version for Setup, the follwoing gilt:
A list describes hardware and operating system requirements for using Data Guard:
■ All members of a Data Guard configuration must run an Oracle image that is built for the same platform.
For example, this means a Data Guard configuration with a primary database on a 32-bit Linux on Intel system can have a standby database that is configured on a 32-bit Linux on Intel system. However, a primary database on a 64-bit HP-UX
system can also be configured with a standby database on a 32-bit HP-UX system, as long as both servers are running 32-bit images.
■ The hardware (for example, the number of CPUs, memory size, storage configuration) can be different between the primary and standby systems. If the standby system is smaller than the primary system, you may have to restrict the work that can be done on the standby system after a switchover or failover.
The standby system must have enough resources available to receive and apply all redo data from the primary database. The logical standby database requires additional resources to translate the redo data into SQL statements and then execute the SQL on the logical standby database.
■ The operating system running on the primary and standby locations must be the same, but the operating system release does not need to be the same. In addition, the standby database can use a different directory structure from the primary database.
I wanted to point out for Naren, that you cannot mix Windows with Unix in Oracle 10.2 to Setup the Dataguard.
regards
Sahba
|
|
|
|
|