ORA-01410 on data dictionary 2006-06-19 - By Baumgartel, Paul
I recently copied a database by restoring a hot backup on another machine,
creating a new controlfile with new DB name, and recovering. All went normally
but we are now getting ORA-01410 (See ORA-01410.ora-code.com): Invalid rowid on some data dictionary queries
. ANALYZE INDEX ...VALIDATE STRUCTURE on SYS indexes reveals
SQL> analyze index sys.I_COL1 validate structure;
analyze index sys.I_COL1 validate structure
*
ERROR at line 1:
ORA-08103 (See ORA-08103.ora-code.com): object no longer exists
This index apparently is created at bootstrap time and can't be rebuilt:
SQL> alter index sys.I_COL1 rebuild;
alter index sys.I_COL1 rebuild
*
ERROR at line 1:
ORA-00701 (See ORA-00701.ora-code.com): object necessary for warmstarting database cannot be altered
Has anyone seen this?
9.2.0.6 on Solaris / SunOS 5.8.
Thanks,
Paul Baumgartel
CREDIT SUISSE
Information Technology
DBA & Admin - NY, KIGA 1
11 Madison Avenue
New York, NY 10010
USA
Phone 212.538.1143
paul.baumgartel@(protected)
www.credit-suisse.com
==============================================================================
Please access the attached hyperlink for an important electronic communications
disclaimer:
http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
==============================================================================
--
http://www.freelists.org/webpage/oracle-l
|
|
