| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> RE: Archive log cannot start automatically
That 's because you forgot to alter the database to set up the archiving
before restarting. Setting the parameters is not all !
-----Original Message-----
From: rungr_at_my-deja.com [mailto:rungr_at_my-deja.com]
Sent: 21. januar 2000 21:43
To: comp.databases.oracle.server_at_list.deja.com
Subject: Re: Archive log cannot start automatically
Message from the Deja.com forum:
comp.databases.oracle.server
Your subscription is set to individual email delivery
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.
Sent via Deja.com http://www.deja.com/ Before you buy. Received on Thu Jan 27 2000 - 17:37:56 CST
 |
 |