Home » Server Options » Data Guard » datagaurd configuration (10.2)
datagaurd configuration [message #504069] Thu, 21 April 2011 07:12
Messages: 5
Registered: April 2011
Location: hyderabad
Junior Member

I am working on physical standby

i configure listener.ora with 1521 port and sid as "prod"

i configure tnsnames.ora with two as prod(on host1) and prod_standby (on HOST2) with 1521 port no

Took cold backup

created standby controlfile as '../../../coldbkp/std_con.ctl';

set the parameters at primary

created the directory to store coldbkp on standby

sent the db files and init<db_name>.ora to standby

configure the listener and tns

moved init<db_name>.ora to init<standby_db_name>.ora and edited

set the parameters(here small doubt either we have append the parameters of standby side to the exisiting configuration parameters of primary or delete primary DG configuration parameters)

created the dirctories to stroe bdup,udump,cdump,db files,logfiles,and controlfile and archivelog files and moved it from backup at standby side

password files created

started the standby db in nomount

alter database mount standby database

alter database recover managed database

and then from primary side i check the log sequence it is 101

and i perform log switch 3 times on my primary now log sequence

is 104 and from standby side i press control+c to come out of the recovery (above command) and i check the archives in archive destination of standby but i dint get those archives in the archive destination of standby

this means what is that physical standby performed correctly
Previous Topic: Error while connecting standby database
Next Topic: DG
Goto Forum:

Current Time: Mon Oct 02 19:32:49 CDT 2023