cancel
Showing results for 
Search instead for 
Did you mean: 

Archive log file error

Former Member
0 Kudos

hi

i have take offline back. now i am taking archive log file backup

there is giving error

BR0002I BRARCHIVE 6.40 (34)

BR0006I Start of offline redo log processing: aechsfgv.sve 2010-01-08 15.26.53

BR0477I Oracle pfile D:\ORACLE\HOD\920\database\initHOD.ora created from spfile D:\ORACLE\HOD\920\database\spfi

leHOD.ora

BR0013W No offline redo log files found for processing

BR0007I End of offline redo log processing: aechsfgv.sve 2010-01-08 15.26.56

BR0280I BRARCHIVE time stamp: 2010-01-08 15.26.57

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: 2010-01-08 15.26.57

BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:

Accepted Solutions (1)

Accepted Solutions (1)

peter_dzurov
Contributor
0 Kudos

Don't you have in your oraarch directory some old offline redo log files? Maybe you have used this redo files during DB recovery after system copy...In such case you can delete them. If it is not the case I would check if these offline redo logs are backed up and if these are still needed. Otherwise you can delete them. You won't observe such warning anymore...

Answers (1)

Answers (1)

markus_doehr2
Active Contributor
0 Kudos

> BR0013W No offline redo log files found for processing

So there is not archive log to be backed up.

Markus

Former Member
0 Kudos

In oraarch\

there is showing lots of file

Former Member
0 Kudos

Hello,

Have a look in oraarch if new archivelogs are correctly generated in the directory and if name look like other files.


C:\>SQLPLUS / AS SYSDBA
SQL>alter system switch logfile;

Regards