oracle logshipping scrit brarchive seems not reading sequence 1000000
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!
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.