on 09-29-2010 11:10 AM
Hi
I am getting error which performing arcihve log backup from db13
ECC6.0, Linux, Oracle 10.2.0.2
BR0202I Saving /oracle/PRD/oraarch/PRDarch1_5442_652040864.dbf
BR0203I to /mnt/backup/redologPRD/PRDarch1_5442_652040864.dbf ...
#ARCHIVE.. /oracle/PRD/oraarch/PRDarch1_5442_652040864.dbf
#SAVED.... /mnt/backup/redologPRD/PRDarch1_5442_652040864.dbf #1/4
BR0280I BRARCHIVE time stamp: 2010-09-29 14.25.45
BR0014I 4 of 4 offline redo log files processed - 167.768 MB of 167.768 MB done
BR0204I Percentage done: 100.00%, estimated end time: 14:25
BR0001I **************************************************
BR0016I 4 offline redo log files processed, total size 167.768 MB
BR0202I Saving space_log
BR0203I to /mnt/backup/redologPRD/PRD ...
BR0278E Command output of 'LANG=C cd /oracle/PRD/sapreorg && LANG=C cp spacePRD.log strucPRD.log /mnt/backup/redologPRD/PRD':
cp: cannot create regular file `/mnt/backup/redologPRD/PRD/spacePRD.log': Permission denied
cp: cannot create regular file `/mnt/backup/redologPRD/PRD/strucPRD.log': Permission denied
BR0280I BRARCHIVE time stamp: 2010-09-29 14.25.45
BR0279E Return code from 'LANG=C cd /oracle/PRD/sapreorg && LANG=C cp spacePRD.log strucPRD.log /mnt/backup/redologPRD/PRD': 1
BR0222E Copying space_log to/from /mnt/backup/redologPRD/PRD failed due to previous errors
BR0202I Saving /oracle/PRD/saparch/aeefptvm.sve
BR0203I to /mnt/backup/redologPRD/PRD ...
BR0202I Saving /oracle/PRD/saparch/archPRD.log
BR0203I to /mnt/backup/redologPRD/PRD ...
BR0007I End of offline redo log processing: aeefptvm.sve 2010-09-29 14.25.45
BR0280I BRARCHIVE time stamp: 2010-09-29 14.25.45
BR0005I BRARCHIVE terminated with errors
We have mapped drive from windows server to linux and it mounted. Till yesterday everything was fine.
Pls suggest
thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Change the file permissions to 755 and start test backup.
Refer SAP Install guide to get an idea on recommended file perissions.
Regards,
Nick Loy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
As weird as it may seem.... do you use the latest BR tools available?
Download the latest tools from SAP Service Marketplace and check if the error appears again.
Regards,
Constantina
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
>
> Hi
>
> BR0202I Saving /oracle/PRD/saparch/aeefptvm.sve
> BR0203I to /mnt/backup/redologPRD/PRD ...
> BR0202I Saving /oracle/PRD/saparch/archPRD.log
> BR0203I to /mnt/backup/redologPRD/PRD ...
>
> Pls suggest
Hi,
copying the archive logs and the protocols works, but only the space_logs not ?
This suggest the the target directory permissions are fine (otherwise the other copies would fail as well).
Are there existing files with the same name from a previuos run with a strange ownership?
ls -l /mnt/backup/redologPRD/PRD/spacePRD.log
ls -l /mnt/backup/redologPRD/PRD/strucPRD.log
???
Volker
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Volker,
After renaming the old files spacePRD.log other files we are able to take the Archive log backups successfully but in Full OFFLine back we are getting the error. Pls find below the log
BR0051I BRBACKUP 7.00 (34)
BR0055I Start of database backup: beefwqqz.ffd 2010-10-01 00.00.17
BR0484I BRBACKUP log file: /oracle/PRD/sapbackup/beefwqqz.ffd
BR0477I Oracle pfile /oracle/PRD/102_64/dbs/initPRD.ora created from spfile /oracle/PRD/102_64/dbs/spfilePRD.ora
BR0101I Parameters
Name Value
oracle_sid PRD
oracle_home /oracle/PRD/102_64
oracle_profile /oracle/PRD/102_64/dbs/initPRD.ora
sapdata_home /oracle/PRD
sap_profile /oracle/PRD/102_64/dbs/initPRD.sap
backup_mode FULL
backup_type offline_force
backup_dev_type disk
backup_root_dir /mnt/backup
compress no
disk_copy_cmd dd
cpio_disk_flags -pdcu
dd_flags obs=64k bs=64k
dd_in_flags ibs=64k bs=64k
exec_parallel 0
system_info prdadm/oraprd ascmprd Linux 2.6.9-67.ELsmp #1 SMP Wed Nov 7 13:56:44 EST 2007 x86_64
oracle_info PRD 10.2.0.2.0 8192 5451 70521832 ascmprd WE8DEC UTF8
sap_info 700 SAPSR3 0002LK0003PRD0011M19918060750015Maintenance_ORA
make_info linuxx86_64 OCI_102 May 30 2008
command_line brbackup -u / -jid FLGOF20101001000000 -c force -t offline_force -m full -p initPRD.sap -a -c force -p initPRD.
BR0116I ARCHIVE LOG LIST before backup for database instance PRD
Parameter Value
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /oracle/PRD/oraarch/PRDarch
Archive format %t_%s_%r.dbf
Oldest online log sequence 5448
Next log sequence to archive 5451
Current log sequence 5451 SCN: 70521832
Database block size 8192 Thread: 1
Current system change number 70534379 ResetId: 652040864
BR0118I Tablespaces and data files
Tablespace TS-Status F-Status File Size Id. Device Link Type MaxSi
PSAPSR3 ONLINE* ONLINE+ /oracle/PRD/sapdata1/sr3_1/sr3.data1 2097160192 4 64776 NOLINK FILE 104857600
PSAPSR3 ONLINE* ONLINE+ /oracle/PRD/sapdata1/sr3_2/sr3.data2 2097160192 5 64776 NOLINK FILE 104857600
PSAPSR3 ONLINE* ONLINE+ /oracle/PRD/sapdata1/sr3_3/sr3.data3 2097160192 6 64776 NOLINK FILE 104857600
PSAPSR3 ONLINE* ONLINE+ /oracle/PRD/sapdata1/sr3_4/sr3.data4 2097160192 7 64776 NOLINK FILE 104857600
PSAPSR3 ONLINE* ONLINE+ /oracle/PRD/sapdata1/sr3_5/sr3.data5 2097160192 8 64776 NOLINK FILE 104857600
PSAPSR3 ONLINE* ONLINE+ /oracle/PRD/sapdata2/sr3_10/sr3.data10 2097160192 13 64777 NOLINK FILE 104857600
PSAPSR3 ONLINE* ONLINE+ /oracle/PRD/sapdata2/sr3_6/sr3.data6 2097160192 9 64777 NOLINK FILE 104857600
PSAPSR3 ONLINE* ONLINE+ /oracle/PRD/sapdata2/sr3_7/sr3.data7 2097160192 10 64777 NOLINK FILE 104857600
PSAPSR3 ONLINE* ONLINE+ /oracle/PRD/sapdata2/sr3_8/sr3.data8 2097160192 11 64777 NOLINK FILE 104857600
PSAPSR3 ONLINE* ONLINE+ /oracle/PRD/sapdata2/sr3_9/sr3.data9 2097160192 12 64777 NOLINK FILE 104857600
PSAPSR3 ONLINE* ONLINE+ /oracle/PRD/sapdata3/sr3_11/sr3.data11 2097160192 14 64778 NOLINK FILE 104857600
PSAPSR3 ONLINE* ONLINE+ /oracle/PRD/sapdata3/sr3_12/sr3.data12 2097160192 15 64778 NOLINK FILE 104857600
PSAPSR3 ONLINE* ONLINE+ /oracle/PRD/sapdata3/sr3_13/sr3.data13 2097160192 16 64778 NOLINK FILE 104857600
PSAPSR3 ONLINE* ONLINE+ /oracle/PRD/sapdata3/sr3_14/sr3.data14 2097160192 17 64778 NOLINK FILE 104857600
PSAPSR3 ONLINE* ONLINE+ /oracle/PRD/sapdata3/sr3_15/sr3.data15 2097160192 18 64778 NOLINK FILE 104857600
PSAPSR3 ONLINE* ONLINE+ /oracle/PRD/sapdata4/sr3_16/sr3.data16 2097160192 19 64779 NOLINK FILE 104857600
PSAPSR3 ONLINE* ONLINE+ /oracle/PRD/sapdata4/sr3_17/sr3.data17 2097160192 20 64779 NOLINK FILE 104857600
PSAPSR3 ONLINE* ONLINE+ /oracle/PRD/sapdata4/sr3_18/sr3.data18 2097160192 21 64779 NOLINK FILE 104857600
PSAPSR3 ONLINE* ONLINE+ /oracle/PRD/sapdata4/sr3_19/sr3.data19 2097160192 22 64779 NOLINK FILE 104857600
PSAPSR3 ONLINE* ONLINE+ /oracle/PRD/sapdata4/sr3_20/sr3.data20 2097160192 23 64779 NOLINK FILE 104857600
PSAPSR3 ONLINE* ONLINE+ /oracle/PRD/sapdata4/sr3_21/sr3.data21 2097160192 45 64779 NOLINK FILE 104857600
PSAPSR3700 ONLINE* ONLINE+ /oracle/PRD/sapdata1/sr3700_1/sr3700.data1 2097160192 24 64776 NOLINK FILE 104857600
PSAPSR3700 ONLINE* ONLINE+ /oracle/PRD/sapdata1/sr3700_2/sr3700.data2 2097160192 25 64776 NOLINK FILE 104857600
PSAPSR3700 ONLINE* ONLINE+ /oracle/PRD/sapdata1/sr3700_3/sr3700.data3 2097160192 26 64776 NOLINK FILE 104857600
PSAPSR3700 ONLINE* ONLINE+ /oracle/PRD/sapdata1/sr3700_4/sr3700.data4 2097160192 27 64776 NOLINK FILE 104857600
PSAPSR3700 ONLINE* ONLINE+ /oracle/PRD/sapdata2/sr3700_5/sr3700.data5 2097160192 28 64777 NOLINK FILE 104857600
PSAPSR3700 ONLINE* ONLINE+ /oracle/PRD/sapdata1/sr3700_3/sr3700.data3 2097160192 26 64776 NOLINK FILE 104857600
PSAPSR3700 ONLINE* ONLINE+ /oracle/PRD/sapdata1/sr3700_4/sr3700.data4 2097160192 27 64776 NOLINK FILE 104857600
PSAPSR3700 ONLINE* ONLINE+ /oracle/PRD/sapdata2/sr3700_5/sr3700.data5 2097160192 28 64777 NOLINK FILE 104857600
PSAPSR3700 ONLINE* ONLINE+ /oracle/PRD/sapdata2/sr3700_6/sr3700.data6 2097160192 29 64777 NOLINK FILE 104857600
PSAPSR3700 ONLINE* ONLINE+ /oracle/PRD/sapdata2/sr3700_7/sr3700.data7 2097160192 30 64777 NOLINK FILE 104857600
PSAPSR3700 ONLINE* ONLINE+ /oracle/PRD/sapdata2/sr3700_8/sr3700.data8 2097160192 31 64777 NOLINK FILE 104857600
PSAPSR3700 ONLINE* ONLINE+ /oracle/PRD/sapdata3/sr3700_10/sr3700.data10 2097160192 33 64778 NOLINK FILE 104857600
PSAPSR3700 ONLINE* ONLINE+ /oracle/PRD/sapdata3/sr3700_11/sr3700.data11 2097160192 34 64778 NOLINK FILE 104857600
PSAPSR3700 ONLINE* ONLINE+ /oracle/PRD/sapdata3/sr3700_12/sr3700.data12 2097160192 35 64778 NOLINK FILE 104857600
PSAPSR3700 ONLINE* ONLINE+ /oracle/PRD/sapdata3/sr3700_9/sr3700.data9 2097160192 32 64778 NOLINK FILE 104857600
PSAPSR3700 ONLINE* ONLINE+ /oracle/PRD/sapdata4/sr3700_13/sr3700.data13 2097160192 36 64779 NOLINK FILE 104857600
PSAPSR3700 ONLINE* ONLINE+ /oracle/PRD/sapdata4/sr3700_14/sr3700.data14 2097160192 37 64779 NOLINK FILE 104857600
PSAPSR3700 ONLINE* ONLINE+ /oracle/PRD/sapdata4/sr3700_15/sr3700.data15 2097160192 38 64779 NOLINK FILE 104857600
PSAPSR3700 ONLINE* ONLINE+ /oracle/PRD/sapdata4/sr3700_16/sr3700.data16 2097160192 39 64779 NOLINK FILE 104857600
PSAPSR3700 ONLINE* ONLINE+ /oracle/PRD/sapdata4/sr3700_17/sr3700.data17 2097160192 41 64779 NOLINK FILE 104857600
PSAPSR3700 ONLINE* ONLINE+ /oracle/PRD/sapdata4/sr3700_18/sr3700.data18 2097160192 42 64779 NOLINK FILE 104857600
PSAPSR3700 ONLINE* ONLINE+ /oracle/PRD/sapdata4/sr3700_19/sr3700.data19 2097160192 46 64779 NOLINK FILE 104857600
PSAPSR3USR ONLINE* ONLINE+ /oracle/PRD/sapdata1/sr3usr_1/sr3usr.data1 20979712 40 64776 NOLINK FILE 104857600
PSAPTEMP ONLINE# ONLINE+ /oracle/PRD/sapdata2/temp_1/temp.data1 2097160192 -1 64777 NOLINK FILE 104857600
PSAPUNDO ONLINE- ONLINE+ /oracle/PRD/sapdata3/undo_1/undo.data1 9185533952 2 64778 NOLINK FILE 104857600
SYSAUX ONLINE* ONLINE+ /oracle/PRD/sapdata1/sysaux_1/sysaux.data1 209723392 3 64776 NOLINK FILE 104857600
SYSAUX ONLINE* ONLINE+ /oracle/PRD/sapdata1/sysaux_2/sysaux.data2 209723392 44 64776 NOLINK FILE 104857600
SYSTEM ONLINE* SYSTEM+ /oracle/PRD/sapdata1/system_1/system.data1 838868992 1 64776 NOLINK FILE 104857600
SYSTEM ONLINE* SYSTEM+ /oracle/PRD/sapdata1/system_2/system.data2 838868992 43 64776 NOLINK FILE 104857600
BR0119I Redo log files
File Size Group Device Status Link Type
/oracle/PRD/origlogA/log_g11m1.dbf 52429312 1 64774 INUSE NOLINK FILE
/oracle/PRD/mirrlogA/log_g11m2.dbf 52429312 1 64771 INUSE NOLINK FILE
/oracle/PRD/origlogB/log_g12m1.dbf 52429312 2 64775 INUSE NOLINK FILE
/oracle/PRD/mirrlogB/log_g12m2.dbf 52429312 2 64772 INUSE NOLINK FILE
/oracle/PRD/origlogA/log_g13m1.dbf 52429312 3 64774 INUSE NOLINK FILE
/oracle/PRD/mirrlogA/log_g13m2.dbf 52429312 3 64771 INUSE NOLINK FILE
/oracle/PRD/origlogB/log_g14m1.dbf 52429312 4 64775 INUSE NOLINK FILE
/oracle/PRD/origlogB/log_g14m1.dbf 52429312 4 64775 INUSE NOLINK FILE
/oracle/PRD/mirrlogB/log_g14m2.dbf 52429312 4 64772 INUSE NOLINK FILE
BR0120I Control files
File Size Id. Device Link Type
/oracle/PRD/origlogA/cntrl/cntlrPRD.dbf 24166400 0 64774 NOLINK FILE
/oracle/PRD/origlogB/cntrl/cntrlPRD.dbf 24166400 0 64775 NOLINK FILE
/oracle/PRD/sapdata1/cntrl/cntrlPRD.dbf 24166400 0 64776 NOLINK FILE
BR0280I BRBACKUP time stamp: 2010-10-01 00.00.18
BR0057I Backup of database: PRD
BR0058I BRBACKUP action ID: beefwqqz
BR0059I BRBACKUP function ID: ffd
BR0110I Backup mode: FULL
BR0077I Database files for backup:
/oracle/PRD/origlogA/log_g11m1.dbf
/oracle/PRD/origlogB/log_g12m1.dbf
/oracle/PRD/origlogA/log_g13m1.dbf
/oracle/PRD/origlogB/log_g14m1.dbf
/oracle/PRD/origlogA/cntrl/cntlrPRD.dbf
BR0061I 52 files found for backup, total size 93003.416 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: /mnt/backup/beefwqqz
BR0289I BRARCHIVE will be started at the end of processing
BR0134I Unattended mode with 'force' active - no operator confirmation allowed
BR0370I Directory /mnt/backup/beefwqqz created
BR0202I Saving init_ora
BR0203I to /mnt/backup/PRD ...
BR0278E Command output of 'LANG=C cd /oracle/PRD/102_64/dbs && LANG=C cp initPRD.ora spfilePRD.ora /mnt/backup/PRD':
cp: cannot create regular file `/mnt/backup/PRD/initPRD.ora': Permission denied
cp: cannot create regular file `/mnt/backup/PRD/spfilePRD.ora': Permission denied
BR0280I BRBACKUP time stamp: 2010-10-01 00.00.18
BR0279E Return code from 'LANG=C cd /oracle/PRD/102_64/dbs && LANG=C cp initPRD.ora spfilePRD.ora /mnt/backup/PRD': 1
BR0222E Copying init_ora to/from /mnt/backup/PRD failed due to previous errors
BR0056I End of database backup: beefwqqz.ffd 2010-10-01 00.00.18
BR0280I BRBACKUP time stamp: 2010-10-01 00.00.18
BR0054I BRBACKUP terminated with errors
BR0280I BRBACKUP time stamp: 2010-10-01 00.00.18
BR0291I BRARCHIVE will be started with options '-U -jid FLGOF20101001000000 -d disk -c force -p initPRD.sap -s'
BR0280I BRBACKUP time stamp: 2010-10-01 00.00.24
BR0292I Execution of BRARCHIVE finished with return code 0
>
> I think you have to apply Volker 's idea from above again, this time to /mnt/backup/PRD/initPRD.ora.
>
Are there existing files with the same name from a previuos run with a strange ownership?
... and may be the spfilePRD.ora as well
But before you delete these, list them to find out why the ownership of these files is weird.
Volker
Hi,
I renamed the older files and started the backup - but Full offline failed (archieve log successful).
DB13 log
BR0051I BRBACKUP 7.00 (34)
BR0055I Start of database backup: beegvfsz.ffd 2010-10-06 00.00.33
BR0484I BRBACKUP log file: /oracle/PRD/sapbackup/beegvfsz.ffd
BR0477I Oracle pfile /oracle/PRD/102_64/dbs/initPRD.ora created from spfile /oracle/PRD/102_64/dbs/spfilePRD.ora
BR0101I Parameters
Name Value
oracle_sid PRD
oracle_home /oracle/PRD/102_64
oracle_profile /oracle/PRD/102_64/dbs/initPRD.ora
sapdata_home /oracle/PRD
sap_profile /oracle/PRD/102_64/dbs/initPRD.sap
backup_mode FULL
backup_type offline_force
backup_dev_type disk
backup_root_dir /mnt/backup
compress no
disk_copy_cmd dd
cpio_disk_flags -pdcu
dd_flags obs=64k bs=64k
dd_in_flags ibs=64k bs=64k
exec_parallel 0
system_info prdadm/oraprd ascmprd Linux 2.6.9-67.ELsmp #1 SMP Wed Nov 7 13:56:44 EST 2007 x86_64
oracle_info PRD 10.2.0.2.0 8192 5468 70830455 ascmprd WE8DEC UTF8
sap_info 700 SAPSR3 0002LK0003PRD0011M19918060750015Maintenance_ORA
make_info linuxx86_64 OCI_102 May 30 2008
command_line brbackup -u / -jid FLGOF20101006000000 -c force -t offline_force -m full -p initPRD.sap -a -c force -p initPRD.
BR0116I ARCHIVE LOG LIST before backup for database instance PRD
Parameter Value
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /oracle/PRD/oraarch/PRDarch
Archive format %t_%s_%r.dbf
Oldest online log sequence 5465
Next log sequence to archive 5468
Current log sequence 5468 SCN: 70830455
Database block size 8192 Thread: 1
Current system change number 70831233 ResetId: 652040864
BR0118I Tablespaces and data files
Tablespace TS-Status F-Status File Size Id. Device Link Type MaxSi
PSAPSR3 ONLINE* ONLINE+ /oracle/PRD/sapdata1/sr3_1/sr3.data1 2097160192 4 64776 NOLINK FILE 104857600
PSAPSR3 ONLINE* ONLINE+ /oracle/PRD/sapdata1/sr3_2/sr3.data2 2097160192 5 64776 NOLINK FILE 104857600
PSAPSR3 ONLINE* ONLINE+ /oracle/PRD/sapdata1/sr3_3/sr3.data3 2097160192 6 64776 NOLINK FILE 104857600
PSAPSR3 ONLINE* ONLINE+ /oracle/PRD/sapdata1/sr3_4/sr3.data4 2097160192 7 64776 NOLINK FILE 104857600
PSAPSR3 ONLINE* ONLINE+ /oracle/PRD/sapdata1/sr3_5/sr3.data5 2097160192 8 64776 NOLINK FILE 104857600
PSAPSR3 ONLINE* ONLINE+ /oracle/PRD/sapdata2/sr3_10/sr3.data10 2097160192 13 64777 NOLINK FILE 104857600
PSAPSR3 ONLINE* ONLINE+ /oracle/PRD/sapdata2/sr3_6/sr3.data6 2097160192 9 64777 NOLINK FILE 104857600
PSAPSR3 ONLINE* ONLINE+ /oracle/PRD/sapdata2/sr3_7/sr3.data7 2097160192 10 64777 NOLINK FILE 104857600
PSAPSR3 ONLINE* ONLINE+ /oracle/PRD/sapdata2/sr3_8/sr3.data8 2097160192 11 64777 NOLINK FILE 104857600
PSAPSR3 ONLINE* ONLINE+ /oracle/PRD/sapdata2/sr3_9/sr3.data9 2097160192 12 64777 NOLINK FILE 104857600
PSAPSR3 ONLINE* ONLINE+ /oracle/PRD/sapdata3/sr3_11/sr3.data11 2097160192 14 64778 NOLINK FILE 104857600
PSAPSR3 ONLINE* ONLINE+ /oracle/PRD/sapdata3/sr3_12/sr3.data12 2097160192 15 64778 NOLINK FILE 104857600
PSAPSR3 ONLINE* ONLINE+ /oracle/PRD/sapdata3/sr3_13/sr3.data13 2097160192 16 64778 NOLINK FILE 104857600
PSAPSR3 ONLINE* ONLINE+ /oracle/PRD/sapdata3/sr3_14/sr3.data14 2097160192 17 64778 NOLINK FILE 104857600
PSAPSR3 ONLINE* ONLINE+ /oracle/PRD/sapdata3/sr3_15/sr3.data15 2097160192 18 64778 NOLINK FILE 104857600
PSAPSR3 ONLINE* ONLINE+ /oracle/PRD/sapdata4/sr3_16/sr3.data16 2097160192 19 64779 NOLINK FILE 104857600
PSAPSR3 ONLINE* ONLINE+ /oracle/PRD/sapdata4/sr3_17/sr3.data17 2097160192 20 64779 NOLINK FILE 104857600
PSAPSR3 ONLINE* ONLINE+ /oracle/PRD/sapdata4/sr3_18/sr3.data18 2097160192 21 64779 NOLINK FILE 104857600
PSAPSR3 ONLINE* ONLINE+ /oracle/PRD/sapdata4/sr3_19/sr3.data19 2097160192 22 64779 NOLINK FILE + /oracle/PRD/sapdata2/sr3700_7/sr3700.data7 2097160192 30 64777 NOLINK FILE 104857600
PSAPSR3700 ONLINE* ONLINE+ /oracle/PRD/sapdata2/sr3700_8/sr3700.data8 2097160192 31 64777 NOLINK FILE 104857600
SYSTEM ONLINE* SYSTEM+ /oracle/PRD/sapdata1/system_2/system.data2 838868992 43 64776 NOLINK FILE 104857600
BR0119I Redo log files
File Size Group Device Status Link Type
/oracle/PRD/origlogA/log_g11m1.dbf 52429312 1 64774 INUSE NOLINK FILE
/oracle/PRD/mirrlogA/log_g11m2.dbf 52429312 1 64771 INUSE NOLINK FILE
/oracle/PRD/origlogB/log_g12m1.dbf 52429312 2 64775 INUSE NOLINK FILE
/oracle/PRD/mirrlogB/log_g12m2.dbf 52429312 2 64772 INUSE NOLINK FILE
/oracle/PRD/origlogA/log_g13m1.dbf 52429312 3 64774 INUSE NOLINK FILE
/oracle/PRD/mirrlogA/log_g13m2.dbf 52429312 3 64771 INUSE NOLINK FILE
/oracle/PRD/origlogB/log_g14m1.dbf 52429312 4 64775 INUSE NOLINK FILE
/oracle/PRD/mirrlogB/log_g14m2.dbf 52429312 4 64772 INUSE NOLINK FILE
BR0120I Control files
File Size Id. Device Link Type
/oracle/PRD/origlogA/cntrl/cntlrPRD.dbf 24166400 0 64774 NOLINK FILE
/oracle/PRD/origlogB/cntrl/cntrlPRD.dbf 24166400 0 64775 NOLINK FILE
/oracle/PRD/sapdata1/cntrl/cntrlPRD.dbf 24166400 0 64776 NOLINK FILE
BR0280I BRBACKUP time stamp: 2010-10-06 00.00.34
BR0057I Backup of database: PRD
BR0058I BRBACKUP action ID: beegvfsz
BR0059I BRBACKUP function ID: ffd
BR0110I Backup mode: FULL
BR0077I Database files for backup:
/oracle/PRD/origlogA/log_g11m1.dbf
/oracle/PRD/origlogB/log_g12m1.dbf
/oracle/PRD/origlogA/log_g13m1.dbf
/oracle/PRD/origlogB/log_g14m1.dbf
/oracle/PRD/origlogA/cntrl/cntlrPRD.dbf
BR0061I 52 files found for backup, total size 93003.416 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: /mnt/backup/beegvfsz
BR0289I BRARCHIVE will be started at the end of processing
BR0134I Unattended mode with 'force' active - no operator confirmation allowed
BR0370I Directory /mnt/backup/beegvfsz created
BR0202I Saving init_ora
BR0203I to /mnt/backup/PRD ...
BR0202I Saving /oracle/PRD/102_64/dbs/initPRD.sap
BR0203I to /mnt/backup/PRD ...
BR0280I BRBACKUP time stamp: 2010-10-06 00.00.34
BR0198I Profiles saved successfully
BR0280I BRBACKUP time stamp: 2010-10-06 00.00.34
BR0307I Shutting down database instance PRD ...
BR0280I BRBACKUP time stamp: 2010-10-06 00.02.34
BR0308I Shutdown of database instance PRD successful
BR0202I Saving /oracle/PRD/sapdata1/sr3_1/sr3.data1
BR0203I to /mnt/backup/beegvfsz/sr3.data1 ...
#FILE..... /oracle/PRD/sapdata1/sr3_1/sr3.data1
#SAVED.... /mnt/backup/beegvfsz/sr3.data1 #1/1
BR0280I BRBACKUP time stamp: 2010-10-06 00.05.39
BR0063I 1 of 51 files processed - 2000.008 MB of 92980.369 MB done
BR0204I Percentage done: 2.15%, estimated end time: 3:56
BR0001I *_________________________________________________
BR0202I Saving /oracle/PRD/sapdata1/sr3_2/sr3.data2
BR0203I to /mnt/backup/beegvfsz/sr3.data2 ...
#FILE..... /oracle/PRD/sapdata1/sr3_2/sr3.data2
#SAVED.... /mnt/backup/beegvfsz/sr3.data2 #1/2
BR0280I BRBACKUP time stamp: 2010-10-06 00.07.58
BR0063I 2 of 51 files processed - 4000.016 MB of 92980.369 MB done
BR0204I Percentage done: 4.30%, estimated end time: 2:52
BR0001I **________________________________________________
BR0202I Saving /oracle/PRD/sapdata1/sr3_3/sr3.data3
BR0203I to /mnt/backup/beegvfsz/sr3.data3 ...
#FILE..... /oracle/PRD/sapdata1/sr3_3/sr3.data3
#SAVED.... /mnt/backup/beegvfsz/sr3.data3 #1/3
BR0280I BRBACKUP time stamp: 2010-10-06 00.10.16
BR0063I 3 of 51 files processed - 6000.023 MB of 92980.369 MB done
BR0204I Percentage done: 6.45%, estimated end time: 2:30
BR0001I ***_______________________________________________
BR0202I Saving /oracle/PRD/sapdata1/sr3_4/sr3.data4
BR0203I to /mnt/backup/beegvfsz/sr3.data4 ...
#FILE..... /oracle/PRD/sapdata1/sr3_4/sr3.data4
#SAVED.... /mnt/backup/beegvfsz/sr3.data4 #1/4
BR0280I BRBACKUP time stamp: 2010-10-06 00.12.34
BR0063I 4 of 51 files processed - 8000.031 MB of 92980.369 MB done
BR0204I Percentage done: 8.60%, estimated end time: 2:20
BR0001I ****______________________________________________
BR0202I Saving /oracle/PRD/sapdata1/sr3_5/sr3.data5
#FILE..... /oracle/PRD/sapdata1/system_1/system.data1
#SAVED.... /mnt/backup/beegvfsz/system.data1 #1/46
BR0280I BRBACKUP time stamp: 2010-10-06 01.50.47
BR0063I 46 of 51 files processed - 91980.359 MB of 92980.369 MB done
BR0204I Percentage done: 98.92%, estimated end time: 1:51
BR0001I *************************************************_
BR0202I Saving /oracle/PRD/sapdata1/system_2/system.data2
BR0203I to /mnt/backup/beegvfsz/system.data2 ...
#FILE..... /oracle/PRD/sapdata1/system_2/system.data2
#SAVED.... /mnt/backup/beegvfsz/system.data2 #1/47
BR0280I BRBACKUP time stamp: 2010-10-06 01.51.45
BR0063I 47 of 51 files processed - 92780.367 MB of 92980.369 MB done
BR0204I Percentage done: 99.78%, estimated end time: 1:51
BR0001I **************************************************
BR0202I Saving /oracle/PRD/origlogA/log_g11m1.dbf
BR0203I to /mnt/backup/beegvfsz/log_g11m1.dbf ...
#FILE..... /oracle/PRD/origlogA/log_g11m1.dbf
#SAVED.... /mnt/backup/beegvfsz/log_g11m1.dbf #1/48
BR0280I BRBACKUP time stamp: 2010-10-06 01.51.49
BR0063I 48 of 51 files processed - 92830.368 MB of 92980.369 MB done
BR0204I Percentage done: 99.84%, estimated end time: 1:51
BR0001I **************************************************
BR0202I Saving /oracle/PRD/origlogB/log_g12m1.dbf
BR0203I to /mnt/backup/beegvfsz/log_g12m1.dbf ...
#FILE..... /oracle/PRD/origlogB/log_g12m1.dbf
#SAVED.... /mnt/backup/beegvfsz/log_g12m1.dbf #1/49
BR0280I BRBACKUP time stamp: 2010-10-06 01.51.53
BR0063I 49 of 51 files processed - 92880.368 MB of 92980.369 MB done
BR0204I Percentage done: 99.89%, estimated end time: 1:52
BR0001I **************************************************
BR0202I Saving /oracle/PRD/origlogA/log_g13m1.dbf
BR0203I to /mnt/backup/beegvfsz/log_g13m1.dbf ...
#FILE..... /oracle/PRD/origlogA/log_g13m1.dbf
#SAVED.... /mnt/backup/beegvfsz/log_g13m1.dbf #1/50
BR0280I BRBACKUP time stamp: 2010-10-06 01.51.57
BR0063I 50 of 51 files processed - 92930.369 MB of 92980.369 MB done
BR0204I Percentage done: 99.95%, estimated end time: 1:52
BR0001I **************************************************
BR0202I Saving /oracle/PRD/origlogB/log_g14m1.dbf
BR0203I to /mnt/backup/beegvfsz/log_g14m1.dbf ...
#FILE..... /oracle/PRD/origlogB/log_g14m1.dbf
#SAVED.... /mnt/backup/beegvfsz/log_g14m1.dbf #1/51
BR0280I BRBACKUP time stamp: 2010-10-06 01.52.01
BR0063I 51 of 51 files processed - 92980.369 MB of 92980.369 MB done
BR0204I Percentage done: 100.00%, estimated end time: 1:52
BR0001I **************************************************
BR0280I BRBACKUP time stamp: 2010-10-06 01.52.03
BR0330I Starting and mounting database instance PRD ...
BR0280I BRBACKUP time stamp: 2010-10-06 01.52.11
BR0331I Start and mount of database instance PRD successful
BR0280I BRBACKUP time stamp: 2010-10-06 01.52.11
BR0530I Cataloging backups of all database files...
BR0278E Command output of 'SHELL=/bin/sh /oracle/PRD/102_64/bin/rman nocatalog':
Recovery Manager: Release 10.2.0.2.0 - Production on Wed Oct 6 01:52:11 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
RMAN>
RMAN> connect target *
connected to target database: PRD (DBID=1715704480, not open)
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> 29> 30> 31> 32> 33> 34> 35> 36> 37>
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of catalog command on default channel at 10/06/2010 01:52:13
ORA-19625: error identifying file /mnt/backup/beegvfsz/sr3.data1
ORA-27041: unable to open file
Linux-x86_64 Error: 22: Invalid argument
Additional information: 2
RMAN>
Recovery Manager complete.
BR0280I BRBACKUP time stamp: 2010-10-06 01.52.13
BR0279E Return code from 'SHELL=/bin/sh /oracle/PRD/102_64/bin/rman nocatalog': 1
BR0536E RMAN call for database instance PRD failed
BR0280I BRBACKUP time stamp: 2010-10-06 01.52.13
BR0532E Cataloging backups of all database files failed
BR0280I BRBACKUP time stamp: 2010-10-06 01.52.13
BR0307I Shutting down database instance PRD ...
BR0280I BRBACKUP time stamp: 2010-10-06 01.52.18
BR0308I Shutdown of database instance PRD successful
BR0280I BRBACKUP time stamp: 2010-10-06 01.52.18
BR0304I Starting and opening database instance PRD ...
BR0280I BRBACKUP time stamp: 2010-10-06 01.52.28
BR0305I Start and open of database instance PRD successful
BR0056I End of database backup: beegvfsz.ffd 2010-10-06 01.52.13
BR0280I BRBACKUP time stamp: 2010-10-06 01.52.29
BR0054I BRBACKUP terminated with errors
BR0280I BRBACKUP time stamp: 2010-10-06 01.52.29
BR0291I BRARCHIVE will be started with options '-U -jid FLGOF20101006000000 -d disk -c force -p initPRD.sap -s'
BR0280I BRBACKUP time stamp: 2010-10-06 01.53.45
BR0292I Execution of BRARCHIVE finished with return code 0
Hi
Below is the details
ls -l /mnt/backup/beegvfsz/sr3.data1
[root@nddsprd sr3_1]# ls -l
total 2050016
-rw-r----- 1 oraprd dba 2097160192 Oct 7 12:23 sr3.data1
ls -l /oracle/PRD/sapdata1/sr3_1/sr3.data1
[root@nddsprd beegvfsz]# ls -l /mnt/backup/beegvfsz/sr3.data1
-rwxrwSrwt 1 prdadm dba 2097160192 Oct 6 01:14 /mnt/backup/beegvfsz/sr3.data1
-rwxrwSrwt 1 prdadm dba 2097160192 Oct 6 01:14 /mnt/backup/beegvfsz/sr3.data1
Strange.
I can see two possible issues here:
-rwxrwSrwt
You wrote that is is a mapped Windows drive.
Did someone (perhaps you) play around with Windows permissions or the way how the drive is mounted in Unix?
prdadm
Should be oraprd.
For further testing, what is the output of the following commands:
as user oraprd:
file /mnt/backup/beegvfsz/sr3.data1
as user prdadm:
ls -l `which brbackup`
Well,
the good news is, that obviously the backup runs successfull.
It now just seems that the cataloging fails due to rman not being able to catalog the network file.
Question: Do you use incremental backups ?
If no, change the FULL to ALL (or in DB13 FULL tho WHOLE) -> End of problem
If yes, ... weird! no idea if it is legal to catalog "nfs"ed files.
Volker
EDIT: Any changes to the mount options of the target filesystem?
Mind to show what a simple "mount" says about your nfs mounted target?
Edited by: Volker Borowski on Oct 7, 2010 10:12 PM
Hi,
If it had been working prior.....Has somebody be tinkering with the mounts user policy on the DOMAIN ?
Mark
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
cp: cannot create regular file `/mnt/backup/redologPRD/PRD/spacePRD.log': Permission denied
Please ensure that u have maintained the correct permission (777) for the file system file /mnt/backup/redologPRD/PRD/
Regards,
Varadhu...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
>Please ensure that u have maintained the correct permission (777) for the file system file /mnt/backup/redologPRD/PRD/
Not a good idea and security if you give 777, allow permission which is required. This mean you are giving all access to all OS userIDs. Assign appropriate owner and group and permission rights. If you need more help request your UNIX admin.
Hi,
As mentioned in the log you need to give the write permissions to the directory /mnt/backup/redologPRD/PRD.
Regards,
Rohan.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.