how to recover db 
Author Message
 how to recover db
Hi

We have a Disaster Recovery site and a online site.
How should I recover the db in case
the synchronization (in terms of hardware) between the sites fails
and I need to replicate the data from one site to another?

TIA

Jacinle



Mon, 13 Sep 2004 09:12:43 GMT
 how to recover db

There are a few ways to do this ........
1) maintain an identical production image at DR site and have the DB
in a rollforward pending state; ship archive logs from production and
rollforward DR db to the end of those logs.
2) have over-night/incremental/delta backups and then do a redirected
restore
3) have triggers over a federated db to the DR site
4) use DPropR in push-pull config to sync DR database
5) use disk mirroring/dist file systems, for eg HAGEO

lot of ways ....find the best one suitable for you shop !!

Quote:

> Hi

> We have a Disaster Recovery site and a online site.
> How should I recover the db in case
> the synchronization (in terms of hardware) between the sites fails
> and I need to replicate the data from one site to another?

> TIA

> Jacinle



Tue, 14 Sep 2004 00:31:37 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Urgent - How to recover DB via data files ?

2. Urgent advice needed - recover db with old mdf and new ldf

3. How to recover db after deleting transaction log

4. Trying to recover DB after system failure.

5. Pls help me recover DB from I/O Error 823

6. Backup/Recover DB data

7. LOG DEV destroy BUT DAT DEV exists. Recover DB ?

8. LOG DEV destroy BUT DAT DEV exists. Recover DB ?

9. How can I recover DB 1 hour before I made a update mistake?

10. DB Under Recovering for long time

11. Recovering db marked SUSPECT

12. Recovering from dead DB connection


 
Powered by phpBB® Forum Software