lunar2000整理的数据库恢复实例

gisrs_ren · 发表于 2003-7-25 22:37

好阿

rick8020 · 发表于 2003-7-26 09:49

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

pengst2 · 发表于 2003-7-26 11:21

thanks!!!

smallpine · 发表于 2003-8-27 09:45

好文章！

huhs2008 · 发表于 2003-8-29 10:33

小弟在做恢复时出现如下错误，请各位赐教：
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 · 发表于 2003-8-29 11:20

谢谢

halbert · 发表于 2003-8-29 11:30

谢谢了。

BruDog · 发表于 2003-8-29 16:46

我也支持一下

forehead · 发表于 2003-8-29 16:57

thank you very much

[精华] lunar2000整理的数据库恢复实例