oracle rman设置路径找到自动备份的控制文件
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> [color=#cc3333]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