oracle - How to connect to a standby database which is in MOUNTED state and know the applied archive log sequence number? -


how connect standby database in mounted state , know applied archive log sequence number?

i want connect database in standby mode , fire select query know archive log number.

connect instance sysdba:

export oracle_sid=*database_name* export oracle_home=/path/to/oracle/home sqlplus / sysdba 

to last log file should able query v$archived_log.

select max(sequence#) v$archived_log 

Comments

Popular posts from this blog

scala - 'wrong top statement declaration' when using slick in IntelliJ -

c# - DevExpress.Wpf.Grid.InfiniteGridSizeException was unhandled -

PySide and Qt Properties: Connecting signals from Python to QML -