RMAN问题 FOR 8I：change archivelog all validate命令不行

dongjh

我的数据库是8i,现在我的archive log损害了。想用change archivelog all validate 命令来做，但是报以下错。同样的命令在9i,oracle8下都可以做。请高手帮忙啊。 \r\nRMAN-03022: compiling command: change \r\nRMAN-03026: error recovery releasing channel resources \r\nRMAN-00571: =========================================================== \r\nRMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== \r\nRMAN-00571: =========================================================== \r\nRMAN-03002: failure during compilation of command \r\nRMAN-03013: command type: change \r\nRMAN-06003: ORACLE error from target database: RMAN-20021: database not set

老邱

RMAN-06003: ORACLE error from target database: RMAN-20021: database not set\r\n\r\n前面的输出是怎么样的？有没有connect target？

dongjh

前面的输出：\r\nRecovery Manager: Release 8.1.6.0.0 - Production\r\n\r\nRMAN-06005: connected to target database: TOAD (DBID=3367825312)\r\nRMAN-06009: using target database controlfile instead of recovery catalog\r\n已经connect catalog了。

yddll

你没连接到catalog，你是使用的target database controlfile

dongjh

我用的是NO CATALOG方式啊，是用CONTROLFILE 做target database的啊。

老邱

把你的语句和输出完整地贴出来

dongjh

F:\\Oracle\\Ora81\\BIN>;rman target / nocatalog\r\n\r\nRecovery Manager: Release 8.1.6.0.0 - Production\r\n\r\nRMAN-06005: connected to target database: TOAD (DBID=3367825312)\r\nRMAN-06009: using target database controlfile instead of recovery catalog\r\nRMAN>; change archivelog all unavailable;\r\n\r\nRMAN-03022: compiling command: change\r\nRMAN-03026: error recovery releasing channel resources\r\nRMAN-00571: ===========================================================\r\nRMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============\r\nRMAN-00571: ===========================================================\r\nRMAN-03002: failure during compilation of command\r\nRMAN-03013: command type: change\r\nRMAN-06003: ORACLE error from target database: RMAN-20021: database not set

老邱

你没有allocate channel。如果你是想在rman catalog里把实际已经没有的archive log信息删掉，可以\r\nallocate channel for delete type disk;\r\nchange archivelog all validate;

yddll

好象只有9里面才会自己allocate channel

yddll

ORA-06512 at stringline string\r\nCause: Backtrace message as the stack is unwound by unhandled exceptions. \r\n\r\nAction: Fix the problem causing the exception or write an exception handler for this condition. Or you may need to contact your application administrator or database administrator.