RE: screw up ongoing

  • From: "David" <thump@xxxxxxxxxxxxxxxx>
  • To: "'Bobak, Mark'" <Mark.Bobak@xxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Sat, 4 Sep 2004 14:29:13 -0700

9204
I'm in the process of restoring to an alternate node system and undo.
Thanks
David

-----Original Message-----
From: Bobak, Mark [mailto:Mark.Bobak@xxxxxxxxxxxxxxx]=20
Sent: Friday, September 03, 2004 4:07 PM
To: thump@xxxxxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: screw up ongoing


David,

What version? 8i? 9iR2?




-----Original Message-----
From:   oracle-l-bounce@xxxxxxxxxxxxx on behalf of David
Sent:   Fri 9/3/2004 6:02 PM
To:     oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx&subject=3Dunsubscribe=20
To search the archives - //www.freelists.org/archives/oracle-l/


--
To unsubscribe - mailto:oracle-l-request@xxxxxxxxxxxxx&subject=unsubscribe 
To search the archives - //www.freelists.org/archives/oracle-l/

Other related posts: