Re: Reset Archive Log Sequence

Bun wrote:
<snip>
>
> The archive log sequence number has jumped to 99999 (and the last
> archive log file become "abc99999.arc"). But I found that the archive
> log sequence number cannot jump to 100000 automatically. Now the Oracle
<snip>

This is a wild guess, but try changing the archive log prefix in the init.ora file from 'abc' to 'ab' (or something less than 3 characters). 'abc100000' is > 8 characters so it may be a file system limitation as opposed to an oracle limitation. Did you check the alert.log file for errors? I would think there would be some kind of error message if it couldn't create the archive log file.

If that doesn't work, then it's probably an oracle limit. You can use the alter database open resetlogs command to reset the sequence, but you have to fake media recovery before you can use it. Follow the steps in the manual to do a recover database manual, give it a bogus file name, then CANCEL. You can now do a 'alter database open resetlogs' command. This will take a few minutes as it rewrites the sequence numbers. Be aware that this also invalidates any previous backups. Good Luck.

-- 
---
Allen Kirby			AT&T ITS Production Services
akirby_at_att.com			Alpharetta, GA.