Hemant Corrupted archivelogs. Interesting. Just yesterday I was trying to point out to someone on this list that having only weekly backups can leave you vulnerable to this sort of thing. Not that it is the end of the world, I've had production systems in that configuration, but the business users need to understand the vulnerability. I'm not sure if I was completely convincing.
Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> -----Original Message----- Sent: Thursday, August 14, 2003 12:44 AM To: Multiple recipients of list ORACLE-L I do have PTC Windchill running at my site. The first thing I did when the database was "handed over to IT Operations" was to switch to ARCHIVELOG. [A year later, we had some problem with the I/O controller which corrupted the online archivelog file and also some of the files in the HotBackup-to-Disk. I had to restore the database from the previous night's backup and reapply the archivelogs till the last good archivelog. Potentially, we lost some data !] As per the Site Info document that was provided by the Parametric consultants who did the implementation, we are running WindChill 5.0 which is NOT certified with 8.1.7. Yes, we are still running 8.1.6 The Windchill installation create's its own ORACLE_HOME and datafiles in a "database" directory under the ORACLE_HOME. {A side note : Plumtree, BlueMartini and TivoliIdentityManager also create datafiles under $ORACLE_HOME/database or $ORACLE_HOME/dbs ! At least for these implementation, I am involved before they go live and either the consultant modifies the script to create the datafiles in the location I specify or I shutdown the database after the application installation and relocate the datafiles !} Hemant K Chitale --- "M.Godlewski" <[EMAIL PROTECTED]> wrote: > Thanks Rich! > > I'm hope the product does support archive log mode. Could make for > some creative backup plans otherwise. > > "Jesse, Rich" <[EMAIL PROTECTED]> wrote: > I can't comment on the product itself since I've never used it. > Strictly > speaking from the DB end of Windchill, ignore most of what PTC says > about > setting up Oracle. It's a bare bones install with no tuning > whatsoever. > The Oracle software comes as a fixed, non-patchable, non-OFA > version. The > default DB setup puts all files on the same mountpoint as the > software. I'm > trying to remember if archivelog mode is suported or not (yes, you > heard > that correctly). It may depend on if there's external vaulting or > not. > There's no RI in the schema. This has been my experience with most > vendor > product implementations on Oracle. Hopefully, I'm remebering this > correctly! > > This being said, I've not touched the production DB for tuning or > downtime > since I created it back in October. After the software was installed > (which > also installs their version of Oracle and the DB) and re-installed > several > times prior to production, we moved the DB to a proper 6-way RAID 10 > (or is > it 0+1? I forget) and some smaller mirrored stripes, splitting up > data from > control from redo from archive, and all's been well WITH THE DB ever > since. > I used what I consider "standard" items in the init.ora (CBO, > archivelog, > etc) and haven't needed to tune it. I haven't even (yet) needed to > apply > Tim Gorman's optimizer index parameter fixes. The only thing I've > needed to > watch for is the growth of the LOBs. YMMV! > > Also, our account rep has been VERY receptive in our feedback, and > they are > using some of our suggestions in versions since (and for other > customers). > I'll give them credit for that. > > One final note: Not every place is going to have a dedicated DBA. > Most > vendors that I've dealt with want to set things up in a simple > generic > fashion, probably in an effort to reduce initial problems. I think > that may > be a little short-sighted in some cases, as I think performance is a > major > cause of support calls ("The system's slow") and can be very > difficult to > correctly troubleshoot and remedy remotely a year or two after > implementation. Just my $.02 on that... > > HTH! GL! :) > > Rich > > Rich Jesse System/Database Administrator > [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA > > > -----Original Message----- > Sent: Wednesday, August 13, 2003 9:14 AM > To: Multiple recipients of list ORACLE-L > > > We are planning to install and test a product called PTC Windchill. > Has > anyone used this software? Is there any gotchas with it? > > TIA > M. > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Jesse, Rich > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like > subscribing). > > > > --------------------------------- > Do you Yahoo!? > The New Yahoo! Search - Faster. Easier. Bingo. Hemant K Chitale http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
