RE: make 'export' work after 'SYSAUX' offline
Date: Wed, 2 Nov 2011 15:00:07 +0000
Message-ID: <59AD0932D8A0DB4BAD93E0E078B37929010B4D34_at_evcspmbx4.ads.northwestern.edu>
Hi,
Here are the steps from Oracle support that finally made traditional 'export' (not export datapump) work with 'SYSAUX' tablespace offline. Note: need to restart the database in 'upgrade' mode.
SQL> shutdown immediate; SQL> startup upgrade SQL> _at_?/rdbms/admin/catnoqm.sql SQL> shutdown immediate; SQL> startup
Flora
-----Original Message-----
From: Uzzell, Stephan [mailto:SUzzell_at_MICROS.COM]
Sent: Thursday, October 27, 2011 9:21 AM
To: Flora Deng; 'oracle-l_at_freelists.org'
Subject: RE: make 'export' work after 'SYSAUX' offline
Hi Flora,
Just to confirm, you do not have the redo necessary to recover the sysaux datafile?
Stephan Uzzell
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Flora Deng
Sent: Wednesday, 26 October, 2011 15:38
To: 'oracle-l_at_freelists.org'
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 '_at_?/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 -- http://www.freelists.org/webpage/oracle-lReceived on Wed Nov 02 2011 - 10:00:07 CDT