SUMMARY: Solaris 8 / Oracle 8

From: topher <topher_at_findtopher.com>
Date: Thu Aug 01 2002 - 18:26:51 EDT
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/sunmanagers
Received 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