Redo logs lost, old backups
HELP! I got hit with something or someone today and all the redologs for 2 of my production databases disappeared. I have no idea how, and will leave it to the SysAdmin to figure out what happened and how to prevent it from happening again. I am not in archivelog mode and normally take nightly cold backups. If at all possible, I need to recover these databases. The other problem is that my backup script was broken and (during my absence, I should never have taken a 2 week honeymoon!) no backups were taken. So, I'm working with 2 week old cold backup, and wondered if anyone knows a way (unsupported, of course) to recover the tablespaces that hold data with the old system datafile? I have tried all methods of recovery I could come up with to get the database to start without the logfiles, (using recover ... using backup controlfile, rebuilding controlfile) ... but always end up with a message that the system tablespace needs media recovery. I took a cold backup of the mess before I started tinkering with it, and I'm willing to try anything. Any ideas? The information contained in this email is intended for the personal and confidential use of the addressee only. It may also be privileged information. If you are not the intended recipient then you are hereby notified that you have received this document in error and that any review, distribution or copying of this document is strictly prohibited. If you have received this communication in error, please notify Celltech Group immediately on: +44 (0)1753 534655, or email '[EMAIL PROTECTED]' Celltech Group plc 216 Bath Road, Slough, SL1 4EN, Berkshire, UK Registered Office as above. Registered in England No. 2159282 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Maser, Donna (SEA) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: schema documentation
Marin, The new Q-Designer from Quest has saved me on this one. I used to HATE writing documentation, but not now! You can write really good (comprehensive and comprehendible!) html docs. Modification is easy, but the vanilla docs are quite good. - Donna -Original Message- Sent: Thursday, October 18, 2001 6:00 AM To: Multiple recipients of list ORACLE-L Hi, is anyone aware of a tool that will reverse engineer a database and generate appropriate documentation for it (i.e. tables, columns, column types, type definitions, package procedures,parameters, etc, etc) in fancy HTML (or something similar) OraSnap performs something like this (in the Database Objects section) but the output is not detailed enough (since this is not the goal of OraSnap) thanx, Marin When someone is seeking, it happens quite easily that he only sees the thing that he is seeking; that he is unable to find anything, unable to absorb anything, because he is only thinking of the thing he is seeking, because he is obsessed with his goal. Seeking means: to have a goal; but finding means: to be free, to be receptive, to have no goal. ... Herman Hesse, Siddhartha -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Marin Dimitrov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). The information contained in this email is intended for the personal and confidential use of the addressee only. It may also be privileged information. If you are not the intended recipient then you are hereby notified that you have received this document in error and that any review, distribution or copying of this document is strictly prohibited. If you have received this communication in error, please notify Celltech Group immediately on: +44 (0)1753 534655, or email '[EMAIL PROTECTED]' Celltech Group plc 216 Bath Road, Slough, SL1 4EN, Berkshire, UK Registered Office as above. Registered in England No. 2159282 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Maser, Donna (SEA) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: ER Diagram of a schema
I have recently been using the new QDesigner tool from Quest Software (think TOAD) and have been very happy with it. Reverse Engineering, Conceptual/Physical Data Models and some great reporting tools. -Original Message- Sent: Thursday, July 26, 2001 5:36 AM To: Multiple recipients of list ORACLE-L Hi guys, What queries to run on a schema to get info that would enable me to draw an ER Diagram of that schema ? Baiju The information contained in this email is intended for the personal and confidential use of the addressee only. It may also be privileged information. If you are not the intended recipient then you are hereby notified that you have received this document in error and that any review, distribution or copying of this document is strictly prohibited. If you have received this communication in error, please notify Celltech Group immediately on: +44 (0)1753 534655, or email '[EMAIL PROTECTED]' Celltech Group plc 216 Bath Road, Slough, SL1 4EN, Berkshire, UK Registered Office as above. Registered in England No. 2159282 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Maser, Donna (SEA) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Trigger on Create User
Hi Guys, I was hoping to use the new 8i triggers to prevent new users from getting assigned to the SYSTEM tablespace. Has anyone seen a way to build a trigger on a CREATE USER statement? Thx, Donna Maser The information contained in this email is intended for the personal and confidential use of the addressee only. It may also be privileged information. If you are not the intended recipient then you are hereby notified that you have received this document in error and that any review, distribution or copying of this document is strictly prohibited. If you have received this communication in error, please notify Celltech Group immediately on: +44 (0)1753 534655, or email '[EMAIL PROTECTED]' Celltech Group plc 216 Bath Road, Slough, SL1 4EN, Berkshire, UK Registered Office as above. Registered in England No. 2159282 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Maser, Donna (SEA) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: have been wondering for quite a while
From the manual: CONSTRAINT_TYPE Type of constraint definition: C (check constraint on a table) P (primary key) U (unique key) R (referential integrity) V (with check option, on a view) O (with read only, on a view) -Original Message- Sent: Monday, July 02, 2001 1:47 PM To: Multiple recipients of list ORACLE-L DBAs: On the user_constraints view, you can find the constraint_type has five distinct values: C, O, P, R, U, and V. C=check, P=primary key, R=foreign key, U=unique key. What about O and V? If I assume O=optional(null/not null), I really can not guess V. Anyone can help?, Thanks in advance. William -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: William Dong INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). The information contained in this email is intended for the personal and confidential use of the addressee only. It may also be privileged information. If you are not the intended recipient then you are hereby notified that you have received this document in error and that any review, distribution or copying of this document is strictly prohibited. If you have received this communication in error, please notify Celltech Group immediately on: +44 (0)1753 534655, or email '[EMAIL PROTECTED]' Celltech Group plc 216 Bath Road, Slough, SL1 4EN, Berkshire, UK Registered Office as above. Registered in England No. 2159282 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Maser, Donna (SEA) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: PL/SQL - invail declare of char
Easy one, Neil, you spelled calendar two different ways. (both of which are incorrect, not that it matters!) calandarString CHAR(10) := ' '; RETURN (calanderString); -Original Message- Sent: Wednesday, April 04, 2001 11:41 AM To: Multiple recipients of list ORACLE-L Hello, I know I am missing something. I just can't see it right now. Could someone please tell me what is wrong here? We use version 8.1.6 on Spar Solaris 7. I am getting the following error when I try to create this function as sys. PLS-00201: identifier 'CALANDERSTRING' must be declared Here is the function. CREATE OR REPLACE FUNCTION ACADEMICYEARTERM_TO_CAL( ayear4 IN CHAR, aterm2 IN CHAR) RETURN CHAR IS calandarString CHAR(10) := ' '; BEGIN SELECT term_desc || ' ' || to_char(start_date, '') into calanderString from term where term = aterm2 and academic_year = ayear4; RETURN (calanderString); EXCEPTION WHEN OTHERS THEN RETURN(calanderString); END; / TIA! Neil MacDannald, Database Analyst San Joaquin Delta College, Information Services Voice: (209)954-5300, Fax: (209)954-5302 email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Web Page: http://www.deltacollege.org/emp/nmacdannald http://www.deltacollege.org/emp/nmacdannald The information contained in this email is intended for the personal and confidential use of the addressee only. It may also be privileged information. If you are not the intended recipient then you are hereby notified that you have received this document in error and that any review, distribution or copying of this document is strictly prohibited. If you have received this communication in error, please notify Celltech Group immediately on: +44 (0)1753 534655, or email '[EMAIL PROTECTED]' Celltech Group plc 216 Bath Road, Slough, SL1 4EN, Berkshire, UK Registered Office as above. Registered in England No. 2159282 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Maser, Donna (SEA) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: Update two columns in a single update statement
RTFM (SQL Reference) update tablename set col1 = 45, col2 = 33 where ... -Original Message- Sent: Thursday, March 29, 2001 3:51 PM To: Multiple recipients of list ORACLE-L Hi! Can I update two columns in a single update statement? What is the exact syntax for this... update tablename set col1,col2 = 45,33 Just like in an insert statement, you would go insert into (col1,col2) values (45,33) This is 8.1.6 on Win2k. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Helmut Daiminger INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). The information contained in this email is intended for the personal and confidential use of the addressee only. It may also be privileged information. If you are not the intended recipient then you are hereby notified that you have received this document in error and that any review, distribution or copying of this document is strictly prohibited. If you have received this communication in error, please notify Celltech Group immediately on: +44 (0)1753 534655, or email '[EMAIL PROTECTED]' Celltech Group plc 216 Bath Road, Slough, SL1 4EN, Berkshire, UK Registered Office as above. Registered in England No. 2159282 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Maser, Donna (SEA) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: Why is there air?
Jared, I am still waiting/hoping for an answer... Why IS there air? - Donna -Original Message- Sent: Thursday, March 22, 2001 11:46 AM To: Multiple recipients of list ORACLE-L Hmmm I thought my post said that I was in no way trying to discourage off-topic posts. Maybe I wasn't clear? And I've always considered my articulate. :) Oh well. I was not trying to put a stop to off topic posts, I was merely reminding everyone that this forum is a valuable troubleshooting, tech support and educational resource for many people. If you want to segue from chocolate to carpet bombing foreign countries, go ahead, although your analyst may find it more interesting than I do. :) Let's just remember that there *is* a technical side to this forum as well. Well, *this* post appears fairly innocuous, maybe I won't get flamed. ;) ( just kidding, Jack and Bill ) Jared The information contained in this email is intended for the personal and confidential use of the addressee only. It may also be privileged information. If you are not the intended recipient then you are hereby notified that you have received this document in error and that any review, distribution or copying of this document is strictly prohibited. If you have received this communication in error, please notify Celltech Group immediately on: +44 (0)1753 534655, or email '[EMAIL PROTECTED]' Celltech Group plc 216 Bath Road, Slough, SL1 4EN, Berkshire, UK Registered Office as above. Registered in England No. 2159282 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Maser, Donna (SEA) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: What or who is PUBLIC?
Ron, PUBLIC is not actually a ROLE, it is a 'user group'. It always is available to ALL users in a database. If used in reference to a synonym, privilege, role, or subroutine (variable, constant, function, procedure) of a package it means the synonym, privilege, role, or subroutine is accessible to every database user. The other use of public is in reference to a rollback segment within a parallel server database, where public means that any instance requiring a rollback segment can use it . Donna -Original Message- Sent: Thursday, March 08, 2001 2:22 PM To: Multiple recipients of list ORACLE-L Can anyone point me to a paper or explanation of the Oracle role? called PUBLIC? How do you manage permissions for PUBLIC? Ron Smith Database Administration [EMAIL PROTECTED] The information contained in this email is intended for the personal and confidential use of the addressee only. It may also be privileged information. If you are not the intended recipient then you are hereby notified that you have received this document in error and that any review, distribution or copying of this document is strictly prohibited. If you have received this communication in error, please notify Celltech Group immediately on: +44 (0)1753 534655, or email '[EMAIL PROTECTED]' Celltech Group plc 216 Bath Road, Slough, SL1 4EN, Berkshire, UK Registered Office as above. Registered in England No. 2159282 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Maser, Donna (SEA) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: eek!
Hi Dennis, You must be on the west coast! That was FUN!! (I'm in the Seattle area, but originally from Alaska, where earthquakes are considered to be more a form of entertainment than a major disaster.) Did you run to the computer room as soon as the aftershocks ceased? Were the machines all still in place? If not, you have a problem. Donna -Original Message- Sent: Wednesday, February 28, 2001 11:17 AM To: Multiple recipients of list ORACLE-L We just had an earthquake. I'm fairly freeked. How's everyone's disaster recover strategy? I'll think I'll be reviewing ours today. Dennis Taylor Niels is bohring. The information contained in this email is intended for the personal and confidential use of the addressee only. It may also be privileged information. If you are not the intended recipient then you are hereby notified that you have received this document in error and that any review, distribution or copying of this document is strictly prohibited. If you have received this communication in error, please notify Celltech Group immediately on: +44 (0)1753 534655, or email '[EMAIL PROTECTED]' Celltech Group plc 216 Bath Road, Slough, SL1 4EN, Berkshire, UK Registered Office as above. Registered in England No. 2159282 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Maser, Donna (SEA) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: eek!
Yes, actually, I was. After that one, the rest were child's play! -Original Message- Sent: Wednesday, February 28, 2001 12:41 PM To: Multiple recipients of list ORACLE-L You must not have been in Anchorage in 64! -Original Message- Donna (SEA) Sent: Wednesday, February 28, 2001 11:58 AM To: Multiple recipients of list ORACLE-L Hi Dennis, You must be on the west coast! That was FUN!! (I'm in the Seattle area, but originally from Alaska, where earthquakes are considered to be more a form of entertainment than a major disaster.) Did you run to the computer room as soon as the aftershocks ceased? Were the machines all still in place? If not, you have a problem. Donna -Original Message- Sent: Wednesday, February 28, 2001 11:17 AM To: Multiple recipients of list ORACLE-L We just had an earthquake. I'm fairly freeked. How's everyone's disaster recover strategy? I'll think I'll be reviewing ours today. Dennis Taylor Niels is bohring. The information contained in this email is intended for the personal and confidential use of the addressee only. It may also be privileged information. If you are not the intended recipient then you are hereby notified that you have received this document in error and that any review, distribution or copying of this document is strictly prohibited. If you have received this communication in error, please notify Celltech Group immediately on: +44 (0)1753 534655, or email '[EMAIL PROTECTED]' Celltech Group plc 216 Bath Road, Slough, SL1 4EN, Berkshire, UK Registered Office as above. Registered in England No. 2159282 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Maser, Donna (SEA) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Steve Orr INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Maser, Donna (SEA) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: eek!
True, nothing fell on my head with this one. I will admit that I no longer am calling this one fun. I ran home at lunch and found quite a bit of damage to the brick entryway. Of course, no earthquake insurance, talk about needing diasaster recovery! I need a bigger bank balance! Walt, were you in Fairbanks to go to school? I attending the university there around that same time. - Donna -Original Message- Sent: Wednesday, February 28, 2001 1:09 PM To: Multiple recipients of list ORACLE-L I'd say the fun quotient is inversely proportional to the number of things that fall on your head. At least that was my experience in Fairbanks in 1976 when an earthquake occured there... --Walt Weaver Bozeman, Montana, USA The information contained in this email is intended for the personal and confidential use of the addressee only. It may also be privileged information. If you are not the intended recipient then you are hereby notified that you have received this document in error and that any review, distribution or copying of this document is strictly prohibited. If you have received this communication in error, please notify Celltech Group immediately on: +44 (0)1753 534655, or email '[EMAIL PROTECTED]' Celltech Group plc 216 Bath Road, Slough, SL1 4EN, Berkshire, UK Registered Office as above. Registered in England No. 2159282 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Maser, Donna (SEA) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
