OER D/L

Hello All,

Can we do dump and load on OER server and later-on apply the same on live server, below activities are for the same:
  • Dump and load database on OER server (including type conversion).
  • Stop Live DB after dump/load completed and apply all live ai (al-roll forward) files on OER server.
  • Recreate/restore live database with latest backup of OER server.
We can minimize live downtime with this approach but what all seniors we should consider while doing so, kindly provide your supervision on the same.

Regards,
 

Cringer

ProgressTalk.com Moderator
Staff member
If you dump and load it breaks Replication and you'll have to reseed it using a -REPLTargetCreation backup from Production.
 
Hello Cringer, thanks for your reply.

Yes, OER breaks during this activity and we will recreate it once all done. Please give your views on above approach.

Regards,
 

Cringer

ProgressTalk.com Moderator
Staff member
My apologies - I misunderstood what you are trying to do. You will not be able to apply the live AI files to the databases on the OER server. It's just not possible.

Depending on your Progress version and license, there are 2 main ways of doing a dump and load:

1) Dump and Load on the live server, using methods to reduce the time such as concurrent dump files, loading the data on the new DB as soon as it's dumped rather than waiting for it all to be finished before starting the load. If you have a reasonably modern Progress version then there's quite alot of things you can do to improve the performance of this. In particular the index build. When you build your new database have all the indexes inactive, then do an idxbuild right at the end to activate the indexes. This is far quicker than loading the data with active indexes.
2) Use Change Data Capture. This requires additional licenses unless you are using Advanced Enterprise RDBMS. The White Star Software guys showed at EMEA PUG Challenge that it's possible to do this with very minimal downtime indeed. (Just make sure you bring your sequence values across)

What size is the database you are wanting to dump and load?

The key to all of this is testing though, whatever method you use.

And make sure you compare a tabanalys of the old and the new databases to make sure you have brought all the records across!
 
Hello Cringer, database size is around 800 GB.

Hello Tom, thanks for your reply. I meant by, type-1 to type-2 storage area during this dump/load.

Regards,
 
Top