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
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 

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: 4580
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
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?
Previous Topic: how to recover the bad control files?
Next Topic: RMAN Tuning
Goto Forum:
  


Current Time: Mon May 27 00:55:39 CDT 2024