on 08-02-2007 1:30 PM
Hello Everyone,
<b>
I was performing offline BRBACKUP through brtools over disk for which i changed backup_root_dir in initSID.sap and the drive over which iam taking this backup has 100 gb of free space and total databse size for backup is 51 gb. After i hv started BRBACKUP iam getting following error message:the error message is in bold:</b>
-
Detail log: bdvvlbnh.afd
-
BR0051I BRBACKUP 7.00 (24)
BR0055I Start of database backup: bdvvlbnh.afd 2007-08-02 15.01.17
BR0484I BRBACKUP log file: I:\oracle\SMD\sapbackup\bdvvlbnh.afd
BR0477I Oracle pfile G:\oracle\SMD\102\database\initSMD.ora created from spfile G:\oracle\SMD\102\database\spfileSMD.ora
BR0101I Parameters
Name Value
oracle_sid SMD
oracle_home G:\oracle\SMD\102
oracle_profile G:\oracle\SMD\102\database\initSMD.ora
sapdata_home I:\oracle\SMD
sap_profile G:\oracle\SMD\102\database\initSMD.sap
backup_mode ALL
backup_type offline_force
backup_dev_type disk
backup_root_dir Z:\offlinebackupsolman02082007
compress no
disk_copy_cmd copy
cpio_disk_flags -pdcu
exec_parallel 0
system_info smdadm SOLUTIOND Windows 5.2 Build 3790 Intel
oracle_info SMD 10.2.0.2.0 8192 862 9470189 SOLUTIOND WE8DEC UTF8
sap_info 700 SAPSR3 0002LK0003SMD0011G19261628030013NetWeaver_ORA
make_info NTintel OCI_10201_SHARE Mar 20 2007
command_line H:\usr\sap\SMD\SYS\exe\nuc\NTI386\brbackup.exe -p initSMD.sap -d disk -t offline_force -m all -k no -e 0 -l E -U
BR0116I ARCHIVE LOG LIST before backup for database instance SMD
Parameter Value
Database log mode Archive Mode
Automatic archival Enabled
Archive destination H:\oracle\SMD\oraarch\SMDarch
Archive format ARC%S_%R.%T
Oldest online log sequence 859
Next log sequence to archive 862
Current log sequence 862 SCN: 9470189
Database block size 8192 Thread: 1
Current system change number 9496044 ResetId: 625157965
BR0118I Tablespaces and data files
Tablespace TS-Status F-Status File Size Id. Device Link Type MaxSize IncrSize BlkSize
PSAPSR3 ONLINE* ONLINE+ I:\ORACLE\SMD\SAPDATA2\SR3_10\SR3.DATA10 440410112 13 8 NOLINK FILE 10485760000 20971520 8192
PSAPSR3 ONLINE* ONLINE+ I:\ORACLE\SMD\SAPDATA2\SR3_11\SR3.DATA11 440410112 26 8 NOLINK FILE 10485760000 20971520 8192
PSAPSR3 ONLINE* ONLINE+ I:\ORACLE\SMD\SAPDATA2\SR3_1\SR3.DATA1 2097160192 4 8 NOLINK FILE 10485760000 20971520 8192
PSAPSR3 ONLINE* ONLINE+ I:\ORACLE\SMD\SAPDATA2\SR3_2\SR3.DATA2 2097160192 5 8 NOLINK FILE 10485760000 20971520 8192
PSAPSR3 ONLINE* ONLINE+ I:\ORACLE\SMD\SAPDATA2\SR3_3\SR3.DATA3 2097160192 6 8 NOLINK FILE 10485760000 20971520 8192
PSAPSR3 ONLINE* ONLINE+ I:\ORACLE\SMD\SAPDATA2\SR3_4\SR3.DATA4 2097160192 7 8 NOLINK FILE 10485760000 20971520 8192
PSAPSR3 ONLINE* ONLINE+ I:\ORACLE\SMD\SAPDATA2\SR3_5\SR3.DATA5 2097160192 8 8 NOLINK FILE 10485760000 20971520 8192
PSAPSR3 ONLINE* ONLINE+ I:\ORACLE\SMD\SAPDATA2\SR3_6\SR3.DATA6 2097160192 9 8 NOLINK FILE 10485760000 20971520 8192
PSAPSR3 ONLINE* ONLINE+ I:\ORACLE\SMD\SAPDATA2\SR3_7\SR3.DATA7 2097160192 10 8 NOLINK FILE 10485760000 20971520 8192
PSAPSR3 ONLINE* ONLINE+ I:\ORACLE\SMD\SAPDATA2\SR3_8\SR3.DATA8 2097160192 11 8 NOLINK FILE 10485760000 20971520 8192
PSAPSR3 ONLINE* ONLINE+ I:\ORACLE\SMD\SAPDATA2\SR3_9\SR3.DATA9 2097160192 12 8 NOLINK FILE 10485760000 20971520 8192
PSAPSR3700 ONLINE* ONLINE+ I:\ORACLE\SMD\SAPDATA3\SR3700_1\SR3700.DATA1 2852134912 14 8 NOLINK FILE 10485760000 20971520 8192
PSAPSR3700 ONLINE* ONLINE+ I:\ORACLE\SMD\SAPDATA3\SR3700_2\SR3700.DATA2 3061850112 15 8 NOLINK FILE 10485760000 20971520 8192
PSAPSR3700 ONLINE* ONLINE+ I:\ORACLE\SMD\SAPDATA3\SR3700_3\SR3700.DATA3 2998935552 16 8 NOLINK FILE 10485760000 20971520 8192
PSAPSR3700 ONLINE* ONLINE+ I:\ORACLE\SMD\SAPDATA3\SR3700_4\SR3700.DATA4 2820677632 17 8 NOLINK FILE 10485760000 20971520 8192
PSAPSR3700 ONLINE* ONLINE+ I:\ORACLE\SMD\SAPDATA3\SR3700_5\SR3700.DATA5 2820677632 22 8 NOLINK FILE 10485760000 20971520 8192
PSAPSR3700 ONLINE* ONLINE+ I:\ORACLE\SMD\SAPDATA3\SR3700_6\SR3700.DATA6 2820677632 23 8 NOLINK FILE 10485760000 20971520 8192
PSAPSR3700 ONLINE* ONLINE+ I:\ORACLE\SMD\SAPDATA3\SR3700_7\SR3700.DATA7 2820677632 24 8 NOLINK FILE 10485760000 20971520 8192
PSAPSR3700 ONLINE* ONLINE+ I:\ORACLE\SMD\SAPDATA3\SR3700_8\SR3700.DATA8 2820677632 25 8 NOLINK FILE 10485760000 20971520 8192
PSAPSR3DB ONLINE* ONLINE+ I:\ORACLE\SMD\SAPDATA4\SR3DB_1\SR3DB.DATA1 2097160192 19 8 NOLINK FILE 10485760000 20971520 8192
PSAPSR3DB ONLINE* ONLINE+ I:\ORACLE\SMD\SAPDATA4\SR3DB_2\SR3DB.DATA2 2097160192 20 8 NOLINK FILE 10485760000 20971520 8192
PSAPSR3DB ONLINE* ONLINE+ I:\ORACLE\SMD\SAPDATA4\SR3DB_3\SR3DB.DATA3 1048584192 21 8 NOLINK FILE 10485760000 20971520 8192
PSAPSR3USR ONLINE* ONLINE+ I:\ORACLE\SMD\SAPDATA4\SR3USR_1\SR3USR.DATA1 20979712 18 8 NOLINK FILE 10485760000 20971520 8192
PSAPTEMP ONLINE# ONLINE+ I:\ORACLE\SMD\SAPDATA1\TEMP_1\TEMP.DATA1 891297792 -1 8 NOLINK FILE 10485760000 20971520 8192
PSAPUNDO ONLINE- ONLINE+ I:\ORACLE\SMD\SAPDATA1\UNDO_1\UNDO.DATA1 4068483072 2 8 NOLINK FILE 10485760000 20971520 8192
SYSAUX ONLINE* ONLINE+ I:\ORACLE\SMD\SAPDATA1\SYSAUX_1\SYSAUX.DATA1 209723392 3 8 NOLINK FILE 10485760000 20971520 8192
SYSTEM ONLINE* SYSTEM+ I:\ORACLE\SMD\SAPDATA1\SYSTEM_1\SYSTEM.DATA1 471867392 1 8 NOLINK FILE 10485760000 20971520 8192
BR0119I Redo log files
File Size Group Device Status Link Type
J:\ORACLE\SMD\ORIGLOGA\LOG_G11M1.DBF 52429312 1 9 STALE NOLINK FILE
G:\ORACLE\SMD\MIRRLOGA\LOG_G11M2.DBF 52429312 1 6 STALE NOLINK FILE
J:\ORACLE\SMD\ORIGLOGB\LOG_G12M1.DBF 52429312 2 9 INUSE NOLINK FILE
G:\ORACLE\SMD\MIRRLOGB\LOG_G12M2.DBF 52429312 2 6 INUSE NOLINK FILE
J:\ORACLE\SMD\ORIGLOGA\LOG_G13M1.DBF 52429312 3 9 INUSE NOLINK FILE
G:\ORACLE\SMD\MIRRLOGA\LOG_G13M2.DBF 52429312 3 6 INUSE NOLINK FILE
J:\ORACLE\SMD\ORIGLOGB\LOG_G14M1.DBF 52429312 4 9 STALE NOLINK FILE
G:\ORACLE\SMD\MIRRLOGB\LOG_G14M2.DBF 52429312 4 6 STALE NOLINK FILE
BR0120I Control files
File Size Id. Device Link Type
J:\oracle\SMD\origlogA\cntrl\cntlrSMD.dbf 12664832 0 9 NOLINK FILE
J:\oracle\SMD\origlogB\cntrl\cntrlSMD.dbf 12664832 0 9 NOLINK FILE
I:\oracle\SMD\sapdata1\cntrl\cntrlSMD.dbf 12664832 0 8 NOLINK FILE
BR0616I Tablespaces in table TSORA for SAP owner SAPSR3:
PSAPSR3, PSAPSR3700, PSAPSR3USR
BR0280I BRBACKUP time stamp: 2007-08-02 15.01.27
BR0057I Backup of database: SMD
BR0058I BRBACKUP action ID: bdvvlbnh
BR0059I BRBACKUP function ID: afd
BR0110I Backup mode: ALL
BR0077I Database files for backup:
J:\ORACLE\SMD\ORIGLOGA\LOG_G11M1.DBF
J:\ORACLE\SMD\ORIGLOGB\LOG_G12M1.DBF
J:\ORACLE\SMD\ORIGLOGA\LOG_G13M1.DBF
J:\ORACLE\SMD\ORIGLOGB\LOG_G14M1.DBF
J:\oracle\SMD\origlogA\cntrl\cntlrSMD.dbf
BR0061I 32 files found for backup, total size 51402.291 MB
BR0143I Backup type: offline_force
BR0112I Files will not be compressed
BR0130I Backup device type: disk
BR0106I Files will be saved on disk in directory: Z:\offlinebackupsolman02082007\bdvvlbnh
BR0064I Database instance SMD will be shut down now
BR0280I BRBACKUP time stamp: 2007-08-02 15.01.27
BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRBACKUP:
BR0280I BRBACKUP time stamp: 2007-08-02 15.02.28
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...
BR0370I Directory Z:\offlinebackupsolman02082007\bdvvlbnh created
BR0370I Directory Z:\offlinebackupsolman02082007\SMD created
BR0202I Saving init_ora
BR0203I to Z:\offlinebackupsolman02082007\SMD ...
BR0202I Saving G:\oracle\SMD\102\database\initSMD.sap
BR0203I to Z:\offlinebackupsolman02082007\SMD ...
BR0280I BRBACKUP time stamp: 2007-08-02 15.02.29
BR0198I Profiles saved successfully
BR0280I BRBACKUP time stamp: 2007-08-02 15.02.29
BR0307I Shutting down database instance SMD ...
BR0280I BRBACKUP time stamp: 2007-08-02 15.03.03
BR0308I Shutdown of database instance SMD successful
BR0202I Saving I:\ORACLE\SMD\SAPDATA2\SR3_10\SR3.DATA10
BR0203I to Z:\offlinebackupsolman02082007\bdvvlbnh\SR3.DATA10 ...
#FILE..... I:\ORACLE\SMD\SAPDATA2\SR3_10\SR3.DATA10
#SAVED.... Z:\offlinebackupsolman02082007\bdvvlbnh\SR3.DATA10 #1/1
BR0280I BRBACKUP time stamp: 2007-08-02 15.03.55
BR0063I 1 of 32 files processed - 420.008 MB of 51402.291 MB done
BR0204I Percentage done: 0.82%, estimated end time: 17:59
BR0001I __________________________________________________
BR0202I Saving I:\ORACLE\SMD\SAPDATA2\SR3_11\SR3.DATA11
BR0203I to Z:\offlinebackupsolman02082007\bdvvlbnh\SR3.DATA11 ...
#FILE..... I:\ORACLE\SMD\SAPDATA2\SR3_11\SR3.DATA11
#SAVED.... Z:\offlinebackupsolman02082007\bdvvlbnh\SR3.DATA11 #1/2
BR0280I BRBACKUP time stamp: 2007-08-02 15.04.46
BR0063I 2 of 32 files processed - 840.016 MB of 51402.291 MB done
BR0204I Percentage done: 1.63%, estimated end time: 17:23
BR0001I *_________________________________________________
BR0202I Saving I:\ORACLE\SMD\SAPDATA2\SR3_1\SR3.DATA1
BR0203I to Z:\offlinebackupsolman02082007\bdvvlbnh\SR3.DATA1 ...
#FILE..... I:\ORACLE\SMD\SAPDATA2\SR3_1\SR3.DATA1
#SAVED.... Z:\offlinebackupsolman02082007\bdvvlbnh\SR3.DATA1 #1/3
BR0280I BRBACKUP time stamp: 2007-08-02 15.08.43
BR0063I 3 of 32 files processed - 2840.023 MB of 51402.291 MB done
BR0204I Percentage done: 5.53%, estimated end time: 16:55
BR0001I ***_______________________________________________
BR0202I Saving I:\ORACLE\SMD\SAPDATA2\SR3_2\SR3.DATA2
BR0203I to Z:\offlinebackupsolman02082007\bdvvlbnh\SR3.DATA2 ...
#FILE..... I:\ORACLE\SMD\SAPDATA2\SR3_2\SR3.DATA2
#SAVED.... Z:\offlinebackupsolman02082007\bdvvlbnh\SR3.DATA2 #1/4
BR0280I BRBACKUP time stamp: 2007-08-02 15.12.37
BR0063I 4 of 32 files processed - 4840.031 MB of 51402.291 MB done
BR0204I Percentage done: 9.42%, estimated end time: 16:50
BR0001I *****_____________________________________________
BR0202I Saving I:\ORACLE\SMD\SAPDATA2\SR3_3\SR3.DATA3
BR0203I to Z:\offlinebackupsolman02082007\bdvvlbnh\SR3.DATA3 ...
#FILE..... I:\ORACLE\SMD\SAPDATA2\SR3_3\SR3.DATA3
#SAVED.... Z:\offlinebackupsolman02082007\bdvvlbnh\SR3.DATA3 #1/5
BR0280I BRBACKUP time stamp: 2007-08-02 15.16.31
BR0063I 5 of 32 files processed - 6840.039 MB of 51402.291 MB done
BR0204I Percentage done: 13.31%, estimated end time: 16:48
BR0001I *******___________________________________________
BR0202I Saving I:\ORACLE\SMD\SAPDATA2\SR3_4\SR3.DATA4
BR0203I to Z:\offlinebackupsolman02082007\bdvvlbnh\SR3.DATA4 ...
BR0278E <b>Command output of 'copy I:\ORACLE\SMD\SAPDATA2\SR3_4\SR3.DATA4 Z:\offlinebackupsolman02082007\bdvvlbnh\SR3.DATA4':
Not enough server storage is available to process this command.
0 file(s) copied.</b><b>BR0280I BRBACKUP time stamp: 2007-08-02 15.19.08
BR0279E Return code from 'copy I:\ORACLE\SMD\SAPDATA2\SR3_4\SR3.DATA4 Z:\offlinebackupsolman02082007\bdvvlbnh\SR3.DATA4': 1
BR0222E Copying I:\ORACLE\SMD\SAPDATA2\SR3_4\SR3.DATA4 to/from Z:\offlinebackupsolman02082007\bdvvlbnh\SR3.DATA4 failed due to previous errors</b>
BR0280I BRBACKUP time stamp: 2007-08-02 15.19.13
BR0304I Starting and opening database instance SMD ...
BR0280I BRBACKUP time stamp: 2007-08-02 15.19.31
BR0305I Start and open of database instance SMD successful
BR0056I End of database backup: bdvvlbnh.afd 2007-08-02 15.19.08
BR0280I BRBACKUP time stamp: 2007-08-02 15.19.33
BR0054I BRBACKUP terminated with errors
<b>Secondly i also tried performing OFFLINE full backup + Redologs backup through db13 and set the appropriate disk directories in backup_root_dir and archive_copy_dir in initSID.sap and selected archive function as -s and started job immediately but no files /directories are saved in the mentioned directories. why
is it so happening? wt is the procedure of taking backup through db13?</b>
Requested to Revert to these two queries at earliuest as iam struggling since long.
Regards,
Somya
Hello,
Eric is right, brbackup doesnt accept logical network drives you must use the exact name of the share
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
As i already said iam not facing any problem in BRBACKUP ( not even on calling it through command prompt) ,its recognising drive,iam facing problem in BRBACKUP when i schedule it frm db13 ,in the job log its giving this error message.
initSMD.sap file is as:
<b>
@(#) $Id: //bas/700_REL/src/ccm/rsbr/initNT.sap#9 $ SAP
########################################################################
#
SAP BR*Tools sample profile. #
The parameter syntax is the same as for init.ora parameters. #
Enclose parameter values which consist of more than one symbol in #
double quotes. #
After any symbol, parameter definition can be continued on the next #
line. #
A parameter value list should be enclosed in parentheses, the list #
items should be delimited by commas. #
There can be any number of white spaces (blanks, tabs and new lines) #
between symbols in parameter definition. #
Comment lines must start with a hash character. #
#
########################################################################
backup mode [all | all_data | full | incr | sap_dir | ora_dir
| all_dir | <tablespace_name> | <file_id> | <file_id1>-<file_id2>
| <generic_path> | (<object_list>)]
default: all
backup_mode = all
restore mode [all | all_data | full | incr | incr_only | incr_full
| incr_all | <tablespace_name> | <file_id> | <file_id1>-<file_id2>
| <generic_path> | (<object_list>) | partial | non_db
redirection with '=' is not supported here - use option '-m' instead
default: all
restore_mode = all
backup type [offline | offline_force | offline_standby | offline_split
| offline_mirror | offline_stop | online | online_cons | online_split
| online_mirror | online_standby | offstby_split | offstby_mirror
default: offline
backup_type = online_cons
backup device type
[tape | tape_auto | tape_box | pipe | pipe_auto | pipe_box | disk
| disk_copy | disk_standby | stage | stage_copy | stage_standby
| util_file | util_file_online | rman_util | rman_disk | rman_stage
| rman_prep]
default: tape
backup_dev_type = disk
backup root directory [<path_name> | (<path_name_list>)]
default: %SAPDATA_HOME%\sapbackup
#backup_root_dir = I:\oracle\SMD\sapbackup
backup_root_dir = Y:\backuponline07082007
stage root directory [<path_name> | (<path_name_list>)]
default: value of the backup_root_dir parameter
stage_root_dir = I:\oracle\SMD\sapbackup
compression flag [no | yes | hardware | only]
default: no
compress = no
compress command
first $-character is replaced by the source file name
second $-character is replaced by the target file name
<target_file_name> = <source_file_name>.Z
for compress command the -c option must be set
recommended setting for brbackup -k only run:
"%SAPEXE%\mkszip -l 0 -c $ > $"
no default
compress_cmd = "H:\usr\sap\SMD\SYS\exe\nuc\NTI386\mkszip -c $ > $"
uncompress command
first $-character is replaced by the source file name
second $-character is replaced by the target file name
<source_file_name> = <target_file_name>.Z
for uncompress command the -c option must be set
no default
uncompress_cmd = "H:\usr\sap\SMD\SYS\exe\nuc\NTI386\uncompress -c $ > $"
directory for compression [<path_name> | (<path_name_list>)]
default: value of the backup_root_dir parameter
compress_dir = I:\oracle\SMD\sapreorg
brarchive function [save | second_copy | double_save | save_delete
| second_copy_delete | double_save_delete | copy_save
| copy_delete_save | delete_saved | delete_copied]
default: save
archive_function = save
directory for archive log copies to disk
default: first value of the backup_root_dir parameter
archive_copy_dir = Y:\archivesonline07082007
directory for archive log copies to stage
default: first value of the stage_root_dir parameter
archive_stage_dir = I:\oracle\SMD\sapbackup
delete archive logs from duplex destination [only | no | yes | check]
default: only
archive_dupl_del = only
new sapdata home directory for disk_copy | disk_standby
no default
new_db_home = X:\oracle\C11
stage sapdata home directory for stage_copy | stage_standby
default: value of the new_db_home parameter
stage_db_home = /oracle/C11
original sapdata home directory for split mirror disk backup
no default
orig_db_home = /oracle/C11
remote host name
no default
remote_host = <host_name>
remote user name
default: current operating system user
remote_user = <user_name>
tape copy command [cpio | cpio_gnu | dd | dd_gnu | rman | rman_gnu
rman_dd | rman_dd_gnu]
default: cpio
tape_copy_cmd = cpio
disk copy command [copy | copy_gnu | dd | dd_gnu | rman | rman_gnu]
default: copy
disk_copy_cmd = copy
stage copy command [rcp | scp | ftp]
default: rcp
stage_copy_cmd = rcp
pipe copy command [rsh | ssh]
default: rsh
pipe_copy_cmd = rsh
flags for cpio output command
default: -ovB
cpio_flags = -ovB
flags for cpio input command
default: -iuvB
cpio_in_flags = -iuvB
flags for cpio command for copy of directories to disk
default: -pdcu
use flags -pdu for gnu tools
cpio_disk_flags = -pdcu
flags for dd output command
default: "obs=16k"
caution: option "obs=" not supported for Windows
recommended setting:
Unix: "obs=nk bs=nk", example: "obs=64k bs=64k"
Windows: "bs=nk", example: "bs=64k"
dd_flags = "bs=64k"
flags for dd input command
default: "ibs=16k"
caution: option "ibs=" not supported for Windows
recommended setting:
Unix: "ibs=nk bs=nk", example: "ibs=64k bs=64k"
Windows: "bs=nk", example: "bs=64k"
dd_in_flags = "bs=64k"
number of members in RMAN save sets [ 1 | 2 | 3 | 4 | tsp | all ]
default: 1
saveset_members = 1
additional parameters for RMAN
rman_channels and rman_filesperset are only used when rman_util,
rman_disk or rman_stage
rman_channels defines the number of parallel sbt channel allocations
rman_filesperset = 0 means:
one file per save set - for non-incremental backups
all files in one save set - for incremental backups
the others have the same meaning as for native RMAN
rman_channels = 1
rman_filesperset = 0
rman_maxpiecesize = 0 # in KB - former name rman_kbytes
rman_rate = 0 # in KB - former name rman_readrate
rman_maxopenfiles = 0
rman_maxsetsize = 0 # in KB - former name rman_setsize
additional parameters for RMAN version 8.1
the parameters have the same meaning as for native RMAN
rman_diskratio = 0 # deprecated in Oracle 10g
rman_pool = 0
rman_copies = 0 | 1 | 2 | 3 | 4 # former name rman_duplex
rman_proxy = no | yes | only
special parameters for an external backup library, example:
rman_parms = "BLKSIZE=65536 ENV=(BACKUP_SERVER=HOSTNAME)"
rman_send = "'<command>'"
rman_send = ("channel sbt_1 '<command1>' parms='<parameters1>'",
"channel sbt_2 '<command2>' parms='<parameters2>'")
rman_compress = no | yes
rman_maxcorrupt = (<dbf_name>|<dbf_id>:<corr_cnt>, ...)
remote copy-out command (backup_dev_type = pipe)
$-character is replaced by current device address
no default
copy_out_cmd = "dd ibs=8k obs=64k of=$"
remote copy-in command (backup_dev_type = pipe)
$-character is replaced by current device address
no default
copy_in_cmd = "dd ibs=64k obs=8k if=$"
rewind command
$-character is replaced by current device address
no default
operating system dependent, examples:
HP-UX: "mt -f $ rew"
TRU64: "mt -f $ rewind"
AIX: "tctl -f $ rewind"
Solaris: "mt -f $ rewind"
Windows: "mt -f $ rewind"
Linux: "mt -f $ rewind"
rewind = "mt -f $ rewind"
rewind and set offline command
$-character is replaced by current device address
default: value of the rewind parameter
operating system dependent, examples:
HP-UX: "mt -f $ offl"
TRU64: "mt -f $ offline"
AIX: "tctl -f $ offline"
Solaris: "mt -f $ offline"
Windows: "mt -f $ offline"
Linux: "mt -f $ offline"
rewind_offline = "mt -f $ offline"
tape positioning command
first $-character is replaced by current device address
second $-character is replaced by number of files to be skipped
no default
operating system dependent, examples:
HP-UX: "mt -f $ fsf $"
TRU64: "mt -f $ fsf $"
AIX: "tctl -f $ fsf $"
Solaris: "mt -f $ fsf $"
Windows: "mt -f $ fsf $"
Linux: "mt -f $ fsf $"
tape_pos_cmd = "mt -f $ fsf $"
mount backup volume command in auto loader / juke box
used if backup_dev_type = tape_box | pipe_box
no default
mount_cmd = "<mount_cmd> $ $ $ [$]"
dismount backup volume command in auto loader / juke box
used if backup_dev_type = tape_box | pipe_box
no default
dismount_cmd = "<dismount_cmd> $ $ [$]"
split mirror disks command
used if backup_type = offline_split | online_split | offline_mirror
| online_mirror
no default
split_cmd = "<split_cmd> [$]"
resynchronize mirror disks command
used if backup_type = offline_split | online_split | offline_mirror
| online_mirror
no default
resync_cmd = "<resync_cmd> [$]"
additional options for SPLITINT interface program
no default
split_options = "<split_options>"
resynchronize after backup flag [no | yes]
default: no
split_resync = no
pre-split command
no default
pre_split_cmd = "<pre_split_cmd>"
post-split command
no default
post_split_cmd = "<post_split_cmd>"
volume size in KB = K, MB = M or GB = G (backup device dependent)
default: 1200M
recommended values for tape devices without hardware compression:
60 m 4 mm DAT DDS-1 tape: 1200M
90 m 4 mm DAT DDS-1 tape: 1800M
120 m 4 mm DAT DDS-2 tape: 3800M
125 m 4 mm DAT DDS-3 tape: 11000M
112 m 8 mm Video tape: 2000M
112 m 8 mm high density: 4500M
DLT 2000 10/20 GB: 10000M
DLT 2000XT 15/30 GB: 15000M
DLT 4000 20/40 GB: 20000M
DLT 7000 35/70 GB: 35000M
recommended values for tape devices with hardware compression:
60 m 4 mm DAT DDS-1 tape: 1000M
90 m 4 mm DAT DDS-1 tape: 1600M
120 m 4 mm DAT DDS-2 tape: 3600M
125 m 4 mm DAT DDS-3 tape: 10000M
112 m 8 mm Video tape: 1800M
112 m 8 mm high density: 4300M
DLT 2000 10/20 GB: 9000M
DLT 2000XT 15/30 GB: 14000M
DLT 4000 20/40 GB: 18000M
DLT 7000 35/70 GB: 30000M
tape_size = 100G
volume size in KB = K, MB = M or GB = G used by brarchive
default: value of the tape_size parameter
tape_size_arch = 100G
level of parallel execution
default: 0 - set to number of backup devices
exec_parallel = 0
address of backup device without rewind
[<dev_address> | (<dev_address_list>)]
no default
operating system dependent, examples:
HP-UX: /dev/rmt/0mn
TRU64: /dev/nrmt0h
AIX: /dev/rmt0.1
Solaris: /dev/rmt/0mn
Windows: /dev/nmt0 | /dev/nst0
Linux: /dev/nst0
tape_address = /dev/nmt0
address of backup device without rewind used by brarchive
default: value of the tape_address parameter
operating system dependent
tape_address_arch = /dev/nmt0
address of backup device with rewind
[<dev_address> | (<dev_address_list>)]
no default
operating system dependent, examples:
HP-UX: /dev/rmt/0m
TRU64: /dev/rmt0h
AIX: /dev/rmt0
Solaris: /dev/rmt/0m
Windows: /dev/mt0 | /dev/st0
Linux: /dev/st0
tape_address_rew = /dev/mt0
address of backup device with rewind used by brarchive
default: value of the tape_address_rew parameter
operating system dependent
tape_address_rew_arch = /dev/mt0
address of backup device with control for mount/dismount command
[<dev_address> | (<dev_address_list>)]
default: value of the tape_address_rew parameter
operating system dependent
tape_address_ctl = /dev/...
address of backup device with control for mount/dismount command
used by brarchive
default: value of the tape_address_rew_arch parameter
operating system dependent
tape_address_ctl_arch = /dev/...
volumes for brarchive
[<volume_name> | (<volume_name_list>) | SCRATCH]
no default
volume_archive = (SMDA01, SMDA02, SMDA03, SMDA04, SMDA05,
SMDA06, SMDA07, SMDA08, SMDA09, SMDA10,
SMDA11, SMDA12, SMDA13, SMDA14, SMDA15,
SMDA16, SMDA17, SMDA18, SMDA19, SMDA20,
SMDA21, SMDA22, SMDA23, SMDA24, SMDA25,
SMDA26, SMDA27, SMDA28, SMDA29, SMDA30)
volumes for brbackup
[<volume_name> | (<volume_name_list>) | SCRATCH]
no default
volume_backup = (SMDB01, SMDB02, SMDB03, SMDB04, SMDB05,
SMDB06, SMDB07, SMDB08, SMDB09, SMDB10,
SMDB11, SMDB12, SMDB13, SMDB14, SMDB15,
SMDB16, SMDB17, SMDB18, SMDB19, SMDB20,
SMDB21, SMDB22, SMDB23, SMDB24, SMDB25,
SMDB26, SMDB27, SMDB28, SMDB29, SMDB30)
expiration period for backup volumes in days
default: 30
expir_period = 30
recommended usages of backup volumes
default: 100
tape_use_count = 100
backup utility parameter file
default: no parameter file
util_par_file = initSMD.utl
mount/dismount command parameter file
default: no parameter file
mount_par_file = initSMD.mnt
Oracle connection name to the primary database
[primary_db = <conn_name> | LOCAL]
no default
primary_db = <conn_name>
Oracle connection name to the standby database
[standby_db = <conn_name> | LOCAL]
no default
standby_db = <conn_name>
description of parallel instances for Oracle RAC
parallel_instances = <inst_desc> | (<inst_desc_list>)
<inst_desc_list> - <inst_desc>[,<inst_desc>...]
<inst_desc> - <Oracle_sid>:<Oracle_home>@<conn_name>
<Oracle_sid> - Oracle system id for parallel instance
<Oracle_home> - Oracle home for parallel instance
<conn_name> - Oracle connection name to parallel instance
Please include the local instance in the parameter definition!
default: no parallel instances
example for initRAC001.sap:
parallel_instances = (RAC001:/oracle/RAC/920_64@RAC001,
RAC002:/oracle/RAC/920_64@RAC002, RAC003:/oracle/RAC/920_64@RAC003)
database owner of objects to be checked
<owner> | (<owner_list>)
default: all SAP owners
check_owner = sapr3
database objects to be excluded from checks
all_part | non_sap | [<owner>.]<table> | [<owner>.]<index>
| [<owner>.]<prefix>* | <tablespace> | (<object_list>)
default: no exclusion, example:
check_exclude = (SDBAH, SAPR3.SDBAD)
database owner of SDBAH, SDBAD and XDB tables for cleanup
<owner> | (<owner_list>)
default: all SAP owners
cleanup_owner = sapr3
retention period in days for brarchive log files
default: 30
cleanup_brarchive_log = 30
retention period in days for brbackup log files
default: 30
cleanup_brbackup_log = 30
retention period in days for brconnect log files
default: 30
cleanup_brconnect_log = 30
retention period in days for brrestore log files
default: 30
cleanup_brrestore_log = 30
retention period in days for brrecover log files
default: 30
cleanup_brrecover_log = 30
retention period in days for brspace log files
default: 30
cleanup_brspace_log = 30
retention period in days for archive log files saved on disk
default: 30
cleanup_disk_archive = 30
retention period in days for database files backed up on disk
default: 30
cleanup_disk_backup = 30
retention period in days for brspace export dumps and scripts
default: 30
cleanup_exp_dump = 30
retention period in days for Oracle trace and audit files
default: 30
cleanup_ora_trace = 30
retention period in days for records in SDBAH and SDBAD tables
default: 100
cleanup_db_log = 100
retention period in days for records in XDB tables
default: 100
cleanup_xdb_log = 100
retention period in days for database check messages
default: 100
cleanup_check_msg = 100
database owner of objects to adapt next extents
<owner> | (<owner_list>)
default: all SAP owners
next_owner = sapr3
database objects to adapt next extents
all | all_ind | special | [<owner>.]<table> | [<owner>.]<index>
| [<owner>.]<prefix>* | <tablespace> | (<object_list>)
default: all abjects of selected owners, example:
next_table = (SDBAH, SAPR3.SDBAD)
database objects to be excluded from adapting next extents
all_part | [<owner>.]<table> | [<owner>.]<index> | [<owner>.]<prefix>*
| <tablespace> | (<object_list>)
default: no exclusion, example:
next_exclude = (SDBAH, SAPR3.SDBAD)
database objects to get special next extent size
all_sel:<size>[/<limit>] | [<owner>.]<table>:<size>[/<limit>]
| [<owner>.]<index>:<size>[/<limit>]
| [<owner>.]<prefix>*:<size>[/<limit>] | (<object_size_list>)
default: according to table category, example:
next_special = (SDBAH:100K, SAPR3.SDBAD:1M/200)
maximum next extent size
default: 2 GB - 5 * <database_block_size>
next_max_size = 1G
maximum number of next extents
default: 0 - unlimited
next_limit_count = 300
database owner of objects to update statistics
<owner> | (<owner_list>)
default: all SAP owners
stats_owner = sapr3
database objects to update statistics
all | all_ind | all_part | missing | info_cubes | dbstatc_tab
| dbstatc_mon | dbstatc_mona | [<owner>.]<table> | [<owner>.]<index>
| [<owner>.]<prefix>* | <tablespace> | (<object_list>) | harmful
| locked | system_stats | oradict_stats
default: all abjects of selected owners, example:
stats_table = (SDBAH, SAPR3.SDBAD)
database objects to be excluded from updating statistics
all_part | info_cubes | [<owner>.]<table> | [<owner>.]<index>
| [<owner>.]<prefix>* | <tablespace> | (<object_list>)
default: no exclusion, example:
stats_exclude = (SDBAH, SAPR3.SDBAD)
method for updating statistics for tables not in DBSTATC
E | EH | EI | EX | C | CH | CI | CX | A | AH | AI | AX | E= | C= | =H
| =I | =X | +H | +I
default: according to internal rules
stats_method = E
sample size for updating statistics for tables not in DBSTATC
P<percentage_of_rows> | R<thousands_of_rows>
default: according to internal rules
stats_sample_size = P10
number of buckets for updating statistics with histograms
default: 75
stats_bucket_count = 75
threshold for collecting statistics after checking
default: 50%
stats_change_threshold = 50
number of parallel threads for updating statistics
default: 1
stats_parallel_degree = 1
processing time limit in minutes for updating statistics
default: 0 - no limit
stats_limit_time = 0
parameters for calling DBMS_STATS supplied package
all:R|B:A|D|0|<degree> | all_part:R|B:A|D|0|<degree>
| info_cubes:R|B:A|D|0|<degree> | [<owner>.]<table>:R|B:A|D|0|<degree>
| [<owner>.]<prefix>*:R|B:A|D|0|<degree> | (<object_list>) | NO
'R' - row sampling, 'B' - block sampling, 'A' - auto degree,
'D' - default degree, '0' - table degree
default: ALL:R:0
stats_dbms_stats = ([ALL:R:1,][<owner>.]<table>:R:<degree>,...)
definition of info cube tables
default | rsnspace_tab | [<owner>.]<table> | [<owner>.]<prefix>*
| (<object_list>) | null
default: from RSNSPACE control table
stats_info_cubes = (/BIC/D, /BI0/D, ...)
recovery type [complete | dbpit | tspit | reset | restore | apply
| disaster]
default: complete
recov_type = complete
directory for brrecover file copies
default: $SAPDATA_HOME/sapbackup
recov_copy_dir = I:\oracle\SMD\sapbackup
time period for searching for backups
0 - all available backups, >0 - backups from n last days
default: 30
recov_interval = 30
degree of paralelism for applying archive log files
0 - use Oracle default parallelism, 1 - serial, >1 - parallel
default: Oracle default
recov_degree = 0
number of lines for scrolling in list menus
0 - no scrolling, >0 - scroll n lines
default: 20
scroll_lines = 20
time period for displaying profiles and logs
0 - all available logs, >0 - logs from n last days
default: 30
show_period = 30
directory for brspace file copies
default: $SAPDATA_HOME/sapreorg
space_copy_dir = I:\oracle\SMD\sapreorg
directory for table export dump files
default: $SAPDATA_HOME/sapreorg
exp_dump_dir = I:\oracle\SMD\sapreorg
database tables for reorganization
[<owner>.]<table> | [<owner>.]<prefix>* | [<owner>.]<prefix>%
| (<table_list>)
no default
reorg_table = (SDBAH, SAPR3.SDBAD)
database indexes for rebuild
[<owner>.]<index> | [<owner>.]<prefix>* | [<owner>.]<prefix>%
| (<index_list>)
no default
rebuild_index = (SDBAH0, SAPR3.SDBAD0)
database tables for export
[<owner>.]<table> | [<owner>.]<prefix>* | [<owner>.]<prefix>%
| (<table_list>)
no default
exp_table = (SDBAH, SAPR3.SDBAD)
database tables for import
<table> | (<table_list>)
no default
do not specify table owner in the list - use -o|-owner option for this
imp_table = (SDBAH, SDBAD)
@(#) $Id: //bas/700_REL/src/ccm/rsbr/initNT.sap#9 $ SAP
########################################################################
#
SAP BR*Tools sample profile. #
The parameter syntax is the same as for init.ora parameters. #
Enclose parameter values which consist of more than one symbol in #
double quotes. #
After any symbol, parameter definition can be continued on the next #
line. #
A parameter value list should be enclosed in parentheses, the list #
items should be delimited by commas. #
There can be any number of white spaces (blanks, tabs and new lines) #
between symbols in parameter definition. #
Comment lines must start with a hash character. #
#
########################################################################
backup mode [all | all_data | full | incr | sap_dir | ora_dir
| all_dir | <tablespace_name> | <file_id> | <file_id1>-<file_id2>
| <generic_path> | (<object_list>)]
default: all
backup_mode = all
restore mode [all | all_data | full | incr | incr_only | incr_full
| incr_all | <tablespace_name> | <file_id> | <file_id1>-<file_id2>
| <generic_path> | (<object_list>) | partial | non_db
redirection with '=' is not supported here - use option '-m' instead
default: all
restore_mode = all
backup type [offline | offline_force | offline_standby | offline_split
| offline_mirror | offline_stop | online | online_cons | online_split
| online_mirror | online_standby | offstby_split | offstby_mirror
default: offline
backup_type = online_cons
backup device type
[tape | tape_auto | tape_box | pipe | pipe_auto | pipe_box | disk
| disk_copy | disk_standby | stage | stage_copy | stage_standby
| util_file | util_file_online | rman_util | rman_disk | rman_stage
| rman_prep]
default: tape
backup_dev_type = disk
backup root directory [<path_name> | (<path_name_list>)]
default: %SAPDATA_HOME%\sapbackup
#backup_root_dir = I:\oracle\SMD\sapbackup
backup_root_dir = Y:\backuponline07082007
stage root directory [<path_name> | (<path_name_list>)]
default: value of the backup_root_dir parameter
stage_root_dir = I:\oracle\SMD\sapbackup
compression flag [no | yes | hardware | only]
default: no
compress = no
compress command
first $-character is replaced by the source file name
second $-character is replaced by the target file name
<target_file_name> = <source_file_name>.Z
for compress command the -c option must be set
recommended setting for brbackup -k only run:
"%SAPEXE%\mkszip -l 0 -c $ > $"
no default
compress_cmd = "H:\usr\sap\SMD\SYS\exe\nuc\NTI386\mkszip -c $ > $"
uncompress command
first $-character is replaced by the source file name
second $-character is replaced by the target file name
<source_file_name> = <target_file_name>.Z
for uncompress command the -c option must be set
no default
uncompress_cmd = "H:\usr\sap\SMD\SYS\exe\nuc\NTI386\uncompress -c $ > $"
directory for compression [<path_name> | (<path_name_list>)]
default: value of the backup_root_dir parameter
compress_dir = I:\oracle\SMD\sapreorg
brarchive function [save | second_copy | double_save | save_delete
| second_copy_delete | double_save_delete | copy_save
| copy_delete_save | delete_saved | delete_copied]
default: save
archive_function = save
directory for archive log copies to disk
default: first value of the backup_root_dir parameter
archive_copy_dir = Y:\archivesonline07082007
directory for archive log copies to stage
default: first value of the stage_root_dir parameter
archive_stage_dir = I:\oracle\SMD\sapbackup
delete archive logs from duplex destination [only | no | yes | check]
default: only
archive_dupl_del = only
new sapdata home directory for disk_copy | disk_standby
no default
new_db_home = X:\oracle\C11
stage sapdata home directory for stage_copy | stage_standby
default: value of the new_db_home parameter
stage_db_home = /oracle/C11
original sapdata home directory for split mirror disk backup
no default
orig_db_home = /oracle/C11
remote host name
no default
remote_host = <host_name>
remote user name
default: current operating system user
remote_user = <user_name>
tape copy command [cpio | cpio_gnu | dd | dd_gnu | rman | rman_gnu
rman_dd | rman_dd_gnu]
default: cpio
tape_copy_cmd = cpio
disk copy command [copy | copy_gnu | dd | dd_gnu | rman | rman_gnu]
default: copy
disk_copy_cmd = copy
stage copy command [rcp | scp | ftp]
default: rcp
stage_copy_cmd = rcp
pipe copy command [rsh | ssh]
default: rsh
pipe_copy_cmd = rsh
flags for cpio output command
default: -ovB
cpio_flags = -ovB
flags for cpio input command
default: -iuvB
cpio_in_flags = -iuvB
flags for cpio command for copy of directories to disk
default: -pdcu
use flags -pdu for gnu tools
cpio_disk_flags = -pdcu
flags for dd output command
default: "obs=16k"
caution: option "obs=" not supported for Windows
recommended setting:
Unix: "obs=nk bs=nk", example: "obs=64k bs=64k"
Windows: "bs=nk", example: "bs=64k"
dd_flags = "bs=64k"
flags for dd input command
default: "ibs=16k"
caution: option "ibs=" not supported for Windows
recommended setting:
Unix: "ibs=nk bs=nk", example: "ibs=64k bs=64k"
Windows: "bs=nk", example: "bs=64k"
dd_in_flags = "bs=64k"
number of members in RMAN save sets [ 1 | 2 | 3 | 4 | tsp | all ]
default: 1
saveset_members = 1
additional parameters for RMAN
rman_channels and rman_filesperset are only used when rman_util,
rman_disk or rman_stage
rman_channels defines the number of parallel sbt channel allocations
rman_filesperset = 0 means:
one file per save set - for non-incremental backups
all files in one save set - for incremental backups
the others have the same meaning as for native RMAN
rman_channels = 1
rman_filesperset = 0
rman_maxpiecesize = 0 # in KB - former name rman_kbytes
rman_rate = 0 # in KB - former name rman_readrate
rman_maxopenfiles = 0
rman_maxsetsize = 0 # in KB - former name rman_setsize
additional parameters for RMAN version 8.1
the parameters have the same meaning as for native RMAN
rman_diskratio = 0 # deprecated in Oracle 10g
rman_pool = 0
rman_copies = 0 | 1 | 2 | 3 | 4 # former name rman_duplex
rman_proxy = no | yes | only
special parameters for an external backup library, example:
rman_parms = "BLKSIZE=65536 ENV=(BACKUP_SERVER=HOSTNAME)"
rman_send = "'<command>'"
rman_send = ("channel sbt_1 '<command1>' parms='<parameters1>'",
"channel sbt_2 '<command2>' parms='<parameters2>'")
rman_compress = no | yes
rman_maxcorrupt = (<dbf_name>|<dbf_id>:<corr_cnt>, ...)
remote copy-out command (backup_dev_type = pipe)
$-character is replaced by current device address
no default
copy_out_cmd = "dd ibs=8k obs=64k of=$"
remote copy-in command (backup_dev_type = pipe)
$-character is replaced by current device address
no default
copy_in_cmd = "dd ibs=64k obs=8k if=$"
rewind command
$-character is replaced by current device address
no default
operating system dependent, examples:
HP-UX: "mt -f $ rew"
TRU64: "mt -f $ rewind"
AIX: "tctl -f $ rewind"
Solaris: "mt -f $ rewind"
Windows: "mt -f $ rewind"
Linux: "mt -f $ rewind"
rewind = "mt -f $ rewind"
rewind and set offline command
$-character is replaced by current device address
default: value of the rewind parameter
operating system dependent, examples:
HP-UX: "mt -f $ offl"
TRU64: "mt -f $ offline"
AIX: "tctl -f $ offline"
Solaris: "mt -f $ offline"
Windows: "mt -f $ offline"
Linux: "mt -f $ offline"
rewind_offline = "mt -f $ offline"
tape positioning command
first $-character is replaced by current device address
second $-character is replaced by number of files to be skipped
no default
operating system dependent, examples:
HP-UX: "mt -f $ fsf $"
TRU64: "mt -f $ fsf $"
AIX: "tctl -f $ fsf $"
Solaris: "mt -f $ fsf $"
Windows: "mt -f $ fsf $"
Linux: "mt -f $ fsf $"
tape_pos_cmd = "mt -f $ fsf $"
mount backup volume command in auto loader / juke box
used if backup_dev_type = tape_box | pipe_box
no default
mount_cmd = "<mount_cmd> $ $ $ [$]"
dismount backup volume command in auto loader / juke box
used if backup_dev_type = tape_box | pipe_box
no default
dismount_cmd = "<dismount_cmd> $ $ [$]"
split mirror disks command
used if backup_type = offline_split | online_split | offline_mirror
| online_mirror
no default
split_cmd = "<split_cmd> [$]"
resynchronize mirror disks command
used if backup_type = offline_split | online_split | offline_mirror
| online_mirror
no default
resync_cmd = "<resync_cmd> [$]"
additional options for SPLITINT interface program
no default
split_options = "<split_options>"
resynchronize after backup flag [no | yes]
default: no
split_resync = no
pre-split command
no default
pre_split_cmd = "<pre_split_cmd>"
post-split command
no default
post_split_cmd = "<post_split_cmd>"
volume size in KB = K, MB = M or GB = G (backup device dependent)
default: 1200M
recommended values for tape devices without hardware compression:
60 m 4 mm DAT DDS-1 tape: 1200M
90 m 4 mm DAT DDS-1 tape: 1800M
120 m 4 mm DAT DDS-2 tape: 3800M
125 m 4 mm DAT DDS-3 tape: 11000M
112 m 8 mm Video tape: 2000M
112 m 8 mm high density: 4500M
DLT 2000 10/20 GB: 10000M
DLT 2000XT 15/30 GB: 15000M
DLT 4000 20/40 GB: 20000M
DLT 7000 35/70 GB: 35000M
recommended values for tape devices with hardware compression:
60 m 4 mm DAT DDS-1 tape: 1000M
90 m 4 mm DAT DDS-1 tape: 1600M
120 m 4 mm DAT DDS-2 tape: 3600M
125 m 4 mm DAT DDS-3 tape: 10000M
112 m 8 mm Video tape: 1800M
112 m 8 mm high density: 4300M
DLT 2000 10/20 GB: 9000M
DLT 2000XT 15/30 GB: 14000M
DLT 4000 20/40 GB: 18000M
DLT 7000 35/70 GB: 30000M
tape_size = 100G
volume size in KB = K, MB = M or GB = G used by brarchive
default: value of the tape_size parameter
tape_size_arch = 100G
level of parallel execution
default: 0 - set to number of backup devices
exec_parallel = 0
address of backup device without rewind
[<dev_address> | (<dev_address_list>)]
no default
operating system dependent, examples:
HP-UX: /dev/rmt/0mn
TRU64: /dev/nrmt0h
AIX: /dev/rmt0.1
Solaris: /dev/rmt/0mn
Windows: /dev/nmt0 | /dev/nst0
Linux: /dev/nst0
tape_address = /dev/nmt0
address of backup device without rewind used by brarchive
default: value of the tape_address parameter
operating system dependent
tape_address_arch = /dev/nmt0
address of backup device with rewind
[<dev_address> | (<dev_address_list>)]
no default
operating system dependent, examples:
HP-UX: /dev/rmt/0m
TRU64: /dev/rmt0h
AIX: /dev/rmt0
Solaris: /dev/rmt/0m
Windows: /dev/mt0 | /dev/st0
Linux: /dev/st0
tape_address_rew = /dev/mt0
address of backup device with rewind used by brarchive
default: value of the tape_address_rew parameter
operating system dependent
tape_address_rew_arch = /dev/mt0
address of backup device with control for mount/dismount command
[<dev_address> | (<dev_address_list>)]
default: value of the tape_address_rew parameter
operating system dependent
tape_address_ctl = /dev/...
address of backup device with control for mount/dismount command
used by brarchive
default: value of the tape_address_rew_arch parameter
operating system dependent
tape_address_ctl_arch = /dev/...
volumes for brarchive
[<volume_name> | (<volume_name_list>) | SCRATCH]
no default
volume_archive = (SMDA01, SMDA02, SMDA03, SMDA04, SMDA05,
SMDA06, SMDA07, SMDA08, SMDA09, SMDA10,
SMDA11, SMDA12, SMDA13, SMDA14, SMDA15,
SMDA16, SMDA17, SMDA18, SMDA19, SMDA20,
SMDA21, SMDA22, SMDA23, SMDA24, SMDA25,
SMDA26, SMDA27, SMDA28, SMDA29, SMDA30)
volumes for brbackup
[<volume_name> | (<volume_name_list>) | SCRATCH]
no default
volume_backup = (SMDB01, SMDB02, SMDB03, SMDB04, SMDB05,
SMDB06, SMDB07, SMDB08, SMDB09, SMDB10,
SMDB11, SMDB12, SMDB13, SMDB14, SMDB15,
SMDB16, SMDB17, SMDB18, SMDB19, SMDB20,
SMDB21, SMDB22, SMDB23, SMDB24, SMDB25,
SMDB26, SMDB27, SMDB28, SMDB29, SMDB30)
expiration period for backup volumes in days
default: 30
expir_period = 30
recommended usages of backup volumes
default: 100
tape_use_count = 100
backup utility parameter file
default: no parameter file
util_par_file = initSMD.utl
mount/dismount command parameter file
default: no parameter file
mount_par_file = initSMD.mnt
Oracle connection name to the primary database
[primary_db = <conn_name> | LOCAL]
no default
primary_db = <conn_name>
Oracle connection name to the standby database
[standby_db = <conn_name> | LOCAL]
no default
standby_db = <conn_name>
description of parallel instances for Oracle RAC
parallel_instances = <inst_desc> | (<inst_desc_list>)
<inst_desc_list> - <inst_desc>[,<inst_desc>...]
<inst_desc> - <Oracle_sid>:<Oracle_home>@<conn_name>
<Oracle_sid> - Oracle system id for parallel instance
<Oracle_home> - Oracle home for parallel instance
<conn_name> - Oracle connection name to parallel instance
Please include the local instance in the parameter definition!
default: no parallel instances
example for initRAC001.sap:
parallel_instances = (RAC001:/oracle/RAC/920_64@RAC001,
RAC002:/oracle/RAC/920_64@RAC002, RAC003:/oracle/RAC/920_64@RAC003)
database owner of objects to be checked
<owner> | (<owner_list>)
default: all SAP owners
check_owner = sapr3
database objects to be excluded from checks
all_part | non_sap | [<owner>.]<table> | [<owner>.]<index>
| [<owner>.]<prefix>* | <tablespace> | (<object_list>)
default: no exclusion, example:
check_exclude = (SDBAH, SAPR3.SDBAD)
database owner of SDBAH, SDBAD and XDB tables for cleanup
<owner> | (<owner_list>)
default: all SAP owners
cleanup_owner = sapr3
retention period in days for brarchive log files
default: 30
cleanup_brarchive_log = 30
retention period in days for brbackup log files
default: 30
cleanup_brbackup_log = 30
retention period in days for brconnect log files
default: 30
cleanup_brconnect_log = 30
retention period in days for brrestore log files
default: 30
cleanup_brrestore_log = 30
retention period in days for brrecover log files
default: 30
cleanup_brrecover_log = 30
retention period in days for brspace log files
default: 30
cleanup_brspace_log = 30
retention period in days for archive log files saved on disk
default: 30
cleanup_disk_archive = 30
retention period in days for database files backed up on disk
default: 30
cleanup_disk_backup = 30
retention period in days for brspace export dumps and scripts
default: 30
cleanup_exp_dump = 30
retention period in days for Oracle trace and audit files
default: 30
cleanup_ora_trace = 30
retention period in days for records in SDBAH and SDBAD tables
default: 100
cleanup_db_log = 100
retention period in days for records in XDB tables
default: 100
cleanup_xdb_log = 100
retention period in days for database check messages
default: 100
cleanup_check_msg = 100
database owner of objects to adapt next extents
<owner> | (<owner_list>)
default: all SAP owners
next_owner = sapr3
database objects to adapt next extents
all | all_ind | special | [<owner>.]<table> | [<owner>.]<index>
| [<owner>.]<prefix>* | <tablespace> | (<object_list>)
default: all abjects of selected owners, example:
next_table = (SDBAH, SAPR3.SDBAD)
database objects to be excluded from adapting next extents
all_part | [<owner>.]<table> | [<owner>.]<index> | [<owner>.]<prefix>*
| <tablespace> | (<object_list>)
default: no exclusion, example:
next_exclude = (SDBAH, SAPR3.SDBAD)
database objects to get special next extent size
all_sel:<size>[/<limit>] | [<owner>.]<table>:<size>[/<limit>]
| [<owner>.]<index>:<size>[/<limit>]
| [<owner>.]<prefix>*:<size>[/<limit>] | (<object_size_list>)
default: according to table category, example:
next_special = (SDBAH:100K, SAPR3.SDBAD:1M/200)
maximum next extent size
default: 2 GB - 5 * <database_block_size>
next_max_size = 1G
maximum number of next extents
default: 0 - unlimited
next_limit_count = 300
database owner of objects to update statistics
<owner> | (<owner_list>)
default: all SAP owners
stats_owner = sapr3
database objects to update statistics
all | all_ind | all_part | missing | info_cubes | dbstatc_tab
| dbstatc_mon | dbstatc_mona | [<owner>.]<table> | [<owner>.]<index>
| [<owner>.]<prefix>* | <tablespace> | (<object_list>) | harmful
| locked | system_stats | oradict_stats
default: all abjects of selected owners, example:
stats_table = (SDBAH, SAPR3.SDBAD)
database objects to be excluded from updating statistics
all_part | info_cubes | [<owner>.]<table> | [<owner>.]<index>
| [<owner>.]<prefix>* | <tablespace> | (<object_list>)
default: no exclusion, example:
stats_exclude = (SDBAH, SAPR3.SDBAD)
method for updating statistics for tables not in DBSTATC
E | EH | EI | EX | C | CH | CI | CX | A | AH | AI | AX | E= | C= | =H
| =I | =X | +H | +I
default: according to internal rules
stats_method = E
sample size for updating statistics for tables not in DBSTATC
P<percentage_of_rows> | R<thousands_of_rows>
default: according to internal rules
stats_sample_size = P10
number of buckets for updating statistics with histograms
default: 75
stats_bucket_count = 75
threshold for collecting statistics after checking
default: 50%
stats_change_threshold = 50
number of parallel threads for updating statistics
default: 1
stats_parallel_degree = 1
processing time limit in minutes for updating statistics
default: 0 - no limit
stats_limit_time = 0
parameters for calling DBMS_STATS supplied package
all:R|B:A|D|0|<degree> | all_part:R|B:A|D|0|<degree>
| info_cubes:R|B:A|D|0|<degree> | [<owner>.]<table>:R|B:A|D|0|<degree>
| [<owner>.]<prefix>*:R|B:A|D|0|<degree> | (<object_list>) | NO
'R' - row sampling, 'B' - block sampling, 'A' - auto degree,
'D' - default degree, '0' - table degree
default: ALL:R:0
stats_dbms_stats = ([ALL:R:1,][<owner>.]<table>:R:<degree>,...)
definition of info cube tables
default | rsnspace_tab | [<owner>.]<table> | [<owner>.]<prefix>*
| (<object_list>) | null
default: from RSNSPACE control table
stats_info_cubes = (/BIC/D, /BI0/D, ...)
recovery type [complete | dbpit | tspit | reset | restore | apply
| disaster]
default: complete
recov_type = complete
directory for brrecover file copies
default: $SAPDATA_HOME/sapbackup
recov_copy_dir = I:\oracle\SMD\sapbackup
time period for searching for backups
0 - all available backups, >0 - backups from n last days
default: 30
recov_interval = 30
degree of paralelism for applying archive log files
0 - use Oracle default parallelism, 1 - serial, >1 - parallel
default: Oracle default
recov_degree = 0
number of lines for scrolling in list menus
0 - no scrolling, >0 - scroll n lines
default: 20
scroll_lines = 20
time period for displaying profiles and logs
0 - all available logs, >0 - logs from n last days
default: 30
show_period = 30
directory for brspace file copies
default: $SAPDATA_HOME/sapreorg
space_copy_dir = I:\oracle\SMD\sapreorg
directory for table export dump files
default: $SAPDATA_HOME/sapreorg
exp_dump_dir = I:\oracle\SMD\sapreorg
database tables for reorganization
[<owner>.]<table> | [<owner>.]<prefix>* | [<owner>.]<prefix>%
| (<table_list>)
no default
reorg_table = (SDBAH, SAPR3.SDBAD)
database indexes for rebuild
[<owner>.]<index> | [<owner>.]<prefix>* | [<owner>.]<prefix>%
| (<index_list>)
no default
rebuild_index = (SDBAH0, SAPR3.SDBAD0)
database tables for export
[<owner>.]<table> | [<owner>.]<prefix>* | [<owner>.]<prefix>%
| (<table_list>)
no default
exp_table = (SDBAH, SAPR3.SDBAD)
database tables for import
<table> | (<table_list>)
no default
do not specify table owner in the list - use -o|-owner option for this
imp_table = (SDBAH, SDBAD)</b>
Revert please.
Regards,
Somya
Somya,
is Y: a network drive: Yes or NO
if Yes, then it is quite normal that this works on the command prompt but not in DB13.
DB13 uses user ID SAPserviceSMD, this user ID DOES NOT have Y: connected and this will never work.
Please use
servername\sharename\directory instead.
I repeat, your actual setup will never work in DB13... unless you go back to Windows NT 4.0
Why is that? because since Windows 2000, Microsoft has changed this behavior. in old times, when you mounted a drive, it was accessible to all users. This was a security risk and Microsoft blocked it.
I hope this answers your question.
Hello Markus,
Y is a mapped drive on solman server which exists on another server which has OS 2000 as T drive , i also tried mapping onto another server's drive which has OS 2003 , there also its failing.
Now wt i hv done:i went to tat server whose name is biwdev , shared the folder backuponline08082007 on tat drive (T drive of biwdev which is mapped on to my solmana s Y drive ) to everyone with all privileges and the share name i kept as backuponline08082007 only.
After tat i defined <b>backup_root_dir =
biwdev\backuponline08082007\backuponline08082007</b> parameter in initSMD.sap and started scheduling backup in db13 ,it still gave the same error:
<b>Job log
Job started
Step 001 started (program RSDBAJOB, variant &0000000000026, user ID ASYSADM)
Execute logical command BRBACKUP On host solutiond
Parameters:-u / -jid FLLOG20070808174800 -c force -t online -m full -p initSMD.sap -a -c force -p initSMD.sap -
s
BR0051I BRBACKUP 7.00 (24)
BR0282E Directory '
biwdev\backuponline08082007\backuponline08082007' not found
BR0182E Checking parameter/option 'backup_root_dir' failed
BR0056I End of database backup: bdvwpdfw.log 2007-08-08 17.48.36
BR0280I BRBACKUP time stamp: 2007-08-08 17.48.39
BR0054I BRBACKUP terminated with errors
External program terminated with exit code 3
BRBACKUP returned error status E
Job finished </b>
Plz revert to this . Also revert to 3 queries raised earlier in this message:
Regards,
Somya
Hello Eric,
Plz find net use results and revert:
C:\Documents and Settings\smdadm.SOLUTIOND>net use
New connections will be remembered.
Status Local Remote Network
-
OK Y:
biwdev\t$ Microsoft Windows Network
OK Z:
biwlive\y$ Microsoft Windows Network
The command completed successfully.
C:\Documents and Settings\smdadm.SOLUTIOND>
Regards,
Somya
Not working still .
<b>Job log
Job started
Step 001 started (program RSDBAJOB, variant &0000000000028, user ID ASYSADM)
Execute logical command BRBACKUP On host solutiond
Parameters:-u / -jid FLLOG20070810090600 -c force -t online -m full -p initSMD.sap -a -c force -p initSMD.sap -
s
BR0051I BRBACKUP 7.00 (24)
BR0282E Directory '
biwdev\y$\backuponline08082007' not found
BR0182E Checking parameter/option 'backup_root_dir' failed
BR0056I End of database backup: bdvwxenk.log 2007-08-10 09.06.36
BR0280I BRBACKUP time stamp: 2007-08-10 09.06.39
BR0054I BRBACKUP terminated with errors
External program terminated with exit code 3
BRBACKUP returned error status E
Job finished </b>
Hi,
You have to apply the note 988038, to schedule the back up from db13. And your initSMD.sap should be having the permission like this, its owner should be orasid user and group should be dba. To take the redo log backup you have to select the function -s and schedule the backup it will work.
Its not taking this path at all, not recognissing ,
biwdev\y$\backuponline08082007
its taking
biwdev\t$\backuponline08082007 path w/o user name and password but i tried to se tat path also in backup_root_dir but isnt working.I think it cannot accept network drives at all.......................i hv given up now.................
Hello,
As Eric asked, please supply initSMD.sap.
Again It seems that your Y drive is not reachable fronm your server
try to do this:
- change backup_root_dir to G:/oracle/SMD/sapbackup or where sapbackup is located
- start the backup but dont choose ALL
brbackup.exe -p initSMD.sap -d disk -t online -m SYSTEM, this will backup SYSTEM and you will see if it is OK
Thanks
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
there is not configuration for db13, if initSMD.sap is configured correctly.
can you send your initSMD.sap as well as a screenshot of YouDrives and contents of Y.?
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Now i tried with ampping to the same previous Z drive of my server to y drive of another server and its again giving the same error:
Job Log:
<b>Job started
Step 001 started (program RSDBAJOB, variant &0000000000013, user ID ASYSADM)
Execute logical command BRBACKUP On host solutiond
Parameters:-u / -jid FLLOG20070803182500 -c force -t online -m full -p initSMD.sap -a -c force -p initSMD.sa
s
BR0051I BRBACKUP 7.00 (24)
BR0282E Directory 'Z:\backuponline03082007' not found
BR0182E Checking parameter/option 'backup_root_dir' failed
BR0056I End of database backup: bdvvqrli.log 2007-08-03 18.25.22
BR0280I BRBACKUP time stamp: 2007-08-03 18.25.25
BR0054I BRBACKUP terminated with errors
External program terminated with exit code 3
BRBACKUP returned error status E
Job finished </b>
Give me ur Email id inorder to send u initSMD.sap as well as a screenshot of YouDrives and contents of Y.
Tahnks,
Somya
Hello Ahmed,
I doono why u r asking to logon with system user for performing BRBACKUP . I suppose in this command line u meant <b>system</b> with user system and password of tat user ,when iam executing this cmd iam getting the following error:
<b>Microsoft Windows [Version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp.
C:\Documents and Settings\smdadm.SOLUTIOND>brbackup -u system/bankok123 -c force
-t online -m full -p initSMD.sap -a -c force -p initSMD.sap
BR0051I BRBACKUP 7.00 (24)
BR0055I Start of database backup: bdvvubhc.fnd 2007-08-04 10.55.00
BR0484I BRBACKUP log file: I:\oracle\SMD\sapbackup\bdvvubhc.fnd
BR0280I BRBACKUP time stamp: 2007-08-04 10.55.03
BR0301E SQL error -28000 at location BrDbConnect-2, SQL statement:
'CONNECT system/*********'
ORA-28000: the account is locked
BR0310E Connect to database instance SMD failed
BR0280I BRBACKUP time stamp: 2007-08-04 10.55.05
BR0301E SQL error -28000 at location BrDbConnect-2, SQL statement:
'CONNECT system/*********'
ORA-28000: the account is locked
BR0310E Connect to database instance SMD failed
BR0056I End of database backup: bdvvubhc.fnd 2007-08-04 10.55.03
BR0280I BRBACKUP time stamp: 2007-08-04 10.55.05
BR0054I BRBACKUP terminated with errors
BR0280I BRBACKUP time stamp: 2007-08-04 10.55.05
BR0291I BRARCHIVE will be started with options '-U -d disk -c force -p initSMD.s
ap'
BR0002I BRARCHIVE 7.00 (24)
BR0006I Start of offline redo log processing: advvubhh.sve 2007-08-04 10.55.05
BR0484I BRARCHIVE log file: I:\oracle\SMD\saparch\advvubhh.sve
BR0280I BRARCHIVE time stamp: 2007-08-04 10.55.08
BR0301W SQL error -28000 at location BrDbConnect-2, SQL statement:
'CONNECT system/*********'
ORA-28000: the account is locked
BR0310W Connect to database instance SMD failed
BR0280I BRARCHIVE time stamp: 2007-08-04 10.55.09
BR0301W SQL error -28000 at location BrDbConnect-2, SQL statement:
'CONNECT system/*********'
ORA-28000: the account is locked
BR0310W Connect to database instance SMD failed
BR0039I Last offline redo log file H:\oracle\SMD\oraarch\SMDARCHARC00867_0625157
965.001 will not be backed due to connect error to database instance SMD
BR0013W No offline redo log files found for processing
BR0280I BRARCHIVE time stamp: 2007-08-04 10.55.14
BR0301W SQL error -28000 at location BrDbConnect-2, SQL statement:
'CONNECT system/*********'
ORA-28000: the account is locked
BR0310W Connect to database instance SMD failed
BR0007I End of offline redo log processing: advvubhh.sve 2007-08-04 10.55.13
BR0280I BRARCHIVE time stamp: 2007-08-04 10.55.14
BR0004I BRARCHIVE completed successfully with warnings
BR0280I BRBACKUP time stamp: 2007-08-04 10.55.14
BR0292I Execution of BRARCHIVE finished with return code 1
C:\Documents and Settings\smdadm.SOLUTIOND></b>
Thanks,
Somya
Hello eric,
I hv unlocked the sytem oracle account through these commands and now the cmd <b>brbackup -u system/<pass> -c force -t online -m full -p initSMD.sap -a -c force -p initSMD.sap</b> is ruuning fine ,now i hv a few problems and questions to ask:
1. When iam scheduling Full online+Redo logs backup through db13 its failing ,the job completes with error and gives following message:
<b>Job log
Job started
Step 001 started (program RSDBAJOB, variant &0000000000024, user ID ASYSADM)
Execute logical command BRBACKUP On host solutiond
Parameters:-u / -jid FLLOG20070807111500 -c force -t online -m full -p initSMD.sap -a -c force -p initSMD.sap -
s
BR0051I BRBACKUP 7.00 (24)
BR0282E Directory 'Y:\backuponline07082007' not found
BR0182E Checking parameter/option 'backup_root_dir' failed
BR0056I End of database backup: bdvwiwnk.log 2007-08-07 11.15.24
BR0280I BRBACKUP time stamp: 2007-08-07 11.15.27
BR0054I BRBACKUP terminated with errors
External program terminated with exit code 3
BRBACKUP returned error status E
Job finished </b>
If after this i run the command:
<b>brbackup -u system/<pass> -c force -t online -m full -p initSMD.sap -a -c force -p initSMD.sap </b> in command prompt the backup runs successfully showing progress in action logs of the same job scheduled in db13 but the logs there still show the same message and after tat backup runs successfully? Do we need to run this coomand frm command prompt also after scheduling Db13 backup job also inorder to complete db13 backup?and alone scheduling db13 backup doesnt work?
2. While scheduling backup through db13 ,wt normal option is suggested , i went for FULL ONLINE backup+ Redo Logs ,the logs of which gave the following traces ,i saw an error in between although the complete backup run was shown to be successful and completed with error code 0 :
<b>BR0315I 'Alter tablespace SYSTEM begin backup' successful
BR0202I Saving I:\ORACLE\SMD\SAPDATA1\SYSTEM_1\SYSTEM.DATA1
BR0203I to Y:\backuponline07082007\bdvwimxv\SYSTEM.DATA1 ...
#FILE..... I:\ORACLE\SMD\SAPDATA1\SYSTEM_1\SYSTEM.DATA1
#SAVED.... Y:\backuponline07082007\bdvwimxv\SYSTEM.DATA1 #1/26
BR0280I BRBACKUP time stamp: 2007-08-07 10.58.51
BR0063I 26 of 26 files processed - 50340.203 MB of 50340.203 MB done
BR0204I Percentage done: 100.00%, estimated end time: 10:58
BR0001I **************************************************
BR0280I BRBACKUP time stamp: 2007-08-07 10.58.52
BR0317I 'Alter tablespace SYSTEM end backup' successful
BR0280I BRBACKUP time stamp: 2007-08-07 10.58.56
BR0530I Cataloging backups of all database files...
BR0278E Command output of 'G:\oracle\SMD\102\BIN\rman nocatalog':
Recovery Manager: Release 10.2.0.2.0 - Production on Tue Aug 7 10:58:57 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
RMAN>
RMAN> connect target *
connected to target database: SMD (DBID=1323263181)
using target database control file instead of recovery catalog
RMAN> *end-of-file*
RMAN>
host command complete
RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28>
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of catalog command on default channel at 08/07/2007 10:59:09
ORA-19625: error identifying file Y:\BACKUPONLINE07082007\BDVWIMXV\SR3.DATA10
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.
RMAN>
Recovery Manager complete.
BR0280I BRBACKUP time stamp: 2007-08-07 10.59.10
BR0279E Return code from 'G:\oracle\SMD\102\BIN\rman nocatalog': 1
BR0536E RMAN call for database instance SMD failed
BR0280I BRBACKUP time stamp: 2007-08-07 10.59.10
BR0532E Cataloging backups of all database files failed
BR0056I End of database backup: bdvwimxv.fnd 2007-08-07 10.59.10
BR0280I BRBACKUP time stamp: 2007-08-07 10.59.11
BR0054I BRBACKUP terminated with errors
BR0280I BRBACKUP time stamp: 2007-08-07 10.59.11
BR0291I BRARCHIVE will be started with options '-U -d disk -c force -p initSMD.sap'
BR0280I BRBACKUP time stamp: 2007-08-07 10.59.51
BR0292I Execution of BRARCHIVE finished with return code 0 </b>
why is it showing this error and wll this error create any problem during restoreand recovery , i mean is this reliable backup ,and wll its restoration lead to considtent restoration and recovery?
3. lastly i want to ask wt option shld be selected in db13 whether we shld go for Whole online +offline redo backups or Full online + offline redo backups because in the first one as mentioned before an error occured................................................... ? wt are the recommended suggested options tat shld be used there?
requested to revert at earliest.
points guaranteed .
<b>Fidel and Ahmed:</b> I was expecting replies frm ur side in this forum .
Regards ,
Somya
Hi,
It seems Y doesnt exist in your server or permissions are missing
What is the drives you have mapped in the server?
What the permissions of the drive?
SERVICE<SID> and <SID>ADM must have full access to this drive
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
check that Z drive accept large files. whats the largest datafile in your BD
Z drive is FAT ot NTFS?
check also the permissions
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello ahmed,
I hv changed the drive to another servers y drive.Wt i hv done is i have mapped another servers drive over this server and taking back up in it . Through this drive I hv taken full offline and online BRBACKUP through BRTOOLS in tat drive so it accepts large files . Its NTFS . is this kind of thing supported through db13 also because its not recognising the backup_root directory,the job for backup starts and just finishes in a few seconds showing finished and giving the following error trace:
<b>Job log</b>----
<b>Job started
Step 001 started (program RSDBAJOB, variant &0000000000012, user ID ASYSADM)
Execute logical command BRBACKUP On host solutiond
Parameters:-u / -jid FLLOG20070803161500 -c force -t online -m full -p initSMD.sap -a -c force -p initSMD.sap -
s
BR0051I BRBACKUP 7.00 (24)
BR0282E Directory 'Y:\backuponline' not found
BR0182E Checking parameter/option 'backup_root_dir' failed
BR0056I End of database backup: bdvvqgnm.log 2007-08-03 16.22.22
BR0280I BRBACKUP time stamp: 2007-08-03 16.22.24
BR0054I BRBACKUP terminated with errors
External program terminated with exit code 3
BRBACKUP returned error status E
Job finished</b>
Iam not clear abt the procedure of taking backup through db13 ? can u plz tell the steps:
Plz revert at earliest as this is urgent.
Reagrds,
Somya
drive Z: looks very much like networkdriveletter????
by the way:
disk_copy_cmd copy
means that a cmd.exe's copy is invoked.
you can try to reproduce the problem by running this command out of the command box.
reasons:
no 100 GB free space on the target volue, disk quotas enabled and no more quotas etc.
Peter
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Peter,
Z: is network drive only, another server's drive tat i hv mapped on to my solman server whose backup iam taking and placing over tat drive
disk_copy_cmd copy - how to to reproduce the problem by running this command out of the command box?
100 GB free space is there on the target volume , how toc heck if disk quotas are enabled /no more quotas etc.
Thanks and Regards,
Somya
Hello Everyone,
I hv resolved the BRBACK through BRTOOLS on my own . There was some problem on tat drive ,when i started on another drive , it worked. Can some one help me out with performing backup through DB13:
When iam performing OFFLINE full backup + Redologs backup through db13 and set the appropriate disk directories in backup_root_dir and archive_copy_dir in initSID.sap and selected archive function as -s a job gewts started immediately as <b>DBA:FULLONL+LOG_____@150000/5000</b> and gets completed also within a few seconds but no files /directories are saved in the mentioned directories. why
is it so happening? wt is the procedure of taking backup through db13?plz revert at earliest.
Regards,
Somya
start cmd.exe as sidadm and run following command in this box:
copy I:ORACLESMDSAPDATA2SR3_4SR3.DATA4 Z:offlinebackupsolman02082007bdvvlbnhSR3.DATA4
by the way: Network Driveletters are not supported, because you are normaly not able to create them from within the ABAP server and the Desktop created network driveletter are belonging to a different User session with different authorization.
Peter
Additionally as mentioned in the long error message of running brbackup through brtools iam also getting the following message at the end of the previous long mentioned message:
BR0292I Execution of BRBACKUP finished with return code 5
BR0668I Warnings or errors occurred - you can continue to ignore them or go back
to repeat the last action
BR0280I BRTOOLS time stamp: 2007-08-02 18.01.50
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
Thanks and Regards,
Somya
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
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.