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!

recovery datafile

694352Oct 18 2009 — edited Oct 21 2009

Hi

I changed the datafile offline, and the database is noarchivelog mode.

After a few days I want to bring the datafile online.
Since there will be no transactions to this datafile, during recovery oracle only need to update the checkpoint scn of this datafile

Do I need archivelogs in this scenerio inorder to bring the datafile online?

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 18 2009

Added on Oct 18 2009

#general-database-discussions

31 comments

2,275 views