on 06-12-2009 5:03 PM
When I run brtools or launch an Archivelog backup using DBACOCKPIT the job never finds the archive logs. The logs are in the directory but they are not being found. Any ideals on where to look?
Thanks
Troy
These are the logs from BRTOOLS
BR0291I BRARCHIVE will be started with options '-p initDEV.sap -save_delete -d disk -c -k no -l E'
BR0280I BRTOOLS time stamp: 2009-06-12 10.51.24
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
c
BR0280I BRTOOLS time stamp: 2009-06-12 10.51.25
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...
###############################################################################
BR0002I BRARCHIVE 7.00 (32)
BR0006I Start of offline redo log processing: aeaubcmv.svd 2009-06-12 10.51.25
BR0484I BRARCHIVE log file: e:\oracle\DEV\saparch\aeaubcmv.svd
BR0477I Oracle pfile G:\oracle\DEV\102\database\initDEV.ora created from spfile G:\oracle\DEV\102\database\spfileDEV.ora
BR0013W No offline redo log files found for processing
BR0007I End of offline redo log processing: aeaubcmv.svd 2009-06-12 10.51.31
BR0280I BRARCHIVE time stamp: 2009-06-12 10.51.32
BR0004I BRARCHIVE completed successfully with warnings
###############################################################################
BR0292I Execution of BRARCHIVE finished with return code 1
BR0668I Warnings or errors occurred - you can continue to ignore them or go back to repeat the last action
BR0280I BRTOOLS time stamp: 2009-06-12 10.51.32
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
HI,
Using the summary brarchive log arch<sid>.log, brarchive determines the redo number as of which the system is to save the redo logs. The tool then finds the corresponding files for the offline redo logs in the oraarch directory. This process may fail for different reasons which are mentioned below:
1. Corruption in the arch<sid>.log file
2. Incorrect archiving mode
3. Program error in brarchive
4. Database was reset with RESET LOGS
5. Subdirectory in the saparch directory
6. Other warnings are displayed before BR013W
7. Mixing the archiving process (on the hard disk and on tape)
8. Problem with redo log numbers greater than 99999
9. No redo logs available
Please check SAP Note 490976 (BR013W No offline redo log files found for processing) which tells about the possible causes behind BR013W warning and the solutions for each of them. Your issue must be due to any one of these possible causes.
regards,
Subhajit.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
is archive_mode activated or not?
please share contents from file G:\oracle\DEV\102\database\initDEV.ora
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Archive log mode is active, I should have put in the original post that it is generating logs to the listed directory they just aren't being seen. I have tried changing the directory it log_archive_dest1 points to and so on it does't make a difference. I do not use and initfile I use the spfile structure instead these are the entries for the logs.
*.log_archive_dest=''
*.log_archive_dest_1='location=e:\oracle\dev\saparch\'
*.log_archive_start=TRUE
*.log_buffer=14262784
*.log_checkpoint_interval=0
*.log_checkpoint_timeout=0
*.log_checkpoints_to_alert=TRUE
initfile dump of spfile
Troy.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.