Oracle Spatial

as i said ,oracle spatial is wonderfull technologies for database system,whenever i heard that ,i feel this is big enginner thing.you may dont know about thing what is that?This system give the service about location base.Such as system keep several things on ground and people can see any change something.you may intrested about recognition system on image proccessing lessons,Oracle spatial maked kind of recognition.Exactly this is ground and location.

Certainly,in addition to if you like gis ,you must see that and feel because this is good news for gis enginnering.

New Oracle ACE

it is finnish .i was awarded Oracle ACE and  became oracle ACE ,it is honor for me and  this is my page in oracle ace  my ace profile .as i said  ”now focus on dijkstra algorithm”.

 

 

Compare Active dataguard and data guard

This article is very importan for understand what active dataguard and dataguard mean so if you read this ,you will better understand

http://blogs.oracle.com/stevenChan/2008/10/comparing_oracle_data_guard_vs_active_data_guard_f.html

LOCAL VS REMOTE Snapshot

i decided ,snapshot is too high system , If the conpany have big data on database so sonetimes DBA should immediate backup for database ,that time we thinking what will i happen? or what will i take? thats questions are true so we sould make this method.This method divided 2 parts

1.SNAPSHOT

1.a.REMOTE SNAPSHOT

1.b.LOCAL SNAPSHOT

1.a.a.SNAPSHOT MIRROR

1.a.b.COPY-ON-WRITE SNAPSHOT

1.b.a.SNAPSHOT MIRROR

1.b.b.COPY-ON-WRITE SNAPSHOT

Actually we thaught about this situation remote system is make foe disaster situation so DBA can control with outside by the way data is secure with this system.Dublicate image can become  at remote side.

Another side local side,local snapshot have data at local side,so you can connect with internal .Another important thing for side ,it is twice host for this situation ,some system use two host.

we will enter deeply but this is only begining

Block Change Tracking with Oracle

The last blog ,i wrote Block Change Tracking on oracle ,today i write about Block Change Tracking on oracle ,acttualyblock change tracking writer and blog change tracking link each other ,base on INCRIMENTAL UPDATE BACKUP this structure 10g feature.

BCTW is as notebook for incremantal update backup systems becuse this notebook is consist of every change segment on backup so database dont need copy %100 database .after days , i will explain Incremental Update Backups .Before i told another 2 statements for this systems .

Understanding CTWR…

CTWR(Change Track Writer) This is new options for database because that’s incremental update backup options one so this is missions very very important for database.Actually database can make a backup itself but that’ copy itself ,after that it can paste another disk ,this is basic method ,ctwr is important point for database because CTWR is capture every different part on disk so everytime database is not copy all of database ,only capture different parts on database .

Database backup confrontation with System Crashes

Always database not clearly work ,Every person want smooth system ,it is only imagine ,actual system is linear work .Today i was sharing about crashing problems on database.This is CRASH on DB.

Crash Reasons…

1.System powers problem

2.Server Controlless (reboot or other servers deficts)

3.Parallel executing other application program

4.others server problems

these are some problems but if system crash with these problems , persons can check the some constant with sqlplus…

First of all the person check datafile or backup files ,so person understand system active or not because if system is ACTIVE mode ,Tablespace is backupmode

this scripts …

SELECT a.name , b.status from v$datafile ,v$backup

WHERE a.file#=b.file# and b.status=’ACTIVE’;

referance:Oracle DBA Automation Scripts (Book)

http://www.informit.com/articles/article.aspx?p=30348 (Article)

oracle 11g Release 2

Today Oracle 11G r2 is new beginig ,this version for linux new generation types,so almost Oracle could  every os

system

Today Oracle 11G r2 is new beginig ,this version for linux new generation types,so almost Oracle could support  every os .