日期:2014-05-17  浏览次数:20794 次

急!!!请教rman恢复问题,有知道的朋友麻烦帮帮忙!在线等!
我把整个过程给大家   麻烦知道的朋友帮忙指导一下   谢谢!

环境   :windows2000+oracle   8.1.7

C:\> rman

Recovery   Manager:   Release   8.1.7.0.0   -   Production

RMAN>   connect   target   wzgl/wzgl@jgxt   --连接目标数据库

RMAN-06005:   connected   to   target   database:   JGXT   (DBID=2973324594)

RMAN>   connect   catalog   rman/cat@catdb   --连接rman数据库

RMAN-06008:   connected   to   recovery   catalog   database

RMAN>   register   database;   --注册目标数据库

RMAN-03022:   compiling   command:   register
RMAN-03023:   executing   command:   register
RMAN-08006:   database   registered   in   recovery   catalog
RMAN-03023:   executing   command:   full   resync
RMAN-08002:   starting   full   resync   of   recovery   catalog
RMAN-08004:   full   resync   complete

备份脚本
run   {
allocate   channel   'dev1 '   type   disk   ;
allocate   channel   'dev2 '   type   disk   ;
allocate   channel   'dev3 '   type   disk   ;
backup   full   tag   'dbfull '   format   'E:/jgxtbak/full%u_%p_%c '   database   ;
sql   'alter   system   archive   log   current '   ;
backup   filesperset   3   archivelog   all   delete   input;
release   channel   dev1;
release   channel   dev2;
release   channel   dev3;
}


备份成功   如果使用下面恢复脚本可以正常恢复   :
run   {
allocate   channel   'dev1 '   type   disk   ;
allocate   channel   'dev2 '   type   disk   ;
allocate   channel   'dev3 '   type   disk   ;
restore   database   ;
recover   database   ;
release   channel   dev1   ;
release   channel   dev2   ;
release   channel   dev3   ;
}

但是如果我删除了数据库重新建立却无法恢复,知道怎么恢复的朋友麻烦告诉我一下   我备份是完全备份   但是恢复时候却提示找不到文件
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-06026:   some   targets   not   found   -   aborting   restore
RMAN-06023:   no   backup   or   copy   of   datafile   6   found   to   restore
RMAN-06023:   no   backup   or   copy   of   datafile   5   found   to   restore
RMAN-06023:   no   backup   or   copy   of   datafile   4   found   to   restore
RMAN-06023:   no   backup   or   copy   of   datafile   3   found   to   restore
RMAN-06023:   no   backup