[manisiva2002]

Dear Views

I have a suitation like this :
At 12.00 i have taken Hot backup
At 12.20 i add a datafile to a tablespace
At 12.30 the system crashes.

Now can i recover the newly added datafile. If so How ?

And can any one explain how the Oracle gets crashed ?

Please mail me at manips15@hotmail.com.

With regards
MANI PS

[Hings]

Yes Dear Manisiva,

You can recover database because your database is in Archivelog mode. You can perform following steps...

(1) Shutdown Immediate. ( If not work then Shutdown abort.)
(2) Startup mount
(3) Recover Database (Using Auto Option)
(4) alter database open.

I guess this will help you out.

Thanks,

Hings...
============
Still Learning...

[clio_usa]

Oracle crashes when you have hardware, media or database failure.

In media failure the disk(s) or controllers fail and the data is unaccesible.

In hardware failure the MB, RAM, CPU, power suplly fail, and the instance is crashing.

In database failure, bugs or internal errors cause the instance to crash.


Hope that helps,

clio_usa
OCP - DBA