0 Replies Latest reply: Oct 31, 2013 10:15 AM by GTS (DBA) RSS

    ALTER SYSTEM  ARCHIVELOG CURRENT

    GTS (DBA)

      Greeting to all ;


      I am trying to froce log switch but i am getting error.

      My db version is 10.2.0.4 on Oracle Linux 5.5.


      SQL> select GROUP# , ARCHIVED , MEMBERS , STATUS , FIRST_CHANGE# from v$LOG;

       

          GROUP# ARC    MEMBERS STATUS          FIRST_CHANGE#

      ---------- --- ---------- --------------- -------------

               1 YES          1 INACTIVE              1499347

               2 NO           1 CURRENT               1499349

               3 YES          1 INACTIVE              1499344

       

       

      SQL> ALTER SYSTEM ARCHIVELOG CURRENT;

      ALTER SYSTEM ARCHIVELOG CURRENT

                   *

      ERROR at line 1:

      ORA-02065: illegal option for ALTER SYSTEM

       

      SOURCE_LINK :  ALTER SYSTEM SWITCH LOGFILE vs ALTER SYSTEM ARCHIVELOG CURRENT

       

      ------

       

      Question 2 :

       

      Each online or archived redo log file is uniquely identified by its log sequence number


      Online redo log  file LSN  and  archived redo log  LSN -  should be  same or  may different ?

       

      For ex : 

      Suppose , online redo logfile  have  bunch of redo entries , - >  when log switch occurs , LSN is created.

      When those entries reaching archive destination    - > does oracle change LSN ?

       

      Thanks ..