Linux - iftop

http://sealmemory.blogspot.tw/2012/10/iftop-linux.html
http://www.ex-parrot.com/~pdw/iftop/
http://www.vpser.net/manage/iftop.html
http://sealmemory.blogspot.tw/2012/10/iftop-linux.html

--安裝

tar zxvf iftop-0.17.tar.gz

cd iftop-0.17

./configure

make

make install

or

yum  install iftop

--執行

# iftop -i eth1 -B





netstat
top

JDE - issue, reserved by xxx

It's the JDE system behavior to provide the application/data consistency. When one session is editing/processing specific data entry, other sessions could not change the same data entry, even using same JDE account. This situation(reserved by xxx) could caused by program design, system operation method or web browser  timeout.

Refer to document: User Record Reservations P00095

VMware - vSphere 相容 CPU 64bit VT

虛擬機器上要裝64-bit os CPU需要兩種支援(下載cpu-z軟體檢測)

1.要支援64位元，如下圖紅框處需顯示「EM64T」

2.若是用虛擬軟體還要支援Virtualization Technology，可如下圖紅框處需顯示「VT-x」

INTEL網站的 CPU 全列表，有沒有支援VT，一目了然。

以下是連結:

http://ark.intel.com/VTList.aspx

windows failed to start. a recent hardware of software changemight be the cause. to fix the problem:
1. insert your windows installation disc and restart you computer.
2. choose your language settings, and then click "next."
3. click "repair your computer."
if you do not have this disc,contact your system administrator or computer manufacturer for assistance.

file"\windows\system32\boot\winload.exe
status:0xc000035a
info:attempting to load a 64-bit application,however this cpu is not compatible with 64-bit mode.

Oracle Linux Support and Oracle VM Support Global Price List

1 Year Support 1
Oracle Linux Network
119.00
System
Oracle Linux Basic Limited
499.00
System
Oracle Linux Basic
1,199.00
System
Oracle Linux Premier Limited
1,399.00
System
Oracle Linux Premier
2,299.00
System


1 Year Support Oracle VM Premier Limited 599.00 System
Oracle VM Premier 1,199.00 System



Oracle Linux Premier Limited and Oracle Linux Basic Limited support services are available only for systems with no more than 2 physical CPUs per system. Where computers are clustered, each system within the cluster must have no more than 2 physical CPUs.
Oracle Linux Premier, Oracle Linux Basic and Oracle Linux Network support services are available for
systems with any number of physical CPUs per system


Oracle VM support services are provided at the support level and for the term defined in your order. When ordering Oracle VM support services you must comply with the following availability rules:
Oracle VM Premier Limited support services are available only for systems with no more than 2 physical
CPUs per system.

Oracle VM - OVM server cannot install on GPT boot partition

某台server之前安裝vSphere 5.5，想要重新安裝Oracle VM 時遇到這個問題 "OVM server cannot install on GPT boot partition"

解決方式如下:
1. Boot up to installation Windows 7/Vista/2008 DVD/CD.
2. Click install but don't follow through.
3. Press SHIFT-F10 to bring up console.
4. Type "diskpart"
5. Once inside diskpart type:
-> list disk (find the one you want to convert)
-> select disk 0 (select the one you want from the list. You can see an asterisk on GPT column)
-> clean
-> exit
6. Reboot your server with OVM disk.

HP Blade Server - C7000 GBE2C network switch vlan configuration with vSphere server

[Main Menu]
info - Information Menu
stats - Statistics Menu
cfg - Configuration Menu
oper - Operations Command Menu
boot - Boot Options Menu
maint - Maintenance Menu
diff - Show pending config changes [global command]
apply - Apply pending config changes [global command]
save - Save updated config to FLASH [global command]
revert - Revert pending or applied changes [global command]
exit - Exit [global command, always available]
>> Main#


/ If placed at the beginning of a command, displays the Main Menu. Otherwise, this is used to separate multiple commands placed on the same line.
diff Shows any pending configuration changes that have not been applied. diff flash displays all pending configuration changes that have been applied but not saved to flash memory (NVRAM), as well as those that have not been applied.
apply Applies pending configuration changes.
save Saves the active configuration to backup, and saves the current configuration as active. save n saves the current configuration as active, without saving the active configuration to backup.
revert Removes changes that have been made, but not applied. revert apply removes all changes that have not been saved.


