how to change to archive mode?

All posts relating to Oracle database administration.

Moderator: Tim...

how to change to archive mode?

Postby Guest » Mon Nov 01, 2004 6:09 pm

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?
Guest
 

RE:how to change to archive mode?

Postby Tim... » Mon Nov 01, 2004 6:09 pm

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...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17935
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

RE:how to change to archive mode?

Postby Guest » Mon Nov 01, 2004 6:09 pm

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;
Guest
 

RE:how to change to archive mode?

Postby Tim... » Mon Nov 01, 2004 6:09 pm

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...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17935
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK


Return to Oracle Database Administration

Who is online

Users browsing this forum: No registered users and 8 guests

cron