Server Initiatied Oracle restore fail with an error "RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece"

Problem

Server Initiatied Oracle restore fail with an error

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

DBA intiatied Control file restore or Archive Log restore also fail and report the error

CDbsbOra::processMessage: ORA-19511: Error received from media manager layer, error text:
CDbsbOra::processMessage:    BEError(0xe0001501) The specified backup object wasnot found in Backup Exec catalogs.

 

 

Error Message

SGMON on media server shows the following output:

 

BECAT: [11/21/12 16:50:59] [4504] SQL connection: 221eb60 select * from ControlInfo
BECAT: [11/21/12 16:50:59] [4504] Input Parameters for VxBSARestore_View : [1] (BE_1fnqshvd_1_1),[4](ServerName::\\Servername.Domain.com\Instance),[5]
(0),[2](1800),[3](1800)
BECAT: [11/21/12 16:50:59] [4504] SELECT * FROM CatVxBSARestore_View WHERE PieceId LIKE 'BE[_]1fnqshvd[_]1[_]1' AND ResourceName = 'ServerName::\\Servername.Domain.com\Instance' AND CreateTime >= 1800 AND CreateTime <= 1800 ORDER BY CreateTime DESC, ImageNumber, PieceId, FragmentNumber
BECAT: [11/21/12 16:50:59] [4504] SQL connection: 221eb60 SELECT * FROM CatVxBSARestore_View WHERE PieceId LIKE 'BE[_]1fnqshvd[_]1[_]1' AND ResourceName = 'ServerName::\\Servername.Domain.com\Instance' AND CreateTime >= ? AND CreateTime <= ? ORDER BY CreateTime DESC, ImageNumber, PieceId, FragmentNumber
BECAT: [11/21/12 16:50:59] [4504] result(0) numRetry(300)
BECAT: [11/21/12 16:50:59] [4504] Number of records returned: 0
BECAT: [11/21/12 16:50:59] [4504] m_sqlqueryTTL( 0 )
BECAT: [11/21/12 16:50:59] [4504] return 100
BECAT: [11/21/12 16:50:59] [4504] out : CAT_BSET_NOT_FOUND

 

Cause

This issue occurs if the Oracle Server Time Zone is set to MYT, SGT. This issue may also occur with other Time Zone. If the Time Zone set on your server is not the one mentioned here then please confirm the debug log output to verify if the issue is same.

Solution

A hotfix is now available for this issue in the current version(s) of the product(s) mentioned in this article. Refer to the Hotfix link under Related Documents at the end of this article to obtain the hotfix needed to resolve the issue.

 

 

Backup Exec 2012 Rev 1798 Service Pack 3 (TECH205351).

 

 

Workaround:

Change the Linux Server Time Zone to GMT and run the restore.

Note:- Please apply the above workaround only if you are performing a Redirect Restore of Oracle data to a different Server. If you are restoring Archive Logs from RMAN on the same server (Production Server) which was backed up or restoring Control file to the same server please check with Oracle support if the Linux system Time Zone can be changed.

.


Applies To

This issue is presently seen with Oracle installed on Linux (RHEL) servers.

Terms of use for this information are found in Legal Notices.

Search

Survey

Did this article answer your question or resolve your issue?

No
Yes

Did this article save you the trouble of contacting technical support?

No
Yes

How can we make this article more helpful?

Email Address (Optional)