Need to Reset Redo Log Sequence number without restor and recovery
387378Jul 25 2009 — edited Aug 4 2009Hello,
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