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