oracle rman设置路径找到自动备份的控制文件

教程发布:风哥 教程分类:ITPUX技术网 更新日期:2022-02-12 浏览学习:45

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

本文标签:
网站声明:本文由风哥整理发布,转载请保留此段声明,本站所有内容将不对其使用后果做任何承诺,请读者谨慎使用!
【上一篇】
【下一篇】