RE: screw up ongoing

From: Bobak, Mark <Mark.Bobak_at_il.proquest.com>
Date: Fri, 3 Sep 2004 19:07:11 -0400
Message-ID: <4C9B6FDA0B06FE4DAF5918BBF0AD82CF09EFEB41@bosmail00.bos.il.pqe>

David,

What version? 8i? 9iR2?

-----Original Message-----

From:	oracle-l-bounce_at_freelists.org on behalf of David
Sent:	Fri 9/3/2004 6:02 PM
To:	oracle-l_at_freelists.org
Cc:=09
Subject:	screw up ongoing

It has been too long since I have worked with RMAN extensively. I now have to do an emergency restore... I have been reading and reading and trying a few thigns, but so for no progress.
Thsi si in regards to the package body that got deleted on accident and exsits no where else.
I don't want to do TSPITR because I just need 1 package body.

In the old days, I would have restored the system and rbs/undo tbs. recreated the control file and done an open resetlogs and grabbed the package body code.

I'm getting frustrated and not quite grasping the equivilant to this in RMAN....any help is appreciated.
The prod db is up and available, but with a missing package body. I'm needing to restore to an alternate node, just system, undo and then create temp and perform recover manaually or via rman. I think I'm close, but just getting hung up on syntax due to be so rusty with RMAN.
I'm also wanting to use nocatalog so there is no chance of impacting the prod db.

Any help is truly appreciated as I have none here.
--=20

..
David
--

To unsubscribe - =
mailto:oracle-l-request_at_freelists.org&subject=3Dunsubscribe=20 To search the archives - http://www.freelists.org/archives/oracle-l/

--

To unsubscribe - mailto:oracle-l-request_at_freelists.org&subject=unsubscribe To search the archives - http://www.freelists.org/archives/oracle-l/ Received on Fri Sep 03 2004 - 18:02:43 CDT