cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

back up falure

Former Member

on ‎06-10-2009 7:43 AM

0 Kudos

Hi,

When i am trying to take full back up from DB13 it become failure.iam getting below error message.

BR0227E Not enough disk space in F:\SAPDEVBACKUP\DATA for backup, missing at least 23710.443 MB

F directory we have free space of 104 GB.

Please find the log details below.

BR0051I BRBACKUP 7.00 (22)

BR0055I Start of database backup: beatpjfs.afd 2009-06-10 12.02.00

BR0484I BRBACKUP log file: E:\oracle\VMD\sapbackup\beatpjfs.afd

BR0477I Oracle pfile E:\oracle\VMD\102\database\initVMD.ora created from spfile E:\oracle\VMD\102\database\spfileVMD.ora

BR0101I Parameters

Name Value

oracle_sid VMD

oracle_home E:\oracle\VMD\102

oracle_profile E:\oracle\VMD\102\database\initVMD.ora

sapdata_home E:\oracle\VMD

sap_profile E:\oracle\VMD\102\database\initVMD.sap

backup_mode ALL

backup_type offline_force

backup_dev_type disk

backup_root_dir F:\SAPDEVBACKUP\DATA

compress no

disk_copy_cmd copy

cpio_disk_flags -pdcu

exec_parallel 0

system_info SAPServiceVMD BLRSAP002 Windows 5.2 Build 3790 Service Pack 1 Intel

oracle_info VMD 10.2.0.2.0 8192 8679 120412092 BLRSAP002 UTF8 UTF8

sap_info 700 SAPSR3 0002LK0003VMD0011G17903365280013NetWeaver_ORA

make_info NTintel OCI_10201_SHARE Jan 29 2007

command_line brbackup -u / -jid ALGOF20090610120148 -c force -t offline_force -m all -p initVMD.sap -a -c force -p initV

BR0116I ARCHIVE LOG LIST before backup for database instance VMD

Parameter Value

Database log mode Archive Mode

Automatic archival Enabled

Archive destination C:\oracle\VMD\oraarch\VMDarch

Archive format ARC%S_%R.%T

Oldest online log sequence 8676

Next log sequence to archive 8679

Current log sequence 8679 SCN: 120412092

Database block size 8192 Thread: 1

Current system change number 120436351 ResetId: 622656011

BR0118I Tablespaces and data files

Tablespace TS-Status F-Status File Size Id. Device Link Type M

PSAPSR3 ONLINE* ONLINE+ E:\ORACLE\VMD\SAPDATA1\SR3_1\SR3.DATA1 2097160192 4 4 NOLINK FILE 10485

PSAPSR3 ONLINE* ONLINE+ E:\ORACLE\VMD\SAPDATA1\SR3_2\SR3.DATA2 2097160192 5 4 NOLINK FILE 10485

PSAPSR3700 ONLINE* ONLINE+ E:\ORACLE\VMD\SAPDATA1\SR3700_1\SR3700.DATA1 3439337472 24 4 NOLINK FILE 10485

PSAPSR3700 ONLINE* ONLINE+ E:\ORACLE\VMD\SAPDATA1\SR3700_2\SR3700.DATA2 3544195072 25 4 NOLINK FILE 10485

PSAPSR3700 ONLINE* ONLINE+ E:\ORACLE\VMD\SAPDATA1\SR3700_3\SR3700.DATA3 3607109632 26 4 NOLINK FILE 10485

PSAPSR3700 ONLINE* ONLINE+ E:\ORACLE\VMD\SAPDATA1\SR3700_4\SR3700.DATA4 3502252032 27 4 NOLINK FILE 10485

PSAPSR3700 ONLINE* ONLINE+ E:\ORACLE\VMD\SAPDATA2\SR3700_5\SR3700.DATA5 3271565312 28 4 NOLINK FILE 10485

PSAPSR3700 ONLINE* ONLINE+ E:\ORACLE\VMD\SAPDATA2\SR3700_6\SR3700.DATA6 3271565312 29 4 NOLINK FILE 10485

PSAPSR3700 ONLINE* ONLINE+ E:\ORACLE\VMD\SAPDATA2\SR3700_7\SR3700.DATA7 3271565312 30 4 NOLINK FILE 10485

PSAPSR3700 ONLINE* ONLINE+ E:\ORACLE\VMD\SAPDATA2\SR3700_8\SR3700.DATA8 3187679232 31 4 NOLINK FILE 10485

PSAPSR3700 ONLINE* ONLINE+ E:\ORACLE\VMD\SAPDATA3\SR3700_10\SR3700.DATA10 2998935552 33 4 NOLINK FILE 10485

