Wednesday, March 7, 2007

Oracle Data Guard: 01 physical standby database configuration

Click here to read the previous step.

To create a standby database is preferred to have the same names and path names for all the Oracle files (datafiles, redo log files, control files) of the primary database.

Online redo logs, archived redo logs and standby redo logs are used to maintaining the transactional consistency of the primary and standby databases.
In the following table you can see the relationships between these files and the type of database:


For this dataguard configuration I will setup two virtual machines, in order the primary and the physical standby:

Primary
hostname: macbook1
static IP: 192.168.0.10
DB_NAME: DGUARD
DB_UNIQUE_NAME: PRIMARY
SERVICE_NAMES: PRIMARY
listener: default listener configuration
net service name to point to the standby database: STANDBY_MACBOOK2

Standby
hostname: macbook2
static IP: 192.168.0.11
DB_NAME: DGUARD
DB_UNIQUE_NAME: STANDBY
SERVICE_NAMES: STANDBY
listener: default listener configuration
net service name to point to the standby database: STANDBY_MACBOOK2

The pictures below describe the dbca installation of the primary database.

































Click here to read the next step.

6 comments:

Egidio Ndabagoye said...

Hello Marco i'm 9i OCP.Very informative blog.

oakleyses said...

abercrombie and fitch, instyler, ghd, bottega veneta, ugg boots, jimmy choo outlet, soccer shoes, ugg pas cher, herve leger, beats by dre, birkin bag, abercrombie and fitch, north face jackets, soccer jerseys, mont blanc, rolex watches, lululemon outlet, celine handbags, nike roshe run, nike trainers, giuseppe zanotti, hollister, wedding dresses, nike huarache, mcm handbags, vans shoes, chi flat iron, babyliss pro, north face outlet, nike roshe, ugg australia, ugg, marc jacobs, barbour, nfl jerseys, p90x, new balance shoes, asics running shoes, ferragamo shoes, mac cosmetics, insanity workout, uggs outlet, reebok outlet, longchamp, valentino shoes

oakleyses said...

converse, air max, gucci, canada goose, juicy couture outlet, canada goose, wedding dresses, moncler, ralph lauren, lancel, montre homme, moncler, louboutin, oakley, karen millen, vans, coach outlet store online, air max, canada goose jackets, ugg, hollister clothing store, louis vuitton, baseball bats, hollister, rolex watches, juicy couture outlet, iphone 6 cases, canada goose uk, canada goose outlet, ugg, moncler, moncler outlet, timberland boots, hollister, supra shoes, moncler, canada goose, converse shoes, toms shoes, moncler, moncler, canada goose, ugg boots, ray ban, parajumpers, canada goose

NettechIndia said...

Thanks for sharing this valuable information to our vision. You have posted a trust worthy blog keep sharing.
oracle training in Mumbai
oracle dba training in Mumbai
oracle rac training in Mumbai
oracle data guard training in mumbai
oracle golden gate training in mumbai
oracle developer training in mumbai

yanmaneee said...

kate spade handbags
hogan outlet
michael kors outlet
nike foamposite
christian louboutin shoes
air max 97
yeezy
kobe shoes
fila
nike air vapormax

Unknown said...

Contin meilleures répliques de sacs de créateurs site utile portefeuilles de répliques apprendre ceci ici maintenant répliques de sacs de haute qualité