标题: standby端收到了归档日志,但是不自动做Media Recovery [打印本页] 作者: jadesuper 时间: 2010-01-10 15:34 标题: standby端收到了归档日志,但是不自动做Media Recovery 备库上报错:
alter database recover managed standby database disconnect from session
Sun Jan 10 14:03:32 2010
Attempt to start background Managed Standby Recovery process (stdby1)
MRP0 started with pid=29, OS id=17433
Sun Jan 10 14:03:32 2010
MRP0: Background Managed Standby Recovery process started (stdby1)
Sun Jan 10 14:03:37 2010
Managed Standby Recovery not using Real Time Apply
Sun Jan 10 14:03:39 2010
Media Recovery Waiting for thread 2 sequence 13
Fetching gap sequence in thread 2, gap sequence 13-13
FAL[client, MRP0]: Error 1034 fetching archived redo log from PROD
Sun Jan 10 14:03:39 2010
Errors in file /u01/app/oracle/admin/stdby/bdump/stdby1_mrp0_17433.trc:
ORA-01034: ORACLE not available
Sun Jan 10 14:03:39 2010
Completed: alter database recover managed standby database disconnect from session
Sun Jan 10 14:04:09 2010
FAL[client, MRP0]: Error 1034 fetching archived redo log from PROD
Sun Jan 10 14:04:09 2010
Errors in file /u01/app/oracle/admin/stdby/bdump/stdby1_mrp0_17433.trc:
ORA-01034: ORACLE not available
Sun Jan 10 14:04:29 2010
Managed Standby Recovery not using Real Time Apply
Sun Jan 10 14:04:39 2010
FAL[client, MRP0]: Error 1034 fetching archived redo log from PROD
Sun Jan 10 14:04:39 2010
Errors in file /u01/app/oracle/admin/stdby/bdump/stdby1_mrp0_17433.trc:
ORA-01034: ORACLE not available
Sun Jan 10 14:05:10 2010
FAL[client, MRP0]: Error 1034 fetching archived redo log from PROD
Sun Jan 10 14:05:10 2010
Errors in file /u01/app/oracle/admin/stdby/bdump/stdby1_mrp0_17433.trc:
ORA-01034: ORACLE not available
Sun Jan 10 14:05:40 2010
FAL[client, MRP0]: Error 1034 fetching archived redo log from PROD
Sun Jan 10 14:05:40 2010
Errors in file /u01/app/oracle/admin/stdby/bdump/stdby1_mrp0_17433.trc:
ORA-01034: ORACLE not available
Sun Jan 10 14:06:10 2010
FAL[client]: Failed to request gap sequence
GAP - thread 2 sequence 13-13
DBID 118726872 branch 707821078
FAL[client]: All defined FAL servers have been attempted.
-------------------------------------------------------------
Check that the CONTROL_FILE_RECORD_KEEP_TIME initialization
parameter is defined to a value that is sufficiently large
enough to maintain adequate log switch information to resolve
archivelog gaps.
-------------------------------------------------------------
在备库上查看trc文件:
bash-2.04#
bash-2.04#
bash-2.04#
bash-2.04# cat /u01/app/oracle/admin/stdby/bdump/stdby1_mrp0_17433.trc
/u01/app/oracle/admin/stdby/bdump/stdby1_mrp0_17433.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters and Data Mining options
ORACLE_HOME = /u01/app/oracle/db_1
System name: HP-UX
Node name: hp183
Release: B.11.11
Version: U
Machine: 9000/800
Instance name: stdby1
Redo thread mounted by this instance: 1
Oracle process number: 0
Unix process pid: 17433, image: oracle@hp183
Async driver not configured : errno=13
*** SERVICE NAME) 2010-01-10 14:03:32.640
*** SESSION ID140.1) 2010-01-10 14:03:32.640
ARCH: Connecting to console port...
*** 2010-01-10 14:03:32.640 60679 kcrr.c
MRP0: Background Managed Standby Recovery process started
*** 2010-01-10 14:03:37.650 1011 krsm.c
Managed Recovery: Initialization posted.
Recovery target incarnation = 7, activation ID = 119673322
Influx buffer limit = 12480 (50% x 24960)
Start recovery at thread 2 ckpt scn 1291928 logseq 13 block 2
*** 2010-01-10 14:03:39.128
Media Recovery add redo thread 2
*** 2010-01-10 14:03:39.182
Media Recovery add redo thread 1
*** 2010-01-10 14:03:39.185 1011 krsm.c
Managed Recovery: Active posted.
*** 2010-01-10 14:03:39.243 60679 kcrr.c
Media Recovery Waiting for thread 2 sequence 13
*** 2010-01-10 14:03:39.247 60679 kcrr.c
Fetching gap sequence in thread 2, gap sequence 13-13
*** 2010-01-10 14:03:39.431 60679 kcrr.c
FAL[client, MRP0]: Error 1034 fetching archived redo log from PROD
ORA-01034: ORACLE not available
*** 2010-01-10 14:04:09.630
*** 2010-01-10 14:04:09.630 60679 kcrr.c
FAL[client, MRP0]: Error 1034 fetching archived redo log from PROD
ORA-01034: ORACLE not available
*** 2010-01-10 14:04:39.817
*** 2010-01-10 14:04:39.817 60679 kcrr.c
FAL[client, MRP0]: Error 1034 fetching archived redo log from PROD
ORA-01034: ORACLE not available
*** 2010-01-10 14:05:10.011
*** 2010-01-10 14:05:10.011 60679 kcrr.c
FAL[client, MRP0]: Error 1034 fetching archived redo log from PROD
ORA-01034: ORACLE not available
*** 2010-01-10 14:05:40.214
*** 2010-01-10 14:05:40.214 60679 kcrr.c
FAL[client, MRP0]: Error 1034 fetching archived redo log from PROD
ORA-01034: ORACLE not available
*** 2010-01-10 14:06:10.235
-----------------------------------------------------------
Check that the CONTROL_FILE_RECORD_KEEP_TIME initialization
parameter is defined to a value that is sufficiently large
enough to maintain adequate log switch information to resolve
archivelog gaps.
-----------------------------------------------------------
bash-2.04#
再不LAS,可重启主库,再观察LAS。作者: jadesuper 时间: 2010-01-12 13:56
FAL[client]: Failed to request gap sequence
GAP - thread 2 sequence 10-10
DBID 118726872 branch 707938639
FAL[client]: All defined FAL servers have been attempted.
-------------------------------------------------------------
Check that the CONTROL_FILE_RECORD_KEEP_TIME initialization
parameter is defined to a value that is sufficiently large
enough to maintain adequate log switch information to resolve
archivelog gaps.
-------------------------------------------------------------
Mon Jan 11 08:37:50 2010
RFS[3]: Possible network disconnect with primary database
Closing latent archivelog for thread 1 sequence 13
EOF located at block 76 low SCN 0:1334599 next SCN 0:1335845
Latent archivelog '/u01/arch/arch_13_1_707938639.arc'
If you wish to failover to this standby database, you should use the
following command to manually register the archivelog for recovery:
ALTER DATABASE REGISTER LOGFILE '/u01/arch/arch_13_1_707938639.arc';