Unsolved
This post is more than 5 years old
2 Intern
•
139 Posts
0
1535
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.......
vishwanathkrish
75 Posts
0
June 5th, 2012 20:00
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
SabarnaDeb
2 Intern
2 Intern
•
139 Posts
0
June 5th, 2012 21:00
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.
SabarnaDeb
2 Intern
2 Intern
•
139 Posts
0
June 11th, 2012 07:00
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............
SabarnaDeb
2 Intern
2 Intern
•
139 Posts
0
June 12th, 2012 07:00
At last oracle backup with encryption option completed.
Reason: week password. (easy)
Sol: strong password with some special character.