Hi,

Is it possible to create a Sequential dump of a table and users are in the system? Does anyone has design a disaster recovery process for BaaN IV C4, Oracle 8i Win2000?

Thanks

Technically it is possible to take sequential dump of table when users are in the system. But the sequential dump locks the entire table and users are not able to update the tables during the time the tables is being dumped . And this is big concern for big transaction tables. So practically it is not possible to take sequential dump when users are in the system.

There could be many approaches to disaster recovery like
oracle stand-by server with another oracle instance in read only mode or online replication using oracle utilities or OS approach using win2k replication capabilities or using baan tabledef6.1 approach .

Though Baan tabledef6.1 approach is considered unsafe compared to other approaches , we have used this approach and we are running it successfully since 7 months without any problems.

You need to take care off dictionary separately in order to be able to online program script / object /dictionary etc replication. U may see these thread as a reference.

Online replication of file system objects (http://www.baanboard.com/baanboard/showthread.php?s=&threadid=10551)