解决物理standby 归档日志损坏ORA-00334
分类： Oracle2014-06-28 10:49:07
物理备库归档日志损坏导致mrp进程没有起来，datagurad不同步
standby trace log日志
Errors in file /app//diag/rdbms/crds3dbdg/crds3db/trace/crds3db_pr00_1395.trc (incident=96300):
ORA-00353: 日志损坏接近块 16152 更改 875606062 时间 01/02/2014 13:11:57
'/orasjrz/crds3db/oraarch/2_8556_798146541.arc'
Incident details in: /app/oracle/diag/rdbms/crds3dbdg/crds3db/incident/incdir_96300/crds3db_pr00_1395_i96300.trc
Completed: alter database recover managed standby database using current logfile disconnect
Errors with log /orasjrz/crds3db/oraarch/3_8491_798146541.arc
MRP0: Background Media Recovery terminated with error 354
Errors in file /app/oracle/diag/rdbms/crds3dbdg/crds3db/trace/crds3db_pr00_1395.trc:
ORA-00354: 损坏重做日志块标头
ORA-00353: 日志损坏接近块 16152 更改 875606062 时间 01/02/2014 13:11:57
ORA-00334: 归档日志: '/orasjrz/crds3db/oraarch/2_8556_798146541.arc'
Managed Standby Recovery not using Real Time Apply
Thu Jan 23 10:07:26 2014
Sweep [inc2][96299]: completed
Recovery interrupted!
Thu Jan 23 10:07:26 2014
Sweep [inc][96300]: completed
Thu Jan 23 10:07:26 2014
Dumping diagnostic data in directory=[cdmp_20140123100726], requested by (instance=1, osid=1395 (PR00)), summary=[incident=96300].
Recovered data files to a consistent state at change 875605791
MRP0: Background Media Recovery process shutdown (crds3db)
Thu Jan 23 10:09:09 2014
RFS[23]: Selected log 32 for thread 3 sequence 8941 dbid -1664027027 branch 798146541
Thu Jan 23 10:09:10 2014
Archived Log entry 27271 added for thread 3 sequence 8940 ID 0x9cd0ed6d dest 1:
exit
Thu Jan 23 10:21:23 2014
RFS[24]: Selected log 22 for thread 2 sequence 9076 dbid -1664027027 branch 798146541
Thu Jan 23 10:21:23 2014
Archived Log entry 27272 added for thread 2 sequence 9075 ID 0x9cd0ed6d dest 1:
Thu Jan 23 10:24:59 2014
RAC primary：
把主库归档传到备库
ASMCMD> cp thread_2_seq_8556.13009.835796493 /home/grid/
copying +oraarch/crds3db/archivelog/2014_01_02/thread_2_seq_8556.13009.835796493 -> /home/grid//thread_2_seq_8556.13009.835796493
ASMCMD> exit
[grid@his2 ~]$ cd /home/grid/
[grid@his2 ~]$ ls
cvuqdisk-1.0.9-1.rpm Desktop oradiag_grid thread_2_seq_8556.13009.835796493
[grid@his2 ~]$ exit
logout
[root@his2 ~]# cd /home/grid/
[root@his2 grid]# scp thread_2_seq_8556.13009.835796493 hisdg:/orasjrz/crds3db/oraarch/2_8556_798146541.arc
The authenticity of host 'hisdg (192.168.20.11)' can't be established.
RSA key fingerprint is d5:95:c6:d9:02:45:00:a1:75:ac:84:f9:5a:6a:00:ca.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added 'hisdg,192.168.20.11' (RSA) to the list of known hosts.
password:
thread_2_seq_8556.13009.835796493 100% 11MB 10.6MB/s 00:00
STANDBY DATABASE
SQL> alter database recover managed standby database using current logfile disconnect;
Database altered.
SQL> select process,status,sequence#,thread# from v$managed_standby;
PROCESS STATUS SEQUENCE# THREAD#
——— ———— ———- ———-
ARCH CLOSING 8939 3
ARCH CLOSING 9074 2
ARCH CONNECTED 0 0
ARCH CLOSING 9326 1
RFS IDLE 0 0
RFS IDLE 0 0
RFS IDLE 0 0
RFS IDLE 0 0
RFS IDLE 8940 3
RFS IDLE 0 0
RFS IDLE 0 0
PROCESS STATUS SEQUENCE# THREAD#
——— ———— ———- ———-
RFS IDLE 0 0
RFS IDLE 9075 2
RFS IDLE 0 0
RFS IDLE 0 0
RFS IDLE 9327 1
16 rows selected.
SQL> alter database recover managed standby database using current logfile disconnect;
Database altered.
SQL> select process,status,sequence#,thread# from v$managed_standby;
PROCESS STATUS SEQUENCE# THREAD#
——— ———— ———- ———-
ARCH CLOSING 8939 3
ARCH CLOSING 9074 2
ARCH CONNECTED 0 0
ARCH CLOSING 9326 1
RFS IDLE 0 0
RFS IDLE 0 0
RFS IDLE 0 0
RFS IDLE 0 0
RFS IDLE 8940 3
RFS IDLE 0 0
RFS IDLE 0 0
PROCESS STATUS SEQUENCE# THREAD#
——— ———— ———- ———-
RFS IDLE 0 0
RFS IDLE 9075 2
RFS IDLE 0 0
RFS IDLE 0 0
RFS IDLE 9327 1
16 rows selected.
SQL> alter database recover managed standby database using current logfile disconnect;
Database altered.
SQL> /
Database altered.
STANDBY TRACE LOG 日志分析进程已经正常起来了
alter database recover managed standby database using current logfile disconnect
Attempt to start background Managed Standby Recovery process (crds3db)
Thu Jan 23 10:07:19 2014
MRP0 started with pid=36, OS id=1393
MRP0: Background Managed Standby Recovery process started (crds3db)
started logmerger process
Thu Jan 23 10:07:24 2014
Managed Standby Recovery starting Real Time Apply
Parallel Media Recovery started with 2 slaves
Waiting for all non-current ORLs to be archived…
All non-current ORLs have been archived.
Media Recovery Log /orasjrz/crds3db/oraarch/2_8556_798146541.arc
Media Recovery Log /orasjrz/crds3db/oraarch/1_8776_798146541.arc
Media Recovery Log /orasjrz/crds3db/oraarch/3_8491_798146541.arc
alter database recover managed standby database using current logfile disconnect
Attempt to start background Managed Standby Recovery process (crds3db)
Thu Jan 23 10:24:59 2014
MRP0 started with pid=36, OS id=1525
MRP0: Background Managed Standby Recovery process started (crds3db)
started logmerger process
Thu Jan 23 10:25:04 2014
Managed Standby Recovery starting Real Time Apply
Parallel Media Recovery started with 2 slaves
Waiting for all non-current ORLs to be archived…
All non-current ORLs have been archived.
Media Recovery Log /orasjrz/crds3db/oraarch/2_8556_798146541.arc
Media Recovery Log /orasjrz/crds3db/oraarch/1_8776_798146541.arc
Media Recovery Log /orasjrz/crds3db/oraarch/3_8491_798146541.arc
Completed: alter database recover managed standby database using current logfile disconnect
Thu Jan 23 10:25:37 2014
Media Recovery Log /orasjrz/crds3db/oraarch/3_8492_798146541.arc
Media Recovery Log /orasjrz/crds3db/oraarch/2_8557_798146541.arc
Thu Jan 23 10:25:51 2014
Media Recovery Log /orasjrz/crds3db/oraarch/2_8558_798146541.arc
Media Recovery Log /orasjrz/crds3db/oraarch/1_8777_798146541.arc
Media Recovery Log /orasjrz/crds3db/oraarch/1_8778_798146541.arc
sql>select process,status,sequence#,thread# from v$managed_standby;
PROCESS STATUS SEQUENCE# THREAD#
——— ———— ———- ———-
ARCH CLOSING 9075 2
ARCH CLOSING 9074 2
ARCH CONNECTED 0 0
ARCH CLOSING 8940 3
RFS IDLE 0 0
RFS IDLE 0 0
RFS IDLE 0 0
RFS IDLE 0 0
RFS WRITING 8941 3
RFS IDLE 0 0
RFS IDLE 0 0
PROCESS STATUS SEQUENCE# THREAD#
——— ———— ———- ———-
RFS IDLE 0 0
RFS WRITING 9076 2
RFS IDLE 0 0
RFS IDLE 0 0
RFS WRITING 9327 1
MRP0 APPLYING_LOG 8778 1
17 rows selected.
