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
Post a Comment