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