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!

changing archive log mode without shutting down database

934646Dec 5 2012 — edited Dec 5 2012

Hi all,

Is there any way to set the database to archive log mode before shutting down the database and when the database shuts and starts, the database should be automatically in archive log mode?

because we can not shutdown the database in weekdays and we have system reboot on weekend and we are not here on that day. So is there a way to set the database in archive log at the memory level so that when the database reboots, it should automatically start in archive log mode.

my environment is windows server 2008 R2 with oracle 11.2.0.3

Thanks in advance.

Edited by: 931643 on Dec 5, 2012 10:37 AM

This post has been answered by sb92075 on Dec 5 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 2 2013

Added on Dec 5 2012

#general-database-discussions

7 comments

1,075 views