From: topher (topher@findtopher.com)
Date: Mon Jul 29 2002 - 22:03:51 EDT
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
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.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: Processed by Mailcrypt 3.5.6 and Gnu Privacy Guard <http://www.gnupg.org/>
iD8DBQE9RfQAMee5Z1qzrBERAoSNAKCIhCwccQYdK688D5fpSYM5IksmwQCeJf0d
IhV7cAtnEN0Slox+OqqRSpw=
=kTgX
-----END PGP SIGNATURE-----
_______________________________________________
sunmanagers mailing list
sunmanagers@sunmanagers.org
http://www.sunmanagers.org/mailman/listinfo/sunmanagers
This archive was generated by hypermail 2.1.7 : Wed Apr 09 2008 - 23:24:40 EDT