Re: Difference between "alter database archivelog" and "alter system archive log start"

In article <3584bc52.84488_at_news.mindspring.com>,   robertch_at_mindspring.com wrote:
>
>

{SNIP}
>
> When I tried "alter database archivelog", it changed output in Line
> (1) to "Archive Mode", but it did not have any effect on Line(2). On
> the other hand, "alter system archive log start" changed output in
> Line (2) to "Enabled", but did not have any effect on Line(1). What
> is the difference between these two commands? What the heck is
> happening in the database system level? Thank you very much in
> advance.
>

Hi Robert,

The "ALTER DATABASE ARHIVELOG" switch changes the default setting in the init<orcl>.ora file. To use that to start archiving, you'd have to restart the database. The "ALTER SYSTEM ARCHIVE LOG START" command starts redo log archiving regardless of the setting in the init file. Note that if you are setting up full time archiving, you should also specify "LOG_ARCHIVE_DEST" and "LOG_ARCHIVE_FORMAT" in the init<orcl>.ora file. See the Oracle DBA Handbook 7.3 pp. 535 & 552. for specific 'oraspeak' on this. good luck !!

-Russell Therrien
Information Systems Administrator, DBA
Tracor Systems Technologies
Student Information Systems Project
California, MD (really)

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Wed Jun 17 1998 - 10:28:40 CDT