Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

oracle logshipping scrit brarchive seems not reading sequence 1000000

hi experts,

My logshipping script is now back to sequence 100000 after archiving file ARC99999. The script encountered an error stating that the suggestion file is ARC00000_. The only file that is in the folder is that file ARC00000 but it seems the script is not reading the file. When I try pasting the next file ARC00001, it prompts with an error that the next redo log should be the sequence 100000 which is ARC00000. I dont really know why it's not reading the file.

thanks in advance!

Former Member
Former Member replied

It seems you have to adjust Oracle parameter log_archive_format for numbers > 99999.

Have a look at SAP Note 490976 - BR013W No offline redo log files found for processing, section 8.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question