Restore Controlfile from SBT Tape Fails RMAN-6172 (Doc ID 1314134.1)

rongshiyuan發表於2014-05-22
RESTAI

Restore Controlfile from SBT Tape Fails RMAN-6172 (Doc ID 1314134.1)


In this Document

Symptoms
Cause
Solution


Applies to:

Oracle Database - Enterprise Edition - Version 9.0.1.0 and later
Information in this document applies to any platform.
***Checked for relevance on 16-Apr-2014***

Symptoms

Restore of controlfile from SBT tape to new host.
Media Manager configuration is set to restore to new host.
The Media Manager lists the controlfile backuppiece as available in the media manager repository.
RMAN restore fails:

RMAN> restore controlfile from '' ;

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

Cause

The backuppiece has expired:

RMAN> list backup of controlfile;


This shows the status of the controlfile as EXPIRED.

Solution

 

RMAN> crosscheck backup of controlfile;


The crosscheck command updates outdated RMAN repository information about backups whose repository records do not match their physical status.

Controlfile status will be updated to AVAILABLE.

Restore of controlfile is then successful.

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/17252115/viewspace-1167441/，如需轉載，請註明出處，否則將追究法律責任。

相關文章