Monthly Archives: 七月 2013

逻辑dataguard 异常关机数据不同步

0

Posted on by

昨天晚上机器异常关闭,导致今天逻辑dataguard 起来的时候报错,

后台日志报错,每一秒报一次。

LOGMINER: krvxpsr summary for session# = 1 
LOGMINER: StartScn: 0 (0x0000.00000000) 
LOGMINER: EndScn: 0 (0x0000.00000000) 
LOGMINER: HighConsumedScn: 2330791977 (0x0000.8aed1029) 
LOGMINER: session_flag 0x1
Mon Jul 15 11:05:18 CST 2013
LOGMINER: krvxpsr summary for session# = 1 
LOGMINER: StartScn: 0 (0x0000.00000000) 
LOGMINER: EndScn: 0 (0x0000.00000000) 
LOGMINER: HighConsumedScn: 2330791977 (0x0000.8aed1029) 
LOGMINER: session_flag 0x1
Mon Jul 15 11:05:19 CST 2013
LOGMINER: krvxpsr summary for session# = 1 
LOGMINER: StartScn: 0 (0x0000.00000000) 
LOGMINER: EndScn: 0 (0x0000.00000000) 
LOGMINER: HighConsumedScn: 2330791977 (0x0000.8aed1029) 
LOGMINER: session_flag 0x1
Mon Jul 15 11:05:20 CST 2013
LOGMINER: krvxpsr summary for session# = 1 
LOGMINER: StartScn: 0 (0x0000.00000000) 
LOGMINER: EndScn: 0 (0x0000.00000000) 
LOGMINER: HighConsumedScn: 2330791977 (0x0000.8aed1029) 
LOGMINER: session_flag 0x1

 

v$logstdby_process 内容为:

逻辑dataguard 异常关机数据不同步

 

发现缺少几个归档文件,但是打开库的几个归档都RFS过来了,就当中少了几个。

逻辑dataguard 异常关机数据不同步2

 

就把其中的几个缺失的几个归档拷贝到逻辑库上,注册进去:

ALTER DATABASE REGISTER LOGICAL LOGFILE '/home/oracle/arch_bak/thread_1_seq_2622.536.820804115';
ALTER DATABASE REGISTER LOGICAL LOGFILE '/home/oracle/arch_bak/thread_1_seq_2623.469.820807813';
ALTER DATABASE REGISTER LOGICAL LOGFILE '/home/oracle/arch_bak/thread_1_seq_2624.525.820807827';
ALTER DATABASE REGISTER LOGICAL LOGFILE '/home/oracle/arch_bak/thread_1_seq_2625.369.820832333';
ALTER DATABASE REGISTER LOGICAL LOGFILE '/home/oracle/arch_bak/thread_1_seq_2626.333.820839197';


ALTER DATABASE REGISTER LOGICAL LOGFILE '/home/oracle/arch_bak/thread_2_seq_1982.465.820807813';
ALTER DATABASE REGISTER LOGICAL LOGFILE '/home/oracle/arch_bak/thread_2_seq_1983.320.820807827';
ALTER DATABASE REGISTER LOGICAL LOGFILE '/home/oracle/arch_bak/thread_2_seq_1984.398.820839197';
ALTER DATABASE REGISTER LOGICAL LOGFILE '/home/oracle/arch_bak/thread_2_seq_1985.341.820839247';

然后apply数据库

alter database start logical standby apply immediate; 

看后台日志apply成功

Mon Jul 15 13:16:21 CST 2013
LOGMINER: End mining logfile: /home/oracle/arch_bak/thread_1_seq_2622.536.820804115
Mon Jul 15 13:16:22 CST 2013
LOGMINER: Begin mining logfile for session 1 thread 1 sequence 2623, /home/oracle/arch_bak/thread_1_seq_2623.469.820807813
Mon Jul 15 13:17:46 CST 2013
LOGMINER: End mining logfile: /home/oracle/arch_bak/thread_1_seq_2623.469.820807813
Mon Jul 15 13:17:46 CST 2013
LOGMINER: Begin mining logfile for session 1 thread 1 sequence 2624, /home/oracle/arch_bak/thread_1_seq_2624.525.820807827
Mon Jul 15 13:17:46 CST 2013
LOGMINER: End mining logfile: /home/oracle/arch_bak/thread_2_seq_1982.465.820807813
Mon Jul 15 13:17:46 CST 2013
LOGMINER: Begin mining logfile for session 1 thread 2 sequence 1983, /home/oracle/arch_bak/thread_2_seq_1983.320.820807827
Mon Jul 15 13:17:46 CST 2013
LOGMINER: End mining logfile: /home/oracle/arch_bak/thread_2_seq_1983.320.820807827
Mon Jul 15 13:17:46 CST 2013
LOGMINER: Begin mining logfile for session 1 thread 2 sequence 1984, /home/oracle/arch_bak/thread_2_seq_1984.398.820839197
Mon Jul 15 13:17:46 CST 2013
LOGMINER: End mining logfile: /home/oracle/arch_bak/thread_1_seq_2624.525.820807827
Mon Jul 15 13:17:46 CST 2013
LOGMINER: Begin mining logfile for session 1 thread 1 sequence 2625, /home/oracle/arch_bak/thread_1_seq_2625.369.820832333

