DB2 HADR Setup (Use when Databases Lose Connectivity or to Resynch Logs)
1. On the primary server issue:
db2 stop hadr on database icmnlsdb
2. On the primary server:
db2 BACKUP DATABASE [database] TO "/cm/dbfs/lsbak/offline/full" WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 COMPRESS WITHOUT PROMPTING
Note: Document DB Backup Timestamp ICMNLSDB.0.db2inst1.NODE0000.CATN0000.20080320232702.001
3. FTP backup file to [standbyserver]:/cm/dbfs/lsbak/offline/full
4. On the standby server:
db2 restore database [database] from "/cm/dbfs/lsbak/offline/full" taken at 20080320232702 replace history file without rolling forward
Note: Timestamp = 20080320232702
There should be no need to change any other HADR parms as they should be maintained.
No comments:
Post a Comment