Home » RDBMS Server » Server Administration » RMAN Invalid Objects
RMAN Invalid Objects [message #267226] Wed, 12 September 2007 14:25 Go to next message
Creems
Messages: 70
Registered: July 2007
Location: Johannesburg
Member
Hello, I have this invalid objects owned by RMAN. And I have ran utlrp.sql but it's not compiling ... Please what do I do?

OWNER OBJECT_TYPE OBJECT_NAME STATUS
--------------- -------------------- ----------------------------
RMAN PACKAGE BODY DBMS_RCVCAT INVALID
RMAN PACKAGE BODY DBMS_RCVMAN INVALID
RMAN VIEW RC_ARCHIVED_LOG INVALID
RMAN VIEW RC_BACKUP_CONTROLFILE INVALID
RMAN VIEW RC_BACKUP_CORRUPTION INVALID
RMAN VIEW RC_BACKUP_DATAFILE INVALID
RMAN VIEW RC_BACKUP_PIECE INVALID
RMAN VIEW RC_BACKUP_REDOLOG INVALID
RMAN VIEW RC_BACKUP_SET INVALID
RMAN VIEW RC_BACKUP_SPFILE INVALID
RMAN VIEW RC_CHECKPOINT INVALID

Regards,

Cherish
Re: RMAN Invalid Objects [message #267289 is a reply to message #267226] Wed, 12 September 2007 23:59 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

HI,
Try to compile manually.
alter view viewname compile;


Regards
Mohammed Taj
Re: RMAN Invalid Objects [message #267364 is a reply to message #267226] Thu, 13 September 2007 01:59 Go to previous message
animesh303
Messages: 12
Registered: June 2006
Junior Member
Hi

Try compiling manually and inform us of the errors encountered.
Moreover, I would love to know if you did any recent modification to the database which might have made the objects invalid.

Regards
Animesh
Previous Topic: 10g Upgrade - block size change
Next Topic: Database can't be started (merged)
Goto Forum:
  


Current Time: Sat Nov 30 04:49:12 CST 2024