Re: Trying to recover a corrupted Undo Tablespace

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 01 Oct 2005 07:06:21 +0200
Message-ID: <e66sj1h14ujcc0r1ia5reu3re4o51s9v9v@4ax.com>

On 30 Sep 2005 14:42:41 -0700, "Funky Paw" <rgaudet77_at_hotmail.com> wrote:

> I
>was going to run the BLOCKRECOVER in RMAN but the RMAN user doesn not
>have rights on the target database and since I can't open the database,
>I can't grant it the necessary rights.

connect / as sysdba should work (connect target / in rman) If that doesn't work, you probably aren't a member of the local ora_dba group, and you need to resolve that issue. Also, you should always post exact error messages.

--
Sybrand Bakker, Senior Oracle DBA

Received on Sat Oct 01 2005 - 00:06:21 CDT