备库常用命令合集（更新中）

Inkcup

#查看归档执行时间，文件大小
select to_char(first_time,'yyyy-mm-dd hh24'),sum(block_size*blocks)/1024/1024,count(*) from v$archived_Log GROUP by  to_char(first_time,'yyyy-mm-dd hh24') order by 1;

#查看归档任务序列号，归档状态，执行时间
select thread#,sequence#,applied,to_char(first_time,'yyyy-mm-dd hh24:mi:ss') from v$archived_log order by 3;

#查看归档日志文件路径
show parameter log_archive_dest;

#查看备库状态（总）
select name,open_mode,database_role,switchover_status from v$database;

#查看触发器名（是否存在）
select trigger_name from dba_triggers where trigger_name='DG_APPLY_LOG';

#查看触发器内容
select TRIGGER_BODY from  dba_triggers where trigger_name='DG_APPLY_LOG';

#查看备库开启状态
select open_mode from v$database;

#备库应用同步
alter database recover managed standby database using current logfile disconnect from session;

#查看所用补丁状况
select PATCH_ID,PATCH_TYPE,DESCRIPTION,ACTION,ACTION_TIME,STATUS,TARGET_VERSION  from dba_registry_sqlpatch

Inkcup

#查看日志文件位置：
select member from v$logfile;

#查看主库临时文件位置：
select name from v$tempfile;

#查看主库数据文件位置：
select FILE#,NAME from v$datafile;

Inkcup

#查看联机日志文件数量：
select group#, bytes/1024/1024 MB, members FROM v$log;

#查看备用联机日志文件数量：
select group#,bytes/1024/1024MB,status from v$standby_log;

#查看实例名称
ps -ef | grep smon

#检查是否有日志间隔(gap),如果有结果显示，需要从主库手动拷贝缺失的归档日志到备库并注册
SELECT * FROM V$ARCHIVE_GAP;

-- 取消当前恢复进程
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

-- 增加并行度(根据CPU核心数调整，通常2-8)
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE PARALLEL 6 DISCONNECT FROM SESSION;