cancel
Showing results for 
Search instead for 
Did you mean: 

RMAN-03009: failure of allocate command on sbt_1 channel

former_member210731
Participant
0 Kudos

Hi,

I am looking to take RMAN online backup using BR* Tools.

I have configured the parameter in initSID.sap for RMAN backup onto disk.

o backup_dev_type = rman_disk

o tape_copy_cmd = rman

o disk_copy_cmd = rman

But when i start the backup it is failing with the below error message (although the backup device type is disk)

RMAN-0300: failure of allocate command on str1 channel

ORA-19554: error allocating device, device_type=SBT_TAPE and device_name:

ORA-27211:Failed to load Media Management Library.

Can some help me in sorting the same.

Regards

Mahendra K

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

>> RMAN-0300: failure of allocate command on str1 channel

>> ORA-19554: error allocating device, device_type=SBT_TAPE and device_name:

>> ORA-27211:Failed to load Media Management Library.

On the RMAN console;

CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' CLEAR;

Then, try to backup again.

And an additional statement, here from Oracle;

ORA-27211: Failed to load Media Management Library 
Cause: User-supplied SBT_LIBRARY or libobk.so could not be loaded. 
Call to dlopen for media library returned error. See Additional information for error code.
Action: Retry the command with proper media library. Or re-install Media management module for Oracle.

Best regards,

Orkun Gedik

former_member210731
Participant
0 Kudos

Hi Orkun,

Thanks for the response, the default device type on RMAN is already DISK, below details.

RMAN> show all;

using target database control file instead of recovery catalog

RMAN configuration parameters for database with db_unique_name ASD 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 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default

CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/oracle/ASD/112_64/dbs/snapcf_ASD.f'; # default

Regards

Former Member
0 Kudos

>> o backup_dev_type = rman_disk

>> o tape_copy_cmd = rman

>> o disk_copy_cmd = rman

Try this;

backup_dev_type = disk

Best regards,

Orkun Gedik

former_member210731
Participant
0 Kudos

Hi,

Will it initiate RMAN backup even if the device typer is disk and not rman_disk?

Regards

Former Member
0 Kudos

Hi,

>

> Will it initiate RMAN backup even if the device typer is disk and not rman_disk?

>

> Regards

Check title "RMAN Backups Without Backup Library", in http://help.sap.com/saphelp_nw04/helpdata/EN/3f/9d800e1aec11d2b42c00609419997a/frameset.htm

Best regards,

Orkun Gedik

former_member210731
Participant
0 Kudos

Hi Orkun,

I have tested the same but it has started normal online backup without RMAN option.

command shown in the sapbackup file is as below:

brbackup -p initASD.sap -d disk -t online -m all -k yes -e 0 -l E -U

I would like to perform RMAN backup.

Regards

Former Member
0 Kudos

Hi Orkun,

>

> I have tested the same but it has started normal online backup without RMAN option.

>

> command shown in the sapbackup file is as below:

> brbackup -p initASD.sap -d disk -t online -m all -k yes -e 0 -l E -U

>

> I would like to perform RMAN backup.

>

> Regards

http://help.sap.com/saphelp_nw04/helpdata/EN/3f/9d80081aec11d2b42c00609419997a/content.htm

Check the statement, below;

Use

This section describes how you can use the Oracle Recovery Manager (RMAN) with the SAP backup library.

Integration

The SAP backup library is an implementation of the Oracle interface System Backup to Tape (SBT) in the form of a Dynamic Link Library (DLL). The Oracle server process calls this DLL to back up data, usually to tape.

Without this library, the Oracle Server process can only back up to a local disk. For tape management reasons, an SBT backup library is always required for a backup to tape.

Best regards,

Orkun Gedik

former_member210731
Participant
0 Kudos

Hi Orkun,

Agreed, but i want to take the backup on to the disk and have specified the same as my destination path as well.

but it i done know from where is it picking SBT_TAPE device? Is there some parameter specifically needed to set for RMAN backup onto disk.

Regards

Former Member
0 Kudos

Hi Orkun,

>

> Agreed, but i want to take the backup on to the disk and have specified the same as my destination path as well.

>

> but it i done know from where is it picking SBT_TAPE device? Is there some parameter specifically needed to set for RMAN backup onto disk.

>

> Regards

Hi,

When you set "backup_dev_type = rman_*", it will backup to the tape, automatically. If you would like to backup to disk, you should have an external library.

You can find the "RMAN Backup Strategies" in, http://help.sap.com/saphelp_sm32/helpdata/en/0e/f10a7443d711d29fef0000e8a5ae06/content.htm

If you would like to backup to the remote storage, you can find the info, below;

http://help.sap.com/saphelp_nw70ehp1/helpdata/EN/87/e4eb7c2cc35242a01ae5f592df71af/content.htm

You can use RMAN savesets, also;

Check the note 1101530 - Support for RMAN savesets for backups on hard disk, also

Best regards,

Orkun Gedik

Edited by: Orkun Gedik on Jun 9, 2011 10:35 AM

former_member210731
Participant
0 Kudos

Hi Orkun,

Your 1st link states the we can only take the disk bakcup of RMAN w/o Media library and which means i must be able to take the backup onto local disk w/o MML.

I am still sure how to perform the backup onto local disk, as said earlier i am able to perform normal RMAN backup w/o brtools.

Can you help me identify a solution or it is a mandatory to have MML for any backup with RMAN (disk /tape)

Regards

former_member210731
Participant
0 Kudos

Hi Orkun,

getting the below error.

afosdev:oraasd 81> brbackup -p initASD.sap -d disk -t online -m incr

BR0051I BRBACKUP 7.00 (32)

BR0114W Software compression not supported for 'rman'

BR0055I Start of database backup: begblkai.ind 2011-06-09 14.04.00

