BR0227E Not enough disk space

[Former Member]

Hello Oracle experts. I am trying to take a full online backup but I keep on getting the BRO227E error: Is there a parameter or a stwich to over ride this error.

What we would like to do is start the backup and than move the compressed files to another directory. But we need to start the backup first.............

Thanks for your time

-

---

• Backup of database on 'BSRpxi300', Instance=pxi_34 ***

***

*

Parameters used for brbackup

*

-p : parameter file is pxi_onlinebackup_params.sap

-c : no confirmation (unattended)

-l E : ENGLISH

-d disk : Disk backup

-m full : Mode is full backup

-k yes : Compression on

-t online : Online backup mode

-U : system/oracle

*

• Start time is

09:43 AM

BR0051I BRBACKUP 6.40 (45)

BR0055I Start of database backup: bdxpklxb.fnd 2008-04-01 09.43.31

BR0484I BRBACKUP log file: G:\oracle\PXI\sapbackup\bdxpklxb.fnd

BR0477I Oracle pfile e:\oracle\pxi\920\database\initPXI.ora created from spfile e:\oracle\pxi\920\database\spfilePXI.ora

BR0227E Not enough disk space in D:\SAP_ONLINE_Backup for backup, missing at least 15099.660 MB

BR0056I End of database backup: bdxpklxb.fnd 2008-04-01 09.43.35

BR0280I BRBACKUP time stamp: 2008-04-01 09.43.35

BR0054I BRBACKUP terminated with errors

• End time is

09:43 AM

• BAckup Completed!!

• Starting directory Cleanup

Microsoft (R) Windows Script Host Version 5.6

Copyright (C) Microsoft Corporation 1996-2001. All rights reserved.

Looking for files with date older than 4/1/2008

-

---

