how to change to archive mode?

[Guest]

I wonder how to change to archive mode?

I tried this command
alter system archive log all;
but here is the error:
ORA-00258: manual archiving in NOARCHIVELOG
mode must identify log.

then I stop the database, change pfile : initDD.ora
enable this parameter:
LOG_ARCHIVE_START=TRUE

then restart the database, but I found nothing changed:
select name,log_mode from v$database;

name log_mode
-------------------------------------------------
DD NOARCHIVELOG

I tried the command (...archive log all) and the same error:(ORA-00258)
why?

[Tim...]

Hi.

The first example on this page is how to switch on archivelog in a single node instance:

http://www.oracle-base.com/articles/9i/ ... nRAC9i.php

The rest of the article focusses on doing the same thing in a RAC configuration so ignore that.

Cheers

Tim...

[Guest]

Tim, Thanks very much.
I did it like this:

alter system set log_archive_start=true scope=SPFILE;
shutdown immediate;
startup mount;
archive log start;
alter database archivelog;
alter database open;

but I cann't set parameter log_archive_dest
ORA-32107 failure in updating SPFILE;
ORA-00439 Futures not supported Managed standby

can you tell me why?

btw
I have enabled the parameter in pfile;

[Tim...]

Hi.

Read my article and you'll see it's log_archive_dest_1, not log_archive_dest. The parameter you are using is an old and deprecated way to set the value.

Cheers

Tim...