Re: fresh dba

From: BL <c50342182003_at_yahoo.com.hk>
Date: Sat, 13 Aug 2005 21:59:46 +0800
Message-ID: <ddl04r$2ji0$1@news.hgc.com.hk>

Hi .Thx.
Suppose the datafile /u01/ora8/oradata/datafile01.dbf is on disk1 which is failure, I can't replace that disk for some reason but need to recover the database.
I should:

1. start the database in "startup mount" mode
2. rename the datafile
3. use rman to restore and recover the datafile
4. open database

Correct?

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> ???????:bcrrf1lgpac7s4pr4maju5qq3rldmn5qkl_at_4ax.com...
> On Sat, 13 Aug 2005 19:47:59 +0800, "BL" <c50342182003_at_yahoo.com.hk>
> wrote:
>
>>Hi all,
>>
>>I am a fresh dba. I have a problem that if the database crash, what
>>procedures should I do?
>>1. try to "startup" the database again.
>>2. if "startup" failed, check what problems in the alert log file.
>>3. fixed the problem
>>4. try to "startup" again
>>
>>Am I correct?
>>
>>Thanks
>>Brian
>>
>>
> I would first investigate why it went down at all (usually surfaces in
> the alert log). If the system tablespace is damaged no need to even
> try to restart it. If there is any file corrupt, better take an O/S
> backup of your current situation, you may need to revert to it.
>
> --
> Sybrand Bakker, Senior Oracle DBA
Received on Sat Aug 13 2005 - 08:59:46 CDT