Presentation from OUGN 2010 available

2010/04/21

The presentation and the supporting report for my “Rails as a back-end processor for Apex” presentation at OUGN are now available for download.  Please let me know if you have any comments.


OUGN vårseminar 2010 og Oracles best bevarte hemmelighet

2010/04/19

Oracle User Group Norway (OUGN) avholdt sitt årlige seminar på Kielferga Color Magic 14.-16. april. Fra Senitel deltok Vidar Andersen og undertegnede. Vi ønsket å skape mer blest rundt Oracle Application Express (Apex).  Det ser ut som Apex på mange måter er Oracles best bevarte hemmelighet. Strategien er vekselvis å ikke snakke om det, og å snakke det ned: “Ja du kan jo bruke Apex til enkle applikasjoner, men for skikkelig greier, da … “. Bakgrunnen for dette er selvsagt at det ikke er noe ekstra penger å hente for Oracle dersom en kunde velger å bruke Apex. Velger man derimot ADF/Java så tvinger det i det minste frem en applikasjons-server lisens.

Vi er overbevist om at Apex er ett av de absolutt beste utviklingsverktøyene for Oracle applikasjoner til web. Få andre rammeverk gir tilsvarende robusthet og smidighet. Med Apex kan små utviklingsteam lage avanserte applikasjoner på svært kort tid. Applikasjonene kan utvikles i korte og effektive iterasjoner, det er gode muligheter for å bruke smidige metoder som Agile eller XP. Vi anbefaler alle å ta en kikk på Apex. Det gjelder spesielt for de som allerede kan PL/SQL, da er du allerede mer enn 50% på vei til å beherske Apex.


Restore again

2010/04/08

A few weeks ago I wrote about Oracle backups and restore/recovery. A company called “DRS” for the sake of anonymity was mentioned. They are still struggling with the (test) restore and recovery of a Windows based Oracle server.

My company has started to take a serious look at this field (cloud backups that is). We have initiated a search for a suitable partner that can provide the infrastructure needed for such services. Recent events have led us to believe that hosting infrastructure should indeed be handled by experts. By that I mean expert in every sense of the word: highly skilled/experienced  and works only/mainly with … The former is just as important as the latter. I sometimes meet people that work only with one technology/product; they automatically assume that this makes them experts.

We want to create a service for backing up Oracle databases. It will use the native backup utilities for creating local backups. These backups will be available for regular restore and recovery operations. In addition, they will be transferred (encrypted and compressed) to a remote site. The encryption key will only be available at the client site, making it safe to store backups from several customers on the same backup server.  Initially this will be a pure off-site storage solutions, future versions will have the ability to perform test restore/recovery operations at the site of the remote backup. The ultimate goal is to create a full disaster recovery solution for small and medium sized businesses.

In future posts I will describe the technical solution in more detail. Specifically; I will discuss bandwidth requirements, Oracle features needed and how to seed the backup with the help of removable media.