linux修改显示自动备份文件路径,设置路径找到自动备份的控制文件

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