If it's not a prod. Database which it doesn't seem to be and you can bear the loss of one week's data. Use the create controlfile, create a new controlfile and open the database with resetlogs.
Thanks, Inder -----Original Message----- Sent: Monday, July 07, 2003 11:59 AM To: Multiple recipients of list ORACLE-L Hei all, My database is Oracle 801 running on windowsNT with NOARCHIVELOG mode. I got the memory problem and it has been end with one of RBS datafile currption. The DB does not allowed me either drop the datafile or tablespace. So what i have done the following steps. 1)created control file using alter database backup to trace command. 2) removed the datafiles for the tablespace( here its rollback segment tablespace), which has been currupted from the trace file. 3)created the new control by running the modified create controlfile command. 4) database mounted 5) At the end alter database open command results the following error. ORA-00600: internal error code, arguments: [19944], [], [], [], [], [], [], []. What could be done next to open the database sucessfully. Please give the earliest solution. I had full cold back which has been taken last week and having daily database export dump. thanks. nirmal. ===== fsdfsdfsdfsdfs __________________________________ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nirmal Kumar M 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: Singh Pushpinder 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).
