Database Software

Hi,

When I initiate a backup thru BRbackup it hungs after creating a folder. I checked permissions of the BR* files. As a matter of fact. on other servers it is running without any problem. Even I compared SPFILE and init<SID>.sap files. Please see the *.and file log.


MBES01:oras01 10> more beayrvav.and
BR0051I BRBACKUP 7.00 (41)
BR0055I Start of database backup: beayrvav.and 2009-07-07 08.12.17
BR0484I BRBACKUP log file: /oracle/S01/sapbackup/beayrvav.and
BR0477I Oracle pfile /oracle/S01/102_64/dbs/initS01.ora created from spfile /oracle/S01/102_64/dbs/spfileS01.ora

BR0101I Parameters

Name Value

oracle_sid S01
oracle_home /oracle/S01/102_64
oracle_profile /oracle/S01/102_64/dbs/initS01.ora
sapdata_home /oracle/S01
sap_profile /oracle/S01/102_64/dbs/initS01.sap
backup_mode ALL
backup_type online
backup_dev_type disk
backup_root_dir /oracle/S01/sapbackup
compress no
disk_copy_cmd rman
cpio_disk_flags -pdcu
exec_parallel 0
rman_compress no
system_info oras01/oras01 MBES01 AIX 3 5 00CD16724C00
oracle_info S01 10.2.0.2.0 8192 2959 21202296 MBES01 UTF8 UTF8
sap_info 700 SAPSR3 0002LK0003S010011E21297128880015Maintenance_ORA
make_info rs6000_64 OCI_102 Apr 8 2009
command_line /usr/sap/S01/SYS/exe/run/brbackup -p initS01.sap -d disk -t online -m all -k no -e 0 -o dist,time -l E -U

BR0116I ARCHIVE LOG LIST before backup for database instance S01

Parameter Value

Database log mode Archive Mode
Automatic archival Enabled
Archive destination /oracle/S01/oraarch/S01arch
Archive format %t_%s_%r.dbf
Oldest online log sequence 2956
Next log sequence to archive 2959
Current log sequence 2959 SCN: 21202296
Database block size 8192 Thread: 1
Current system change number 21209894 ResetId: 674792151

BR0118I Tablespaces and data files

Tablespace TS-Status F-Status File Size Id. Device Link Type
MaxSize IncrSize BlkSize

