Re: v$archived_log problem after restoring db on a new server

On 4 May 2005 12:31:32 -0700, "crajac66_at_gmail.com" <crajac66_at_gmail.com> wrote:

>Thanks for the feedback. I will recereate the controlfile (i.e. alter
>database backup controlfile to trace) and use the new controlfile to
>clear out the old data from v$archived_log. The old sequence#'s are
>causing some problem's with a backup script that I'm using that query's
>v$archived_log.
>
>Craig Jackson

Repair the cause (ie your script) instead of curing the symptom.

Or better: dump the script and use Rman.

--
Sybrand Bakker, Senior Oracle DBA