Re: archival mode

> AFAIK no, since you need to mount the database in exclusive mode to
> issue "ALTER DATABASE archivelog".
>
> Beware: Altering the database is not enough in Oracle. You need to set
> the instance parameter (init.ora) log_archive_start=true. This requires
> a complete shutdown of the instance in 7.3.4.

But you can stop archiving and restart it later w/o shuting down the db.

svrmgrl> archive log stop

or

svrmgrl> archive log start

Regards,

Knut

-- 
Knut Talman                                     Fon +49 30 72 62 01 411
dba_at_myToys.de                                   Fax +49 30 72 62 01 222
          The degree of normality in a database is inversely             
                    proportional to that of its DBA