PSAPSR3 ONLINE* ONLINE+ /oracle/S01/sapdata2/sr3_1/sr3.data1 2579505152 4 3276802 NOLINK FILE 104
85760000 20971520 8192
PSAPSR3 ONLINE* ONLINE+ /oracle/S01/sapdata2/sr3_10/sr3.data10 1069555712 13 3276802 NOLINK FILE 104
85760000 20971520 8192
PSAPSR3 ONLINE* ONLINE+ /oracle/S01/sapdata2/sr3_2/sr3.data2 2558533632 5 3276802 NOLINK FILE 104
85760000 20971520 8192
PSAPSR3 ONLINE* ONLINE+ /oracle/S01/sapdata2/sr3_3/sr3.data3 3334479872 6 3276802 NOLINK FILE 104
85760000 20971520 8192
PSAPSR3 ONLINE* ONLINE+ /oracle/S01/sapdata2/sr3_4/sr3.data4 3984596992 7 3276802 NOLINK FILE 104
85760000 20971520 8192
PSAPSR3 ONLINE* ONLINE+ /oracle/S01/sapdata2/sr3_5/sr3.data5 3166707712 8 3276802 NOLINK FILE 104
85760000 20971520 8192
PSAPSR3 ONLINE* ONLINE+ /oracle/S01/sapdata2/sr3_6/sr3.data6 2998935552 9 3276802 NOLINK FILE 104
85760000 20971520 8192
PSAPSR3 ONLINE* ONLINE+ /oracle/S01/sapdata2/sr3_7/sr3.data7 2977964032 10 3276802 NOLINK FILE 104
85760000 20971520 8192
PSAPSR3 ONLINE* ONLINE+ /oracle/S01/sapdata2/sr3_8/sr3.data8 2852134912 11 3276802 NOLINK FILE 104
85760000 20971520 8192
PSAPSR3 ONLINE* ONLINE+ /oracle/S01/sapdata2/sr3_9/sr3.data9 2810191872 12 3276802 NOLINK FILE 104
85760000 20971520 8192
PSAPSR3700 ONLINE* ONLINE+ /oracle/S01/sapdata3/sr3700_1/sr3700.data1 3523223552 14 3276802 NOLINK FILE 104
85760000 20971520 8192
PSAPSR3700 ONLINE* ONLINE+ /oracle/S01/sapdata3/sr3700_2/sr3700.data2 4299169792 15 3276802 NOLINK FILE 104
85760000 20971520 8192
PSAPSR3700 ONLINE* ONLINE+ /oracle/S01/sapdata3/sr3700_3/sr3700.data3 3607109632 16 3276802 NOLINK FILE 104
85760000 20971520 8192
PSAPSR3700 ONLINE* ONLINE+ /oracle/S01/sapdata3/sr3700_4/sr3700.data4 3428851712 17 3276802 NOLINK FILE 104
85760000 20971520 8192
PSAPSR3DB ONLINE* ONLINE+ /oracle/S01/sapdata4/sr3db_1/sr3db.data1 2097160192 19 3276802 NOLINK FILE 104
85760000 20971520 8192
PSAPSR3DB ONLINE* ONLINE+ /oracle/S01/sapdata4/sr3db_2/sr3db.data2 2097160192 20 3276802 NOLINK FILE 104
85760000 20971520 8192
PSAPSR3DB ONLINE* ONLINE+ /oracle/S01/sapdata4/sr3db_3/sr3db.data3 1048584192 21 3276802 NOLINK FILE 104
85760000 20971520 8192
PSAPSR3USR ONLINE* ONLINE+ /oracle/S01/sapdata4/sr3usr_1/sr3usr.data1 20979712 18 3276802 NOLINK FILE 104
85760000 20971520 8192
PSAPTEMP ONLINE# ONLINE+ /oracle/S01/sapdata1/temp_1/temp.data1 1017126912 -1 3276802 NOLINK FILE 104
85760000 20971520 8192
PSAPUNDO ONLINE- ONLINE+ /oracle/S01/sapdata1/undo_1/undo.data1 2705334272 2 3276802 NOLINK FILE 104
85760000 20971520 8192
SYSAUX ONLINE* ONLINE+ /oracle/S01/sapdata1/sysaux_1/sysaux.data1 230694912 3 3276802 NOLINK FILE 104
85760000 20971520 8192
SYSTEM ONLINE* SYSTEM+ /oracle/S01/sapdata1/system_1/system.data1 513810432 1 3276802 NOLINK FILE 104
85760000 20971520 8192

BR0119I Redo log files

File Size Group Device Status Link Type

/oracle/S01/origlogA/log_g11m1.dbf 52429312 1 3276802 INUSE NOLINK FILE
/oracle/S01/mirrlogA/log_g11m2.dbf 52429312 1 3276802 INUSE NOLINK FILE
/oracle/S01/origlogB/log_g12m1.dbf 52429312 2 3276802 INUSE NOLINK FILE
/oracle/S01/mirrlogB/log_g12m2.dbf 52429312 2 3276802 INUSE NOLINK FILE
/oracle/S01/origlogA/log_g13m1.dbf 52429312 3 3276802 INUSE NOLINK FILE
/oracle/S01/mirrlogA/log_g13m2.dbf 52429312 3 3276802 INUSE NOLINK FILE
/oracle/S01/origlogB/log_g14m1.dbf 52429312 4 3276802 INUSE NOLINK FILE
/oracle/S01/mirrlogB/log_g14m2.dbf 52429312 4 3276802 INUSE NOLINK FILE

BR0120I Control files

File Size Id. Device Link Type

/oracle/S01/origlogA/cntrl/cntrlS01.dbf 14368768 0 3276802 NOLINK FILE
/oracle/S01/origlogB/cntrl/cntrlS01.dbf 14368768 0 3276802 NOLINK FILE
/oracle/S01/sapdata1/cntrl/cntrlS01.dbf 14368768 0 3276802 NOLINK FILE

BR0616I Tablespaces in table TSORA for SAP owner SAPSR3:
PSAPSR3, PSAPSR3700, PSAPSR3USR

BR0379I Distribution of files on volume #1:

