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

From: William Beilstein <BeilstWH_at_obg.com>
Date: Wed, 13 Jun 2001 09:17:31 -0700
Message-ID: <F001.003279A1.20010613070729@fatcity.com>

Not true, the restore of the cold backup will get rid of the second batch run, but will not add the new online transactions. I guess you have three options.

restore cold backup, have the users reenter their online transactions.
write a program to programmatically remove the second batch transaction.
extract the online transactions into a temp table, export the temp table, restore cold backup, import temp table, move the temp table data back into the real tables.

>>> rgramolini_at_tax.state.vt.us 06/13/01 09:41AM >>>
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).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: William Beilstein
  INET: BeilstWH_at_obg.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).

Received on Wed Jun 13 2001 - 11:17:31 CDT