It’s my life – 第 2 页

flashback standby database

2016-06-15 没有评论

Flashback之后的standby database如何打开，操作如下：

SQL> flashback database to restore point myrs1;

Flashback complete.

SQL> shutdown immediate
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.

Total System Global Area  521936896 bytes
Fixed Size                  2254824 bytes
Variable Size             356517912 bytes
Database Buffers          159383552 bytes
Redo Buffers                3780608 bytes
Database mounted.
SQL> 
SQL> alter database recover managed standby database using current logfile disconnect;
alter database recover managed standby database using current logfile disconnect
*
ERROR at line 1:
ORA-01665: control file is not a standby control file


SQL> 
SQL> 
SQL> alter database convert to physical standby;

Database altered.

SQL> 
SQL> 
SQL> shutdown immediate
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL> 
SQL> 
SQL> startup
ORACLE instance started.

Total System Global Area  521936896 bytes
Fixed Size                  2254824 bytes
Variable Size             356517912 bytes
Database Buffers          159383552 bytes
Redo Buffers                3780608 bytes
Database mounted.
Database opened.
SQL> alter database recover managed standby database using current logfile disconnect;

Database altered.

SQL>

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

SQL> flashback database to restore point myrs1;

Flashback complete.

SQL> shutdown immediate

ORA-01109: database not open

Database dismounted.

ORACLE instance shut down.

SQL> startup mount

ORACLE instance started.

Total System Global Area 521936896 bytes

Fixed Size 2254824 bytes

Variable Size 356517912 bytes

Database Buffers 159383552 bytes

Redo Buffers 3780608 bytes

Database mounted.

SQL>

SQL> alter database recover managed standby database using current logfile disconnect;

alter database recover managed standby database using current logfile disconnect

*

ERROR at line 1:

ORA-01665: control file is not a standby control file

SQL>

SQL> alter database convert to physical standby;

Database altered.

SQL>

SQL> shutdown immediate

ORA-01109: database not open

Database dismounted.

ORACLE instance shut down.

SQL>

SQL> startup

ORACLE instance started.

Total System Global Area 521936896 bytes

Fixed Size 2254824 bytes

Variable Size 356517912 bytes

Database Buffers 159383552 bytes

Redo Buffers 3780608 bytes

Database mounted.

Database opened.

SQL> alter database recover managed standby database using current logfile disconnect;

Database altered.

SQL>

..experience, It's my life, Working case

基于Solaris sparc的Oracle调优

2014-09-28 没有评论

一、RAC 中cluster wait time高问题 1.设置LMS进程为FX 60，不要过多调整lms进程的数量注：在Solaris 10 Update 10之后，以及Solaris 11，才可以设置进程的优先级。可以通过看/etc/release看其版本。如Oracle Solaris 10 […]

It's my life

安装数据库软件时，找不到所有节点

2014-07-29 没有评论

某客户用runInstaller安装RAC软件时，在勾选节点的窗口找不到任何的节点。我们可以参考mos上的这个文档进行修复。 Database runInstaller “Nodes Selection” Window Does not Show Cluster Nodes […]

It's my life

Oracle Database In-Memory 现场发布会视频

2014-06-17 没有评论

这是美国时间6月10日，拉里做的12c inmemory option的现场发布会。

It's my life

台湾之行（DAY ONE and DAY TWO）

2014-03-19 4条评论

这个月休了2周的年假，去了一趟台湾。在饱览台湾的人文之美后，我首先要感谢一下我的公司，甲骨文中国，如果放在别的单位，我估计我休假两周回来后，是否还留有我的岗位……有朋友说，回来之后写个攻略吧，嗯……怎么说呢，如果你按照我的攻略走，你也许不能完全体会到台湾的人文之美，台湾的美，要靠你搭乘它的捷运、扶梯 […]

It's my life

latch:transaction allocation

2014-02-28 没有评论

今天遇到一个sql，发生了大量的134的latch，134的latch是transaction allocation。数据库版本是9208. 该sql是：

SELECT DECODE(l.request, 0, 'Holder: ', 'Waiter: ') || l.sid sess,
       s.SQL_HASH_VALUE,
       l.id1,
       l.id2,
       l.lmode,
       l.request,
       l.type
  FROM V$LOCK l, v$session s
