ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 设置路径找到自动备份的控制文件

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

原创 Linux操作系统 作者:paulyibinyi 时间:2008-02-26 15:12:03 0 删除 编辑

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

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7199859/viewspace-195785/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
学习数据库

注册时间:2007-12-11

  • 博文量
    903
  • 访问量
    6524173