Oracle 11gADG运维文档.docx

张欣

1053

12页

51次

2023-12-15

100墨值下载



常用脚本

 

处理

有

gap

，进一步查询

SQL> select * from v$archive_gap;

THREAD# LOW_SEQUENCE# HIGH_SEQUENCE#

---------- ------------- --------------

1 4233 4233

主库备份备库缺失的归档日志

backup as compressed backupset archivelog sequence between 4233 and

4233 thread 1 format '/picclife/app/oracle/archdg/rman_zyt/arch_%u_%d_%t'

not backed up 22 times;

-rw-r----- 1 oracle oinstall 216009728 Sep 9 11:02

arch_3stclvpf_HRDB_986382127

主库传输归档至备库

scp arch_3stclvpf_HRDB_986382127

root@10.127.133.7:/picclife/app/oracle/archdg/.

修改权限

chown oracle.oinstall arch_3stclvpf_HRDB_986382127

注册备份集：

rman target /

RMAN> catalog start with '/picclife/app/oracle/archdg/';

执行

restore

restore archivelog from sequence 4233 until sequence 4233 thread 1;

确认备库

GAP

消失后，对

zabbixhost

中转服务器的归档文件进行删除

主库的备份归档文件，可以不用清除，因为备份策略的关系，会自动清除多余的备份片

备库端的备份文件，暂时保留



查询主备库延迟情况

set linesize 300

col name for a20

col value for a20

col time_computed for a30

select name,value,unit,time_computed from v$dataguard_stats where name

in ('transport lag','apply lag');



查询备库日志应用情况

alter session set NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS';

select THREAD#,applied,Jrst_time,sequence# from v$archived_log where

Jrst_time > '2017-07-10 07:00:00' and applied='NO' order by Jrst_time;



查询



状态及报错

set linesize 200

col dest_name for a40

select DEST_NAME , STATUS , RECOVERY_MODE from v$archive_dest_status;

select dest_id,error from v$archive_dest;



查询备库进程状态

select process,client_process,sequence#,THREAD#,status,BLOCK#,BLOCKS

from

v$managed_standby;

of 12

100墨值下载

数据库 oracle

关注

评论