oracle 磁带 恢复,从磁带中恢复控制文件

我以前legato备份到磁带的, 系统是2003+10g

今天出了问题,需要恢复控制文件,但是提示说找不到自动备份的控制文件,因为我最近一段时间没有执行备份操作,可能控制文件已经比较老了,这样如何操作阿

我可以直接在磁带中把备份集的控制文件备份路径直接写在恢复脚本里,类似 restore controlfile from 路径 么,

C:\>rman target /

Recovery Manager: Release 10.2.0.3.0 - Production on Mon Nov 17 11:09:23 2008

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

connected to target database: SESC_COM (not mounted)

RMAN> set dbid 2329755392

executing command: SET DBID

RMAN> connect target sys/sys@cnc-2

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-06167: already connected

RMAN> run {

2> allocate channel m1 type 'SBT_TAPE'

3> parms 'ENV=(NSR_CLIENT=mf.cnc-2.com,NSR_SERVER=main.cnc-2.com)

';

4> restore controlfile from autobackup;

5> release channel m1;

6> }

using target database control file instead of recovery catalog

allocated channel: m1

channel m1: sid=2191 devtype=SBT_TAPE

channel m1: NMO v4.5.0.0

Starting restore at 17-NOV-08

channel m1: looking for autobackup on day: 20081117

channel m1: looking for autobackup on day: 20081116

channel m1: looking for autobackup on day: 20081115

channel m1: looking for autobackup on day: 20081114

channel m1: looking for autobackup on day: 20081113

channel m1: looking for autobackup on day: 20081112

channel m1: looking for autobackup on day: 20081111

channel m1: no autobackup in 7 days found

released channel: m1

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of restore command at 11/17/2008 11:29:10

RMAN-06172: no autobackup found or specified handle is not a valid copy or piece

RMAN>

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值