Database Administration (MOSC)

MOSC Banner

Enabling archivelog mode question

edited Aug 23, 2013 7:56AM in Database Administration (MOSC) 4 commentsAnswered ✓
I am enabling archivelog mode on one of the databases. My paln is to do the following:

1)shutdown the database

2)startup mount

3)alter database archivelog

4)alter database open

5) shutdown

6) startup

Then I was looking through oracle documentation and found

alter system set log_archive_start=TRUE scope=spfile;

can someone tell me what exactly does it do and whether I need it

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center