Re: Archive log cannot start automatically

In article <TIRh4.197$R2.14480953_at_nr1.ottawa.istar.net>,   "Zhenming" <zmwang_at_maloca.com> wrote:
> After installing the Oracle8i in my Solaris X86 version7, I changed
the
> database running in Archive log mode, I set the parameter
log_archive_start
> = true
> and the other two parameters : log_archive-format, and
log_archive_dest_1.
>
> Then I issued : alter system switch logfile;
> it worked, but when re-issued it again, it didn't work. i checked the
v$log,
> and found that the last log_group was not archived to the detination,
so i
> had to archive it manually by using Archive log all.
>
> i checked the parameters by issuing Show parameter log_archive_start,
it
> showed the value was :true.
>
> I really don't know why it cannot archive a log file automatically, i
have
> done such things in NT, it always works. Is there any way to check an
> auto-archive process to see it works correctly? Any options are
welcome.
>
> Zhenming
>
>

with database shut down:
connect internal
startup mount
alter database archivelog;
alter system archive log start;
alter database open;
archive log list

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Jan 21 2000 - 14:43:17 CST