WHERE (l.id1, l.id2, l.type) IN
       (SELECT id1, id2, type FROM V$LOCK WHERE request > 0)
   and l.SID = s.SID
   and exists (select sw.seq#,
               sw.sid || ',' || s.serial# sids,
               s.username,
               s.SQL_HASH_VALUE
          from v$session_wait sw, v$session s, dba_objects a
         where sw.sid = s.sid
           and sw.event in ('latch free', 'enqueue')
           and s.status = 'ACTIVE'
           and sw.STATE = 'WAITING'
           and s.username is not null
           and sw.seconds_in_wait > 30
           and (a.object_id = s.row_wait_obj# or
               a.data_object_id = s.row_wait_obj#))
ORDER BY l.id1, l.request;

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

SELECT DECODE(l.request, 0, 'Holder: ', 'Waiter: ') || l.sid sess,

s.SQL_HASH_VALUE,

l.id1,

l.id2,

l.lmode,

l.request,

l.type

FROM V$LOCK l, v$session s

WHERE (l.id1, l.id2, l.type) IN

(SELECT id1, id2, type FROM V$LOCK WHERE request > 0)

and l.SID = s.SID

and exists (select sw.seq#,

sw.sid || ',' || s.serial# sids,

s.username,

s.SQL_HASH_VALUE

from v$session_wait sw, v$session s, dba_objects a

where sw.sid = s.sid

and sw.event in ('latch free', 'enqueue')

and s.status = 'ACTIVE'

and sw.STATE = 'WAITING'

and s.username is not null

and sw.seconds_in_wait > 30

and (a.object_id = s.row_wait_obj# or

a.data_object_id = s.row_wait_obj#))

ORDER BY l.id1, l.request;

据客户反映，这个sql之前没有出现问题，只是昨天做了修改，增加了对v$sess […]

It's my life

Wnnn进程导致buffer busy wait

2013-11-21 没有评论

某日，在一个数据库中，发现大量buffer busy wait的进程，经检查，是监控等查询表空间使用率的进程处于buffer busy wait。而其blocking session wnnnn进程。 (1)看到监控程序被1013进程阻塞，blocking session是1013 [crayon- […]

..experience, It's my life, Working case

安装cluster时报错 PRVF-5636

2013-07-10 没有评论

之前写过一篇为rac建dns server的文章，今天在安装11.2.0.3的grid的时候报错 PRVF-5636 : The DNS response time for an unreachable node exceeded “15000” ms on followin […]

It's my life

12c开始的新一轮Lifetime Support

2013-06-27 没有评论

12c开始的新一轮Lifetime Support 注意，11gR2也有一段Waived Extended Support的时期，和9iR2和10gR2一样，在这一时期不加收10%费用。详情请咨询oracle销售。

It's my life

OOW 2012 keynote摘要

2012-10-01 一条评论

Oracle open world(oow) 2012于9月29日在美国旧金山如火如荼的展开了，开始的前两天，已经有不少激动人心的新产品和新特性发布了，在这里，我根据twitter，微博，youtube上的资料简单做了一些摘要，给大家先尝尝鲜，具体的完整信息，可能要的产品发布之后才能获得了。 Lar […]

It's my life

启动oracm的RAC数据库

2012-06-30 没有评论

这是一个9i的RAC数据库，用的oracm做的cluster，现在已经完全过时，估计已经很少有环境还在用了。在这里小记一把启动步骤，以备今后，或者和我有类似环境的朋友查验。 1.启动oracm进程：

以root用户执行：
export ORACLE_HOME=/u01/app/oracle/product/9.2.0
lxrptrdb007:~ # /u01/app/oracle/product/9.2.0/oracm/bin/ocmstart.sh
oracm </dev/null 2>&1 >/u01/app/oracle/product/9.2.0/oracm/log/cm.out &
启动后，将出现oracm的进程：
oracle@lxrptrdb007:~> ps -ef |grep oracm
root     16052     1  0 14:02 ?        00:00:00 oracm
root     16054 16052  0 14:02 ?        00:00:00 oracm
root     16055 16054  0 14:02 ?        00:00:00 oracm
root     16056 16054  0 14:02 ?        00:00:00 oracm
root     16057 16054  0 14:02 ?        00:00:05 oracm
root     16058 16054  0 14:02 ?        00:00:00 oracm
root     16059 16054  0 14:02 ?        00:00:00 oracm
root     16060 16054  0 14:02 ?        00:00:00 oracm
root     16061 16054  0 14:02 ?        00:00:00 oracm
root     16072 16054  0 14:02 ?        00:00:00 oracm
oracle   25283 25250  0 19:13 pts/0    00:00:00 grep oracm
oracle@lxrptrdb007:~>

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

以root用户执行：

export ORACLE_HOME=/u01/app/oracle/product/9.2.0

lxrptrdb007:~ # /u01/app/oracle/product/9.2.0/oracm/bin/ocmstart.sh

oracm </dev/null 2>&1 >/u01/app/oracle/product/9.2.0/oracm/log/cm.out &

启动后，将出现oracm的进程：

oracle@lxrptrdb007:~> ps -ef |grep oracm

root 16052 1 0 14:02 ? 00:00:00 oracm

root 16054 16052 0 14:02 ? 00:00:00 oracm

root 16055 16054 0 14:02 ? 00:00:00 oracm

root 16056 16054 0 14:02 ? 00:00:00 oracm

root 16057 16054 0 14:02 ? 00:00:05 oracm

root 16058 16054 0 14:02 ? 00:00:00 oracm

root 16059 16054 0 14:02 ? 00:00:00 oracm

root 16060 16054 0 14:02 ? 00:00:00 oracm

root 16061 16054 0 14:02 ? 00:00:00 oracm

root 16072 16054 0 14:02 ? 00:00:00 oracm

oracle 25283 25250 0 19:13 pts/0 00:00:00 grep oracm

oracle@lxrptrdb007:~>

2.启动gsd进程： [cray […]

It's my life

用adrci找listener的log

2012-06-28 没有评论

一个再有经验的DBA，也需要熟悉熟悉当前的数据库环境才能动手。特别是11g之后，数据库有不少变化。今天登录了一个新系统，是oracle 11.1.0.7的环境，想找listener.log看看，但是登录后，却发现传统路径下却找不到listener.log文件。 [crayon-6623be7834 […]