2015-01-01 – OracleBlog

instance不随机启动

2015-01-01 没有评论

客户有个机器上的instance，在机器重启后，总是不随机启动，每次都要手工的srvctl的去start一次。这其实是crs的配置缘故：

[root@rac1 ~]# crsctl stat res ora.ora11g.db -p 
NAME=ora.ora11g.db 
TYPE=ora.database.type 
ACL=owner:oracle:rwx,pgrp:oinstall:r--,other::r--,group:dba:r-x,group:oinstall:r-x,user:oracle:r-x 
ACTION_FAILURE_TEMPLATE= 
ACTION_SCRIPT= 
ACTIVE_PLACEMENT=1 
AGENT_FILENAME=%CRS_HOME%/bin/oraagent%CRS_EXE_SUFFIX% 
AUTO_START=restore <<======这里配置的是restore，即上次是手工关闭过，等server重启后，instance也是启动到关机前关闭状态。

1

2

3

4

5

6

7

8

9

[root@rac1 ~]# crsctl stat res ora.ora11g.db -p

NAME=ora.ora11g.db

TYPE=ora.database.type

ACL=owner:oracle:rwx,pgrp:oinstall:r--,other::r--,group:dba:r-x,group:oinstall:r-x,user:oracle:r-x

ACTION_FAILURE_TEMPLATE=

ACTION_SCRIPT=

ACTIVE_PLACEMENT=1

AGENT_FILENAME=%CRS_HOME%/bin/oraagent%CRS_EXE_SUFFIX%

AUTO_START=restore <<======这里配置的是restore，即上次是手工关闭过，等server重启后，instance也是启动到关机前关闭状态。

将auto_start修改成always就可以了。修改方式： [crayon-66285bf6 […]

..unix shell, Useful script

批量取statspack的脚本

2015-01-01 一条评论

做了一个脚本sprpt_batch.sh:

read line
snap_i_id=$1
end_snap=$2

sqlplus -s /nolog<<EOF
conn /as sysdba;
define begin_snap=${snap_i_id};
define end_snap=${end_snap};
define report_name=sprpt_batch_${snap_i_id}_${end_snap}.txt
set echo off
set feedback off
@myspreport
exit
EOF

1

2

3

4

5

6

7

8

9

10

11

12

13

14

read line

snap_i_id=$1

end_snap=$2

sqlplus -s /nolog<<EOF

conn /as sysdba;

define begin_snap=${snap_i_id};

define end_snap=${end_snap};

define report_name=sprpt_batch_${snap_i_id}_${end_snap}.txt

set echo off

set feedback off

@myspreport

exit

EOF

将$ORACLE_HOME/rdbms/admin/spreport.sql和$ORACLE_HOME/rdbms/admin/sprepins.sql拷贝到工作目录下，重命名成myspre […]

Study note

切出的归档日志小于设置的redo大小

2015-01-01 没有评论

数据库产生大量的小日志，原因和log_buffer的大小和redo log file size有关。为了说明这个问题，我们先来看看从log buffer开始写redo log file的过程：（1）写redo log buffer 在pga中产生redo entry（即change record， […]

..experience, Working case

RMAN-00600 [13200]的处理

2015-01-01 没有评论

在dataguard上，使用rman连接catalog数据库进行备份。备份的时候，rman的日志报错如下：

Starting backup at 2014/04/23-10:02:02
archived log /aabb/qb/mobprd/log/fra/mobprd/archivelog/2014_04_23/o1_mf_1_201410_9ofpggpg_.arc not found or out of sync with catalog
skipping inaccessible file /aabb/qb/mobprd/log/fra/mobprd/archivelog/2014_04_23/o1_mf_1_201410_9ofpggpg_.arc
archived log /aabb/qb/mobprd/log/fra/mobprd/archivelog/2014_04_23/o1_mf_1_201411_9ofqblsm_.arc not found or out of sync with catalog
skipping inaccessible file /aabb/qb/mobprd/log/fra/mobprd/archivelog/2014_04_23/o1_mf_1_201411_9ofqblsm_.arc
archived log /aabb/qb/mobprd/log/fra/mobprd/archivelog/2014_04_23/o1_mf_1_201412_9ofr6px7_.arc not found or out of sync with catalog
skipping inaccessible file /aabb/qb/mobprd/log/fra/mobprd/archivelog/2014_04_23/o1_mf_1_201412_9ofr6px7_.arc
archived log /aabb/qb/mobprd/log/fra/mobprd/archivelog/2014_04_23/o1_mf_1_201413_9ofs2v2m_.arc not found or out of sync with catalog
skipping inaccessible file /aabb/qb/mobprd/log/fra/mobprd/archivelog/2014_04_23/o1_mf_1_201413_9ofs2v2m_.arc
RMAN-06061: WARNING: skipping archived log compromises recoverability
released channel: ch00
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 04/23/2014 10:02:23
RMAN-00600: internal error, arguments [13200] [] [] [] []

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

Starting backup at 2014/04/23-10:02:02

archived log /aabb/qb/mobprd/log/fra/mobprd/archivelog/2014_04_23/o1_mf_1_201410_9ofpggpg_.arc not found or out of sync with catalog

skipping inaccessible file /aabb/qb/mobprd/log/fra/mobprd/archivelog/2014_04_23/o1_mf_1_201410_9ofpggpg_.arc

archived log /aabb/qb/mobprd/log/fra/mobprd/archivelog/2014_04_23/o1_mf_1_201411_9ofqblsm_.arc not found or out of sync with catalog

skipping inaccessible file /aabb/qb/mobprd/log/fra/mobprd/archivelog/2014_04_23/o1_mf_1_201411_9ofqblsm_.arc

archived log /aabb/qb/mobprd/log/fra/mobprd/archivelog/2014_04_23/o1_mf_1_201412_9ofr6px7_.arc not found or out of sync with catalog

skipping inaccessible file /aabb/qb/mobprd/log/fra/mobprd/archivelog/2014_04_23/o1_mf_1_201412_9ofr6px7_.arc

archived log /aabb/qb/mobprd/log/fra/mobprd/archivelog/2014_04_23/o1_mf_1_201413_9ofs2v2m_.arc not found or out of sync with catalog

skipping inaccessible file /aabb/qb/mobprd/log/fra/mobprd/archivelog/2014_04_23/o1_mf_1_201413_9ofs2v2m_.arc

RMAN-06061: WARNING: skipping archived log compromises recoverability

released channel: ch00

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of backup command at 04/23/2014 10:02:23

RMAN-00600: internal error, arguments [13200] [] [] [] []

一开始，根据文档：341337.1，以为造成这个报错的原因是，注册在catalog库中的信息，在备份时被调用，由于备份是在da […]

..experience, Working case

打补丁的时候一定要注意opatch版本

2015-01-01 一条评论

在打patch的时候，特别是有些新申请的merge patch，我们需要注意在opatch的readme文档说明，因为有的时候，使用自带版本的opatch，会发生一些千奇百怪的问题。如下面的这个log中，我们看到，这是一个for 10.2.0.3.3的做db replay的patch，由于db r […]