Skip to Content
Former Member
Oct 20, 2009 at 04:23 PM

Change from noarchive mode to archive mode


Hello Gurus,

I want to change my database mode to archive mode in one of my systems.

I am not sure about which procedure to follow....which is the safest to follow.

Through sql :

Shutdown databse

sql> startup mount;

sql> alter database archivelog;

sql> alter database open;

OR sould I use BRTOOLS for this work?

Which is the best approch to do this change and also can u pls tell me the brtools steps?

Thanks in advance!!