| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Urgent: restore from hot backup w/o archivelogs
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 <naveen_nahata_at_mindtree.com> 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: naveen_nahata_at_mindtree.com
>
> 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: ListGuru_at_fatcity.com (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: Rachel Carmichael INET: wisernet100_at_yahoo.com 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: ListGuru_at_fatcity.com (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).Received on Wed Mar 26 2003 - 12:50:45 CST
 |
 |