急!!!请教rman恢复问题，有知道的朋友麻烦帮帮忙！在线等！

[hpym365]

我把整个过程给大家 麻烦知道的朋友帮忙指导一下 谢谢！

环境 :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:[e-mail]
QQ:66033086

[CathySun118]

数据库删除了也是可以恢复的啊
实在不行，就用dbms_backup_restore包直接一个个数据文件、日志文件的去恢复了。

[yanggis]

数据库直接删掉也可以恢复。今天刚做过这个。还测试了一下。

[oraclelogan]

[Quote=引用 1 楼 CathySun118 的回复:]
数据库删除了也是可以恢复的啊
实在不行，就用dbms_backup_restore包直接一个个数据文件、日志文件的去恢复了。
[/Quote]

正解。

[gisinfo]

dbms_backup_restore包
这样太麻烦

[oraclelogan]

你的错误应当是在恢复的时候，
利用备份的控制文件恢复需要指定redo（在rman中恢复就免了）

这个是我的过程，我不利用恢复目录都可以
RMAN> connect target

connected to target database (not started)

RMAN> set dbid 1050796214

executing command: SET DBID

RMAN> startup nomount

Oracle instance started

Total System Global Area 167772160 bytes

Fixed Size 787968 bytes
Variable Size 61864448 bytes
Database Buffers 104857600 bytes
Redo Buffers 262144 bytes

RMAN> restore controlfile from autobackup;

Starting restore at 20-APR-04
using target database controlfile instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=160 devtype=DISK

recovery area destination: E:\oracle\product\10.1.0\flash_recovery_area
database name (or lock name space) used for search: ORCL
channel ORA_DISK_1: autobackup found in the recovery area
channel ORA_DISK_1: autobackup found: E:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AR
EA\ORCL\AUTOBACKUP\2004_04_20\O1_MF_S_523968056_0893FS2X_.BKP
channel ORA_DISK_1: controlfile restore from autobackup complete
output filename=E:\ORACLE\PRODUCT\10.1.0\DB_1\ORCL\CONTROL01.CTL
output filename=E:\ORACLE\PRODUCT\10.1.0\DB_1\ORCL\CONTROL02.CTL
output filename=E:\ORACLE\PRODUCT\10.1.0\DB_1\ORCL\CONTROL03.CTL
Finished restore at 20-APR-04

RMAN> alter database mount;

database mounted
released channel: ORA_DISK_1

RMAN> recover database;

Starting recover at 20-APR-04
Starting implicit crosscheck backup at 20-APR-04
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=160 devtype=DISK
Crosschecked 8 objects
Finished implicit crosscheck backup at 20-APR-04

Starting implicit crosscheck copy at 20-APR-04
using channel ORA_DISK_1
Finished implicit crosscheck copy at 20-APR-04

searching for all files in the recovery area
cataloging files...
cataloging done

List of Cataloged Files
=======================
File Name: E:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\ORCL\AUTOBACKUP\2004_04_
20\O1_MF_S_523968056_0893FS2X_.BKP

using channel ORA_DISK_1

starting media recovery

archive log thread 1 sequence 171 is already on disk as file E:\ORACLE\PRODUCT\1
0.1.0\DB_1\ORCL\REDO03.LOG
archive log filename=E:\ORACLE\PRODUCT\10.1.0\DB_1\ORCL\REDO03.LOG thread=1 sequ
ence=171
media recovery complete
Finished recover at 20-APR-04

RMAN> alter database open resetlogs;

database opened

RMAN>

[oraclelogan]

[Quote=引用 5 楼 oraclelogan 的回复:]
你的错误应当是在恢复的时候，
利用备份的控制文件恢复需要指定redo（在rman中恢复就免了）

这个是我的过程，我不利用恢复目录都可以
RMAN> connect target

connected to target database (not started)

RMAN> set dbid 1050796214

executing command: SET DBID

RMAN> startup nomount

Oracle instance started

Total System Global Area    167772160 bytes

Fixed Size                      787968…
[/Quote]

是在itpub上面找到的资料

[ruihuahan]

但是如果我删除了数据库重新建立却无法恢复
======================================
如果不使用 catalog，备份信息是保存在控制文件中的，原来的控制文件文件没有了，备份信息就没有了，当然也就不能恢复了。
rman 有一个自动备份控制文件选项，如果有控制文件备份，可以先恢复控制文件，然后恢复数据库。

[star_guan2008]

删除了数据库
怎么删除的？ 题外话。.