Operating System - HP-UX
1748006 Members
4425 Online
108757 Solutions
New Discussion юеВ

Re: Lost all datafiles in Database Server!

 
Tung Dang
Advisor

Lost all datafiles in Database Server!

Dear All,
I have a big problem that all of our datafiles, archive files and backup directory was lost. The struture of our database directories is as following:
1)/PROD/oradata: store all datafiles
2)/PROD/oraindex: store all indexfiles
3)/PROD/system: store system tablespace datafiles
4)/PROD/archive: store archive log
5)/PROD/backup: store backup data
The problem is all files of oraindex, system, archive, backup directories were lost. The most of datafiles inside oradata still remain, lost some files and directory inside this directory.
When I checked the Oracle Alert logfile, the duration for the error is very short, it just happened from 15:13:24 to 15:13:27 (just 3 seconds) while all of losted file is around 1TB.
I worry that error is caused by losting matadata because nobody can remove 1TB with just 3 seconds.
Could you please help us to find out the reason
of the error and recomend us how to prevent that problem from happening again.
Thank you very much.
Tung
19 REPLIES 19
Yogeeraj_1
Honored Contributor

Re: Lost all datafiles in Database Server!

hi,

Can you confirm that the database is down?

Are there any errors at the OS level?
Are there any errors in your alert_.log?


revert

kind regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Kapil Jha
Honored Contributor

Re: Lost all datafiles in Database Server!

>>>it just happened from 15:13:24 to 15:13:27 (just 3 seconds)

Can you please tell me what is there is alert.log file in these 3 seconds.

And i suppose removing files does not take much time (well i have not removed such a huge files).
BR,
Kapil
I am in this small bowl, I wane see the real world......
Anshumali
Esteemed Contributor

Re: Lost all datafiles in Database Server!

Did someone try doing lvreduce on these LV's... it may be outcome of that as well.... if thats the case, you may still loose 3 TB in 3 Seconds.....
...Blind shot....
Dreams are not which you see while sleeping, Dreams are which doesnt allow you to sleep while you are chasing for them!!
Tung Dang
Advisor

Re: Lost all datafiles in Database Server!

Dear Sirs,
Thank you very much for your help.
The database down right after files were lost.
There is no errors in syslog.log, so that we can say nobody use lvreduce command.
Please check the attachment for the syslog.log and alert log file for more details.
Thanks and Regards,
Tung
Kapil Jha
Honored Contributor

Re: Lost all datafiles in Database Server!

Can you please send it again as text file or zip file....rar is not working :(
BR,
Kapil
I am in this small bowl, I wane see the real world......
Tung Dang
Advisor

Re: Lost all datafiles in Database Server!

Dear Kapil,
Sorry. I attach again in .zip file. check it please.

rgds,
Tung
Kapil Jha
Honored Contributor

Re: Lost all datafiles in Database Server!

m sorry sir....its not coming.Can you mail me on kapiljha@gmail.com

BR,
Kapil
I am in this small bowl, I wane see the real world......
Tung Dang
Advisor

Re: Lost all datafiles in Database Server!

Dear Mr.Kapil,
I try to attach this file again and send you also. Pls check it.

Tks,
Tung
F Verschuren
Esteemed Contributor

Re: Lost all datafiles in Database Server!

hi, there are no vmunix messages that normaly will pick out hartware messages, can you please post you syslog.conf to see it they are nomaly written to the syslog.log,
and the output of dmesg?