1. @(#) $Id: //bas/BIN/src/ccm/rsbr/initNT.sap#1 $ SAP

########################################################################

1. #

2. Online backup for the bootcamp database

#

########################################################################

1. backup mode [all | all_data | full | incr | sap_dir | ora_dir

2. | <tablespace_name> | <file_id> | <file_id1>-<file_id2>

3. | <generic_path> | (<object_list>)]

4. default: all

backup_mode = full

1. restore mode [all | all_data | full | incr | incr_only | incr_full

2. | <tablespace_name> | <file_id> | <file_id1>-<file_id2>

3. | <generic_path> | (<object_list>)]

4. redirection with '=' is not supported here - use option '-m' instead

5. default: all

restore_mode = full

1. backup type [offline | offline_force | offline_standby | offline_split

2. | offline_stop | online | online_cons | online_split]

3. default: offline

backup_type = online

1. backup device type

2. [tape | tape_auto | tape_box | pipe | pipe_auto | pipe_box | disk

3. | disk_copy | disk_standby | stage | stage_copy | stage_standby

4. | util_file | util_file_online | rman_util | rman_disk | rman_stage

5. | rman_prep]

6. default: tape

backup_dev_type = disk

1. backup root directory [<path_name> | (<path_name_list>)]

2. default: %SAPDATA_HOME%\sapbackup

#backup_root_dir = N:\oracle\dev\sapbackup

backup_root_dir = D:\SAP_ONLINE_Backup

#backup_root_dir = Z:\BSRPXI202_Online_Backup

1. stage root directory [<path_name> | (<path_name_list>)]

2. default: value of the backup_root_dir parameter

#stage_root_dir =

1. compression flag [yes | no | hardware | only]

2. default: no

compress = yes

1. compress command

2. first $-character is replaced by the source file name

3. second $-character is replaced by the target file name

4. <target_file_name> = <source_file_name>.Z

5. for compress command the -c option must be set

6. recommended setting for brbackup -k only run:

7. "%SAPEXE%\mkszip -l 0 -c $ > $"

8. no default

compress_cmd = "c:\windows\sapcluster\mkszip -c $ > $"

1. uncompress command

2. first $-character is replaced by the source file name

3. second $-character is replaced by the target file name

4. <source_file_name> = <target_file_name>.Z

5. for uncompress command the -c option must be set

6. no default

uncompress_cmd = "c:\windows\sapcluster\uncompress -c $ > $"

1. directory for compression [<path_name> | (<path_name_list>)]

2. default: value of the backup_root_dir parameter

#compress_dir = N:\oracle\dev\sapreorg

1. brarchive function [save | second_copy | double_save | save_delete

2. | second_copy_delete | double_save_delete | copy_save

3. | copy_delete_save | delete_saved | delete_copied]

4. default: save

archive_function = save_delete

1. directory for archive log copies to disk

2. default: first value of the backup_root_dir parameter

archive_copy_dir = d:\SAPBackup\ArchiveLogs

1. directory for archive log copies to stage

2. should contain <SID> subdirectory

3. default: first value of the stage_root_dir parameter

archive_stage_dir = d:\SAPBackup\ArchiveLogs\Stage

1. new sapdata home directory for disk_copy | disk_standby

2. no default

1. new_db_home = X:\oracle\C11

1. stage sapdata home directory for stage_copy | stage_standby

2. default: value of the new_db_home parameter

1. stage_db_home = /oracle/C11

1. original sapdata home directory for split mirror disk backup

2. no default

3. orig_db_home = /oracle/C11

1. remote host name

2. no default

1. remote_host = <host_name>

1. remote user name

2. default: current operating system user

1. remote_user = <user_name>

1. tape copy command [cpio | cpio_gnu | dd | dd_gnu | rman | rman_dd]

2. default: cpio

#tape_copy_cmd = cpio

1. disk copy command [copy | dd | dd_gnu | rman]

2. default: copy

disk_copy_cmd = copy

1. stage copy command [rcp | ftp]

2. default: rcp

#stage_copy_cmd = rcp

1. flags for cpio output command

2. default: -ovB $$$$ ASK Kelly

cpio_flags = -ovB

1. flags for cpio input command

2. default: -iuvB

#cpio_in_flags = -iuvB

1. flags for cpio command for copy of directories to disk

2. default: -pdcu

cpio_disk_flags = -pdcu

1. flags for dd output command

2. default: "obs=16k"

3. caution: option "obs=" not supported for Windows NT

4. recommended setting:

5. Unix: "obs=nk bs=nk", example: "obs=64k bs=64k"

6. NT: "bs=nk", example: "bs=64k"

#dd_flags = "bs=64k"

1. flags for dd input command

2. default: "ibs=16k"

3. caution: option "ibs=" not supported for Windows NT

4. recommended setting:

5. Unix: "ibs=nk bs=nk", example: "ibs=64k bs=64k"

6. NT: "bs=nk", example: "bs=64k"

#dd_in_flags = "bs=64k"

1. number of members in RMAN save sets [ 1 | 2 | 3 | 4 | tsp | all ]

2. default: 1

3. saveset_members = 1

1. additional parameters for RMAN

2. rman_channels and rman_filesperset are only used when rman_util,

3. rman_disk or rman_stage

4. rman_channels defines the number of parallel sbt channel allocations

5. rman_filesperset = 0 means:

6. one file per save set - for non-incremental backups

7. all files in one save set - for incremental backups

8. the others have the same meaning as for native RMAN

9. rman_channels = 1

10. rman_filesperset = 0

11. rman_kbytes = 0

12. rman_readrate = 0

13. rman_maxopenfiles = 0

14. rman_setsize = 0

15. additional parameters for RMAN version 8.1

16. the parameters have the same meaning as for native RMAN

17. rman_diskratio = 0

18. rman_pool = 0

19. rman_duplex = 0 | 1 | 2 | 3 | 4

20. rman_proxy = no | yes | only

21. special parameters for an external backup library, example:

22. rman_parms = "BLKSIZE=65536 ENV=(BACKUP_SERVER=HOSTNAME)"

23. rman_send = "'<command>'"

24. rman_send = ("channel sbt_1 '<command1>' parms='<parameters1>'",

25. "channel sbt_2 '<command2>' parms='<parameters2>'")

1. remote copy-out command (backup_dev_type = pipe)

2. $-character is replaced by current device address

3. no default

#copy_out_cmd = "dd ibs=8k obs=64k of=$"

1. remote copy-in command (backup_dev_type = pipe)

2. $-character is replaced by current device address

3. no default

#copy_in_cmd = "dd ibs=64k obs=8k if=$"

1. rewind command

2. $-character is replaced by current device address

3. no default

4. operating system dependent, examples:

5. HP-UX: "mt -f $ rew"

6. OSF1: "mt -f $ rewind"

7. AIX: "tctl -f $ rewind"

8. SINIX: "mt -f $ rewind"

9. SUN: "mt -f $ rewind"

10. NT: "mt -f $ rewind"

11. Linux: "mt -f $ rewind"

#rewind = "mt -f $ rewind"

1. rewind and set offline command

2. $-character is replaced by current device address

3. default: value of the rewind parameter

4. operating system dependent, examples:

5. HP-UX: "mt -f $ offl"

6. OSF1: "mt -f $ offline"

7. AIX: "tctl -f $ offline"

8. SINIX: "mt -f $ offline"

9. SUN: "mt -f $ offline"

10. NT: "mt -f $ offline"

11. Linux: "mt -f $ offline"

#rewind_offline = "mt -f $ offline"

1. tape positioning command

2. first $-character is replaced by current device address

3. second $-character is replaced by number of files to be skipped

4. no default

5. operating system dependent, examples:

6. HP-UX: "mt -f $ fsf $"

7. OSF1: "mt -f $ fsf $"

8. AIX: "tctl -f $ fsf $"

9. SINIX: "mt -f $ fsf $"

10. SUN: "mt -f $ fsf $"

11. NT: "mt -f $ fsf $"

12. Linux "mt -f $ fsf $"

#tape_pos_cmd = "mt -f $ fsf $"

1. mount backup volume command in auto loader / juke box

2. used if backup_dev_type = tape_box | pipe_box

3. no default

4. mount_cmd = "<mount_cmd> $ $ $ [$]"

5. dismount backup volume command in auto loader / juke box

6. used if backup_dev_type = tape_box | pipe_box

7. no default

8. dismount_cmd = "<dismount_cmd> $ $ [$]"

9. split mirror disks command

10. used if backup_type = offline_split | online_split

11. no default

12. split_cmd = "<split_cmd> [$]"

13. resynchronize mirror disks command

14. used if backup_type = offline_split | online_split

15. no default

16. resync_cmd = "<resync_cmd> [$]"

17. volume size in KB = K, MB = M or GB = G (backup device dependent)

18. default: 1200M

19. recommended values for tape devices without hardware compression:

20. 60 m 4 mm DAT DDS-1 tape: 1200M

21. 90 m 4 mm DAT DDS-1 tape: 1800M

22. 120 m 4 mm DAT DDS-2 tape: 3800M

23. 125 m 4 mm DAT DDS-3 tape: 11000M

24. 112 m 8 mm Video tape: 2000M

25. 112 m 8 mm high density: 4500M

26. DLT 2000 10/20 GB: 10000M

27. DLT 2000XT 15/30 GB: 15000M

28. DLT 4000 20/40 GB: 20000M

29. DLT 7000 35/70 GB: 35000M

30. recommended values for tape devices with hardware compression:

31. 60 m 4 mm DAT DDS-1 tape: 1000M

32. 90 m 4 mm DAT DDS-1 tape: 1600M

33. 120 m 4 mm DAT DDS-2 tape: 3600M

34. 125 m 4 mm DAT DDS-3 tape: 10000M

35. 112 m 8 mm Video tape: 1800M

36. 112 m 8 mm high density: 4300M

37. DLT 2000 10/20 GB: 9000M

38. DLT 2000XT 15/30 GB: 14000M

39. DLT 4000 20/40 GB: 18000M

40. DLT 7000 35/70 GB: 30000M

#tape_size = 1200M

1. volume size in KB = K, MB = M or GB = G used by brarchive

2. default: value of the tape_size parameter

3. tape_size_arch = 1200M

1. level of parallel execution

2. default: 0 - set to number of backup devices

exec_parallel = 8

1. address of backup device without rewind

2. [<dev_address> | (<dev_address_list>)]

3. no default

4. operating system dependent, examples:

5. HP-UX: /dev/rmt/0mn

6. OSF1: /dev/nrmt0h

7. AIX: /dev/rmt0.1

8. SINIX: /dev/ios0/rstape005n

9. SUN: /dev/rmt/0mn

10. NT: /dev/nmt0 | /dev/nst0

11. Linux /dev/nst0

#tape_address = /dev/nmt0

1. address of backup device without rewind used by brarchive

2. default: value of the tape_address parameter

3. operating system dependent

4. tape_address_arch = /dev/nmt0

5. address of backup device with rewind

6. [<dev_address> | (<dev_address_list>)]

7. no default

8. operating system dependent, examples:

9. HP-UX: /dev/rmt/0m

10. OSF1: /dev/rmt0h

11. AIX: /dev/rmt0

12. SINIX: /dev/ios0/rstape005

13. SUN: /dev/rmt/0m

14. NT: /dev/mt0 | /dev/st0

15. Linux: /dev/st0

#tape_address_rew = /dev/mt0

1. address of backup device with rewind used by brarchive

2. default: value of the tape_address_rew parameter

3. operating system dependent

4. tape_address_rew_arch = /dev/mt0

5. address of backup device with control for mount/dismount command

6. [<dev_address> | (<dev_address_list>)]

7. default: value of the tape_address_rew parameter

8. operating system dependent

9. tape_address_ctl = /dev/...

10. address of backup device with control for mount/dismount command

11. used by brarchive

12. default: value of the tape_address_rew_arch parameter

13. operating system dependent

14. tape_address_ctl_arch = /dev/...

15. volumes for brarchive

16. [<volume_name> | (<volume_name_list>) | SCRATCH]

17. no default

#volume_archive = (devA01, devA02, devA03, devA04, devA05,

1. devA06, devA07, devA08, devA09, devA10,

2. devA11, devA12, devA13, devA14, devA15,

3. devA16, devA17, devA18, devA19, devA20,

4. devA21, devA22, devA23, devA24, devA25,

5. devA26, devA27, devA28, devA29, devA30)