PSAPSR3700 ONLINE* ONLINE+ E:\ORACLE\VMD\SAPDATA3\SR3700_11\SR3700.DATA11 3103793152 34 4 NOLINK FILE 10485

PSAPSR3700 ONLINE* ONLINE+ E:\ORACLE\VMD\SAPDATA3\SR3700_12\SR3700.DATA12 3082821632 35 4 NOLINK FILE 10485

PSAPSR3700 ONLINE* ONLINE+ E:\ORACLE\VMD\SAPDATA3\SR3700_9\SR3700.DATA9 3082821632 32 4 NOLINK FILE 10485

PSAPSR3700 ONLINE* ONLINE+ E:\ORACLE\VMD\SAPDATA4\SR3700_13\SR3700.DATA13 3082821632 36 4 NOLINK FILE 10485

PSAPSR3700 ONLINE* ONLINE+ E:\ORACLE\VMD\SAPDATA4\SR3700_14\SR3700.DATA14 3355451392 37 4 NOLINK FILE 10485

PSAPSR3700 ONLINE* ONLINE+ E:\ORACLE\VMD\SAPDATA4\SR3700_15\SR3700.DATA15 3124764672 38 4 NOLINK FILE 10485

PSAPSR3700 ONLINE* ONLINE+ E:\ORACLE\VMD\SAPDATA4\SR3700_16\SR3700.DATA16 2768248832 39 4 NOLINK FILE 10485

PSAPSR3700 ONLINE* ONLINE+ E:\ORACLE\VMD\SAPDATA4\SR3700_17\SR3700.DATA17 2789220352 44 4 NOLINK FILE 10485

PSAPSR3700 ONLINE* ONLINE+ E:\ORACLE\VMD\SAPDATA4\SR3700_18\SR3700.DATA18 2768248832 45 4 NOLINK FILE 10485

PSAPSR3700 ONLINE* ONLINE+ E:\ORACLE\VMD\SAPDATA4\SR3700_19\SR3700.DATA19 10485768192 48 4 NOLINK FILE 10485

PSAPSR3700 ONLINE* ONLINE+ E:\ORACLE\VMD\SAPDATA4\SR3700_20\SR3700.DATA20 2579505152 49 4 NOLINK FILE 5242

PSAPSR3700 ONLINE* ONLINE+ E:\ORACLE\VMD\SAPDATA4\SR3700_21\SR3700.DATA21 2579505152 50 4 NOLINK FILE 10485

PSAPSR3700 ONLINE* ONLINE+ E:\ORACLE\VMD\SAPDATA4\SR3700_22\SR3700.DATA22 2579505152 51 4 NOLINK FILE 10485

PSAPSR3DB ONLINE* ONLINE+ E:\ORACLE\VMD\SAPDATA4\SR3DB_1\SR3DB.DATA1 2097160192 41 4 NOLINK FILE 10485

PSAPSR3DB ONLINE* ONLINE+ E:\ORACLE\VMD\SAPDATA4\SR3DB_2\SR3DB.DATA2 2097160192 42 4 NOLINK FILE 10485

PSAPSR3DB ONLINE* ONLINE+ E:\ORACLE\VMD\SAPDATA4\SR3DB_3\SR3DB.DATA3 1048584192 43 4 NOLINK FILE 10485

PSAPSR3USR ONLINE* ONLINE+ E:\ORACLE\VMD\SAPDATA1\SR3USR_1\SR3USR.DATA1 20979712 40 4 NOLINK FILE 10485

PSAPTEMP ONLINE# ONLINE+ E:\ORACLE\VMD\SAPDATA2\TEMP_1\TEMP.DATA1 2097160192 -1 4 NOLINK FILE 10485

PSAPUNDO ONLINE- ONLINE+ E:\ORACLE\VMD\SAPDATA3\UNDO_1\UNDO.DATA1 9143590912 2 4 NOLINK FILE 10485

SYSAUX ONLINE* ONLINE+ E:\ORACLE\VMD\SAPDATA1\SYSAUX_1\SYSAUX.DATA1 272637952 3 4 NOLINK FILE 10485

SYSAUX ONLINE* ONLINE+ E:\ORACLE\VMD\SAPDATA1\SYSAUX_2\SYSAUX.DATA2 272637952 47 4 NOLINK FILE 10485

SYSTEM ONLINE* SYSTEM+ E:\ORACLE\VMD\SAPDATA1\SYSTEM_1\SYSTEM.DATA1 859840512 1 4 NOLINK FILE 10485

