My Writings

Archive for the ‘Oracle’ Category

31 Aug, 2010

The RMAN dilemma

Posted by: Mark In: Oracle

We have a generic RMAN script that backups up most of our database, however we noticed that on one day one of the servers archive logs was increasing in size and after some investigation we found the following issue.
The Problem
RMAN> print script full_disk_disk_backup;
printing stored global script: full_disk_disk_backup
{sql ‘alter system archive log current’;
sql ‘alter database backup [...]

22 Aug, 2010

Oracle Database Downgrade?

Posted by: Mark In: Oracle

Recently I upgraded a database from 10.2.0.3 to 11.1.0.7 however after testing, the customer found that their application wasn’t performing well under the new version. They had a number of other tasks on so they asked me to downgrade them back to the 10.2.0.3 version. These are the steps I took to successfully take them [...]

28 Jan, 2010

Oracle RMAN

Posted by: Mark In: Oracle

End
RMAN Guide for Oracle Real Application Clusters 10gR2;
A short guide to backup and recovery using RMAN in RAC 10gR2
RMAN is a utility that backs up, restores, and recovers Oracle databases. It can be used with or without the central information repository called a recovery catalog. If a recovery catalog is not used, RMAN uses the [...]



  • admin: 1 Thai Baht = 0.32 US Cents
  • Michelle: What do prices mean in US$ ?
  • admin: We haven't been back to that Bar for some time, we felt we got ripped off and Greg wasn't keen to go back. I might pop up and take a photo for you tod

About

About me? Well what can I say. I currently work in the Oracle space for a multi billion dollar company, however my passion is Photography. I often spend the weekends taking pictures of stunning women.. I also enjoy travelling.

Thailand Countdown

  • Bangkok Trip:
    in 4 days, 6 hours, 58 minutes

My Current Location

Latest mapped location
01 Sep 2010

Google maps provided by Maps