6. volumes for brbackup

7. [<volume_name> | (<volume_name_list>) | SCRATCH]

8. no default

#volume_backup = (devB01, devB02, devB03, devB04, devB05,

1. devB06, devB07, devB08, devB09, devB10,

2. devB11, devB12, devB13, devB14, devB15,

3. devB16, devB17, devB18, devB19, devB20,

4. devB21, devB22, devB23, devB24, devB25,

5. devB26, devB27, devB28, devB29, devB30)

6. expiration period for backup volumes in days

7. default: 30

#expir_period = 30

1. recommended usages of backup volumes

2. default: 100

#tape_use_count = 100

1. backup utility parameter file

2. default: no parameter file

3. util_par_file = initdev.utl

4. mount/dismount command parameter file

5. default: no parameter file

6. mount_par_file = initdev.mnt

7. Oracle instance string to the primary database

8. [primary_db = <inst_str> | LOCAL]

9. no default

10. primary_db = <inst_str>

11. description of parallel instances for Oracle Parallel Server

12. parallel_instances = <instance_desc> | (<instance_desc_list>)

13. <instance_desc_list> -> <instance_desc>[,<instance_desc>...]

14. <instance_desc> -> <Oracle_sid>:<Oracle_home>@<inst_str>

15. <Oracle_sid> -> Oracle system id for parallel instance

