on 05-14-2010 8:58 AM
Hi,
We have planned to implement RMAN for taking the backup of our SAP database. The backup would be taken to the local disk.
We plan to run the run the RMAN level 0 backup on every weekend (Sun) and then the incremental backup on everyday of the week(Mon-Sat).
We are not using the SAP Backup library nor any external backup libraries. But I think that backups to local disks does not require a backup Library.
The following Parameters were set in the init<sid>.sap file for our BRTOOLS.
rman_compress = yes
backup_dev_type = disk
disk_copy_cmd = rman_set
But when tried running the BRBACKUP, it failed.
brbackup -p initXID.sap -d rman_prep -t online -m all -e 8 -l E -U (RMAN Preparation Run)
RMAN> connect target *
connected to target database: XID (DBID=3524048029)
using target database control file instead of recovery catalog
RMAN> *end-of-file*
RMAN>
host command complete
RMAN> 2> 3> 4> 5> 6>
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of allocate command on sbt channel at 05/12/2010 05:56:48
ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-27211: Failed to load Media Management Library
Additional information: 25
RMAN>
I am not sure why BRBACKP is trying to use "SBT Channel" even after setting the parameter "backup_dev_type = disk". Can someone please advise ?
Regards
Arun Brelvi
Hi,
Set the following parameter in initSID.sap or the file you use.
backup_type = online
backup_dev_type = disk
backup_root_dir = /oracle/<SID>/sapbackup/<give any directory>
disk_copy_cmd = rman
NOTE: all the parameter I mentioned above will be applicable to rman incremental backup only. Full backup (the so called level 0) to disk is not possible using RMAN.
So in your backup strategy, schedule "Fulldatabase Online backup" (NOT whole database online) from transaction DB13...this will get registered as the level 0 for further RMAN incremental backup.
The command you gave is ending with an error because of the parmeter disk_copy_cmd = rman_set. Any value rman_* will look for tape library (SAP library or external library).
Regards,
Anish
Edited by: Mohammed Anish on May 24, 2010 4:13 PM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Try changing the parameter in init<SID>.sap as below:
backup_dev_type = rman_disk
Also use latest BRTools.
Regards.
Rajesh Narkhede
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
It still gives the same error. I changed the parameter - backup_dev_type = rman_disk. I am using BRBACKUP 7.00 (48).
BR0280I BRBACKUP time stamp: 2010-05-17 04.54.52
BR0057I Backup of database: XID
BR0058I BRBACKUP action ID: bedgbcrb
BR0059I BRBACKUP function ID: fnr
BR0110I Backup mode: FULL
BR0077I Database file for backup: /oracle/XID/sapbackup/cntrlXID.dbf
BR0061I 23 files found for backup, total size 58023.500 MB
BR0143I Backup type: online
BR1397I Files will be compressed by RMAN
BR0130I Backup device type: rman_disk
BR0280I BRBACKUP time stamp: 2010-05-17 04.54.52
BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRBACKUP:
BR0280I BRBACKUP time stamp: 2010-05-17 04.55.02
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...
BR0370I Directory /archive/offLine/xid/bedgbcrb created
BR0202I Saving init_ora
BR0203I to /archive/offLine/xid/XID ...
BR0202I Saving /oracle/XID/102_64/dbs/initXID.sap
BR0203I to /archive/offLine/xid/XID ...
BR0280I BRBACKUP time stamp: 2010-05-17 04.55.03
BR0198I Profiles saved successfully
BR0280I BRBACKUP time stamp: 2010-05-17 04.55.03
BR0504I Starting full database backup (level 0) using RMAN...
BR0278E Command output of 'SHELL=/bin/sh /oracle/XID/102_64/bin/rman nocatalog':
Recovery Manager: Release 10.2.0.4.0 - Production on Mon May 17 04:55:03 2010
Copyright (c) 1982, 2007, Oracle. All rights reserved.
RMAN>
RMAN> connect target *
connected to target database: XID (DBID=3524048029)
using target database control file instead of recovery catalog
RMAN> *end-of-file*
RMAN>
host command complete
RMAN> 2> 3> 4> 5>
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of allocate command on sbt_1 channel at 05/17/2010 04:55:15
ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-27211: Failed to load Media Management Library
Additional information: 25
RMAN>
RMAN>
Recovery Manager complete.
BR0280I BRBACKUP time stamp: 2010-05-17 04.55.21
BR0279E Return code from 'SHELL=/bin/sh /oracle/XID/102_64/bin/rman nocatalog': 1
BR0522E 0 of 22 files/save sets processed by RMAN
BR0536E RMAN call for database instance XID failed
BR0280I BRBACKUP time stamp: 2010-05-17 04.55.21
BR0506E Full database backup (level 0) using RMAN failed
BR0056I End of database backup: bedgbcrb.fnr 2010-05-17 04.55.21
BR0280I BRBACKUP time stamp: 2010-05-17 04.55.24
BR0054I BRBACKUP terminated with errors
Hi,
Try setting the below parameter in init<SID>.sap
First try with:
backup_dev_type = stage
disk_copy_cmd = rman
If it doesn't work then:
backup_dev_type = disk
disk_copy_cmd = rman
Test the backup from command line (as ora<sid> user):
# brbackup u2013m full u2013d disk
Also refer the below useful link:
[http://help.sap.com/saphelp_nw04/helpdata/EN/3f/9d800e1aec11d2b42c00609419997a/frameset.htm|http://help.sap.com/saphelp_nw04/helpdata/EN/3f/9d800e1aec11d2b42c00609419997a/frameset.htm]
Regards.
Rajesh Narkhede
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.