5 Replies Latest reply: May 16, 2012 11:25 PM by sb92075 RSS

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

    937044
      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
          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
            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....
              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
                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
                  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?