Skip to Content
avatar image
Former Member

Error While Oracle DB Backup on Tape

Hi All,

We have CRM 7.02 installed on Windows Server 2008 R2 and Oracle 11.2.0.3 DB.

I have configured backup on tape and it is finishing successfully when we are taking only DB backup either Online or Offline.

Now when, we are taking Complete DB backup including redo logs offline or online, it is failing. I can see in DB13 that first part of backup which is DB backup is green status while second part of redo logs backup has finished with errors.

After checking the log files I have found that all the log files has been copied to the tape drive but the backup status is RED. I have also attached backup log file as backup_log.txt to this discussion.

Logs File is as below:

BR0002I BRARCHIVE 7.20 (22)

BR0006I Start of offline redolog processing: aeknpiaw.cds 2013-02-13 02.57.58

BR0484I BRARCHIVE log file: F:\oracle\SID\saparch\aeknpiaw.cds

BR0101I Parameters

Name Value

oracle_sid SID

oracle_home F:\oracle\SID\11203

oracle_profile F:\oracle\SID\11203\database\initSID.ora

sapdata_home F:\oracle\SID

sap_profile F:\oracle\SID\11203\database\initSID.sap

backup_dev_type tape

compress brtools

compress_dir F:\oracle\SID\sapreorg

tape_copy_cmd brtools

tape_block_size 64K

rewind mt -f $ rewind

rewind_offline mt -f $ offline

tape_size 1003896.178 MB

tape_address /dev/nmt0

tape_address_rew /dev/mt0

volume_archive CRMB02

expir_period 7

tape_use_count 100

archive_dupl_del only

system_info SAPServiceSID CRMPRD Windows 6.1 Build 7600 AMD64

oracle_info SID 11.2.0.3.0 8192 4031 45343007 CRMPRD UTF8 UTF8 2014685077 &SID

sap_info 731 SAPSR3 0002LK0003SID0011L03151809160015Maintenance_ORA

make_info NTAMD64 OCI_11201_SHARE Mar 20 2012

command_line D:\usr\sap\SID\SYS\exe\uc\NTAMD64\brarchive.exe +beknpiaw.aft,21080384895,CRMB02,27:7456 -jid ALGOF20130212220000 -d tape -c force -p initSID.sap -cds

BR0017W Offline redolog file 'F:\oracle\SID\oraarch\SIDARCH1_2343_790879061.DBF' not found

BR0017W Offline redolog file 'F:\oracle\SID\oraarch\SIDARCH1_2344_790879061.DBF' not found

BR0017W Offline redolog file 'F:\oracle\SID\oraarch\SIDARCH1_2345_790879061.DBF' not found

BR0017W Offline redolog file 'F:\oracle\SID\oraarch\SIDARCH1_2346_790879061.DBF' not found

BR0017W Offline redolog file 'F:\oracle\SID\oraarch\SIDARCH1_2347_790879061.DBF' not found

BR0017W Offline redolog file 'F:\oracle\SID\oraarch\SIDARCH1_2348_790879061.DBF' not found

BR0017W Offline redolog file 'F:\oracle\SID\oraarch\SIDARCH1_2349_790879061.DBF' not found

BR0017W Offline redolog file 'F:\oracle\SID\oraarch\SIDARCH1_2350_790879061.DBF' not found

BR0017W Offline redolog file 'F:\oracle\SID\oraarch\SIDARCH1_2351_790879061.DBF' not found

BR0017W Offline redolog file 'F:\oracle\SID\oraarch\SIDARCH1_2352_790879061.DBF' not found

.

.

BR0017E Offline redolog file 'F:\oracle\SID\oraarch\SIDARCH1_3738_790879061.DBF' not found

BR0017E Offline redolog file 'F:\oracle\SID\oraarch\SIDARCH1_3739_790879061.DBF' not found

BR0017E Offline redolog file 'F:\oracle\SID\oraarch\SIDARCH1_3740_790879061.DBF' not found

BR0017E Offline redolog file 'F:\oracle\SID\oraarch\SIDARCH1_3741_790879061.DBF' not found

BR0017E Offline redolog file 'F:\oracle\SID\oraarch\SIDARCH1_3742_790879061.DBF' not found

BR0280I BRARCHIVE time stamp: 2013-02-13 02.58.05

BR0008I Offline redolog processing for database instance: SID

BR0009I BRARCHIVE action ID: aeknpiaw

BR0010I BRARCHIVE function ID: cds

BR0048I Archive function: copy_delete_save

BR0011I 288 offline redolog files found for processing, total size 11579.920 MB

BR0111I Files will be compressed by brtools

BR0130I Backup device type: tape

BR0102I Following backup device will be used: /dev/nmt0

BR0103I Following backup volume will be used: CRMB02

BR0290I This run was started by BRBACKUP

BR0134I Unattended mode with 'force' active - no operator confirmation allowed

BR0201I Compressing F:\oracle\SID\oraarch\SIDARCH1_3743_790879061.DBF

