Database Backup and Recovery (MOSC)

MOSC Banner

Getting ORA-01507 when setting AES256 encryption for controlfile restore in rman

edited Oct 9, 2018 3:59AM in Database Backup and Recovery (MOSC) 8 commentsAnswered

I am trying to restore/duplicate PRODDB1 from HOSTPROD01 to PRCOPY on HOSTTEST01.

The backup was taken with wallet and password encryption with AES256 algorithm.

The steps I have performed are:

Create empty PRCOPY instance on HOSTTEST01

sqlplus / as sysdba

SQL> startup nomount

In RMAN, set the decryption then restore the controlfile:

rman target / nocatalog

RMAN> set encryption algorithm 'AES256';

RMAN> set encryption algorithm 'AES256';

executing command: SET encryption

using target database control file instead of recovery catalog

RMAN> set decryption identified by 'PleaseHelp';

executing command: SET decryption

RMAN>

RMAN> restore controlfile from '/backup_path/PRODDB01_CF_aaaa_1_1_bbbb';

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center