Extract(Read) > Transform(Test&Apply) > Load(Learn) Blog

April 9, 2007

Becareful, availability must be your primary concern, always

Filed under: Oracle How To — H.Tonguç Yılmaz @ 8:15 am

NOARCHIVELOG DATABASE – WITHOUT BACKUP – REDO MEMBERS ARE NOT MULTIPLEXED and somehow one day the DISK WHICH HAS CURRENT REDO CRASHES..

Yesterday one of my best friends called me because of the above situation. Since he is a developer minded expert it was ok for me to help him, if he had a little dba profile I would never answer his calls :)

This one is of the worst situations you may experience, it is similar to making sex with someone you already know having hiv virus without protection, but with Oracle there is always hope! Below is the support message of Oracle, it is like a doctor bringing someone back to life after some minutes of death on the operation table;

Code listing 75 : “_ALLOW_RESETLOGS_CORRUPTION” and EVENTS 10015 example

So please forget tuning, development etc. and immediately check this post for the basic backup and recovery needs like ARCIVELOG MODE-MULTIPLEXING REDO and CONTROL FILES-RMAN BACKUP, even it may be your local XE test database!

1 Comment »

  1. Tonuç abi betimlere bittiğimi belirtmek istiyorum:)
    Ben olsam developer bile olsa yardım emezdim :) Sonuçta IT alanında biri açlışıyorsa yedekleme ve dolaylı olarak veri güvenliği olayından bir haber olmasını , yada ALLAHA emanet gidiyoruz yaklaşımını asla kabul etmem.

    İster milyonlarca kişinin kaydının bulunduğu bir veri tabanı olsun ister ufak bir not yazdığımız text dosyası olsun eğer içindeki veri bizim için önemliyse ve kaybını telefi etmek astarındna pahalıya gelecekse onu yedeklememek boğaz köprüsünden atlayıp ölmemeyi beklemek gidir.

    Kolay gelsin

    Comment by ibrahimdemir — April 16, 2007 @ 6:08 pm | Reply


RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Create a free website or blog at WordPress.com.

%d bloggers like this: