Topic: Database Administration >> configuration of data guard
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| Title: configuration of data guard |
| Neeraj |
Posted: Feb 06, 2008 02:26:08 AM |
Total Post: 228
Joined: Jan, 2007
|
hi,
i want to set up data gurad for my oracle 10g rac database on aix.
so tell me what prerequisties i need & how can i configure data guard ?
thxs |
|
|
 Mohammed Taj |
| Posted: Feb 06, 2008 02:52:22 AM |  |
|
Total Post: 694
Joined: Jul, 2007
|
www.google.com
Search and read and try and come with exact problem if you face.
|
|
|
|
|
| Neeraj |
| Posted: Feb 06, 2008 04:16:05 AM | |
|
Total Post: 228
Joined: Jan, 2007
|
i havnt got any link where i can set up data guard easily
|
|
|
|
|
| Mohammed Taj |
| Posted: Feb 06, 2008 08:14:51 AM | |
|
Total Post: 694
Joined: Jul, 2007
|
http://www.google.ae/search?hl=en&q=Oracle+%2B+Data+guard+%2B+example&meta=
Results 1 - 10 of about 152,000 for Oracle + Data guard + example. (0.24 seconds)
|
|
|
|
|
| dbavinod |
| Posted: Feb 07, 2008 05:18:10 AM | |
|
Total Post: 90
Joined: Sep, 2006
|
Data Guard Operational Prerequisites
The following sections describe operational requirements for using Data Guard:
Hardware and Operating System Requirements
Oracle Software Requirements
Hardware and Operating System Requirements
The following 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.
Oracle Software Requirements
The following list describes Oracle software requirements for using Data Guard:
Oracle Data Guard is available only as a feature of Oracle Database Enterprise Edition. It is not available with Oracle Database Standard Edition. This means the same release of Oracle Database Enterprise Edition must be installed on the primary database and all standby databases in a Data Guard configuration.
Note:
It is possible to simulate a standby database environment with databases running Oracle Database Standard Edition. You can do this by manually transferring archived redo log files using an operating system copy utility or using custom scripts that periodically send archived redo log files from one database to the other. The consequence is that this configuration does not provide the ease-of-use, manageability, performance, and disaster-recovery capabilities available with Data Guard.
Using Data Guard SQL Apply, you will be able to perform a rolling upgrade of the Oracle database software from patch set release n (minimally, this must be release 10.1.0.3) to the next database 10.1.0.(n+1) patch set release. During a rolling upgrade, you can run different releases of the Oracle database on the primary and logical standby databases while you upgrade them, one at a time. For complete information, see Chapter 11, "Using SQL Apply to Upgrade the Oracle Database" and the ReadMe file for the applicable Oracle Database 10g patch set release.
The COMPATIBLE initialization parameter must be set to the same value on all databases in a Data Guard configuration.
If you are currently running Oracle Data Guard on Oracle8i database software, see Oracle Database Upgrade Guide for complete information about upgrading to Oracle Data Guard.
The primary database must run in ARCHIVELOG mode. See Oracle Database Administrator's Guide for more information.
The primary database can be a single instance database or a multi-instance Real Application Clusters database. The standby databases can be single instance databases or multi-instance Real Application Clusters (RAC) databases, and these standby databases can be a mix of both physical and logical types. See Oracle Database High Availability Overview for more information about configuring and using Oracle Data Guard with RAC.
Each primary database and standby database must have its own control file.
If a standby database is located on the same system as the primary database, the archival directories for the standby database must use a different directory structure than the primary database. Otherwise, the standby database may overwrite the primary database files.
To protect against unlogged direct writes in the primary database that cannot be propagated to the standby database, turn on FORCE LOGGING at the primary database before performing datafile backups for standby creation. Keep the database in FORCE LOGGING mode as long as the standby database is required.
The user accounts you use to manage the primary and standby database instances must have SYSDBA system privileges.
Oracle recommends that when you set up Oracle Automatic Storage Management (ASM) and Oracle Managed Files (OMF) in a Data Guard configuration, set it up symmetrically on the primary and standby database. That is, if any database in the Data Guard configuration uses ASM, OMF, or both, then every database in the configuration should use ASM, OMF, or both, respectively. See the scenario in Section 12.12 for more information.
Vinod
|
|
|
|
|
| Mohammed Taj |
| Posted: Feb 07, 2008 07:25:38 AM | |
|
Total Post: 694
Joined: Jul, 2007
|
Don't mind
but i think it is much better to read.
http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/standby.htm#i58150
|
|
|
|
|
| Murtuja |
| Posted: Feb 11, 2008 12:38:29 AM | |
|
Total Post: 814
Joined: Jan, 2006
|
Data Guard and Real Application Clusters
http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14239/rac_support.htm#i641721
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 814 |
| Mohammed Taj | 694 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 386 |
| positive fanatic | 361 |
| Gitesh Trivedi | 322 |
| Gopu Gopi | 239 |
| neeraj sharma | 228 |
| Ramesh Jois | 226 |
| snehalatha p | 169 |
|
|
