- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Reducing downtime for database patching
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
тАО07-01-2003 04:47 AM
тАО07-01-2003 04:47 AM
Re: Reducing downtime for database patching
i think that you answered by yourself the question.
If the patch changes schema and objects, you must get your downtime.
You can save time with the ricompilation, recompiling it on a second server with the exact same patch level, software and so on, and finally reporting it.
But with the oracle db... no way.
unless you can export/import data, but if your db is large, you get no advantage.
Massimo
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-01-2003 05:32 AM
тАО07-01-2003 05:32 AM
Re: Reducing downtime for database patching
maybe you can consider having the database as read-only during the time you are installing the patch...Users being able to query, run reports etc...but no insert, update, deletes.
BTW, installation of patch did not take that much time on my RP5430 - less than an hour. The patch will never update your own data! only Oracle data...
regards
Yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-01-2003 05:53 AM
тАО07-01-2003 05:53 AM
Re: Reducing downtime for database patching
Yogeeraj I'm not completely with you regarding the read-only mode during an patch, for many reasons.
You are absolutely right that oracle modifies only its data (the dictionary), and not the user data, but:
- oracle requires access to the database in read/write mode, to change the data dictionary;
- oracle requires esclusive access to the database;
- if a user issue a query involving system tables, i think the result is not straightforward;
Massimo
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-02-2003 08:19 AM
тАО07-02-2003 08:19 AM
Re: Reducing downtime for database patching
You want to patch oracle while the production database is running!
I think you have to bite the bullet and take an outage.
For small patches - take the db off line and do it then.
If the "patch" is an upgrade - then you build the new version take the production db off line and do an export and import it into the new version - no getting around it.
As others have mentioned - test all this first on a different server.
One thing we are doing to shorten outages is to "split" our production database into parts - multiple databases. Our application just wants data - doesn't care where it is stored. Our total upgrade time is longer, but it can be done in smaller chunks. Instead of one very long outage, we have a series of scheduled shorter ones.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-02-2003 09:52 AM
тАО07-02-2003 09:52 AM
Re: Reducing downtime for database patching
Thanx again.
Clara
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-07-2003 04:11 AM
тАО07-07-2003 04:11 AM
Re: Reducing downtime for database patching
I don't know what your application is like, but I did this.
I let everyone know that any data entered after Wednesday would have to be "redone" in the new version. I made a copy of the production system Wednesday night onto a test server and pointed everyone at that. This let them run reports, etc., while I worked on the production upgrade. I had already done test runs and had all my scripts and stuff ready to go. I think we had production back online on Tuesday. Upgrading the Oracle Financial application was quite involved back then and this was the only way to do it.
Just one more idea for you to consider - good luck!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-07-2003 05:29 AM
тАО07-07-2003 05:29 AM
Re: Reducing downtime for database patching
I appreciate your help.
Clara
- « Previous
-
- 1
- 2
- Next »