Re: Trying to recover a corrupted Undo Tablespace

From: Funky Paw <rgaudet77_at_hotmail.com>
Date: 3 Oct 2005 09:17:37 -0700
Message-ID: <1128356257.785782.292600@g43g2000cwa.googlegroups.com>

Thanks for the response;
When I try to connect to RMAN as sysdba, I get the following message;

RMAN-00579: the following error occurred at 10/03/2005 10:46:01
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database: ORA-01031: insufficient

privileges

I'm not sure what you mean about not being a part of the local ora_dba group as I don't have a local group like that on my machine. It's been over a year since I took my DBA Fundamentals 1 and 2 for Oracle 9 and I haven't really used it since....

Here is the exact error message from the alert log that I'm trying to fix;
Fri Sep 30 16:05:44 2005
Errors in file D:\oracle\admin\CDE\udump\ORA03292.TRC: ORA-01578: ORACLE data block corrupted (file # 2, block # 273) ORA-01110: data file 2: 'D:\ORACLE\ORA90\CDE\UNDOTBS01.DBF'

Fri Sep 30 16:05:44 2005
Error 1578 happened during db open, shutting down database USER: terminating instance due to error 1578 Instance terminated by USER, pid = 3292
ORA-1092 signalled during: ALTER DATABASE OPEN...

Thanks Received on Mon Oct 03 2005 - 11:17:37 CDT