Home » RDBMS Server » Backup & Recovery » why rman report error during restoring the database?
why rman report error during restoring the database? [message #74137] Sat, 18 September 2004 01:08 Go to next message
dark_wei
Messages: 2
Registered: September 2004
Junior Member
I am making a experiment about rman restoring.
target: test catalog: rman
first use rman to create the database full backupset and inc 1 backupset(use backup incremental 0 format <path>db_db_%d_%s_%p_%t database)
then I shutdown the database test.Then rename a datafile.Then execute the following statements:
RMAN>shutdown abort;
RMAN-06402：Oracle 例程已关闭

RMAN>startup mount;
RMAN-06193：已连接到目标数据库 (未启动)
RMAN-06196：Oracle 例程已启动
RMAN-06199：数据库已加载

总的系统全局区域为 35436572字节

Fixed Size 75804字节
Variable Size 11632640字节
Database Buffers 23650304字节
Redo Buffers 77824字节

RMAN>run {
2> allocate channel d1 type disk;
3> restore database;
4> recover database;
5> }
RMAN-03022：正在编译命令：allocate
RMAN-03023：正在执行命令：allocate
RMAN-08030：分配的通道：d1
RMAN-08500：通道 d1：sid=10 devtype=DISK

RMAN-03022：正在编译命令：restore

RMAN-03022：正在编译命令：IRESTORE
RMAN-03026：在释放通道资源时出现错误恢复
RMAN-08031：释放的通道：d1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure during compilation of command
RMAN-03013: command type: restore
RMAN-03002: failure during compilation of command
RMAN-03013: command type: IRESTORE
RMAN-06003: ORACLE error from target database: ORA-01843: 无效的月份
RMAN-06097: text of failing SQL statement: select decode(bitand(festa,(4096+128)
),128,fecps,4096,fecps,0) ,decode(bitand(festa,(4096+128)),128,281474976710655,4
096,controlfile_change#,0) ,decode(bitand(festa,(4096+128)),128,SYSDATE,4096,con
trolfile_time,to_date('JAN 01 1988','MON DD YYYY')) ,feofs ,feonc_scn ,to_date(n
vl(feonc_tim,'01/01/88 00:01:01'),'MM/DD/RR HH24:MI:SS') into :b1,:b2,:b3,:b4,:b
5,:b6 from x$kccfe ,v$database where (fenum=:b7 and fedup=1)
RMAN-06099: error occurred in source file: krmk.pc, line: 22229

Report message to a moderator

Re: why rman report error during restoring the database? [message #74144 is a reply to message #74137] Mon, 20 September 2004 06:18 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Did you consider the NLS variables?
This used to be a bug.
NLS_LANG=AMERICAN_AMERICA.< YourCharacterSet >

  
  

and this is A must.
      
NLS_DATE_FORMAT=DD-MON-YYYY HH24:MI:SS

Report message to a moderator

Re: why rman report error during restoring the database? [message #74145 is a reply to message #74137] Mon, 20 September 2004 06:27 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Hi,

Looks like Oracle Bug 1586048, fixed in 9.0.1:

Solution is to set NLS_LANG = AMERICAN_AMERICA.[[your_charset_goes_here]]

Best regards.

Frank

Report message to a moderator

Re: why rman report error during restoring the database? [message #74153 is a reply to message #74144] Mon, 20 September 2004 23:28 Go to previous message
how to change the nls_lan
Messages: 1
Registered: September 2004
Junior Member
how to change the nls_lang on win2000?

Report message to a moderator

Previous Topic: how to recover the bad control files?
Next Topic: RMAN Tuning
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 13:27:14 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.