RMAN restore from autobackup and tape fails with RMAN-06172
(Doc ID 1222443.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Database - Enterprise Edition - Version 10.1.0.2 to 126.96.36.199 [Release 10.1 to 12.1]
Information in this document applies to any platform.
***Checked for relevance on 20-July-2015***
You are using "restore controlfile from autobackup", the backup is on tape, you've allocated the tape channels and any necessary media manager (tape) parameters for an alternate host restore (if such a restore is happening), but the restore fails with RMAN-06172 errors. For example:
Copyright (c) 1982, 2007, Oracle. All rights reserved.
RMAN> connect target;
2> set DBID=1234567890;
5> allocate channel ch1 type 'SBT_TAPE' parms'ENV=(NB_ORA_CLIENT=source.com,NB_ORA_SERV=dest.com)';
6> set controlfile autobackup format for device type 'sbt_tape' to '%F' ;
7> RESTORE CONTROLFILE FROM AUTOBACKUP;
connected to target database: DEST (not mounted)
using target database control file instead of recovery catalog
executing command: SET DBID
allocated channel: ch1
channel ch1: sid=1114 devtype=SBT_TAPE
channel ch1: VERITAS NetBackup for Oracle - Release 5.1 (2006110403)
executing command: SET CONTROLFILE AUTOBACKUP FORMAT
Starting restore at 29-SEP-10
channel ch1: looking for autobackup on day: 20100929
channel ch1: looking for autobackup on day: 20100928
channel ch1: looking for autobackup on day: 20100927
channel ch1: looking for autobackup on day: 20100926
channel ch1: looking for autobackup on day: 20100925
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!