Create Oracle lite Database (odb) using olite Mobile Development Kit

Oracle Database Lite (olite) is small-scale database for small devices. Oracle Lite can be used in following two design patterns,

  1. You can configure olite database to Mobile client and use automatic synchronization feature of olite server to replicate data between mobile device and oracle database server.
  2. You can use an independent olite database with you mobile application.

Whatever way is used, the data in the mobile is stored in small mobile database files with ODB and OBS extension. ODB file contains data while indexes are stored in OBS file. In olite version, all objects are stored in ODB file. Continue reading “Create Oracle lite Database (odb) using olite Mobile Development Kit”

Archivelog mode concepts | Oracle Hot backup and cold backup

We take complete physical backup of database by copying physical database files including datafiles, control files, password file and parameter file. Backup can be online backup or offline backup. In online backup, our database is in open stage and datafiles have different SCN. Continue reading “Archivelog mode concepts | Oracle Hot backup and cold backup”

Oracle Database

Oracle Corporation is one of the leading IT companies at the moment. Oracle Corporation offers multiple software solution for almost all business areas. List of Products owned by oracle provide us a glint.
List of oracle products
This website will focus on Oracle Database. Oracle RDBMS is undoubtedly the most popular and widely used database. Oracle Database 10g and Oracle Database 11g are the hottest versions at the moment. will make an effort to cover following core and basic topics

  • Database Architecture
  • Backup and Recovery ( OS level and RMAN)
  • Performance and tunning
  • Flash back Features
  • Auditing & Scheduling
  • External tables and SQL Loader

Tasks will be performed using Oracle EM as well as CLI .