- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Lost all datafiles in Database Server!
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-07-2007 03:28 AM
тАО12-07-2007 03:28 AM
Re: Lost all datafiles in Database Server!
Thanks for your help.
The attachment is the syslog.conf and dmesg.log. Pls check it.
Thanks and Best Regards,
Tung
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-07-2007 03:29 AM
тАО12-07-2007 03:29 AM
Re: Lost all datafiles in Database Server!
This is the syslog.conf.
check the attachment pls.
Tung
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-07-2007 03:54 AM
тАО12-07-2007 03:54 AM
Re: Lost all datafiles in Database Server!
ioscan -fnC disk
ioscan -fnC fc
and vgdisplay -v
to check all the disks that are configured are still availeble.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-07-2007 04:11 AM
тАО12-07-2007 04:11 AM
Re: Lost all datafiles in Database Server!
based on the messages in your alert.log, it seems that the /CCBS2DB/ mount point is missing.
where is this mounted?
do a cat /etc/fstab to get more information.
revert
kind regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-09-2007 06:50 PM
тАО12-09-2007 06:50 PM
Re: Lost all datafiles in Database Server!
Thank you for your help.
We are currently using SAN environment with EVA8000, and configuring these volumn group in cluster. The briefly configuration as following:
/dev/vd09/lvol1 /CCBS2DB/backup
/dev/vd01/lvol1 /CCBS2DB/oradata1
/dev/vd01/lvol2 /CCBS2DB/oraindex1
/dev/vd01/lvol3 /CCBS2DB/system
/dev/vd03/lvol1 /CCBS2DB/archive
At the time the problem happened, I used bdf I saw all of these mountpoint still remain, but the "used" of /CCBS2DB/backup, /CCBS2DB/oraindex1, /CCBS2DB/system and /CCBS2DB/archive were 0%; and the "used" of /CCBS2DB/oradata1 was seemly normal. It means that all the directories were still remain, just lost the files and directories inside it.
Now I recovered the database from tape already, and the system run normally. So I think that ioscan and vgdisplay this time do not help us to find out the cause of the problem. If you still want to look it, let me know.
I want to know the root cause of the problem in order to prevent it happen again.
Thank you very much.
Tung
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-10-2007 01:10 AM
тАО12-10-2007 01:10 AM
Re: Lost all datafiles in Database Server!
Just one though about discovering what happened:
Login as root and do some "Esc+K" to check the root shell history.
Best Regards,
Eric Antunes
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-10-2007 01:13 AM
тАО12-10-2007 01:13 AM
Re: Lost all datafiles in Database Server!
I doubt it will work. I hope root command's history isn't logged by default.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-10-2007 01:40 AM
тАО12-10-2007 01:40 AM
Re: Lost all datafiles in Database Server!
vi $HOME/.sh_history
vi
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-10-2007 06:09 PM
тАО12-10-2007 06:09 PM
Re: Lost all datafiles in Database Server!
I checked .sh_history already, and there was no any "rm" or "lvreduce" command related with this problem.
Rgds,
Tung
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-10-2007 09:40 PM
тАО12-10-2007 09:40 PM
Re: Lost all datafiles in Database Server!
sorry for late reply....
There is nothing in alert files they direct up to some unix error.
Error: ORA 1171
Text: datafile
-------------------------------------------------------------------------------
Cause: The checkpoint in the file header could not be advanced.
See accompanying messages for the reason.
The datafile will be taken offline the same as for a write error of a
data block.
Action: See accompanying messages for details.
Restore access to the file, do media recovery, and bring it back
online.
ORA-01115: IO error reading block from file string (block # string)
Cause: Device on which the file resides is probably offline
Action: Restore access to the device
in syslog file some FTP activity was there at the time of crash
Dec 5 15:13:24 COVIS2 ftpd[27915]: USER oss
Dec 5 15:13:24 COVIS2 ftpd[27915]: PASS password
Dec 5 15:13:23 COVIS2 ftpd[29657]: PWD
Dec 5 15:13:24 COVIS2 above message repeats 29 times
Dec 5 15:13:24 COVIS2 ftpd[27915]: FTP LOGIN FROM 10.1.103.31 [10.1.103.31], oss
Dec 5 15:13:24 COVIS2 ftpd[27915]: TYPE ASCII
Dec 5 15:13:24 COVIS2 ftpd[27915]: CWD /ccbs2/stats_raw/
Dec 5 15:13:24 COVIS2 ftpd[27915]: PORT
Dec 5 15:13:24 COVIS2 ftpd[27915]: NLST
Dec 5 15:13:24 COVIS2 ftpd[27915]: QUIT
Dec 5 15:13:24 COVIS2 ftpd[27915]: FTP session closed
Dec 5 15:13:24 COVIS2 ftpd[29657]: PWD
Dec 5 15:13:54 COVIS2 ftpd[28809]: cannot stat private access file /etc/ftpd/ftpgroups: No such file or directory
From oracle error I suppose there was some hardware error but it is strange that only files were deleted not directories.
I would suggest to open a case with HP that would be good because its not a small issue.
BR,
Kapil
- « Previous
-
- 1
- 2
- Next »