This discussion is archived
0 Replies Latest reply: Oct 31, 2013 8:15 AM by GTS (DBA) RSS

ALTER SYSTEM  ARCHIVELOG CURRENT

GTS (DBA) Journeyer
Currently Being Moderated

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