/cfg
[Configuration Menu]
sys - System-wide Parameter Menu
port - Port Menu
l2 - Layer 2 Menu
l3 - Layer 3 Menu
qos - QOS Menu
acl - Access Control List Menu
rmon - RMON Menu
pmirr - Port Mirroring Menu
ufd - Uplink Failure Detection Menu
dump - Dump current configuration to script file
ptcfg - Backup current configuration to FTP/TFTP server
gtcfg - Restore current configuration from FTP/TFTP server
cur - Display current configuration

Command: /cfg/port <port number>
[Port 1 Menu]
gig - Gig Phy Menu
aclqos - Acl/Qos Configuration Menu
8021ppri - Set default 802.1p priority
pvid - Set default port VLAN id
name - Set port name
rmon - Enable/Disable RMON for port
tag - Enable/disable VLAN tagging for port
tagpvid - Enable/disable tagging on pvid
media - Current media copper/fiber
fiber - Set fiber
copper - Set copper
automedia - Set Auto
brate - Set BroadCast Threshold
mrate - Set MultiCast Threshold
drate - Set Dest. Lookup Fail Threshold
ena - Enable port
dis - Disable port
cur - Display current port configuration


[VLAN 1 Menu]
name - Set VLAN name
stg - Assign VLAN to a Spanning Tree Group
add - Add port to VLAN
rem - Remove port from VLAN
def - Define VLAN as list of ports
ena - Enable VLAN
dis - Disable VLAN
del - Delete VLAN
cur - Display current VLAN configuration

/c/port 5 cur
/c/port 5 tag ena tagpvid dis

/c/l2/vlan 64 add 5
/c/l2/vlan 80 add 5
/c/l2/vlan 172 add 5

diff
apply
save

Oracle DB - 實作 Resize ORL and SRL on Primary and Physical Standby in Dataguard Environment

Primary Database:

sqlplus sys/admin as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Wed Dec 18 02:33:02 2013

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select status,instance_name,DB_UNIQUE_NAME,database_role from v$database,v$Instance;

STATUS
------------------------------------
INSTANCE_NAME
------------------------------------------------
DB_UNIQUE_NAME
--------------------------------------------------------------------------------
DATABASE_ROLE
------------------------------------------------
OPEN
DGTEST
DGTEST_P
PRIMARY

SQL> select group#,sum(bytes/1024/1024)"Size in MB" from v$log group by group#;

    GROUP# Size in MB
---------- ----------
 1   50
 2   50
 3   50

SQL> select group#,sum(bytes/1024/1024)"Size in MB" from v$standby_log group by group#;

    GROUP# Size in MB
---------- ----------
 6   50
 4   50
 5   50
 7   50

Standby Database:

$sqlplus '/ as sysdba'

SQL*Plus: Release 11.2.0.1.0 Production on Wed Dec 18 03:08:15 2013

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select status,instance_name,DB_UNIQUE_NAME,database_role from v$database,v$Instance;

STATUS
------------------------------------
INSTANCE_NAME
------------------------------------------------
DB_UNIQUE_NAME
--------------------------------------------------------------------------------
DATABASE_ROLE
------------------------------------------------
OPEN
DGTEST
DGTEST_S
PHYSICAL STANDBY


SQL> select group#, sum(bytes/1024/1024)"Size in MB" from v$log group by group#;

    GROUP# Size in MB
---------- ----------
 1   50
 2   50
 3   50

SQL> select group#,sum(bytes/1024/1024)"Size in MB" from v$standby_log group by group#;

    GROUP# Size in MB
---------- ----------
 6   50
 4   50
 5   50
 7   50

SQL> show parameter standby_file_management

NAME     TYPE
------------------------------------ ---------------------------------
VALUE
------------------------------
standby_file_management      string
auto
SQL> alter system set standby_file_management=manual;

System altered.

SQL> show parameter standby_file_management

NAME     TYPE
------------------------------------ ---------------------------------
VALUE
------------------------------
standby_file_management      string
MANUAL


On the primary database:
Check the status of the Online Redo Logs and resize them by dropping the INACTIVE redo logs and re-creating them with the new size.
SQL> select group#,status from v$log;

    GROUP# STATUS
