Oracle eBusiness Suite Virtual Application Tier

Recently I have been involved in a number of cases where the topic of virtualising the Oracle eBS R12 applications tier has been on the agenda. In all cases the target deployment has been on x86_64 infrastructure (combination of blades and stand alone servers) so the virtualisation platform considered has been either VMware or Oracle VM.

Beyond the obvious known benefits of deploying the applications tier – and where relevant the database tier – on virtual infrastructure one additional benefit that does not seem to receive attention is the ability to provision specific applications components to specific servers.

Mark Burgess has been helping organisations obtain the maximum value from their data management platforms for over 20 years. Mark is passionate about enabling secure, fast and reliable access to organisations data assets.

Oracle RMAN Backup of Read Only Plugged-In Tablespace

Oracle RMAN Transport Tablespace Backup Limitations

Oracle RMAN backup of transportable tablespace has a number of limitations for Oracle 10g. Oracle Transportable Tablespace allow for the efficient movement of large volumes of data between Oracle databases. On the whole this works well and once setup is far more efficient data than processing through database links.

What probably is not widely known is that Oracle RMAN in Oracle Database 10gR2 seems to have some difficulty with backup of a plugged in read only tablespace (the default state for a tablespace that is plugged in using transport tablespace).

There are two issues with using Oracle RMAN for backup on 10g when you have plugged in read only tablespace’s that have not been set to read write:

  • RMAN will not backup the datafile’s for the plugged in tablespace.
  • RMAN will not report the datafile’s as part of the ‘report need backup’ or ‘restore database preview check read only’ commands either.

Mark Burgess has been helping organisations obtain the maximum value from their data management platforms for over 20 years. Mark is passionate about enabling secure, fast and reliable access to organisations data assets.

Managing SQL Query Time using Oracle Database Resource Manager

Session Control with Oracle Database Resource Manager

The Oracle Database Resource Manager (DBRM) provides a wealth of functionality to control what user workloads are able to consume server and database resources. I have recently used the DBRM to provide the following functionality to the application:

  • Provide the ability to limit the duration of reports that are run through the DBMS_SCHEDULER.
  • Provide the ability to cancel and/or limit the duration a query submitted from the application user interface can run.

Mark Burgess has been helping organisations obtain the maximum value from their data management platforms for over 20 years. Mark is passionate about enabling secure, fast and reliable access to organisations data assets.