16. <Oracle_home> -> Oracle home for parallel instance

17. <inst_str> -> Oracle instance string to parallel instance

18. Do not include the local instance in the parameter definition!

19. default: no parallel instances

#

1. example for initC11.sap:

2. parallel_instances = (C11_002:/oracle/C11@C11_002,

3. C11_003:/oracle/C11@C11_003)

#

1. example for initC11_002.sap:

2. parallel_instances = (C11:/oracle/C11@C11,

3. C11_003:/oracle/C11@C11_003)

4. database owner of objects to be checked

5. <owner> | (<owner_list>)

6. default: all SAP owners

7. check_owner = sapr3

8. database objects to be excluded from checks

9. all_part | non_sap | [<owner>.]<table> | [<owner>.]<index>

10. | <tablespace> | (<object_list>)

11. default: no exclusion, example:

12. check_exclude = (SDBAH, SAPR3.SDBAD)

13. database owner of SDBAH, SDBAD and XDB tables for cleanup

14. <owner> | (<owner_list>)

15. default: all SAP owners

16. cleanup_owner = sapr3

17. retention period in days for brarchive log files

18. default: 30

19. cleanup_brarchive_log = 30

20. retention period in days for brbackup log files

21. default: 30

22. cleanup_brbackup_log = 30

23. retention period in days for brconnect log files

24. default: 30

25. cleanup_brconnect_log = 30

26. retention period in days for brrestore log files

27. default: 30

28. cleanup_brrestore_log = 30

29. retention period in days for sapdba log files

30. default: 30

31. cleanup_sapdba_log = 30

32. retention period in days for offline redo log files saved on disk

33. default: 30

34. cleanup_disk_archive = 30

35. retention period in days for database file saved on disk

36. default: 30

