急!!!请教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