Reply from Snowy on Jun 25 at 10:55 AM Hi,
look at file E:\oracle\PRD\102\database\initprd.sap for parameters.
as stated by David, investigate to compress the backup... unless you are sure that hardware compression is active on the tape device.
you have set tape_size to 409600.000 MB.... which is 400GB.
what is the tape type you are using and tape size?
| | | ---------------Original Message---------------
From: vaibhav tyagi
Sent: Monday, June 23, 2014 12:51 AM
Subject: Offline Backup Terminated On Tape Drive
Detail log: beodflqb.aft
BR0051I BRBACKUP 7.00 (32)
BR0055I Start of database backup: beodflqb.aft 2014-06-23 02.00.29
BR0484I BRBACKUP log file: N:\oracle\PRD\sapbackup\beodflqb.aft
BR0477I Oracle pfile E:\oracle\PRD\102\database\initPRD.ora created from spfile E:\oracle\PRD\102\database\spfilePRD.ora
BR0101I Parameters
Name Value
oracle_sid PRD
oracle_home E:\oracle\PRD\102
oracle_profile E:\oracle\PRD\102\database\initPRD.ora
sapdata_home N:\oracle\PRD
sap_profile E:\oracle\PRD\102\database\initprd.sap
backup_mode ALL
backup_type offline_force
backup_dev_type tape
compress no
tape_copy_cmd dd
cpio_flags -ovB
cpio_in_flags -iuvB
dd_flags bs=64k
dd_in_flags bs=64k
rewind mt -f $ rewind
rewind_offline mt -f $ offline
tape_size 409600.000 MB
tape_address /dev/nmt0
tape_address_rew /dev/mt0
volume_backup PRDB01,PRDB02,PRDB03,PRDB04,PRDB05,PRDB06,PRDB07,P RDB08,PRDB09,PRDB10,
PRDB11,PRDB12,PRDB13,PRDB14,PRDB15,PRDB16,PRDB17,P RDB18,PRDB19,PRDB20,
PRDB21,PRDB22,PRDB23,PRDB24,PRDB25,PRDB26,PRDB27,P RDB28,PRDB29,PRDB30,
PRDB31,PRDB32,PRDB33,PRDB34,PRDB35
expir_period 6
tape_use_count 100
exec_parallel 0
system_info SAPServicePRD KRBLPRD Windows 5.2 Build 3790 Service Pack 1 AMD64
oracle_info PRD 10.2.0.2.0 8192 20731 782785761 KRBLPRD UTF8 UTF8
sap_info 700 SAPSR3 PRD U1634407522 R3_ORA 0020225501
make_info NTAMD64 OCI_10201_SHARE Feb 6 2008
command_line brbackup -u / -jid ALGOF20140620020000 -c force -t offline_force -m all -p initprd.sap -a -c force -p initprd.sap -cds
BR0116I ARCHIVE LOG LIST before backup for database instance PRD
Parameter Value
Database log mode Archive Mode
Automatic archival Enabled
Archive destination J:\oracle\PRD\oraarch\PRDarch
Archive format ARC%S_%R.%T
Oldest online log sequence 20728
Next log sequence to archive 20731
Current log sequence 20731 SCN: 782785761
Database block size 8192 Thread: 1
Current system change number 782801616 ResetId: 785315093
BR0118I Tablespaces and data files
Tablespace TS-Status F-Status File Size Id. Device Link Type MaxSize IncrSize BlkSize
PSAPSR3 ONLINE* ONLINE+ F:\ORACLE\PRD\SAPDATA1\SR3_1\SR3.DATA1 7549755392 4 5 NOLINK FILE 10485760000 20971520 8192
PSAPSR3 ONLINE* ONLINE+ F:\ORACLE\PRD\SAPDATA1\SR3_2\SR3.DATA2 7633641472 5 5 NOLINK FILE 10485760000 20971520 8192
PSAPSR3 ONLINE* ONLINE+ F:\ORACLE\PRD\SAPDATA1\SR3_3\SR3.DATA3 7591698432 6 5 NOLINK FILE 10485760000 20971520 8192
PSAPSR3 ONLINE* ONLINE+ F:\ORACLE\PRD\SAPDATA1\SR3_4\SR3.DATA4 7633641472 7 5 NOLINK FILE 10485760000 20971520 8192
PSAPSR3 ONLINE* ONLINE+ F:\ORACLE\PRD\SAPDATA1\SR3_5\SR3.DATA5 7549755392 8 5 NOLINK FILE 10485760000 20971520 8192
PSAPSR3 ONLINE* ONLINE+ G:\ORACLE\PRD\SAPDATA2\SR3_10\SR3.DATA10 7402954752 13 6 NOLINK FILE 10485760000 20971520 8192
PSAPSR3 ONLINE* ONLINE+ G:\ORACLE\PRD\SAPDATA2\SR3_6\SR3.DATA6 7633641472 9 6 NOLINK FILE 10485760000 20971520 8192
PSAPSR3 ONLINE* ONLINE+ G:\ORACLE\PRD\SAPDATA2\SR3_7\SR3.DATA7 7717527552 10 6 NOLINK FILE 10485760000 20971520 8192
PSAPSR3 ONLINE* ONLINE+ G:\ORACLE\PRD\SAPDATA2\SR3_8\SR3.DATA8 7507812352 11 6 NOLINK FILE 10485760000 20971520 8192
PSAPSR3 ONLINE* ONLINE+ G:\ORACLE\PRD\SAPDATA2\SR3_9\SR3.DATA9 7319068672 12 6 NOLINK FILE 10485760000 20971520 8192
PSAPSR3 ONLINE* ONLINE+ H:\ORACLE\PRD\SAPDATA3\SR3_11\SR3.DATA11 7444897792 14 7 NOLINK FILE 10485760000 20971520 8192
PSAPSR3 ONLINE* ONLINE+ H:\ORACLE\PRD\SAPDATA3\SR3_12\SR3.DATA12 7780442112 15 7 NOLINK FILE 10485760000 20971520 8192
PSAPSR3 ONLINE* ONLINE+ H:\ORACLE\PRD\SAPDATA3\SR3_13\SR3.DATA13 7465869312 16 7 NOLINK FILE 10485760000 20971520 8192
PSAPSR3 ONLINE* ONLINE+ H:\ORACLE\PRD\SAPDATA3\SR3_14\SR3.DATA14 7759470592 17 7 NOLINK FILE 10485760000 20971520 8192
PSAPSR3 ONLINE* ONLINE+ H:\ORACLE\PRD\SAPDATA3\SR3_15\SR3.DATA15 7864328192 18 7 NOLINK FILE 10485760000 20971520 8192
PSAPSR3 ONLINE* ONLINE+ I:\ORACLE\PRD\SAPDATA4\SR3_16\SR3.DATA16 7948214272 19 8 NOLINK FILE 10485760000 20971520 8192
PSAPSR3 ONLINE* ONLINE+ I:\ORACLE\PRD\SAPDATA4\SR3_17\SR3.DATA17 8199872512 20 8 NOLINK FILE 10485760000 20971520 8192
PSAPSR3 ONLINE* ONLINE+ I:\ORACLE\PRD\SAPDATA4\SR3_18\SR3.DATA18 8178900992 21 8 NOLINK FILE 10485760000 20971520 8192
PSAPSR3 ONLINE* ONLINE+ I:\ORACLE\PRD\SAPDATA4\SR3_19\SR3.DATA19 7969185792 22 8 NOLINK FILE 10485760000 20971520 8192
PSAPSR3 ONLINE* ONLINE+ I:\ORACLE\PRD\SAPDATA4\SR3_20\SR3.DATA20 7738499072 23 8 NOLINK FILE 10485760000 20971520 8192
PSAPSR3700 ONLINE* ONLINE+ F:\ORACLE\PRD\SAPDATA1\SR3700_1\SR3700.DATA1 4865400832 24 5 NOLINK FILE 10485760000 20971520 8192
PSAPSR3700 ONLINE* ONLINE+ F:\ORACLE\PRD\SAPDATA1\SR3700_2\SR3700.DATA2 4865400832 25 5 NOLINK FILE 10485760000 20971520 8192
PSAPSR3700 ONLINE* ONLINE+ F:\ORACLE\PRD\SAPDATA1\SR3700_3\SR3700.DATA3 4844429312 26 5 NOLINK FILE 10485760000 20971520 8192
PSAPSR3700 ONLINE* ONLINE+ F:\ORACLE\PRD\SAPDATA1\SR3700_4\SR3700.DATA4 4613742592 27 5 NOLINK FILE 10485760000 20971520 8192
PSAPSR3700 ONLINE* ONLINE+ G:\ORACLE\PRD\SAPDATA2\SR3700_5\SR3700.DATA5 4550828032 28 6 NOLINK FILE 10485760000 20971520 8192
PSAPSR3700 ONLINE* ONLINE+ G:\ORACLE\PRD\SAPDATA2\SR3700_6\SR3700.DATA6 4236255232 29 6 NOLINK FILE 10485760000 20971520 8192
PSAPSR3700 ONLINE* ONLINE+ G:\ORACLE\PRD\SAPDATA2\SR3700_7\SR3700.DATA7 4131397632 30 6 NOLINK FILE 10485760000 20971520 8192
PSAPSR3700 ONLINE* ONLINE+ G:\ORACLE\PRD\SAPDATA2\SR3700_8\SR3700.DATA8 4152369152 31 6 NOLINK FILE 10485760000 20971520 8192
PSAPSR3700 ONLINE* ONLINE+ H:\ORACLE\PRD\SAPDATA3\SR3700_10\SR3700.DATA10 4152369152 33 7 NOLINK FILE 10485760000 20971520 8192
PSAPSR3700 ONLINE* ONLINE+ H:\ORACLE\PRD\SAPDATA3\SR3700_11\SR3700.DATA11 4089454592 34 7 NOLINK FILE 10485760000 20971520 8192
PSAPSR3700 ONLINE* ONLINE+ H:\ORACLE\PRD\SAPDATA3\SR3700_12\SR3700.DATA12 4299169792 35 7 NOLINK FILE 10485760000 20971520 8192
PSAPSR3700 ONLINE* ONLINE+ H:\ORACLE\PRD\SAPDATA3\SR3700_9\SR3700.DATA9 4236255232 32 7 NOLINK FILE 10485760000 20971520 8192
PSAPSR3700 ONLINE* ONLINE+ I:\ORACLE\PRD\SAPDATA4\SR3700_13\SR3700.DATA13 4529856512 36 8 NOLINK FILE 10485760000 20971520 8192
PSAPSR3700 ONLINE* ONLINE+ I:\ORACLE\PRD\SAPDATA4\SR3700_14\SR3700.DATA14 4928315392 37 8 NOLINK FILE 10485760000 20971520 8192
PSAPSR3700 ONLINE* ONLINE+ I:\ORACLE\PRD\SAPDATA4\SR3700_15\SR3700.DATA15 4907343872 38 8 NOLINK FILE 10485760000 20971520 8192
PSAPSR3700 ONLINE* ONLINE+ I:\ORACLE\PRD\SAPDATA4\SR3700_16\SR3700.DATA16 4991229952 39 8 NOLINK FILE 10485760000 20971520 8192
PSAPSR3USR ONLINE* ONLINE+ F:\ORACLE\PRD\SAPDATA1\SR3USR_1\SR3USR.DATA1 83894272 40 5 NOLINK FILE 10485760000 20971520 8192
PSAPTEMP ONLINE# ONLINE G:\ORACLE\PRD\SAPDATA2\TEMP_1\TEMP.DATA1 3145736192 -1 6 NOLINK FILE 0 0 8192
PSAPTEMP ONLINE# ONLINE G:\ORACLE\PRD\SAPDATA2\TEMP_2\TEMP.DATA2 3145736192 -2 6 NOLINK FILE 0 0 8192
PSAPUNDO ONLINE- ONLINE+ H:\ORACLE\PRD\SAPDATA3\UNDO_1\UNDO.DATA1 9751764992 2 7 NOLINK FILE 10485760000 20971520 8192
SYSAUX ONLINE* ONLINE+ F:\ORACLE\PRD\SAPDATA1\SYSAUX_1\SYSAUX.DATA1 398467072 3 5 NOLINK FILE 10485760000 20971520 8192
SYSTEM ONLINE* SYSTEM+ F:\ORACLE\PRD\SAPDATA1\SYSTEM_1\SYSTEM.DATA1 922755072 1 5 NOLINK FILE 10485760000 20971520 8192
BR0119I Redo log files
File Size Group Device Status Link Type
L:\ORACLE\PRD\MIRRLOGA\LOG_G11M2.DBF 52429312 1 11 INUSE NOLINK FILE
K:\ORACLE\PRD\ORIGLOGA\LOG_G11M1.DBF 52429312 1 10 INUSE NOLINK FILE
L:\ORACLE\PRD\MIRRLOGB\LOG_G12M2.DBF 52429312 2 11 INUSE NOLINK FILE
K:\ORACLE\PRD\ORIGLOGB\LOG_G12M1.DBF 52429312 2 10 INUSE NOLINK FILE
L:\ORACLE\PRD\MIRRLOGA\LOG_G13M2.DBF 52429312 3 11 INUSE NOLINK FILE
K:\ORACLE\PRD\ORIGLOGA\LOG_G13M1.DBF 52429312 3 10 INUSE NOLINK FILE
L:\ORACLE\PRD\MIRRLOGB\LOG_G14M2.DBF 52429312 4 11 INUSE NOLINK FILE
K:\ORACLE\PRD\ORIGLOGB\LOG_G14M1.DBF 52429312 4 10 INUSE NOLINK FILE
BR0120I Control files
File Size Id. Device Link Type
K:\oracle\PRD\origlogA\cntrl\cntrlPRD.dbf 26787840 0 10 NOLINK FILE
K:\oracle\PRD\origlogB\cntrl\cntrlPRD.dbf 26787840 0 10 NOLINK FILE
N:\oracle\PRD\sapdata1\cntrl\cntrlPRD.dbf 26787840 0 13 NOLINK FILE
BR0280I BRBACKUP time stamp: 2014-06-23 02.00.30
BR0057I Backup of database: PRD
BR0058I BRBACKUP action ID: beodflqb
BR0059I BRBACKUP function ID: aft
BR0110I Backup mode: ALL
BR0077I Database files for backup:
L:\ORACLE\PRD\MIRRLOGA\LOG_G11M2.DBF
L:\ORACLE\PRD\MIRRLOGB\LOG_G12M2.DBF
L:\ORACLE\PRD\MIRRLOGA\LOG_G13M2.DBF
L:\ORACLE\PRD\MIRRLOGB\LOG_G14M2.DBF
K:\oracle\PRD\origlogA\cntrl\cntrlPRD.dbf
BR0061I 47 files found for backup, total size 232665.877 MB
BR0143I Backup type: offline_force
BR0112I Files will not be compressed
BR0130I Backup device type: tape
BR0102I Following backup device will be used: /dev/nmt0
BR0103I Following backup volume will be used: PRDB11
BR0289I BRARCHIVE will be started at the end of processing
BR0134I Unattended mode with 'force' active - no operator confirmation allowed
BR0208I Volume with name PRDB11 required in device /dev/nmt0
BR0280I BRBACKUP time stamp: 2014-06-23 02.00.30
BR0226I Rewinding tape volume in device /dev/mt0 ...
BR0351I Restoring N:\oracle\PRD\sapbackup\.tape.hdr0
BR0355I from /dev/nmt0 ...
BR0241I Checking label on volume in device /dev/nmt0
BR0242I Scratch volume in device /dev/nmt0 will be renamed to PRDB11
BR0280I BRBACKUP time stamp: 2014-06-23 02.00.30
BR0226I Rewinding tape volume in device /dev/mt0 ...
BR0202I Saving N:\oracle\PRD\sapbackup\.tape.hdr0
BR0203I to /dev/nmt0 ...
BR0209I Volume in device /dev/nmt0 has name PRDB11
BR0202I Saving init_ora
BR0203I to /dev/nmt0 ...
BR0202I Saving E:\oracle\PRD\102\database\initprd.sap
BR0203I to /dev/nmt0 ...
BR0280I BRBACKUP time stamp: 2014-06-23 02.00.45
BR0198I Profiles saved successfully
BR0280I BRBACKUP time stamp: 2014-06-23 02.00.46
BR0307I Shutting down database instance PRD ...
BR0280I BRBACKUP time stamp: 2014-06-23 02.01.12
BR0308I Shutdown of database instance PRD successful
BR0202I Saving F:\ORACLE\PRD\SAPDATA1\SR3_1\SR3.DATA1
BR0203I to /dev/nmt0 ...
#FILE..... F:\ORACLE\PRD\SAPDATA1\SR3_1\SR3.DATA1
#SAVED.... SR3.DATA1 PRDB11/4
BR0280I BRBACKUP time stamp: 2014-06-23 02.06.29
BR0063I 1 of 47 files processed - 7200.008 MB of 232665.877 MB done
BR0204I Percentage done: 3.09%, estimated end time: 5:13
BR0001I ** |
| Reply to this email to post your response. __.____._ | In the Spotlight Become a blogger at Toolbox.com and share your expertise with the community. Start today.   _.____.__ |
