NBU 备份 oracle 出错

aixdb2

客户端为win2000+oracle 8.0.5
NBU返回值为6
脚本的.out文件如下：

Recovery Manager: Release 8.0.5.0.0 - Production

RMAN-06009: using target database controlfile instead of recovery catalog
RMAN-06005: connected to target database: ORCL

RMAN>; RUN { 2>; ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE'; 3>; BACKUP 4>;       INCREMENTAL Level=0 5>;       FORMAT 'bk_u%u_s%s_p%p_t%t' 6>;
      DATABASE; 7>; sql 'alter system archive log current'; 8>; RELEASE CHANNEL ch00; 9>; # Backup all archive logs 10>; ALLOCATE CHANNE
L ch00 TYPE 'SBT_TAPE'; 11>; BACKUP 12>;       FILESPERSET 20 13>;       FORMAT 'arch-s%s-p%p' 14>;       ARCHIVELOG ALL; 15>; RELEASE CH
ANNEL ch00; 16>; }
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-00569: ================error message stack follows================
RMAN-00601: fatal error in recovery manager
RMAN-03004: fatal error during execution of command
RMAN-07001: could not open channel ch00
RMAN-10008: could not create channel context
RMAN-10024: error setting up for rpc polling
RMAN-10006: error running sql statement: select distinct my.sid, sex.serial from v$mystat my, x$ksusex sex where sex.sid = my.sid
RMAN-10002: ORACLE error: ORA-01455: converting column overflows integer datatype

aixdb2

数据库在启动时报以下错误：
ORA-00255: error archiving log 2 of thread 1, sequence # 934
ORA-00312: online log 2 thread 1: 'D:\ORANT\DATABASE\LOG3ORCL.ORA'
ORA-00294: invalid archivelog format specifier 'O'

请dx帮忙，谢谢

aixdb2

归档格式为：
log_archive_start = true      
log_archive_dest = %ORACLE_HOME%\arch
log_archive_format = "%ORACLE_SID%%S.%T"

aixdb2

已经解决了，把log_archive_format = "%ORACLE_SID%%S.%T"
改成arch_%t_%s.arc，格式问题

yddll

[quote]原帖由 "aixdb2"]ORA-00294: invalid archivelog format specifier 'O' [/quote 发表：


很明显  

aixdb2

一开始想不到，因为那是oracle默认的，以为NT下的老版本的ORACLE就是这样的。