Reply from USER_1802800 on Apr 24 at 3:15 AM I assume below. Backup is taken on the tape where tape is not behaving. Please let us know which backup tool is being used I mean backup utility if it is taken by any backup tools check your initsid.utl file. Have you tried it taking any disk back. Please check once by taking disk backup this will make you sure that there is no problem with sap and database.
| | | ---------------Original Message--------------- From: kris_adrianto Sent: Monday, April 23, 2012 11:12 PM Subject: Whole database online + redo log backup failed Dear Experts, Yesterday, whole database online + redo log backup failed on my QA systems. Anybody have an ideo to solve this? Below are the detail log and the bold words are highlighted in red on the detail log. Detail log: beijuqqk.ant BR0051I BRBACKUP 7.00 (52) BR0055I Start of database backup: beijuqqk.ant 2012-04-23 21.00.58 BR0484I BRBACKUP log file: /oracle/BWQ/sapbackup/beijuqqk.ant BR0477I Oracle pfile /oracle/BWQ/102_64/dbs/initBWQ.ora created from spfile /oracle/BWQ/102_64/dbs/spfileBWQ.ora BR0280I BRBACKUP time stamp: 2012-04-23 21.00.59 BR0319I Control file copy created: /oracle/BWQ/sapbackup/cntrlBWQ.dbf 26755072 BR0101I Parameters Name Value oracle_sid BWQ oracle_home /oracle/BWQ/102_64 oracle_profile /oracle/BWQ/102_64/dbs/initBWQ.ora sapdata_home /oracle/BWQ sap_profile /oracle/BWQ/102_64/dbs/initBWQ.sap backup_mode ALL backup_type online backup_dev_type tape_box compress no tape_copy_cmd dd cpio_flags -ovB cpio_in_flags -iuvB dd_flags obs=64k bs=64k dd_in_flags ibs=64k bs=64k rewind mt -f $ rewind rewind_offline mt -f $ offline mount_cmd mount_tape_BWQ.csh $ $ $ dismount_cmd dismount_tape_BWQ.csh $ $ tape_size 1536000.000 MB tape_address /dev/rmt/0mn tape_address_rew /dev/rmt/0m tape_address_ctl /dev/scsi/changer/c3t500104F000C8726Fd0 volume_backup BWQB03 expir_period 0 tape_use_count 100 exec_parallel 0 system_info bwqadm/orabwq aopbwd SunOS 5.10 Generic_141444-09 sun4u oracle_info BWQ 10.2.0.2.0 8192 4174 281406106 aopbwd UTF8 UTF8 sap_info 700 SAPSR3 0002LK0003BWQ0011D18087568750015Maintenance_ORA make_info sun_64 OCI_102 Mar 5 2011 command_line brbackup -u / -jid ALLOG20111010210000 -c force -t online -m all -p initBWQ.sap -v BWQB03 -a -c force -p initBWQ.sap -cds BR0116I ARCHIVE LOG LIST before backup for database instance BWQ Parameter Value Database log mode Archive Mode Automatic archival Enabled Archive destination /oracle/BWQ/oraarch/BWQarch Archive format %t_%s_%r.dbf Oldest online log sequence 4171 Next log sequence to archive 4174 Current log sequence 4174 SCN: 281406106 Database block size 8192 Thread: 1 Current system change number 281426876 ResetId: 762342057 BR0118I Tablespaces and data files Tablespace TS-Status F-Status File Size Id. Device Link Type MaxSize IncrSize BlkSize PSAPSR3 ONLINE* ONLINE+ /oracle/BWQ/sapdata2/sr3_1/sr3.data1 10485768192 4 5570704 NOLINK FILE 10485760000 20971520 8192 PSAPSR3 ONLINE* ONLINE+ /oracle/BWQ/sapdata2/sr3_2/sr3.data2 10485768192 5 5570704 NOLINK FILE 10485760000 20971520 8192 PSAPSR3 ONLINE* ONLINE+ /oracle/BWQ/sapdata2/sr3_3/sr3.data3 10485768192 6 5570704 NOLINK FILE 10485760000 20971520 8192 PSAPSR3 ONLINE* ONLINE+ /oracle/BWQ/sapdata2/sr3_4/sr3.data4 10485768192 7 5570704 NOLINK FILE 10485760000 20971520 8192 PSAPSR3 ONLINE* ONLINE+ /oracle/BWQ/sapdata2/sr3_5/sr3.data5 10485768192 16 5570704 NOLINK FILE 10485760000 20971520 8192 PSAPSR3 ONLINE* ONLINE+ /oracle/BWQ/sapdata2/sr3_6/sr3.data6 10485768192 17 5570704 NOLINK FILE 10485760000 20971520 8192 PSAPSR3 ONLINE* ONLINE+ /oracle/BWQ/sapdata2/sr3_7/sr3.data7 10485768192 18 5570704 NOLINK FILE 10485760000 20971520 8192 PSAPSR3 ONLINE* ONLINE+ /oracle/BWQ/sapdata2/sr3_8/sr3.data8 10485768192 19 5570704 NOLINK FILE 10485760000 20971520 8192 PSAPSR3 ONLINE* ONLINE+ /oracle/BWQ/sapdata3/sr3_9/sr3.data9 10485768192 22 5570705 NOLINK FILE 10485760000 20971520 8192 PSAPSR3 ONLINE* ONLINE+ /oracle/BWQ/sapdata4/sr3_10/sr3.data10 10485768192 24 5570706 NOLINK FILE 10485760000 20971520 8192 PSAPSR3 ONLINE* ONLINE+ /oracle/BWQ/sapdata4/sr3_11/sr3.data11 10485768192 25 5570706 NOLINK FILE 10485760000 20971520 8192 PSAPSR3 ONLINE* ONLINE+ /oracle/BWQ/sapdata4/sr3_12/sr3.data12 10485768192 26 5570706 NOLINK FILE 10485760000 20971520 8192 PSAPSR3 ONLINE* ONLINE+ /oracle/BWQ/sapdata4/sr3_13/sr3.data13 10485768192 27 5570706 NOLINK FILE 10485760000 20971520 8192 PSAPSR3 ONLINE* ONLINE+ /oracle/BWQ/sapdata4/sr3_14/sr3.data14 10485768192 28 5570706 NOLINK FILE 10485760000 20971520 8192 PSAPSR3 ONLINE* ONLINE+ /oracle/BWQ/sapdata5/sr3_15/sr3.data15 10464796672 29 5570707 NOLINK FILE 10485760000 20971520 8192 PSAPSR3 ONLINE* ONLINE+ /oracle/BWQ/sapdata5/sr3_16/sr3.data16 10443825152 30 5570707 NOLINK FILE 10485760000 20971520 8192 PSAPSR3 ONLINE* ONLINE+ /oracle/BWQ/sapdata5/sr3_17/sr3.data17 10485768192 31 5570707 NOLINK FILE 10485760000 20971520 8192 PSAPSR3 ONLINE* ONLINE+ /oracle/BWQ/sapdata5/sr3_18/sr3.data18 10422853632 32 5570707 NOLINK FILE 10485760000 20971520 8192 PSAPSR3 ONLINE* ONLINE+ /oracle/BWQ/sapdata5/sr3_19/sr3.data19 2097160192 33 5570707 NOLINK FILE 10485760000 20971520 8192 PSAPSR3 ONLINE* ONLINE+ /oracle/BWQ/sapdata5/sr3_20/sr3.data20 2097160192 34 5570707 NOLINK FILE 10485760000 20971520 8192 PSAPSR3 ONLINE* ONLINE+ /oracle/BWQ/sapdata5/sr3_21/sr3.data21 2097160192 35 5570707 NOLINK FILE 10485760000 20971520 8192 PSAPSR3700 ONLINE* ONLINE+ /oracle/BWQ/sapdata3/sr3700_1/sr3700.data1 3670024192 8 5570705 NOLINK FILE 10485760000 20971520 8192 PSAPSR3700 ONLINE* ONLINE+ /oracle/BWQ/sapdata3/sr3700_2/sr3700.data2 3565166592 9 5570705 NOLINK FILE 10485760000 20971520 8192 PSAPSR3700 ONLINE* ONLINE+ /oracle/BWQ/sapdata3/sr3700_3/sr3700.data3 3544195072 10 5570705 NOLINK FILE 10485760000 20971520 8192 PSAPSR3700 ONLINE* ONLINE+ /oracle/BWQ/sapdata3/sr3700_4/sr3700.data4 1656758272 11 5570705 NOLINK FILE 10485760000 20971520 8192 PSAPSR3700 ONLINE* ONLINE+ /oracle/BWQ/sapdata3/sr3700_5/sr3700.data5 3300925440 20 5570705 NOLINK FILE 10485760000 20971520 8192 PSAPSR3700 ONLINE* ONLINE+ /oracle/BWQ/sapdata3/sr3700_6/sr3700.data6 3468697600 21 5570705 NOLINK FILE 10485760000 20971520 8192 PSAPSR3DB ONLINE* ONLINE+ /oracle/BWQ/sapdata4/sr3db_1/sr3db.data1 2097160192 13 5570706 NOLINK FILE 10485760000 20971520 8192 PSAPSR3DB ONLINE* ONLINE+ /oracle/BWQ/sapdata4/sr3db_2/sr3db.data2 2097160192 14 5570706 NOLINK FILE 10485760000 20971520 8192 PSAPSR3DB ONLINE* ONLINE+ /oracle/BWQ/sapdata4/sr3db_3/sr3db.data3 1048584192 15 5570706 NOLINK FILE 10485760000 20971520 8192 PSAPSR3USR ONLINE* ONLINE+ /oracle/BWQ/sapdata4/sr3usr_1/sr3usr.data1 587210752 12 5570706 NOLINK FILE 10485760000 20971520 8192 PSAPTEMP ONLINE# ONLINE+ /oracle/BWQ/sapdata2/temp_1/temp.data1 17297317888 -2 5570704 NOLINK FILE 17825792000 20971520 8192 PSAPTEMP ONLINE# ONLINE+ /oracle/BWQ/sapdata4/temp_2/temp.data2 2097160192 -1 5570706 NOLINK FILE 10485760000 20971520 8192 PSAPUNDO ONLINE- ONLINE+ /oracle/BWQ/sapdata1/undo_1/undo.data1 9521078272 2 5570703 NOLINK FILE 10485760000 20971520 8192 PSAPUNDO ONLINE- ONLINE /oracle/BWQ/sapdata1/undo_2/undo.data2 9521078272 23 5570703 NOLINK FILE 0 0 8192 SYSAUX ONLINE* ONLINE+ /oracle/BWQ/sapdata1/sysaux_1/sysaux.data1 335552512 3 5570703 NOLINK FILE 10485760000 20971520 8192 SYSTEM ONLINE* SYSTEM+ /oracle/BWQ/sapdata1/system_1/system.data1 534781952 1 5570703 NOLINK FILE 10485760000 20971520 8192 BR0119I Redo log files File Size Group Device Status Link Type /oracle/BWQ/origlogA/log_g11m1.dbf 314573312 1 5570666 INUSE NOLINK FILE /oracle/BWQ/mirrlogA/log_g11m2.dbf 314573312 1 5570664 INUSE NOLINK FILE /oracle/BWQ/origlogB/log_g12m1.dbf 314573312 2 5570667 INUSE NOLINK FILE /oracle/BWQ/mirrlogB/log_g12m2.dbf 314573312 2 5570665 INUSE NOLINK FILE /oracle/BWQ/origlogA/log_g13m1.dbf 314573312 3 5570666 INUSE NOLINK FILE /oracle/BWQ/mirrlogA/log_g13m2.dbf 314573312 3 5570664 INUSE NOLINK FILE /oracle/BWQ/origlogB/log_g14m1.dbf 314573312 4 5570667 INUSE NOLINK FILE /oracle/BWQ/mirrlogB/log_g14m2.dbf 314573312 4 5570665 INUSE NOLINK FILE BR0120I Control files File Size Id. Device Link Type /oracle/BWQ/origlogA/cntrl/cntrlBWQ.dbf 26755072 0 5570666 NOLINK FILE /oracle/BWQ/origlogB/cntrl/cntrlBWQ.dbf 26755072 0 5570667 NOLINK FILE /oracle/BWQ/sapdata1/cntrl/cntrlBWQ.dbf 26755072 0 5570703 NOLINK FILE BR0616I Tablespaces in table TSORA for SAP owner SAPSR3: PSAPSR3, PSAPSR3700, PSAPSR3USR BR0280I BRBACKUP time stamp: 2012-04-23 21.00.59 BR0057I Backup of database: BWQ BR0058I BRBACKUP action ID: beijuqqk BR0059I BRBACKUP function ID: ant BR0110I Backup mode: ALL BR0077I Database file for backup: /oracle/BWQ/sapbackup/cntrlBWQ.dbf BR0061I 36 files found for backup, total size 228771.789 MB BR0143I Backup type: online BR0112I Files will not be compressed BR0130I Backup device type: tape_box BR0102I Following backup device will be used: /dev/rmt/0mn BR0103I Following backup volume will be used: BWQB03 BR0145I Automatic volume mounting is active BR0289I BRARCHIVE will be started at the end of processing BR0134I Unattended mode with 'force' active - no operator confirmation allowed BR0208I Volume with name BWQB03 required in device /dev/rmt/0mn BR0280I BRBACKUP time stamp: 2012-04-23 21.00.59 BR0388I Mounting volume BWQB03 in device /dev/scsi/changer/c3t500104F000C8726Fd0 ... BR0278E Command output of 'mount_tape_BWQ.csh BWQ-B /dev/scsi/changer/c3t500104F000C8726Fd0 BWQB03': Drive 0 Full (Storage Element 1 loaded) BR0280I BRBACKUP time stamp: 2012-04-23 21.01.01 BR0279E Return code from 'mount_tape_BWQ.csh BWQ-B /dev/scsi/changer/c3t500104F000C8726Fd0 BWQB03': 0 BR0390I Mounting volume BWQB03 in device /dev/scsi/changer/c3t500104F000C8726Fd0 failed BR0056I End of database backup: beijuqqk.ant 2012-04-23 21.01.01 BR0280I BRBACKUP time stamp: 2012-04-23 21.01.01 BR0054I BRBACKUP terminated with errors | | 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. _.____.__ |
No comments:
Post a Comment