設定路徑找到自動備份的控制檔案

C:\Documents and Settings\Paul Yi>rman target /

Recovery Manager: Release 9.2.0.4.0 - Production

Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.

connected to target database: PUBTEST (DBID=792660220)

RMAN> startup force nomount

Oracle instance started

Total System Global Area     101785252 bytes

Fixed Size                      454308 bytes
Variable Size                 75497472 bytes
Database Buffers              25165824 bytes
Redo Buffers                    667648 bytes

RMAN> restore controlfile from autobackup;

Starting restore at 26-FEB-08

using target database controlfile instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=11 devtype=DISK
channel ORA_DISK_1: looking for autobackup on day: 20080226
channel ORA_DISK_1: looking for autobackup on day: 20080225
channel ORA_DISK_1: looking for autobackup on day: 20080224
channel ORA_DISK_1: looking for autobackup on day: 20080223
channel ORA_DISK_1: looking for autobackup on day: 20080222
channel ORA_DISK_1: looking for autobackup on day: 20080221
channel ORA_DISK_1: looking for autobackup on day: 20080220
channel ORA_DISK_1: no autobackup in 7 days found
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 02/26/2008 14:52:33
RMAN-06172: no autobackup found or specified handle is not a valid copy or piece

RMAN> set controlfile autobackup format for device type disk to 'd:\backup\%F';   --這句話就是

executing command: SET CONTROLFILE AUTOBACKUP FORMAT

RMAN> restore controlfile from autobackup;

Starting restore at 26-FEB-08

using channel ORA_DISK_1
channel ORA_DISK_1: looking for autobackup on day: 20080226
channel ORA_DISK_1: autobackup found: d:\backup\c-792660220-20080226-0a
channel ORA_DISK_1: controlfile restore from autobackup complete
replicating controlfile
input filename=D:\ORACLE\ORADATA\PUBTEST\CONTROL01.CTL
output filename=D:\ORACLE\ORADATA\PUBTEST\CONTROL02.CTL
output filename=D:\ORACLE\ORADATA\PUBTEST\CONTROL03.CTL
Finished restore at 26-FEB-08