RE: Restore without redolog files

From: James Bullard <jbullard_at_onvia.com>
Date: Wed, 18 Oct 2000 06:56:54 -0700
Message-Id: <10653.119640@fatcity.com>

I think that perhaps you are thinking of "alter database open resetlogs" ?

-----Original Message-----
From: Shevtsov, Eduard [mailto:EShevtsov_at_flagship.ru] Sent: Wednesday, October 18, 2000 7:05 AM To: Multiple recipients of list ORACLE-L Subject: RE: Restore without redolog files

Hi Shahid

Of course you can do standard incomplete recovery 'until cancel', but ...

I know there is a hidden parameter which allows you to open database without current redo logs. I can't remember the exact name at the moment (I'm sure, other guys will help). Please, note! I didn't do it before, but I believe you can open DB and recreate your redo logs. You have to do whole backup before !

Please, correct me if I'm wrong. Any comments??

-----Original Message-----
Sent: 18 ??????? 2000 ?. 15:38
To: 'ORACLE-L_at_fatcity.com'; 'oracledba_at_quickdoc.co.uk'

Guys,
I have to restore a database without redolog files. The database is in archivelog mode. Please advise on the steps to take for point in time recovery.

Thanks.
Shahid.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Shevtsov, Eduard
INET: EShevtsov_at_flagship.ru

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: 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 Oct 18 2000 - 08:56:54 CDT