var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
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 firstname.lastname@example.org.
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.
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,
OCP - DBA