Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Need to Reset Redo Log Sequence number without restor and recovery

387378Jul 25 2009 — edited Aug 4 2009
Hello,

My mistaken in place of offline redo log destination some of the offline archived redos are not generated or overwrite by old so i am very confused which offline redo logs are useful or not, i can check using diffrent view but i am scarred for future recovery.

Can some one tell me how can we reset log sequence number from 1 again so all old offline archive redo i can remove from our storages and backups.
Our current redo sequence number is around 8009, i want to reset to 1 again.

Thanks in advance.

Regards,
Karmesh Kshatriya
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 1 2009
Added on Jul 25 2009
8 comments
5,955 views