Okcan Yasin Saygili's Blog

November 15, 2009

Database backup confrontation with System Crashes

Filed under: database — yasinsaygili @ 3:46 pm

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)


Leave a Comment »

No comments yet.

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: