User Tools

Site Tools


oracle:oracle_sql_querys:status_and_configuration

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
oracle:oracle_sql_querys:status_and_configuration [2019/08/28 07:39]
dodger [Parametros]
oracle:oracle_sql_querys:status_and_configuration [2019/08/28 07:44] (current)
dodger
Line 225: Line 225:
 <code sql> <code sql>
 ALTER SYSTEM RESET <PARAMETER_NAME> ; ALTER SYSTEM RESET <PARAMETER_NAME> ;
 +</code>
 +
 +
 +===== Standby redo logs =====
 +This query  will show ''ORL'' for //ONLINE redo logs// and ''SRL'' for //STANDBY redo logs//
 +
 +<code sql>
 +COL member format 150
 +select lf.group#,l_type.log_type as type, lf.member
 +from v$logfile lf
 +join (
 +   select group#,'ORL' as log_type from v$log
 +   union
 +   select group#,'SRL' as log_type from v$standby_log) l_type
 +on lf.group#=l_type.group#
 +order by lf.group#
 +/
 </code> </code>
  
oracle/oracle_sql_querys/status_and_configuration.txt · Last modified: 2019/08/28 07:44 by dodger