Reply from Snowy on Jun 27 at 10:13 AM Hi,
LTO2`s native size is 200GB. if you compress, this could go up to 400GB, but this can be higher or lower.
from your backup log, it stops some time after 193GB was completed.
also investigate if your backup device handles hardware compression. If this is the case, it would be better as this would take out the load off your CPU while the backup is running.
thanks.
| | | ---------------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. __.____._ |   _.____.__ |
