Highlighted
SabarnaDeb
3 Argentium

Online oracle DB backup using encryption option in NMO 5.0 Networker

Hi All,

For encrypted online oracle db backup , I am using "NSR_AES_ENCRYPTION=True" in RMAN script and given password in "Data Zone Pass Phrase" in server properties but backup is aborted with below error:

* uidaccrac001:RMAN:\imsdb_FULL\SYSTEM savegrp: suppressed 367 lines of output.

* uidaccrac001:RMAN:\imsdb_FULL\SYSTEM RMAN-00571: ===========================================================

* uidaccrac001:RMAN:\imsdb_FULL\SYSTEM RMAN-03002: failure of backup plus archivelog command at 06/04/2012 21:35:14

* uidaccrac001:RMAN:\imsdb_FULL\SYSTEM

* uidaccrac001:RMAN:\imsdb_FULL\SYSTEM RMAN-03009: failure of backup command on CH5 channel at 06/04/2012 21:30:29

* uidaccrac001:RMAN:\imsdb_FULL\SYSTEM ORA-00245: control file backup operation failed

* uidaccrac001:RMAN:\imsdb_FULL\SYSTEM

* uidaccrac001:RMAN:\imsdb_FULL\SYSTEM Recovery Manager complete.

* uidaccrac001:RMAN:\imsdb_FULL\SYSTEM The backup process failed:

* uidaccrac001:RMAN:\imsdb_FULL\SYSTEM RMAN exited with return code '1'.

* uidaccrac001:RMAN:\imsdb_FULL\SYSTEM Exiting with error:

* uidaccrac001:RMAN:\imsdb_FULL\SYSTEM RMAN exited with return code '1'.

uidaccrac001:     RMAN exited with return code '1'.

* uidaccrac001:RMAN:\imsdb_FULL\SYSTEM

Normal backup without using NSR_AES_ENCRYPTION completed successfully.

I have a one small doubt. Do we need to set below RMAN parameter for successfull encryption (NSR_AES_ENCRYPTION=True) online oracle database backup from networker.

CONFIGURE ENCRYPTION FOR DATABASE OFF; # default  ---> ON
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default  -----> AES256

Kindly help.......

0 Kudos
4 Replies

Re: Online oracle DB backup using encryption option in NMO 5.0 Networker

Hi,

      for encrypting  Oracle data using Networker Module for Oracle, you can refer the following Knowledge base article

http://solutions.emc.com/EMCSolutionView.asp?id=esg102896&usertype=C

Thank you,

Vishwanath K

0 Kudos
SabarnaDeb
3 Argentium

Re: Online oracle DB backup using encryption option in NMO 5.0 Networker

Hi Vishwanath,

Thanks for your reply. I had already used "NSR_AES_ENCRYPTION=TRUE" in RMAN script and provided password in "Data Zone pass phrase" but backup is failing with this error "ORA-00245: control file backup operation failed" therefore  do i set below two parameter in RMAN parameter file for sucessful encryption backup.

CONFIGURE ENCRYPTION FOR DATABASE ON;

CONFIGURE ENCRYPTION ALGORITHM 'AES256';

If i start backup without encryption option then backup will complete successfully.

0 Kudos
SabarnaDeb
3 Argentium

Re: Online oracle DB backup using encryption option in NMO 5.0 Networker

Still backup is failing with encryption option.  If i am taking only "user" tablespace including control file with encryption or full database backup without encryption option then backup will get completed successfully.

Kindly suggest what to do............

0 Kudos
SabarnaDeb
3 Argentium

Re: Online oracle DB backup using encryption option in NMO 5.0 Networker

At last oracle backup with encryption option completed.

Reason: week password. (easy)

Sol: strong password with some special character.

0 Kudos