OK -- so first things first -- thanks to all who answered, but VERY ESPECIALLY: John Eisenschmidt (who was up answering emails at midnight UST-5 for me) Erwin Fritz (who was supportive and helpful all the way through) and Michael Connolly (who was also supportive and helpful) oh yeah -- and John O'Reilly who was the first to answer with an out of office reply <grin> After having worked on getting the DBs recovered for most of the night, sat down with the DBAs first thing the next morning, and we decided that we'd need to go the 'hard' way. Oracle support didn't give us much hope of getting the configurations back, so I was forced to restore from backup (something about control and redo logs being too far out of sync?) -- which didn't work (turns out whomever devised the backup schedule didn't use bpstart_notify and bpend_notify to stop and start the database, so a year's worth of backups were hot backups that didn't want to restore either.... <sigh>) We wound up going the 'really' hard way and re-building the whole thing from scratch... very icky, but we're back up and running now, and we're aware of the GIANT hole in our backup schema... sorry it took me so long to summarize, but it's been a wicked long week, and we've JUST gotten back to usability. Lessons learned: 1) check your fiber cables when you connect to a new SAN 2) keep the local disk active for a couple of days as a mirror, just to make sure 3) stop your Oracle database before you try to back it up... (we're implementing Veritas File System snapshots effective tonight) 4) don't trust in other people's work when you take over systems 5) this group ROCKS! I can't believe the help I got! Thanks again to all, and hope you never have to do the same thing, and if you do have to do it, I hope that John, Erwin, and Michael are online for you! later! toph topher originally said: This is in the VAGUE hope that there's a Oracle DBA out there in this group -- no one else has been helpful so far. I'm SO not a DBA, but I'm just trying to exhaust all the options before I wind up doing more work than necessary. (and yes, for those of you who are saying 'why doesn't he restore from backup', that's the 'more work than necessary I'm looking at -- I hate to restore if there's any chance of getting what we've got to work again.... DBA I'm not, Admin with backups, I am) Backstory: Migrated local disk to SAN disk (all on Veritas Managed disks) -- for whatever reason there was a fiber problem, and I lost disk connectivity (course the database files were on the new SAN disk for better performance, right...) anyway, short story long, wound up rebooting and reattaching the disks -- now I'm trying to bring up the Oracle database and having all kinds of issues.... Problem Indicators: Please assume that I'm not all that interested in keeping the DATA in the database (it's for dev boxes and gets refreshed pretty frequently anyway) -- but I WOULD like to keep the users and passwords and such. here's the error from the startup: SVRMGR> Connected. SVRMGR> ORACLE instance started. Total System Global Area 284246176 bytes Fixed Size 73888 bytes Variable Size 126705664 bytes Database Buffers 157286400 bytes Redo Buffers 180224 bytes Database mounted. ORA-01589: must use RESETLOGS or NORESETLOGS option for database open SVRMGR> and here's the information from the 'svrmgrl': $ svrmgrl Oracle Server Manager Release 3.1.7.0.0 - Production Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved. Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production With the Partitioning option JServer Release 8.1.7.0.0 - Production SVRMGR> connect internal Connected. SVRMGR> recover open ORA-00274: illegal recovery option OPEN SVRMGR> recover ORA-00283: recovery session canceled due to errors ORA-01610: recovery using the BACKUP CONTROLFILE option must be done SVRMGR> recover using backup controlfile; ORA-00279: change 108128475 generated at 07/29/2002 14:13:50 needed for thread 1 ORA-00289: suggestion : /opt/oracleloc/dbs/arch1_464747.dbf ORA-00280: change 108128475 for thread 1 is in sequence #464747 Specify log: {<RET>=suggested | filename | AUTO | CANCEL} ORA-00308: cannot open archived log '/opt/oracleloc/dbs/arch1_464747.dbf' ORA-27037: unable to obtain file status SVR4 Error: 2: No such file or directory Additional information: 3 SVRMGR> now I wouldn't know a 'backup controlfile' if it bit me -- so if you have a thought on what one of those is, or how best to find it, I'll take that as an option.... Like I said, it isn't the data that's important, so I could care LESS if the redo logs get run, I just want to keep the structure of the environment. More than happy to answer any further questions, or try just about anything at this point -- it's broken now, so there's not much we can do to break it more (at least as the 'oracle' user). Thanks again for any help -- and no grudges to anyone who needs to tell me this isn't an Oracle group! toph - -- Phrases of Wisdom...... - ----------------------- If you're too open minded, your brains will fall out. _______________________________________________ sunmanagers mailing list sunmanagers@sunmanagers.org http://www.sunmanagers.org/mailman/listinfo/sunmanagersReceived on Thu Aug 1 18:34:25 2002
This archive was generated by hypermail 2.1.8 : Thu Mar 03 2016 - 06:42:50 EST