This discussion is archived
5 Replies Latest reply: May 16, 2012 9:25 PM by sb92075 RSS

How to enable archivelog mode in 11g on windows 7 os?

937044 Newbie
Currently Being Moderated
Here are the few cmd which i put on sql

SQL> archive log list
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 165
Current log sequence 167

SQL> select name, log_mode from v$database;

NAME LOG_MODE
--------- ------------
TEST NOARCHIVELOG

SQL> show parameter spfile

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string e:\product\11.2.0\dbhome_1\database\spfileorcl.ora



SQL> alter system set log_archive_dest_1='/home/oracle/archivelog' scope=spfile;
alter system set log_archive_dest_1='/home/oracle/archivelog' scope=spfile
*
ERROR at line 1:
ORA-32017: failure in updating SPFILE
ORA-16179: incremental changes to "log_archive_dest_1" not allowed with SPFILE

I faced the above error, thought need to enable archiving first:



SQL> alter system set log_archive_start=TRUE
2 scope=spfile;

System altered.

But I received the error again.

SQL> alter system set log_archive_dest_1='/home/oracle/archivelog' scope=spfile;
alter system set log_archive_dest_1='/home/oracle/archivelog' scope=spfile
*
ERROR at line 1:
ORA-32017: failure in updating SPFILE
ORA-16179: incremental changes to "log_archive_dest_1" not allowed with SPFILE


Can anyone plz let me know

1. how to find the error description bc SQL> !oerr ora 16179 is nt working?

2. where I can find complete format of the parameter?
  • 1. Re: How to enable archivelog mode in 11g on windows 7 os?
    anand prakash - oracle Pro
    Currently Being Moderated
    Hi,

    Can you try --
    alter system set log_archive_dest_1='LOCATION=/home/oracle/archivelog' scope=spfile;
    show parameter log_archive_format
    alter system set log_archive_format='arch_%t_%s_%r.arc' SCOPE=spfile;
    shu immediate
    startup mount
    alter database archivelog
    alter database open
    Read http://docs.oracle.com/cd/E11882_01/server.112/e25494/archredo004.htm#ADMIN11339

    Anand

    Edited by: Anand.. on May 16, 2012 8:30 PM --> Added document link
  • 2. Re: How to enable archivelog mode in 11g on windows 7 os?
    CKPT Guru
    Currently Being Moderated
    1. how to find the error description bc SQL> !oerr ora 16179 is nt working?
    SQL> archive log list
    Database log mode              No Archive Mode
    Automatic archival             Disabled
    Archive destination            USE_DB_RECOVERY_FILE_DEST
    Oldest online log sequence     7
    Current log sequence           9
    
    SQL> alter system set log_archive_dest_1='location=c:\oracle' scope=both;
    
    System altered.
    
    SQL> archive log list
    Database log mode              No Archive Mode
    Automatic archival             Disabled
    Archive destination            c:\oracle
    Oldest online log sequence     7
    Current log sequence           9
    SQL> shut immediate
    Database closed.
    Database dismounted.
    ORACLE instance shut down.
    SQL> startup mount
    ORACLE instance started.
    
    Total System Global Area  778387456 bytes
    Fixed Size                  1374808 bytes
    Variable Size             260048296 bytes
    Database Buffers          511705088 bytes
    Redo Buffers                5259264 bytes
    Database mounted.
    SQL> alter database archivelog;
    
    Database altered.
    
    SQL> alter database open;
    
    Database altered.
    
    SQL> archive log list;
    Database log mode              Archive Mode
    Automatic archival             Enabled
    Archive destination            c:\oracle
    Oldest online log sequence     7
    Next log sequence to archive   9
    Current log sequence           9
    SQL>
    2. where I can find complete format of the parameter?
    SQL> show parameter log_archive_format
    
    NAME                                 TYPE        VALUE
    ------------------------------------ ----------- ------------------------------
    log_archive_format                   string      ARC%S_%R.%T
    SQL>
    you want to keep archive log location other than FRA ? Then you can change it as above.
    If not you just skip the step to change location and enable archivelog mode. That should be fine.

    Edited by: CKPT on May 17, 2012 9:47 AM
  • 3. Re: How to enable archivelog mode in 11g on windows 7 os?
    Aman.... Oracle ACE
    Currently Being Moderated
    But why you want to modify the parameter and enable the archivelog mode? Why not let the archives go into the FRA?

    Aman....
  • 4. Re: How to enable archivelog mode in 11g on windows 7 os?
    937044 Newbie
    Currently Being Moderated
    Now one more problem arise I m trying to throw cmd

    sql>startup mount

    error message appears

    No db available
  • 5. Re: How to enable archivelog mode in 11g on windows 7 os?
    sb92075 Guru
    Currently Being Moderated
    Ricky Sehgal wrote:
    Now one more problem arise I m trying to throw cmd

    sql>startup mount

    error message appears

    No db available
    I do not believe.

    is COPY & PASTE broken for you?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points