“Invalid Entry Size” Error During Oracle Database Installation

0

Posted on by

今天在安装oracle database 12c时,出现如下错误,

 

Installation

日志:

INFO: Number of threads for fast copy :1
INFO: invalid entry size (expected 29259198 but got 29259030 bytes)
SEVERE: oracle.sysman.oii.oiif.oiifb.OiifbEndIterateException: invalid entry size (expected 29259198 but got 29259030 bytes)
        at oracle.sysman.oii.oiic.OiicInstallAPISession.doOperation(OiicInstallAPISession.java:490)
        at oracle.sysman.oii.oiic.OiicAPIInstaller.doOperation(OiicAPIInstaller.java:1009)
        at oracle.sysman.oii.oiic.OiicAPIInstaller.doOperation(OiicAPIInstaller.java:970)
        at oracle.install.driver.oui.OUISetupDriver.setup(OUISetupDriver.java:358)
        at oracle.install.driver.oui.SetupJob.call(SetupJob.java:315)
        at oracle.install.driver.oui.SetupJob.call(SetupJob.java:49)
        at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
        at java.util.concurrent.FutureTask.run(FutureTask.java:138)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
        at java.lang.Thread.run(Thread.java:662)

INFO: Update the state machine to STATE_READY
INFO: isSuccessfullInstallation: false
INFO: isSuccessfullRemoteInstallation: true
INFO: Adding ExitStatus FAILURE to the exit status set
INFO: Shutting down OUISetupDriver.JobExecutorThread
SEVERE: [FATAL] invalid entry size (expected 29259198 but got 29259030 bytes)
   CAUSE: No additional information available.
   ACTION: Refer to the logs or contact Oracle Support Services
   SUMMARY:
       - invalid entry size (expected 29259198 but got 29259030 bytes).
Refer associated stacktrace #oracle.install.commons.util.exception.DefaultErrorAdvisor:5867
INFO: Advice is ABORT

官方解释:

1. Once the Oracle installation kit has been downloaded from either OTN or Oracle Software Delivery Cloud confirm the filesizes and checksums match the values from the download site per:


2. If you are moving the software installation from one server to another then transfer the source using ftp/scp in binary mode and check the above values before starting the installation.

 

结果检查cksum 值,果然不一样。所以安装之前还是要检查一下介质。。

Oracle Database 12c Release 1 Grid Infrastructure (12.1.0.1.0) for Linux x86-64 
   linuxamd64_12c_grid_1of2.zip (1,750,478,910 bytes) (cksum – 3177055641
   linuxamd64_12c_grid_2of2.zip (201,673,595 bytes) (cksum – 2753782116) 

 

[oracle@oradbca soft]$ cksum linuxamd64_12c_grid_1of2.zip
2663914591 1750478910 linuxamd64_12c_grid_1of2.zip
[oracle@oradbca soft]$ cksum linuxamd64_12c_grid_2of2.zip 
2753782116 201673595 linuxamd64_12c_grid_2of2.zip

 

 

 

 

 

物理 dataguard add tempfile

0

Posted on by

记一下在物理dataguard上增加tempfile 的过程。。

–版本:

SQL> select * from v$version;

BANNER
——————————————————————————–
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production
PL/SQL Release 11.2.0.3.0 – Production
CORE    11.2.0.3.0      Production
TNS for Linux: Version 11.2.0.3.0 – Production
NLSRTL Version 11.2.0.3.0 – Production

 

–关闭同步
SQL> alter database recover managed standby database cancel;

 

–现有的tempfile

SQL> select name from v$tempfile;

NAME
——————————————————————————–
+DATADG/oradbca/tempfile/temp.304.810137387

 

–增加tempfile 脚本

alter tablespace temp add tempfile '+DATADG/oradbca/tempfile/temp02.dbf' size 10g autoextend off;
alter tablespace temp add tempfile '+DATADG/oradbca/tempfile/temp03.dbf' size 10g autoextend off;
alter tablespace temp add tempfile '+DATADG/oradbca/tempfile/temp04.dbf' size 10g autoextend off;
alter tablespace temp add tempfile '+DATADG/oradbca/tempfile/temp05.dbf' size 10g autoextend off;

 

–启动同步
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT;

 

 

–后面检查一下dataguard同步。

–结局