你的错误应当是在恢复的时候, 利用备份的控制文件恢复需要指定redo(在rman中恢复就免了)这个是我的过程,我不利用恢复目录都可以 RMAN> connect targetconnected to target database (not started)RMAN> set dbid 1050796214executing command: SET DBIDRMAN> startup nomountOracle instance startedTotal System Global Area 167772160 bytesFixed Size 787968 bytes Variable Size 61864448 bytes Database Buffers 104857600 bytes Redo Buffers 262144 bytesRMAN> 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=DISKrecovery 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-04RMAN> alter database mount;database mounted released channel: ORA_DISK_1RMAN> 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-04Starting implicit crosscheck copy at 20-APR-04 using channel ORA_DISK_1 Finished implicit crosscheck copy at 20-APR-04searching for all files in the recovery area cataloging files... cataloging doneList of Cataloged Files ======================= File Name: E:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\ORCL\AUTOBACKUP\2004_04_ 20\O1_MF_S_523968056_0893FS2X_.BKPusing channel ORA_DISK_1starting media recoveryarchive 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-04RMAN> alter database open resetlogs;database openedRMAN>
这样太麻烦
利用备份的控制文件恢复需要指定redo(在rman中恢复就免了)这个是我的过程,我不利用恢复目录都可以
RMAN> connect targetconnected to target database (not started)RMAN> set dbid 1050796214executing command: SET DBIDRMAN> startup nomountOracle instance startedTotal System Global Area 167772160 bytesFixed Size 787968 bytes
Variable Size 61864448 bytes
Database Buffers 104857600 bytes
Redo Buffers 262144 bytesRMAN> 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=DISKrecovery 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-04RMAN> alter database mount;database mounted
released channel: ORA_DISK_1RMAN> 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-04Starting implicit crosscheck copy at 20-APR-04
using channel ORA_DISK_1
Finished implicit crosscheck copy at 20-APR-04searching for all files in the recovery area
cataloging files...
cataloging doneList of Cataloged Files
=======================
File Name: E:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\ORCL\AUTOBACKUP\2004_04_
20\O1_MF_S_523968056_0893FS2X_.BKPusing channel ORA_DISK_1starting media recoveryarchive 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-04RMAN> alter database open resetlogs;database openedRMAN>
是在itpub上面找到的资料
======================================
如果不使用 catalog,备份信息是保存在控制文件中的,原来的控制文件文件没有了,备份信息就没有了,当然也就不能恢复了。
rman 有一个自动备份控制文件选项,如果有控制文件备份,可以先恢复控制文件,然后恢复数据库。