Buat Maintenance Oracle
Biar gw nggak lupa untuk maintenance oracle gw :p
Liat LOG
select ‘Last applied : ‘ Logs, to_char(next_time,’DD-MON-YY:HH24:MI:SS’) Time from v$archived_log where sequence# = (select max(sequence#) from v$archived_log where applied=’YES’) union select ‘Last received : ‘ Logs, to_char(next_time,’DD-MON-YY:HH24:MI:SS’) Time from v$archived_log where sequence# = (select max(sequence#) from v$archived_log);
select NAME Name, VALUE Value, UNIT Unit from v$dataguard_stats union select null,null,’ ‘ from dual union select null,null,’Time Computed: ‘||MIN(TIME_COMPUTED) from v$dataguard_stats;
select to_char(max(last_time),’DD-MON-YYYY HH24:MI:SS’) “Redo onsite” from v$standby_log
Liat Status
SELECT PROCESS, STATUS FROM V$MANAGED_STANDBY;
