user-managed TPITR 无法在sysauxoffline的情况下导出meta data

lory

OS: linux redhat AS 4.0
DB:oracle 10.2.0.5
在看rman的资料，按照手册上的做（B14191-03） user-managed TPITR
http://docs.oracle.com/cd/B19306_01/backup.102/b14191.pdf
on page 20-2



但是在导出tablespace 的meta data时出现：
oracle@RAC1 ~]$ exp \'/ as sysdba \' tablespaces=test1 transport_tablespace=y file=/u01/app/oracle/oradata/CLONEDB/t

Export: Release 10.2.0.5.0 - Production on Tue Jan 15 16:48:23 2013

Copyright (c) 1982, 2007, Oracle. All rights reserved.


Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)
Note: table data (rows) will not be exported
About to export transportable tablespace metadata...
EXP-00008: ORACLE error 1001 encountered
ORA-01001: invalid cursor
ORA-06512: at "SYS.DBMS_SYS_SQL", line 902
ORA-06512: at "SYS.DBMS_SQL", line 19
ORA-06512: at "SYS.DBMS_TTS", line 838
ORA-00376: file 3 cannot be read at this time
ORA-01110: data file 3: '/u01/app/oracle/oradata/CLONEDB/sysaux01.dbf'
ORA-06512: at "SYS.DBMS_PLUGTS", line 1387
ORA-06512: at line 1
EXP-00000: Export terminated unsuccessfully

xifenfei

可以先修复sysaux01.dbf文件

lory

xifenfei 发表于 2013-1-16 18:40
可以先修复sysaux01.dbf文件

我按照手册上面做的user-managed tablespace point in time recovery，
上面没说要恢复sysaux，不过确实在导出的时候要sysaux，
所以怀疑是不是手册上写错了。

Maclean Liu(刘相兵

试试

ALTER SYSTEM SET OPTIMIZER_MODE=RULE;

由于统计信息存放在SYSAUX上，所以CBO的游标会失败，此时用RBO往往可以绕过问题

lory

Maclean Liu(刘相兵 发表于 2013-1-17 17:52
试试

ALTER SYSTEM SET OPTIMIZER_MODE=RULE;

试了设定
ALTER SYSTEM SET OPTIMIZER_MODE=RULE;

还是一样的，应该是要sysaux在线才能做了