on 06-09-2011 6:38 AM
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
>> 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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
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
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
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
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
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
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"
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
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
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.