今天早上一班就发现一DB standby出了问题

查看standby主机各process是否正常时发现MRP不存在.

SQL> alter database recover managed standby database disconnect from session;

SQL> select process, status, sequence# from v$managed_standby;

MRP不能启动

查看alert log发现如下错误

ORA-00332: archived log is too small - may be incompletely archived

ORA-00334: archived log: '/u03/archivelog/$ORACLE_SID/1_21761_665836676.dbf'

standby db 查看1_21761_665836676.dbf的大小

ll -lt -sh 1_21761_665836676.dbf

34M -rw-r----- 1 oracle oinstall 42M Nov 5 07:04 1_21761_665836676.dbf

primary db查看1_21761_665836676.dbf的大小

ll -lt -sh 1_21761_665836676.dbf

42M -rw-r----- 1 oracle oinstall 42M Nov 5 07:12 1_21761_665836676.dbf

将1_21761_665836676.dbf重传到standby主机

scp 1_21761_665836676.dbf 10.182.15.47:/u03/archivelog/fpcsbdb/

再执行alter database recover managed standby database disconnect from session;,一切正常.

这个错误是由于我的疏忽造成,记下来以做为警告.

本来所有的DB都有archive log,backup自动删除的,怕自己时间久了会把基本的命令忘记就取消了.

ITPub博客

ORA-00332: archived log is too small - may be incompletely archived