alter database open resetlogs; you won't be able to apply the archived logs he sends over later on (yes Jeremiah I know there is a way to recover through a resetlogs but they will be doing work against the database in the interim!)
but if data loss is not a problem, that's the way to go Rachel --- Naveen Nahata <[EMAIL PROTECTED]> wrote: > I have got a set of datafiles backed up from the client but he didn't > send me > the required archive logs > > now for testing purpose we need to get the DB up at our site but the > archive > logs are not there, the client will send the same but it will take > time > > Is there any way to get the DB up without applying the archive logs > > DATA LOSS IS NOT A PROBLEM > > Regards > Naveen > > > DISCLAIMER: > This message (including attachment if any) is confidential and may be > privileged. Before opening attachments please check them for viruses > and defects. MindTree Consulting Private Limited (MindTree) will not > be responsible for any viruses or defects or any forwarded > attachments emanating either from within MindTree or outside. If you > have received this message by mistake please notify the sender by > return e-mail and delete this message from your system. Any > unauthorized use or dissemination of this message in whole or in part > is strictly prohibited. Please note that e-mails are susceptible to > change and MindTree shall not be liable for any improper, untimely or > incomplete transmission. > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Naveen Nahata > 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). > __________________________________________________ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael 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).
