| datagaurd configuration [message #504069] |
Thu, 21 April 2011 07:12 |
 |
sri6885
Messages: 5
Registered: April 2011
Location: hyderabad
|
Junior Member |
|
|
Hi ALL,
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