BR0484I BRBACKUP log file: /oracle/ASD/sapbackup/begblkai.ind

BR0071E BRBACKUP currently running or was killed

BR0072I Please delete file /oracle/ASD/sapbackup/.lock.brb if BRBACKUP was killed

BR0073E Setting of BRBACKUP lock failed

BR0280I BRBACKUP time stamp: 2011-06-09 14.04.05

BR0301E SQL error -1017 at location BrDbConnect-2, SQL statement:

'CONNECT system/*******'

ORA-01017: invalid username/password; logon denied

BR0310E Connect to database instance ASD failed

BR0056I End of database backup: begblkai.ind 2011-06-09 14.04.00

BR0280I BRBACKUP time stamp: 2011-06-09 14.04.05

BR0054I BRBACKUP terminated with errors

Former Member
0 Kudos

Hi Srirangarajan,

>>BR0301E SQL error -1017 at location BrDbConnect-2, SQL statement:

'CONNECT system/*******'

This is another issue. Execute the command below;

brbackup -u / -p initASD.sap -d disk -t online -m incr

Best regards,

Orkun Gedik

former_member210731
Participant
0 Kudos

Hi Orkun,

Please correct my understanding,

1st we have to start full backup with normal brbackup and only incremental backups are taken with RMAN

Regards

Former Member
0 Kudos

You are exactly correct, my friend

but you can also take full online and offline by using RMAN

Former Member
0 Kudos

Let me clear the issue,

You can take full backup with RMAN, also. And continue with incremental backup with RMAN. If you backup with brbackup, you will not be able to continue with RMAN.

Best regards,

Orkun Gedik

former_member210731
Participant
0 Kudos

Thanks for the response, Since i am not able to start full online backup with RMAN, I have started the online backup with not mode and will later take incremental backup with RMAN.

will it be any issue? also is there any work around to get RMAN backup?

Regards

former_member210731
Participant
0 Kudos

I have started the backup with below options.

brbackup -p initASD.sap -d disk -t online -m all -k yes -e 0 -l E -U

and it is running fine onto local HDD, my initASD.sap file has following entries.

backup_dev_type = disk

disk_copy_cmd = rman

how do i know whether backup is running via RMAN?

Regards

Former Member
0 Kudos

Hi Srirangarajan,

Because you configured an RMAN backup with the parameter, below;

disk_copy_cmd = rman

Now try to take an incremental backup (level 1) and see the result.

For the further information you can check ADM505 - Database Administration Oracle course document.

Best regards,

Orkun Gedik

former_member210731
Participant
0 Kudos

Hi,

I have stated the full backup and which is expected to complete in about 30 minutes and post which i will test the incremental backup as well and confirm.

Regards

Former Member
0 Kudos

perfect!

former_member210731
Participant
0 Kudos

Hi Orkun,

After my sucessful backup completion with the below option

brbackup -p initASD.sap -d disk -t online -m all -k yes -e 0 -l E -U

I later issued below the command ofr incremental backup.

brbackup -u system/asdadm123 -p initASD.sap -d disk -t online -m incr -e 2

but it failed stating: fail to indentfy the full backup and hence i have again started the full backup with below options.

brbackup -u system/asdadm123 -p initASD.sap -d disk -t online -m full -e 2

and post which is will issue the incremental backup options stated above, could let me know whether it will help?

Regards

Former Member
0 Kudos

It should work with the commands, below;

1. Full backup (level 0) without RMAN:

brbackup u2013m full u2013d tape|pipe|util_file

2. Incremental backup (level 1) to disk with RMAN:

brbackup u2013m incr u2013d disk

Use "u2013m full" instead of "u2013m all". What is the error statement, exactly?

For the testing reasons, execute the command more simple, "brbackup -u / -p initASD.sap -d disk -t online -m full"

Former Member
0 Kudos

Hi Srirangarajan,

Did you tested the backup with "-m full" parameter? This is because with "-m all" parameter, the backup will not be cataloged which means that the the full backup cannot be used for RMAN incremental backup.

Best regards,

Orkun Gedik

former_member210731
Participant
0 Kudos

Hi Orkun,

Thanks for all the assistance, I am not able to take level 0 (full backup) and Level 1 backup sucessfully.

For production we plan to follow the below approach, as we do not have enough space in oraarch folder to keep the archive files for long.

Sunday: Level 0 (full backup)

Monday to Saturday: Level 1 (incremental from level 0)

Please confirm to me whether after level 0 can i delete the archive log files and will the next level 1 run to sucess?

Regards

Mahendra K

Former Member
0 Kudos

Hi Mahendra,

>> Please confirm to me whether after level 0 can i delete the archive log files and will the next level 1 run to sucess?

It is upto what kind of backup strategy you are planning to perform. Technically, for the point-in-time recovery you should backup offline redolog files by using "brarchive", at the same time with your database backup. At the production site, I recommend that you start brarchive with "-cds" option, after the succesful RMAN backup. As you know that brarchive delete offline redolog files, after the respectful backup operation, automatically.

If you just want to open the database with the succesfully taken online RMAN backup, you need offline redolog files, as well. In order to copy offline redolog files, created during the online backup, into the same volume with datafiles, you should perform the backup with by "-t online_cons" parameter. At this stage, you can delete copied offline redolog files, manually. Please note that you can delete only backed up offline redolog files, manually.

Until this point, I explained the theory, in order to be clear.

If we come to your conclusion, after you completed level 1 backup succesfully and don't need to restore the database to the level 0 online backup time, you can delete offline redolog files between level 0 and level 1 backup, manually. But, please take into account that you shouldn't delete offline redolog files during created the online backup and beyond, manually.

I hope that I clarified the issue,

Best regards,

Orkun Gedik