RE: make 'export' work after 'SYSAUX' offline

Found a note that "might" help ... Suggestion is to export via table level 
which can be a pain.

Note id: 950128.1 


Rui Amaral
Database Administrator
ITS - SSG
TD Bank Financial Group
220 Bay St., 11th Floor
Toronto, ON, CA, M5K1A2
(bb) (647) 204-9106
 

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Flora Deng
Sent: Wednesday, October 26, 2011 3:38 PM
To: 'oracle-l@xxxxxxxxxxxxx'
Subject: RE: make 'export' work after 'SYSAUX' offline

Hi, community,
I need to salvage some data after SYSAUX tablespace was offline due to disk 
controller problem.
Unfortunately RMAN backup is not good, can backup all datafile except the 
'sysaux' datafile.
The database is still up and running and I need to export data out to migrate 
to a new database server.
But export or export datapump threw error like below:
exporting private type synonyms
. exporting object type definitions for user SCOTT About to export SCOTT's 
objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
EXP-00056: ORACLE error 4063 encountered
ORA-04063: view "SYS.KU$_XMLSCHEMA_VIEW" has errors
EXP-00000: Export terminated unsuccessfully Oracle support suggested deinstall 
XDB component, but the deinstall by running script '@?/rdbms/admin/catnoqm.sql' 
failed.
Complaining 'sysaux' is offline.
Any suggestions and options will be greatly appreciated!

Flora


-------------------------------------------------------------------------
Flora Deng
Oracle Certified Professional Database Administrator Information Technology 
Management Systems Northwestern University 1800 Sherman Ave.,Suite 600, 
Evanston, IL 60201
Phone: 847-467-0587   Fax: 847-491-3887
-------------------------------------------------------------------------




--
http://www.freelists.org/webpage/oracle-l



NOTICE: Confidential message which may be privileged. Unauthorized 
use/disclosure prohibited. If received in error, please go to www.td.com/legal 
for instructions.
AVIS : Message confidentiel dont le contenu peut être privilégié. 
Utilisation/divulgation interdites sans permission. Si reçu par erreur, prière 
d'aller au www.td.com/francais/avis_juridique pour des instructions.
--
http://www.freelists.org/webpage/oracle-l

Other related posts: