V$ARCHIVED_LOG

[nabaig]

DBA'S

My database and shifted between archivelog and noarchivelog a few times.

I opened the database with resetlogs option to reset the control file with the latest incarnation of the database.

But when I look at the V$ARCHIVED_LOG view, it shows me a list of all the logs that were archived at some point of time and are not available now.

Can anyone tell me what this list is used for and whether the logs listed here are necessary for recovery.

Thanks,
Nizar.

[jmodic]

They are listed there in case you need that information if you wan't to perform a database recovery up to the time prior to resetlogs.

[nabaig]

Jurij,

Thanks for all your replies.

Nizar