On 11 Jun 2003 07:50:23 -0700, sybrandb_at_yahoo.com wrote:
>Peter <peter_at_nomorenewsspammin.ca> wrote in message news:<1qbkbvs9j86h2lkqh4ph1tfgvof0lat8an_at_4ax.com>...
>> What is the diffence between
>> alter database archivelog;
>> and alter system archive log start?
>>
>> I am not sure when to use which.
>> Thanks
>
>alter database archivelog puts the database in archivelog mode. This
>is NOT possible in an OPEN database.
>Alter system archivelog start enables automatic archival.
>This statement is useless if the database is in noarchivelog mode as
>opposed to noarchivelog mode.
>
This clears up my question. You actually need both. It is mandatory to
change the mode first and then start it with "Alter system archivelog
start"
Received on Wed Jun 11 2003 - 12:22:30 CDT
