数据库备份错误！急！

显示全部楼层 · 2005-2-28 12:57:00

我使用EXP备份数据库表结构，出现以下错误，请各位帮我看看。谢谢大家！
(1)E(ntire database), (2)U(sers), or (3)T(ables): (2)U > 1
Export grants (yes/no): yes >
Export table data (yes/no): yes > no
Compress extents (yes/no): yes > no
Export done in ZHS16GBK character set and ZHS16GBK NCHAR character set
Note: table data (rows) will not be exported
About to export the entire database ...
. exporting tablespace definitions
. exporting profiles
. exporting user definitions
. exporting roles
. exporting resource costs
. exporting rollback segment definitions
. exporting database links
. exporting sequence numbers
EXP-00008: ORACLE error 904 encountered
ORA-00904: invalid column name
EXP-00000: Export terminated unsuccessfully
2、顺便问一下：
如何让数据库备份时指定某个回滚段为该备份进程专用？以保证其回滚段资源不被系统其他事务争用。再一次感谢各位！

千问 · 2005-2-28 12:57:00

你做exp的版本是不是和数据库的版本一致？是不是在数据库服务器上本地做的exp？

千问 · 2005-2-28 12:57:00

用户模式备份没有问题，就是全库备份会出问题

千问 · 2005-2-28 12:57:00

数据的版本？
select * from v$version;

千问 · 2005-2-28 12:57:00

数据库版本：
SQL> select * from v$version;
BANNER
-------------------------------------------------------------------------
Oracle8i Enterprise Edition Release 8.1.5.0.0, 64 bit - Producti
PL/SQL Release 8.1.5.0.0 - Production
CORE Version 8.1.3.0.0 - Production
TNS for HPUX: Version 8.1.5.0.0 - Production
NLSRTL Version 3.4.0.0.0 - Production
EXP版本：
Export: Release 8.1.5.0.0 - Production on Sun Apr 20 15:48:28 2003
(c) Copyright 1999 Oracle Corporation.All rights reserved.

千问 · 2005-2-28 12:57:00

试试以sys运行一下：
$ORACLE_HOME/javavm/install/initjvm.sql

千问 · 2005-2-28 12:57:00

能否解释一下？

千问 · 2005-2-28 12:57:00

找到的一个资料而已，所以让你试试：
fact: Oracle Server - Enterprise Edition 8.1
fact: Export Utility (EXP)
symptom: Full export fails
symptom: ORA-00904: Invalid column name
change: You recently upgraded your database to version 8.1
cause: When you upgrade, the upgrade process appears to remove the Java System.
An sqlnet client trace level 16 of the export utility indicates the failing statement: SELECT SYNNAM, DBMS_JAVA.LONGNAME(SYNNAM), DBMS_JAVA.LONGNAME(SYNTAB), TABOWN, TABNODE, PUBLIC$, SYNOWN, SYNOWNIDFROM SYS.EXU8SYNU ORDER BY SYNTIME
fix:
Run the script initjvm.sql located in the $ORACLE_HOME/javavm/install directory.