37. cleanup_disk_backup = 30

38. retention period in days for sapdba export dumps and scripts

39. default: 30

40. cleanup_exp_dump = 30

41. retention period in days for Oracle trace and audit files

42. default: 30

43. cleanup_ora_trace = 30

44. retention period in days for records in SDBAH and SDBAD tables

45. default: 100

46. cleanup_db_log = 100

47. retention period in days for records in XDB tables

48. default: 100

49. cleanup_xdb_log = 100

50. retention period in days for database check messages

51. default: 100

52. cleanup_check_msg = 100

53. database owner of objects to adapt next extents

54. <owner> | (<owner_list>)

55. default: all SAP owners

56. next_owner = sapr3

57. database objects to adapt next extents

58. all | all_ind | special | [<owner>.]<table> | [<owner>.]<index>

59. | <tablespace> | (<object_list>)

60. default: all abjects of selected owners, example:

61. next_table = (SDBAH, SAPR3.SDBAD)

62. database objects to be excluded from adapting next extents

63. all_part | [<owner>.]<table> | [<owner>.]<index> | <tablespace>

64. | (<object_list>)

65. default: no exclusion, example:

66. next_exclude = (SDBAH, SAPR3.SDBAD)

67. database objects to get special next extent size

68. all_sel:<size>[/<limit>] | [<owner>.]<table>:<size>[/<limit>]

69. | [<owner>.]<index>:<size>[/<limit>] | (<object_size_list>)

70. default: according to table category, example:

71. next_special = (SDBAH:100K, SAPR3.SDBAD:1M/200)

72. maximum next extent size

73. default: 2 GB - 5 * <database_block_size>

74. next_max_size = 1G

75. maximum number of next extents

76. default: 0 - unlimited

77. next_limit_count = 300

78. database owner of objects to update statistics

79. <owner> | (<owner_list>)

80. default: all SAP owners

81. stats_owner = sapr3

82. database objects to update statistics

83. all | all_ind | all_part | missing | info_cubes | dbstatc_tab

84. | dbstatc_mon | dbstatc_mona | [<owner>.]<table> | [<owner>.]<index>

85. | <tablespace> | (<object_list>)

86. default: all abjects of selected owners, example:

87. stats_table = (SDBAH, SAPR3.SDBAD)

88. database objects to be excluded from updating statistics

89. all_part | info_cubes | non_sap | [<owner>.]<table>

90. | [<owner>.]<index> | <tablespace> | (<object_list>)

91. default: no exclusion, example:

92. stats_exclude = (SDBAH, SAPR3.SDBAD)

93. method for updating statistics for tables not in DBSTATC

94. E | EH | EI | EX | C | CH | CX | E= | C= | =H | =I | =X | +H | +I

95. default: according to internal rules

96. stats_method = E

97. sample size for updating statistics for tables not in DBSTATC

98. P<percentage_of_rows> | R<thousands_of_rows>

99. default: according to internal rules

100. stats_sample_size = P10

101. number of buckets for updating statistics with histograms

102. default: 75

103. stats_bucket_count = 75

104. threshold for collecting statistics after checking

105. default: 50%

106. stats_change_threshold = 50

107. number of parallel threads for updating statistics

108. default: 1

109. stats_parallel_degree = 1

110. processing time limit in minutes for updating statistics

111. default: 0 - no limit

112. stats_limit_time = 0

113. parameters for calling DBMS_STATS supplied package

114. all:R|B:<degree> | all_part:R|B:<degree> | info_cubes:R|B:<degree>

115. | [<owner>.]<table>:R|B:<degree> | (<object_list>)

116. default: NULL - use ANALYZE statement

117. stats_dbms_stats = ([ALL:R:1,][<owner>.]<table>:R|B:<degree>,...)

118. definition of info cube tables

119. [<owner>.]<table> | [<owner>.]<prefix>* | (<object_list>)

120. default: from RSNSPACE control table

121. stats_info_cubes = (/BIC/D, /BI0/D, ...)

[Former Member]

Thank you

[markus_doehr2]

If you backup to disk you have to make sure, you have enough space to take the backup files. That is not the case and that's why you get the error.

The only way is to give the system the missing 15+ GB.

Markus

[Former Member]

Ok thank you Markus for your reply. I thought there might be a parameter to get around this. We will give the system the missing 15+ GB that it needs and away we go.

Thanks again for your response.

Regards