Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Urgent: restore from hot backup w/o archivelogs

Re: Urgent: restore from hot backup w/o archivelogs

From: Rachel Carmichael <wisernet100_at_yahoo.com>
Date: Wed, 26 Mar 2003 10:50:45 -0800
Message-ID: <F001.005737CD.20030326105045@fatcity.com>


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).
>



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: 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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US