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!

Reusing redo logs for archiving

LauryJul 28 2016 — edited Jul 28 2016

Hi,

Although I never encountered that situation I would like to share the following scenario here.

The database is running in archivelog mode.

At time t1 my database is "hanging" and I cannot perform a logswitch anymore (ansd also not an archive log).

As a work-around, I perform a shutdown abort.

I put the database in noarchivelog mode and open it for normal usage.

I shut it down cleanly and open it in archivelog mode.

I then perform a logswitch.

I didn't clear the log group that was "haging".

Does this mean that the data contained in the redo logs are properly archived and that I can used it in case of recovery?

I do not think so because changing the archiving mode doe invalidate the archives previous the archiving mode.

Is that correct?

Thanks and Regards

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 25 2016
Added on Jul 28 2016
18 comments
475 views