---------- ------------------------------------------------
 1 INACTIVE
 2 CURRENT
 3 INACTIVE

SQL> alter database drop logfile group 1;

Database altered.

SQL> alter database add logfile group 1 ('/u01/oracle/oradata/DGTEST/redo01.log') size 25M;
alter database add logfile group 1 ('/u01/oracle/oradata/DGTEST/redo01.log') size 25M
*
ERROR at line 1:
ORA-00301: error in adding log file '/u01/oracle/oradata/DGTEST/redo01.log' -
file cannot be created
ORA-27038: created file already exists
Additional information: 1


SQL> !  rm /u01/oracle/oradata/DGTEST/redo01.log

SQL> alter database add logfile group 1 ('/u01/oracle/oradata/DGTEST/redo01.log') size 25M;

Database altered.

SQL> select group#,status from v$log;

    GROUP# STATUS
---------- ------------------------------------------------
 1 UNUSED
 2 ACTIVE
 3 CURRENT

SQL> alter system checkpoint;

System altered.

SQL> select group#,status from v$log;

    GROUP# STATUS
---------- ------------------------------------------------
 1 UNUSED
 2 INACTIVE
 3 CURRENT

SQL> alter database drop logfile group 2;

Database altered.

SQL> !rm /u01/oracle/oradata/DGTEST/redo02.log

SQL> alter database add logfile group 2 ('/u01/oracle/oradata/DGTEST/redo02.log') size 25M;

Database altered.

SQL> select group#,status from v$log;

    GROUP# STATUS
---------- ------------------------------------------------
 1 UNUSED
 2 UNUSED
 3 CURRENT

SQL> alter system switch logfile;

System altered.

SQL> select group#,status from v$log;

    GROUP# STATUS
---------- ------------------------------------------------
 1 CURRENT
 2 UNUSED
 3 ACTIVE

SQL> alter system checkpoint;

System altered.

SQL> select group#,status from v$log;

    GROUP# STATUS
---------- ------------------------------------------------
 1 CURRENT
 2 UNUSED
 3 INACTIVE

SQL> alter database drop logfile group 3;

Database altered.

SQL>  !rm /u01/oracle/oradata/DGTEST/redo03.log

SQL> alter database add logfile group 3 ('/u01/oracle/oradata/DGTEST/redo03.log') size 25M;

Database altered.

SQL> select group#,sum(bytes/1024/1024)"size in MB" from v$log group by group#;

    GROUP# size in MB
---------- ----------
 1   25
 2   25
 3   25



Moving on to the Standby Redo Logs on the Primary Database:
SQL> select group#,sum(bytes/1024/1024)"size in MB" from v$standby_log group by group#;

    GROUP# size in MB
---------- ----------
 6   50
 4   50
 5   50
 7   50

SQL> select group#,status from v$standby_log;

    GROUP# STATUS
---------- ------------------------------
 4 UNASSIGNED
 5 UNASSIGNED
 6 UNASSIGNED
 7 UNASSIGNED

SQL> alter database drop standby logfile group 4;

Database altered.

SQL> alter database drop standby logfile group 5;

Database altered.

SQL> alter database drop standby logfile group 6;

Database altered.

SQL> alter database drop standby logfile group 7;

Database altered.

SQL> alter database add standby logfile group 4 ('/u01/oracle/oradata/DGTEST/srl0.log') size 25M;
alter database add standby logfile group 5 ('/u01/oracle/oradata/DGTEST/srl1.log') size 25M;
Database altered.

SQL>

Database altered.

SQL> alter database add standby logfile group 6 ('/u01/oracle/oradata/DGTEST/srl2.log') size 25M;

Database altered.

SQL> alter database add standby logfile group 7 ('/u01/oracle/oradata/DGTEST/srl3.log') size 25M;

Database altered.

SQL> select group#,sum(bytes/1024/1024)"size in MB" from v$standby_log group by group#;

    GROUP# size in MB
---------- ----------
         6         25
         4         25
         5         25
         7         25

Moving on to the standby database:

SQL> select group#,status from v$log;

    GROUP# STATUS
---------- ------------------------------------------------
 1 CLEARING_CURRENT
 2 CLEARING
 3 CLEARING

SQL> alter database recover managed standby database cancel;

Database altered.

