我以前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>