BR0203I to F:\oracle\SID\sapreorg\SIDARCH1_3743_790879061.DBF.K ...

BR0202I Saving F:\oracle\SID\sapreorg\SIDARCH1_3743_790879061.DBF.K

BR0203I to /dev/nmt0 ...

#ARCHIVE.. F:\oracle\SID\oraarch\SIDARCH1_3743_790879061.DBF

#SAVED.... SIDARCH1_3743_790879061.DBF.K CRMB02/31 4.1613:1 10648681

BR0280I BRARCHIVE time stamp: 2013-02-13 02.58.22

BR0014I 1 of 288 offline redolog files processed - 42.259 of 11579.920 MB done

BR0204I Percentage done: 0.36%, estimated end time: 4:15

BR0001I __________________________________________________

BR0201I Compressing F:\oracle\SID\oraarch\SIDARCH1_3744_790879061.DBF

BR0203I to F:\oracle\SID\sapreorg\SIDARCH1_3744_790879061.DBF.K ...

BR0202I Saving F:\oracle\SID\sapreorg\SIDARCH1_3744_790879061.DBF.K

BR0203I to /dev/nmt0 ...

.

.

BR0201I Compressing F:\oracle\SID\oraarch\SIDARCH1_4030_790879061.DBF

BR0203I to F:\oracle\SID\sapreorg\SIDARCH1_4030_790879061.DBF.K ...

BR0202I Saving F:\oracle\SID\sapreorg\SIDARCH1_4030_790879061.DBF.K

BR0203I to /dev/nmt0 ...

#ARCHIVE.. F:\oracle\SID\oraarch\SIDARCH1_4030_790879061.DBF

#SAVED.... SIDARCH1_4030_790879061.DBF.K CRMB02/318 3.4534:1 11715880

BR0280I BRARCHIVE time stamp: 2013-02-13 04.17.46

BR0014I 288 of 288 offline redolog files processed - 11579.920 of 11579.920 MB done

BR0204I Percentage done: 100.00%, estimated end time: 4:17

BR0001I **************************************************

BR0280I BRARCHIVE time stamp: 2013-02-13 04.17.46

BR0012I 1 next offline redolog file found for processing, size 41.051 MB

BR0201I Compressing F:\oracle\SID\oraarch\SIDARCH1_4031_790879061.DBF

BR0203I to F:\oracle\SID\sapreorg\SIDARCH1_4031_790879061.DBF.K ...

BR0202I Saving F:\oracle\SID\sapreorg\SIDARCH1_4031_790879061.DBF.K

BR0203I to /dev/nmt0 ...

#ARCHIVE.. F:\oracle\SID\oraarch\SIDARCH1_4031_790879061.DBF

#SAVED.... SIDARCH1_4031_790879061.DBF.K CRMB02/319 2.4143:1 17829027

BR0280I BRARCHIVE time stamp: 2013-02-13 04.18.05

BR0014I 1 of 1 offline redolog file processed - 41.051 of 41.051 MB done

BR0204I Percentage done: 100.00%, estimated end time: 4:18

BR0001I **************************************************

BR0016I 289 offline redolog files processed, total size 11620.971 MB

BR0115I Compression rate for all files 3.3017:1

BR0007I End of offline redolog processing: aeknpiaw.cds 2013-02-13 04.18.05

BR0280I BRARCHIVE time stamp: 2013-02-13 04.18.05

BR0005I BRARCHIVE terminated with errors

Please let us know on how to fix this issue.

Thanks,

Sharib Tasneem

Backup_log.txt.zip (21.5 kB)
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Feb 15, 2013 at 07:13 AM

    HI,

    Please check what is your archive log destination..

    login to sqlplus "/as sysdba"and execute ARCHIVE LOG LIST

    It will give you the current archive location. copy the archive logs to F:\oracle|SID\SIDARCH and try again

    Has anyone changed it?

    If yes, please copy the archive files from that new location to F:\oracle\SID\SIDARCH and try to start the backup ,....

    It will run successfully.

    http://www.databasejournal.com/features/oracle/article.php/3867646/Oracle-Database-Archive-Logging----Where-are-my-archive-logs.htm

    Thanks and Regards,

    Vimal

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 15, 2013 at 07:36 AM

    Imho the log file is self-explaining, if you read it carefully.

    Did you?

    And what makes you think 'that all the log files has been copied to the tape drive' ?

    The brbackup log file is telling you this:

    All the log files from F:\oracle\SID\oraarch\SIDARCH1_3743_790879061.DBF to

    F:\oracle\SID\oraarch\SIDARCH1_4031_790879061.DBF have been copied to the tape drive.

    But brbackup also wanted to save files from

    F:\oracle\SID\oraarch\SIDARCH1_2343_790879061.DBF to

    F:\oracle\SID\oraarch\SIDARCH1_3742_790879061.DBF, but couldn't find them.

    Now it will be your task to find out what happened to those files.

    My guess is that for lack of space someone deleted them, or moved them to a place where brbackup cant find them.

    hope this helps.

    Add comment
    10|10000 characters needed characters exceeded