Use full  script    for DR status .!!


Start & Stop  mrp  !!

  ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
  ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION


SELECT ARCH.THREAD# "Thread", ARCH.SEQUENCE# "Last Sequence Received", APPL.SEQUENCE# "Last Sequence Applied", (ARCH.SEQUENCE# - APPL.SEQUENCE#) "Difference"
FROM
(SELECT THREAD# ,SEQUENCE# FROM V$ARCHIVED_LOG WHERE (THREAD#,FIRST_TIME ) IN (SELECT THREAD#,MAX(FIRST_TIME) FROM V$ARCHIVED_LOG GROUP BY THREAD#)) ARCH,
(SELECT THREAD# ,SEQUENCE# FROM V$LOG_HISTORY WHERE (THREAD#,FIRST_TIME ) IN (SELECT THREAD#,MAX(FIRST_TIME) FROM V$LOG_HISTORY GROUP BY THREAD#)) APPL
WHERE
ARCH.THREAD# = APPL.THREAD#
ORDER BY 1;

select process,client_process,status,sequence# from v$managed_standby;

SELECT * FROM ( SELECT NAME,sequence#,thread#, archived, applied,TO_CHAR(first_time, 'RRRR/MM/DD HH24:MI') AS completed   FROM sys.v$archived_log     ORDER BY sequence# DESC)  WHERE ROWNUM <=5;



select thread#,max(sequence#) from v$log_history group by thread#;

select sequence#,to_char(first_time, 'DD-MON-YY HH:MI:SS AM') FROM V$LOG_HISTORY WHERE SEQUENCE# IN ('527735','208560');




===========Incremental backup  script for standby ==================

{
allocate channel ch1 device type disk;
allocate channel ch2 device type disk;
allocate channel ch3 device type disk;
allocate channel ch4 device type disk;
allocate channel ch5 device type disk;
backup as compressed backupset incremental from SCN 16215096501  database format '/backp_location/standby_%U.dbf';
backup current controlfile for standby format ''/backp_location/standbyctl_bkp01.ctl';
}


=======================================================================


DELETE NOPROMPT ARCHIVELOG UNTIL SEQUENCE = 3375
delete archivelog until time 'sysdate-1'
delete archivelog until sequence 37685
crosscheck archivelog all
delete archivelog until time 'sysdate-5'

DELETE NOPROMPT ARCHIVELOG UNTIL SEQUENCE = 33123;.
find *.dbf -mtime 1 -exec ls -ltr  {} \;


=======================================================

select
   name,
   ceil( space_limit / 1024 / 1024) size_mb,
   ceil( space_used / 1024 / 1024) used_mb,
   decode( nvl( space_used, 0),0, 0,
   ceil ( ( space_used / space_limit) * 100) ) pct_used
from
    v$recovery_file_dest
order by
   name desc;
   


========================================================

Comments

Popular posts from this blog

How to check OS inventory