lunar2000整理的数据库恢复实例

gisrs_ren

好阿

rick8020

真是非常感谢
感谢itpub
更感谢上面那么多热心的网友！

pengst2

thanks!!!

smallpine

好文章！

huhs2008

小弟在做恢复时出现如下错误，请各位赐教：
RMAN>run {
2>   allocate channel c1 type disk;
3>   restore database;
4>   recover database until scn 256706;
5>   sql 'ALTER DATABASE OPEN RESETLOGS';
6>   release channel c1;
7> }
RMAN-03022：正在编译命令：allocate
RMAN-03023：正在执行命令：allocate
RMAN-08030：分配的通道：c1
RMAN-08500：通道 c1：sid=22 devtype=DISK

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

RMAN-03022：正在编译命令：IRESTORE
RMAN-03026：在释放通道资源时出现错误恢复
RMAN-08031：释放的通道：c1
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

anywhere

谢谢

halbert

谢谢了。

BruDog

我也支持一下

forehead

thank you very much