Re: Archivelog mode question - simple

"steve deno" <sldcrew2k_at_yahoo.com> wrote in message news:8e6b14d8.0205090907.53a562f6_at_posting.google.com...
> Hi all,
>
> When you edit your init file to start archiving, then issue alter
> database archivelog, Will the database automatically archive until
> you change that? Or do you have to do it every time you start up?
>
> Also, I don't find a parameter for telling if it's in archivelogmode
> or not. Do you just have to check the log directory to tell?
>
> Thanks

You confuse
- putting the database in archivelog
- enabling *automatic* archival as opposed to *manual* archiving. In fact you can run the database in archivelog mode with manual archiving but that is usually not an option.

What happens is
- when you issue alter database archivelog, Oracle will archive the online redologs *from that point* until you issue alter database noarchivelog - when you change log_archive_start in init<sid>.ora *automatic* archival will be enabled each time you start the database

To check whether the database is in archivelog mode issue either select * from v$database
or
archive log list

Evidently this is discussed in the Oracle Server Administrators manual, the Backup and Recovery Guide and it *was* discussed on the HJR site.

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address