Re: Cannot change to ARCHIVELOG mode

From: James Gardner <fromnewsgroup_at_jgdc.co.uk>
Date: Thu, 5 Dec 2002 08:19:19 -0000
Message-ID: <Q1EH9.12601$DI1.1781@news-binary.blueyonder.co.uk>

you also need to update a minimum of 3 init.ora parameters.

log_archive_start=true

log_archive_dest=place you want to store logs

log_archive_format=the naming convention for each log eg <sid>_%s.arch

Once these are change restart the db and check archive log list again.

James

"TK" <tk_tang_at_hotmail.com> wrote in message news:12f54885.0212042217.9e6158d_at_posting.google.com...
> For the ARCserve Oracle backup agent, it needs to operate in ARCHIVELOG
mode but
> I can't success to change it to ARCHIVELOG mode.
>
> I execute the following statement in a shut down oracle server.
> CONNECT INTERNAL
> STARTUP MOUNT EXCLUSIVE
> ALTER DATABASE ARCHIVELOG
> ALTER DATABASE OPEN
> ARCHIVE LOG START
>
> The ARCHIVE LOG LIST shows the database log mode is still in NOARCHIVELOG.
> I can't find any error from ALRT.log.
>
> Do you have any ideas?
>
> My oracle is 8i and ARCserve is 2000.
>
> Regards,
> TK
> Email: tk_tang_at_hotmail.com
Received on Thu Dec 05 2002 - 02:19:19 CST