Tuesday, July 1, 2014

How to switch/show current log list

C:\Users\rajib.pradhan>SQLPLUS /NOLOG

SQL*Plus: Release 11.2.0.1.0 Production on Wed Jul 2 12:02:23 2014

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

SQL> CONN /AS SYSDBA
Connected.
SQL>
SQL> ARCHIVE LOG LIST
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            D:\app\oradata\ARCHIVE\
Oldest online log sequence     1547
Next log sequence to archive   1549
Current log sequence           1549
SQL>

SQL> ALTER SYSTEM SWITCH LOGFILE;

System altered.

SQL> ARCHIVE LOG LIST
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            D:\app\oradata\ARCHIVE\
Oldest online log sequence     1548
Next log sequence to archive   1550
Current log sequence           1550
SQL> ALTER SYSTEM SWITCH LOGFILE;

System altered.

SQL> ARCHIVE LOG LIST
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            D:\app\oradata\ARCHIVE\
Oldest online log sequence     1549
Next log sequence to archive   1551
Current log sequence           1551
SQL>

No comments:

Post a Comment