Re: **Help Reqd Immdly** - Database Recovery problem...

From: Ruth Gramolini <rgramolini_at_tax.state.vt.us>
Date: Wed, 13 Jun 2001 05:35:29 -0700
Message-ID: <F001.00327699.20010613054142@fatcity.com>

If you can shutdown your database you can just restore all the files from the cold backup. Open your database with resetlogs and you will be okay.

Ruth

Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Wednesday, June 13, 2001 7:20 AM

Hi All,

I have a production database running on archive log mode. Accidentally, I have executed a batch process twice, and now I have to invalidate the transactions applied during my second execution of batch process. More over, Online transaction has also applied to the database after my second run.

I have a cold backup of my entire database which I have taken just before executing the **second** run of batch process.

Is there any way(Backdoor!) to recover my database by creating dummy archive logs for invalidating my second execution of batch process? And also I need to apply the transactions happened after my second run!

Hope this has been discussed here and solution has given by some one of us.

Thanks in Advance.

Regards,
PraSri

Visit http://www.visto.com/info, your free web-based communications center. Visto.com. Life on the Dot.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: DBA DBA
  INET: activedba_at_visto.com

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ruth Gramolini
  INET: rgramolini_at_tax.state.vt.us

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 Jun 13 2001 - 07:35:29 CDT