急!!!请教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 or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore
如果数据库不删除使用该恢复脚本是没问题
但是如果我数据库删除了 要怎么恢复呢？
现在就是要求把数据库删了 能用备份文件恢复吗？
麻烦有脚本的朋友帮忙发给我谢谢 小弟在线等
E-mail:hpym365@163.com
QQ:66033086
[解决办法]
数据库删除了也是可以恢复的啊
实在不行，就用dbms_backup_restore包直接一个个数据文件、日志文件的去恢复了。
[解决办法]
数据库直接删掉也可以恢复。今天刚做过这个。还测试了一下。