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