show parameter dest
 
show parameter log_archive_config
 
select open_mode,protection_mode,database_role,switchover_status from v$database;

set lines 222 pages 100
col error for a20
col gap_status for a20
col dest_name for a20
select dest_id,dest_name,status,type,error,gap_status from v$archive_dest_status where type='PHYSICAL';

GAP_STATUS：
NO GAP：無GAP
LOG SWITCH GAP : 有GAP,日志還沒有切換完成，不需要人工干預(yù)
RESOLVABLE GAP：有GAP,但是可以自動解決，不需要人工干預(yù)
UNRESOLVABLE GAP：有GAP，不能自動解決，需要人工干預(yù)(從主庫SCP歸檔到備庫并重新注冊歸檔恢復(fù))
LOCALLY UNRESOLVABLE GAP：有GAP，不能從本機獲取日志自動解決，可以存其他機器獲取日志自動解決

select thread#,max(sequence#) from gv$archived_log group by thread# order by 1;
tail -1000f alert.log

select status,error,valid_type,valid_role,db_unique_name from v$archive_dest;

set lines 200 pages 100
col name for a100
select name from v$archived_log where thread#=1 and dest_id=1 and sequence# between xxx and xxx;

select thread#,0 not_send_count,not_apply_count
from (select s.thread#,
            s.sequence# - ( select max(s.sequence#) seq
                                from gv$managed_standby i
                                where i.process='ARCH'
                                    and i.thread# = s.thread#) not_apply_count
        from gv$managed_standby s
        where s.process = 'MRP0')
 where not_apply_count >= 0;

with temp as 
 ( select process,thread#,max(sequence#) seq
    from gv$managed_standby
    where process in ('ARCH','LNS')
    group by process,thread#)
select aa.thread#,bb.seq - aa.seq not_send_count,0 not_apply_count
from temp aa.temp bb
where aa.process='ARCH'
    and bb.process='LNS'
    and aa.thread#=bb.thread#
    and bb.seq - aa.seq >= 0
    order by 1;

select dest_id,count(*) from v$archived_log where applied='NO' group by thread#,dest_id order by 1;
select thread#,count(*) from v$archived_log where applied='NO' group by thread#,dest_id order by 1;
select thread#,sequence#,applied from v$archived_log where applied='NO';
 
select thread#,dest_id,to_char(FIRST_TIME,'YYYY-MM-DD HH24:MI:SS'),name,applied,deleted,status from v$archived_log where applied='NO' order by 3;

set lines 222 pages 100
col client_pid for a10
select inst_id,thread#,process,status,client_pid,sequence# from gv$managed_standby;

select logtime,count(*),round(sum(sr)/1024/1024/1024,2) size_gb
 from ( select to_char(first_time,'YYYY-MM-DD') as logtime
            (a.blocks * a.block_size) sz
            from gv$archived_log a
            where a.dest_id = 1 
            and a.first_time > trunc(sysdate - 8))
group by logtime
order by logtime;

alter database recover managed standby database cancel;

alter database recover managed standby database parallel 16 using current logfile disconnect from session;
 
alter database recover managed standby database using current logfile disconnect from session;

1、一般備庫應(yīng)用完歸檔會自動刪除已經(jīng)應(yīng)用的歸檔
2、備庫歸檔不要使用強制刪除(force),如果備庫強制刪除未應(yīng)用的歸檔，此時主庫相應(yīng)的歸檔也會被策略刪除，ADG主備就不可用了
 
select count(*) from v$archive_gap;
select count(*) from v$archived_log where applied='NO';

在主庫操作，將主庫的"log_archive_dest_state_2"設(shè)置為DEFER,停止主庫歸檔向備庫傳輸，可緩解備庫歸檔空間壓力，等備庫歸檔應(yīng)用并自動刪除足夠多時，再將"log_archive_dest_state_2"設(shè)置為enable，開啟主庫對備庫的傳輸
 
show parameter log_archive_dest_state_2
alter system set log_archive_dest_state_2=defer;
alter system set log_archive_dest_state_2=enable;

asmcmd
cd +ARCH/archivelog/2025-01-14/
cp thread_2_seq_458535  /tmp
scp /tmp/thread_2_seq_458535  bakup:/tmp/
 
sqlplus / as sysdba
alter database register logfile '/tmp/thread_2_seq_458535';
#或
rman target /
catalog start with '/tmp/xxxx.dbf'

alter system set "_system_tring_enabled"=FALSE;