SYSTEM ONLINE* SYSTEM+ E:\ORACLE\VMD\SAPDATA1\SYSTEM_2\SYSTEM.DATA2 859840512 46 4 NOLINK FILE 10485

BR0119I Redo log files

File Size Group Device Status Link Type

E:\ORACLE\VMD\ORIGLOGA\LOG_G11M1.DBF 52429312 1 4 INUSE NOLINK FILE

C:\ORACLE\VMD\MIRRLOGA\LOG_G11M2.DBF 52429312 1 2 INUSE NOLINK FILE

E:\ORACLE\VMD\ORIGLOGB\LOG_G12M1.DBF 52429312 2 4 INUSE NOLINK FILE

C:\ORACLE\VMD\MIRRLOGB\LOG_G12M2.DBF 52429312 2 2 INUSE NOLINK FILE

E:\ORACLE\VMD\ORIGLOGA\LOG_G13M1.DBF 52429312 3 4 INUSE NOLINK FILE

BR0120I Control files

File Size Id. Device Link Type

E:\oracle\VMD\origlogA\cntrl\cntlrVMD.dbf 14106624 0 4 NOLINK FILE

E:\oracle\VMD\origlogB\cntrl\cntrlVMD.dbf 14106624 0 4 NOLINK FILE

E:\oracle\VMD\sapdata1\cntrl\cntrlVMD.dbf 14106624 0 4 NOLINK FILE

BR0616I Tablespaces in table TSORA for SAP owner SAPSR3:

PSAPSR3, PSAPSR3700, PSAPSR3USR

BR0227E Not enough disk space in F:\SAPDEVBACKUP\DATA for backup, missing at least 23710.443 MB

BR0056I End of database backup: beatpjfs.afd 2009-06-10 12.02.06

BR0280I BRBACKUP time stamp: 2009-06-10 12.02.06

BR0054I BRBACKUP terminated with errors

BR0280I BRBACKUP time stamp: 2009-06-10 12.02.06

BR0291I BRARCHIVE will be started with options '-U -jid ALGOF20090610120148 -d disk -c force -p initVMD.sap -s'

Show replies
Show replies
Answer

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
‎06-13-2009 12:07 PM
0 Kudos

Hi,

The backup error is due to unavailability of disk space to store the database backup.

You can perform a software / hardware compression.

In case of Software compression,

Set compress = yes in init<dbsid>.sap. You must also set the compress command in the parameter compress_cmd. You should also specify the directory in which compression is to be performed in the parameter compress_dir.

In case of Hardware compression,

Set compress=hardware in init<dbsid>.sap. This parameter can be set when tape units that support hardware compression are used. Just setting this parameter does not activate hardware compression.

The compression rate for backups with and without RMAN can be determined using BR*Tools.

The other option may be to go for a series of partial database backups at different locations.

However, you must ensure that each file of the database is included in at least one partial backup.

regards,

Subhajit.

Show replies
Show replies
Former Member
‎06-10-2009 10:41 AM
0 Kudos

Hi Asif,

Its always a better practise to calculate the DB size before you proceed with the backup .

The below command would give you the Database Size in GB

SQL> select sum(bytes / (102410241024)) "DB Size in GB" from dba_data_files;

Regards,

Ershad Ahmed .

Show replies
Show replies
former_member204746
Active Contributor
‎06-10-2009 12:50 PM
0 Kudos

obviously, you are missing disk space.

a possible solution is to use software compression. read SAP note 8707.

Former Member
‎06-10-2009 8:02 AM
0 Kudos

Hi,

Please note that the total size of your database is around 127 GB and the available disk space is only 104GB thats why it throws an error stating that it cannot accomodatate 23GB of data.

Free your F:\ drive fo another 24GB and try executing the backup again. To let me know whether your issue has been fixed.

Regards,

Balakrishnan

Show replies
Show replies
former_member185031
Active Contributor
‎06-10-2009 7:49 AM
0 Kudos

So what is the current database size. its required additional 24GB space as per the error.

Regards,

Subhash

Show replies
Show replies
Former Member
‎06-10-2009 8:04 AM
0 Kudos

Hi Subhash,

Our DB size is 126 GB and free space is 16 GB.

Regards,

Asif

former_member185031
Active Contributor
‎06-10-2009 8:16 AM
0 Kudos

Table space allocated is 126 GB for your database. So you need the same space for backup.

Regards,

Subhash

Former Member
‎06-10-2009 8:23 AM
0 Kudos

Hi Asif,

If you already have some incompleted backup data files or old db backup, delete those files and re execute the backup. Ensure that you have 128 GB of free disk space

Regards,

Balakrishnan

Ask a Question