Quote:
Originally Posted by *******1
My biggest question following everything out there was this? How do you set your HADR settings on a database without making your clone or backup database Active. Of course if you make your database active, such as after a restore by rolling forward your logs, Stupid HADR says you cant activate HADR on an Active database. So just deactivate you may be thinking. Well I was also, but in my case this did nothing but waste time. A deactive database had no better luck than before.
|
You cannot initiate an HADR pair without a backup (or snapshot) of the primary database that is restored to the standby server and left in rollforward pending state. The reason for this is that both the primary and standby database must be using the same log chain, which means they must come from the same backup or snapshot.
Then you update the db conifig using the following syntax to make the HADR standby settings specific to the standby (which are different than the primary HADR settings:
db2 update db cfg
for <db-name> using PARM-NAME PARM-VALUE
Note that with the above syntax specifying the db name, you do not have to activate the database to run the above commands.