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

Article:TECH202207  |  Created: 2013-01-29  |  Updated: 2013-11-18  |  Article URL http://www.symantec.com/docs/TECH202207
Article Type
Technical Solution


Issue



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



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

 


Environment



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


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.

.


Supplemental Materials

SourceETrack
Value2995598
Description

ORCL:Restore oracle database failed with error 0xE0001501 - specified backup object was not found in Backup Exec Catalogs.




Article URL http://www.symantec.com/docs/TECH202207


Terms of use for this information are found in Legal Notices