Position Size Rate Compressed Duration Speed Name
[m:s] [MB/h]
1 2579505152* 2:19 63712 /oracle/S01/sapdata2/sr3_1/sr3.data1
2 1069555712* 0:59 62238 /oracle/S01/sapdata2/sr3_10/sr3.data10
3 2558533632* 2:19 63194 /oracle/S01/sapdata2/sr3_2/sr3.data2
4 3334479872* 2:48 68143 /oracle/S01/sapdata2/sr3_3/sr3.data3
5 3984596992* 3:19 68744 /oracle/S01/sapdata2/sr3_4/sr3.data4
6 3166707712* 2:49 64332 /oracle/S01/sapdata2/sr3_5/sr3.data5
7 2998935552* 2:38 65165 /oracle/S01/sapdata2/sr3_6/sr3.data6
8 2977964032* 2:39 64302 /oracle/S01/sapdata2/sr3_7/sr3.data7
9 2852134912* 2:28 66162 /oracle/S01/sapdata2/sr3_8/sr3.data8
10 2810191872* 2:29 64752 /oracle/S01/sapdata2/sr3_9/sr3.data9
11 3523223552* 2:49 71574 /oracle/S01/sapdata3/sr3700_1/sr3700.data1
12 4299169792* 3:38 67707 /oracle/S01/sapdata3/sr3700_2/sr3700.data2
13 3607109632* 3:09 65524 /oracle/S01/sapdata3/sr3700_3/sr3700.data3
14 3428851712* 2:48 70072 /oracle/S01/sapdata3/sr3700_4/sr3700.data4
15 2097160192* 1:59 60504 /oracle/S01/sapdata4/sr3db_1/sr3db.data1
16 2097160192* 1:58 61017 /oracle/S01/sapdata4/sr3db_2/sr3db.data2
17 1048584192* 0:59 61017 /oracle/S01/sapdata4/sr3db_3/sr3db.data3
18 20979712* 0:06 12005 /oracle/S01/sapdata4/sr3usr_1/sr3usr.data1
19 2705334272* 2:19 66820 /oracle/S01/sapdata1/undo_1/undo.data1
20 230694912* 0:19 41686 /oracle/S01/sapdata1/sysaux_1/sysaux.data1
21 513810432* 0:38 46422 /oracle/S01/sapdata1/system_1/system.data1
22 14368768 0:00 0* /oracle/S01/sapbackup/cntrlS01.dbf

Total: 51919052800* 45:29 65317

BR0284I BRBACKUP time stamp: 2009-07-07 08.12.19, elapsed time: 0:00
BR0057I Backup of database: S01
BR0058I BRBACKUP action ID: beayrvav
BR0059I BRBACKUP function ID: and
BR0110I Backup mode: ALL
BR0077I Database file for backup: /oracle/S01/sapbackup/cntrlS01.dbf
BR0061I 22 files found for backup, total size 49513.867 MB
BR0143I Backup type: online
BR0112I Files will not be compressed
BR0130I Backup device type: disk
BR0106I Files will be saved on disk in directory: /oracle/S01/sapbackup/beayrvav

BR0284I BRBACKUP time stamp: 2009-07-07 08.12.19, elapsed time: 0:00
BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRBACKUP:
BR0284I BRBACKUP time stamp: 2009-07-07 08.12.54, elapsed time: 0:35
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...

BR0370I Directory /oracle/S01/sapbackup/beayrvav created


*************************

It stops here.. folder "beayrvav" is empty..


****************************************

Pls. see the file permissions..

MBES01:oras01 19> ls -ltr br*
-rwxr-xr-x 1 s01adm sapsys 2786259 Jun 29 13:38 brtools
-rwxr-xr-x 1 s01adm sapsys 7003725 Jun 29 13:38 brspace
-rwxr-xr-x 1 s01adm sapsys 2133353 Jun 29 13:38 brrestore
-rwxr-xr-x 1 s01adm sapsys 5674701 Jun 29 13:38 brrecover
-rwsrwxr-x 1 oras01 sapsys 6792769 Jun 29 13:38 brconnect
-rwsrwxr-x 1 oras01 sapsys 5207187 Jun 29 13:38 brbackup
-rwsrwxr-x 1 oras01 sapsys 5078258 Jun 29 13:38 brarchive


Pls. help me to resolve this problem..

Sundaresh Suryanarayan