Re: Archive log cannot start automatically

Hi folks,

I ran into a similar problem with Solaris v2.6 & Oracle 8.0.5......

An offline backup process had a well-hidden step to force the database down (shutdown abort) if the database didn't come down quietly with shutdown immediate.

upon restart, the ARCH process would NOT start..... By turning off the automatic archiving (and I temporarily took the system out of archivelog to prevent hanging when if uses all its logs), the system would come up quickly, etc.

There's obviously a reason why this is occurring, but it's just not clicking with me tonight....

ALL help is greatly appreciated.

john

Frederic Bidon wrote:

> 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.
>
> _____________________________________________________________
> Deja.com: Before you buy.
> http://www.deja.com/
> * To modify or remove your subscription, go to
> http://www.deja.com/edit_sub.xp?group=comp.databases.oracle.server
> * Read this thread at
> http://www.deja.com/thread/%3C86agd1%24j6f%241%40nnrp1.deja.com%3E
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Sun Feb 13 2000 - 02:47:37 CST