- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Oracle 10g and database corruption with hard shutd...
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
тАО09-14-2005 03:26 AM
тАО09-14-2005 03:26 AM
I have a question regarding Oracle 10g. Back in the day, if Oracle was not shutdown properly before powering off a server, you ran a good chance of database corruption. I was wondering if that is still the case for 10g. THe reason I am asking is that we recently had a power-outtage. When the UPS got low, I shutdown the databases and servers properly. A collegue feels that we should just let them run until the power just shuts off and therefore bringing the systems and database down hard. He feels that Oracle is mature enough at 10g that there will not be any corruption. Any thoughts?
Thanks,
SD
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-14-2005 03:31 AM
тАО09-14-2005 03:31 AM
SolutionPete
Pete
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-14-2005 03:33 AM
тАО09-14-2005 03:33 AM
Re: Oracle 10g and database corruption with hard shutdown
Just some thougths.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-14-2005 03:34 AM
тАО09-14-2005 03:34 AM
Re: Oracle 10g and database corruption with hard shutdown
I would most definitely NOT want to just pull power on a machine. If you have the time, and it is possible, I would VERY HIGHLY RECOMMEND shutting the database down clean first.
If you just pull the plug, there is a risk of corruption especially if someone was in the middle of something when the system goes down.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-14-2005 04:00 AM
тАО09-14-2005 04:00 AM
Re: Oracle 10g and database corruption with hard shutdown
Oracle can recover by itself.
When you start the instance Oracle will roll back uncommitted transactions and roll forward the committed one. If you run a shutdown abort and then re-start the database check the alert log file for these messages.
Saying that if you know your server is to be brought down you should bring them down in a clean way.
Regards
Jean-Luc
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-14-2005 04:21 AM
тАО09-14-2005 04:21 AM
Re: Oracle 10g and database corruption with hard shutdown
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-14-2005 05:44 AM
тАО09-14-2005 05:44 AM
Re: Oracle 10g and database corruption with hard shutdown
In long, he's right in almost any case, with exception to for example a delaylog-mounted filesystem on a disk with immediate_report=1 in combination with san connectivity loss [think HP-UX+FC-AL+FC4500 and add tresspassing] leading to hang of the sdisk driver, leaving to lost unflushed data.
These things *can* and *do* happen, and it's never, ever wise to risk data. someone is paying him for keeping the data safe, and he recommends the very opposite.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-14-2005 06:07 AM
тАО09-14-2005 06:07 AM
Re: Oracle 10g and database corruption with hard shutdown
But its our jobs as sysadmin's to make sure it NEVER happens.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-14-2005 07:07 AM
тАО09-14-2005 07:07 AM
Re: Oracle 10g and database corruption with hard shutdown
Sure Oracle can usually recover by itself, but do you really want to pur yourself and your company through all that hassle the ONE TIME that it didn't? Especially when you've got time to shutdown first? The costs of failure are way too high (for you and your company) when the cost to avoid is so small, even when the risk is low.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-15-2005 04:42 PM
тАО09-15-2005 04:42 PM
Re: Oracle 10g and database corruption with hard shutdown
I agree with john above, for sure Oracle will do automatic recovery BUT is your organisation ready to take the risk of any data corruption possibility (1 in a million maybe)? I sincerely believe that you should be able to provide a more scientific solution to your organisation.
I would never go for an easy solution with High risks! ( for sure Oracle would not recommend what your collegue "feels" ok)
Don't go for Hearsays! look for documentary proofs (if any)
good luck!
kind regards
yogeeraj