| RMAN netbackup is failing [message #453755] |
Fri, 30 April 2010 11:33  |
shrinika
Messages: 306
Registered: April 2008
|
Senior Member |
|
|
My database version is 10g.
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
PL/SQL Release 11.1.0.7.0 - Production
CORE 11.1.0.7.0 Production
TNS for Linux: Version 11.1.0.7.0 - Production
NLSRTL Version 11.1.0.7.0 - Production
My level0 rman backup is failing. Here is the backup script.
connect target;
run { #BACKUP LEVEL_0
allocate channel t1 device type 'sbt_tape';
allocate channel t2 device type 'sbt_tape';
backup incremental level 0 as compressed backupset database;
release channel t1;
release channel t2;
}
Here is the error message...
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on t2 channel at 04/30/2010 04:00:17
ORA-19919: encrypted backups to tertiary storage require Oracle Secure Backup
RMAN-03009: failure of backup command on t2 channel at 04/30/2010 04:00:18
ORA-19919: encrypted backups to tertiary storage require Oracle Secure Backup
When i google, here is what i found.
*Cause: RMAN was configured to create encrypted backups, but the channel
is neither a DISK channel nor an Oracle Secure Backup channel.
*Action: Allocate a DISK channel or an Oracle Secure Backup channel to
use backup encryption.
Since this is netbackup, the issue is from my script or netbackup side? Your reply is very helpful...
|
|
|
|
|
|
| Re: RMAN netbackup is failing [message #453767 is a reply to message #453755] |
Fri, 30 April 2010 13:38  |
shrinika
Messages: 306
Registered: April 2008
|
Senior Member |
|
|
Michal, sorry. it is 11g database.
Here is the SHOW ALL..
RMAN> show all;
RMAN configuration parameters for database with db_unique_name xxxx are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BZIP2'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/ora/app/oracle/product/11.1.0/db_1/dbs/snapcf_XXXX.f'; # default
RMAN> |
|
|
|
|
|
| Re: RMAN netbackup is failing [message #453801 is a reply to message #453769] |
Sat, 01 May 2010 09:40 |
shrinika
Messages: 306
Registered: April 2008
|
Senior Member |
|
|
Michel, Thanks for your response. These are complete set of SHOW ALL output.
I did not miss anything...
My DB has encrypted tablespace. So i changed the the script as below and rerunning L0 backup.
connect target;
run { #BACKUP LEVEL_0
allocate channel t1 device type 'sbt_tape';
allocate channel t2 device type 'sbt_tape';
backup incremental level 0 database;
release channel t1;
release channel t2;
}
This will take a while to complete the L0 backup. In case if this does not work,
then i will use below command inside theRMAN script and try...
SET ENCRYPTION OFF FOR TABLESPACES;
I will update the status.
|
|
|
|
|
|
| Re: RMAN netbackup is failing [message #454257 is a reply to message #453802] |
Tue, 04 May 2010 11:48 |
shrinika
Messages: 306
Registered: April 2008
|
Senior Member |
|
|
Michel,
My problem is resolved now. I found that, i have encrypted tablespace on my database.
So it seems like, compressed backup will not work for encrypted tablespace.
so i changed the script as below.
connect target;
run { #BACKUP LEVEL_0
allocate channel t1 device type 'sbt_tape';
allocate channel t2 device type 'sbt_tape';
backup incremental level 0 database;
release channel t1;
release channel t2;
}
Now it works fine. Thanks for all your input.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
