Author Archives: Norman

   Send article as PDF    In the previous instalment of this exciting series, we completed the full (complete) recovery of the database, tablespaces and data files, as well as looking at recovering individual blocks. In this article, we will … Continue reading →

   Send article as PDF    Locator is “Spatial Lite” if you wish, and costs nothing. It can be installed in Standard or Enterprise Editions with no additional licensing costs. You cannot do everything in Locator that you can in … Continue reading →

   Send article as PDF    It’s supposed to be installed by default, according to the documentation, but for some reason or another, I managed to build a brand new 11.2.0.2 database, on Linux, with no CTXSYS user present.

   Send article as PDF    When installing the Pro*C compiler stuff (technical term) from the 11.2.0.3 client install disc (it’s in zipfile 4 or 7 in case you need to know!) I hit a strange error almost immediately the … Continue reading →

   Send article as PDF    I’ve just created a new database on an HP-UX server. The database is Oracle 9i (yes, I know, I know!) and no matter what I do, I can’t connect via the listener without getting … Continue reading →

   Send article as PDF    In part 6 of this mini-series, I left you with a backed up database using RMAN to take hot backups. This episode looks at restoring and recovering from hot backups.

   Send article as PDF    Due to a document not being supplied to me recently, I built a few 11g databases with the wrong SID. I needed to change them all. I found a few web pages, Oracle and … Continue reading →

   Send article as PDF    In the past few instalments, I’ve looked mainly at databases running in NOARCHIVELOG mode. It’s probably not the best way to run a production system but it is valid to do so. For the … Continue reading →

   Send article as PDF    Previously in this mini-series, I managed to dump and recover a database from a cold backup. Before I move on to similar practices with hot backups, a few terms and observations may well be … Continue reading →

   Send article as PDF    Frits Hoogland’s post on how to clone your Oracle Home rather than installing from scratch. Nice!

   Send article as PDF    So far I have managed to dump and recover a database running in ARCHIVELOG mode. That is the most sensible mode for a production database and will be the case for the rest of … Continue reading →

   Send article as PDF    At the end of Oracle RMAN for Beginners – Part 2 I had created a few backups of the ant12 database. In this part, I explore how to trash a database and recover from … Continue reading →