V-79-57344-832 ORA-19919: encrypted backups to tertiary storage require Oracle Secure Backup

book

Article ID: 100045034

calendar_today

Updated On:

Description

Error Message

0xe0000340 - The Database script returned an error.  Refer to the Database script output section in job logs for more details
ORA-19919: encrypted backups to tertiary storage require Oracle Secure Backup.

Cause

The Oracle Secure Backup SBT library is the only interface that supports RMAN encrypted backups directly to media. If an encrypted RMAN backup using another SBT library is tried, then above error message is seen.

Resolution

1) Turn off Encryption within RMAN (On Oracle Server)
RMAN> CONFIGURE ENCRYPTION FOR DATABASE off;

2) Create an encryption key in Backup Exec. Click on top left corner on the BE icon -> Configuration and Settings
-> Backup Exec Settings ->Network and Security. Click on Manage Keys and create an encryption key.
Note: Pass Phrase is very important to be able to restore the encrypted data so remember it.

3) Create a Backup Job. Select Oracle database from selections. In Backup Job Settings -> Storage tab choose Software or Hardware encryption and select the Encryption key created in point 2. Save the Backup Job and run it.

 

Issue/Introduction

Oracle Backup fails with ORA-19919 encrypted backups to tertiary storage require Oracle Secure Backup.