SQL> select group#,status from v$log;

    GROUP# STATUS
---------- ------------------------------------------------
 1 CLEARING_CURRENT
 2 CLEARING
 3 CLEARING

SQL> alter database clear logfile group 2;

Database altered.

SQL> ^[[A    select group#,status from v$log;

    GROUP# STATUS
---------- ------------------------------------------------
 1 CLEARING_CURRENT
 2 UNUSED
 3 CLEARING

SQL>  alter database drop logfile group 2;

Database altered.

SQL> !rm /u01/oracle/oradata/DGTEST/redo02.log

SQL> alter database add logfile group 2 ('/u01/oracle/oradata/DGTEST/redo02.log') size 25M;

Database altered.

SQL> select group#,status from v$log;

    GROUP# STATUS
---------- ------------------------------------------------
 1 CLEARING_CURRENT
 2 UNUSED
 3 CLEARING

SQL> alter database clear logfile group 3;

Database altered.

SQL> alter database drop logfile group 3;

Database altered.

SQL>  !rm /u01/oracle/oradata/DGTEST/redo03.log

SQL> alter database add logfile group 3 ('/u01/oracle/oradata/DGTEST/redo03.log') size 25M;

Database altered.

SQL> select group#,status from v$log;

    GROUP# STATUS
---------- ------------------------------------------------
 1 CLEARING
 2 CLEARING_CURRENT
 3 UNUSED

SQL> alter database clear logfile group 1;

Database altered.

SQL> alter database drop logfile group 1;

Database altered.

SQL> !rm /u01/oracle/oradata/DGTEST/redo01.log

SQL> alter database add logfile group 1 ('/u01/oracle/oradata/DGTEST/redo01.log') size 25M;

Database altered.

SQL> select group#,sum(bytes/1024/1024)"size in MB" from v$log group by group#;

    GROUP# size in MB
---------- ----------
 1   25
 2   25
 3   25

SQL> select group#,sum(bytes/1024/1024)"size in MB" from v$standby_log group by group#;

    GROUP# size in MB
---------- ----------
 6   50
 4   50
 5   50
 7   50

SQL> select group#,status from v$standby_log;

    GROUP# STATUS
---------- ------------------------------
 4 ACTIVE
 5 UNASSIGNED
 6 UNASSIGNED
 7 UNASSIGNED

SQL> alter database drop standby logfile group 5;

Database altered.

SQL> alter database add standby logfile group 5 ('/u01/oracle/oradata/DGTEST/srl1.log') size 25M;

Database altered.

SQL> alter database drop standby logfile group 6;

Database altered.

SQL> alter database drop standby logfile group 7;

Database altered.

SQL>  alter database add standby logfile group 6 ('/u01/oracle/oradata/DGTEST/srl2.log') size 25M;

Database altered.

SQL> alter database add standby logfile group 7 ('/u01/oracle/oradata/DGTEST/srl3.log') size 25M;

Database altered.

SQL> alter system checkpoint;
alter system checkpoint
             *
ERROR at line 1:
ORA-16000: database open for read-only access


SQL> ALTER DATABASE CLEAR LOGFILE GROUP 4;

Database altered.

SQL> select group#,status from v$standby_log;

    GROUP# STATUS
---------- ------------------------------
 4 UNASSIGNED
 5 UNASSIGNED
 6 UNASSIGNED
 7 UNASSIGNED

SQL>  select group#,status from v$standby_log;

    GROUP# STATUS
---------- ------------------------------
 4 UNASSIGNED
 5 UNASSIGNED
 6 UNASSIGNED
 7 UNASSIGNED

SQL> alter database drop standby logfile group 4;

Database altered.

SQL> alter database add standby logfile group 4 ('/u01/oracle/oradata/DGTEST/srl0.log') size 25M;


Database altered.

SQL>  select group#,status from v$standby_log;

    GROUP# STATUS
---------- ------------------------------
 4 UNASSIGNED
 5 UNASSIGNED
 6 UNASSIGNED
 7 UNASSIGNED

SQL> alter system set standby_file_management=auto;

System altered.

SQL> alter database recover managed standby database disconnect from session using current logfile;
or ALTER DATABASE RECOVER MANAGED STANDBY DATABASE THROUGH ALL SWITCHOVER DISCONNECT USING CURRENT LOGFILE;

Database altered.

SQL> select group#,status from v$standby_log;

    GROUP# STATUS
---------- ------------------------------
         4 ACTIVE
         5 UNASSIGNED
         6 UNASSIGNED
         7 UNASSIGNED

SQL> select process,status,sequence# from v$managed_standby;

PROCESS     STATUS  SEQUENCE#
--------------------------- ------------------------------------ ----------
ARCH    CLOSING      17149
ARCH    CLOSING      17150
ARCH    OPENING      14989
ARCH    CLOSING      17148
RFS    IDLE  0
RFS    IDLE  0
RFS    IDLE      17151
RFS    IDLE  0
MRP0    APPLYING_LOG      17151

9 rows selected.

Primary:

SQL> select max(sequence#) from v$archived_log;

MAX(SEQUENCE#)
--------------
 17150

SQL> alter system switch logfile;

System altered.

SQL> alter system switch logfile;

System altered.

SQL> select max(sequence#) from v$archived_log;

MAX(SEQUENCE#)
--------------
 17152


Standby:
SQL>  select max(sequence#) from v$archived_log where applied='YES';

MAX(SEQUENCE#)
--------------
 17149

SQL> select max(sequence#) from v$archived_log where applied='YES';

MAX(SEQUENCE#)
--------------
 17152


On the 2nd standby database:
$sqlplus '/ as sysdba'

SQL*Plus: Release 11.2.0.1.0 Production on Wed Dec 18 03:08:18 2013

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select status,instance_name,DB_UNIQUE_NAME,database_role from v$database,v$Instance;

STATUS
------------------------------------
INSTANCE_NAME
------------------------------------------------
DB_UNIQUE_NAME
--------------------------------------------------------------------------------
DATABASE_ROLE
------------------------------------------------
OPEN
DGTEST
DGTEST_S_US
PHYSICAL STANDBY


SQL>
SQL> select group#, sum(bytes/1024/1024)"Size in MB" from v$log group by group#;

    GROUP# Size in MB
---------- ----------
 1   50
 2   50
 3   50

SQL> select group#,sum(bytes/1024/1024)"Size in MB" from v$standby_log group by group#;

    GROUP# Size in MB
---------- ----------
 6   50
 4   50
 5   50
 7   50

SQL> show parameter standby_file_management

NAME     TYPE
------------------------------------ ---------------------------------
VALUE
------------------------------
standby_file_management      string
AUTO
SQL> alter system set standby_file_management=manual;

System altered.

SQL> show parameter standby_file_management

NAME     TYPE
------------------------------------ ---------------------------------
VALUE
------------------------------
standby_file_management      string
MANUAL
SQL> select group#,status from v$log;

    GROUP# STATUS
---------- ------------------------------------------------
 1 CLEARING_CURRENT
 2 CLEARING
 3 CLEARING

SQL> alter database recover managed standby database cancel;

Database altered.

SQL> select group#,status from v$log;

    GROUP# STATUS
---------- ------------------------------------------------
 1 CLEARING_CURRENT
 2 CLEARING
 3 CLEARING

SQL> alter database clear logfile group 2;

Database altered.

SQL> select group#,status from v$log;

    GROUP# STATUS
---------- ------------------------------------------------
 1 CLEARING_CURRENT
 2 UNUSED
 3 CLEARING

SQL>  alter database drop logfile group 2;

Database altered.

SQL> !rm /u01/oracle/oradata/DGTEST/redo02.log

SQL> alter database add logfile group 2 ('/u01/oracle/oradata/DGTEST/redo02.log') size 25M;

Database altered.

SQL> select group#,status from v$log;

    GROUP# STATUS
---------- ------------------------------------------------
 1 CLEARING_CURRENT
 2 UNUSED
 3 CLEARING

SQL> alter database clear logfile group 3;

Database altered.

SQL> alter database drop logfile group 3;

Database altered.

SQL>  !rm /u01/oracle/oradata/DGTEST/redo03.log

SQL>
SQL> alter database add logfile group 3 ('/u01/oracle/oradata/DGTEST/redo03.log') size 25M;

Database altered.

SQL> select group#,status from v$log;

    GROUP# STATUS
---------- ------------------------------------------------
 1 CLEARING
 2 CLEARING_CURRENT
 3 UNUSED

SQL> alter database clear logfile group 1;

Database altered.

SQL> alter database drop logfile group 1;

Database altered.

SQL> !rm /u01/oracle/oradata/DGTEST/redo01.log

SQL> alter database add logfile group 1 ('/u01/oracle/oradata/DGTEST/redo01.log') size 25M;

Database altered.

SQL> select group#,sum(bytes/1024/1024)"size in MB" from v$log group by group#;

    GROUP# size in MB
---------- ----------
 1   25
 2   25
 3   25

SQL> select group#,sum(bytes/1024/1024)"size in MB" from v$standby_log group by group#;

    GROUP# size in MB
---------- ----------
 6   50
 4   50
 5   50
 7   50

SQL> select group#,status from v$standby_log;

    GROUP# STATUS
---------- ------------------------------
 4 UNASSIGNED
 5 UNASSIGNED
 6 UNASSIGNED
 7 UNASSIGNED

SQL>  alter database drop standby logfile group 4;

Database altered.

SQL> alter database drop standby logfile group 5;

Database altered.

SQL>  alter database drop standby logfile group 6;

Database altered.

SQL> alter database drop standby logfile group 7;

Database altered.

SQL>  alter database add standby logfile group 4 ('/u01/oracle/oradata/DGTEST/srl0.log') size 25M;

Database altered.

SQL> alter database add standby logfile group 5 ('/u01/oracle/oradata/DGTEST/srl1.log') size 25M;

Database altered.

SQL> alter database add standby logfile group 6 ('/u01/oracle/oradata/DGTEST/srl2.log') size 25M;

Database altered.

SQL> alter database add standby logfile group 7 ('/u01/oracle/oradata/DGTEST/srl3.log') size 25M;

Database altered.

SQL> select group#,sum(bytes/1024/1024)"size in MB" from v$standby_log group by group#;

    GROUP# size in MB
---------- ----------
 6   25
 4   25
 5   25
 7   25

SQL> select group#,status from v$standby_log;

    GROUP# STATUS
---------- ------------------------------
 4 UNASSIGNED
 5 UNASSIGNED
 6 UNASSIGNED
 7 UNASSIGNED

SQL> select group#,sum(bytes/1024/1024)"size in MB" from v$log group by group#;

    GROUP# size in MB
---------- ----------
 1   25
 2   25
 3   25

SQL>
SQL> alter system set standby_file_management=auto;

System altered.

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

Database altered.

SQL> select process,status,sequence# from v$managed_standby;

PROCESS     STATUS  SEQUENCE#
--------------------------- ------------------------------------ ----------
ARCH    CONNECTED  0
ARCH    CONNECTED  0
ARCH    CONNECTED  0
ARCH    CONNECTED  0
RFS    IDLE  0
MRP0    WAIT_FOR_LOG      17151
RFS    IDLE  0
RFS    IDLE  0
RFS    IDLE  0
RFS    IDLE  0
RFS    IDLE  0

PROCESS     STATUS  SEQUENCE#
--------------------------- ------------------------------------ ----------
RFS    IDLE  0
RFS    IDLE  0
RFS    IDLE  0
RFS    IDLE  0
RFS    IDLE  0
RFS    IDLE  0
RFS    IDLE  0
RFS    IDLE  0
RFS    IDLE  0
RFS    IDLE  0
RFS    IDLE  0

PROCESS     STATUS  SEQUENCE#
--------------------------- ------------------------------------ ----------
RFS    IDLE  0
RFS    IDLE  0
RFS    IDLE  0
RFS    IDLE  0
RFS    IDLE  0
RFS    IDLE  0
RFS    IDLE  0
RFS    IDLE  0
RFS    IDLE  0
RFS    IDLE  0
RFS    IDLE  0

PROCESS     STATUS  SEQUENCE#
--------------------------- ------------------------------------ ----------
RFS    IDLE  0
RFS    IDLE  0
RFS    IDLE  0
RFS    IDLE  0
RFS    IDLE  0
RFS    IDLE  0

39 rows selected.

SQL>  select max(sequence#) from v$archived_log where applied='YES';

MAX(SEQUENCE#)
--------------
 17150

SQL> select max(sequence#) from v$archived_log where applied='YES';

MAX(SEQUENCE#)
--------------
 17152