on 02-15-2013 7:04 AM
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
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.
Thanks and Regards,
Vimal
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.