Adamhuan's Data Center - 【逻辑驱动数据】
数据玩物、代码屋、1/0游戏：（零和博弈）/ 禅宗意志 / 规则战争 / 解放数据力量 / 技术的飞速发展并没有改变这个世界，因为，这个世界从没有变，它只是越来越趋近于它本来的模样。
今天，回顾下之前遇到的一个参数的问题【archive_lag_target】
该参数的作用是强制数据库在某个时间间隔达成的时候执行日志切换（log switch）
它的单位是秒，因此：
如果，你设置成1800，表示1800/60=30分钟
该参数的工作原理是：
如果设置了该参数，那[……]
Adamhuan
前提：
1. 主库：Oracle RAC 10g
2. 备库：Oracle DB 10g 10205
主库：
|
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 |
[root@rac2 ~]# su - grid [grid@rac2 ~]$ [grid@rac2 ~]$ crs_stat -t -v Name Type R/RA F/FT Target State Host ---------------------------------------------------------------------- ora....SM1.asm application 0/5 0/0 ONLINE ONLINE rac1 ora....C1.lsnr application 0/5 0/0 ONLINE ONLINE rac1 ora.rac1.gsd application 0/5 0/0 ONLINE ONLINE rac1 ora.rac1.ons application 0/3 0/0 ONLINE ONLINE rac1 ora.rac1.vip application 0/0 0/0 ONLINE ONLINE rac1 ora....SM2.asm application 0/5 0/0 ONLINE ONLINE rac2 ora....C2.lsnr application 0/5 0/0 ONLINE ONLINE rac2 ora.rac2.gsd application 0/5 0/0 ONLINE ONLINE rac2 ora.rac2.ons application 0/3 0/0 ONLINE ONLINE rac2 ora.rac2.vip application 0/0 0/0 ONLINE ONLINE rac2 ora.zona.db application 0/1 0/1 ONLINE ONLINE rac2 ora....a1.inst application 0/5 0/0 ONLINE ONLINE rac1 ora....a2.inst application 0/5 0/0 ONLINE ONLINE rac2 [grid@rac2 ~]$ [grid@rac2 ~]$ exit logout [root@rac2 ~]# su - oracle [oracle@rac2 ~]$ [oracle@rac2 ~]$ ps -ef | grep pmon oracle 3484 1 0 08:12 ? 00:00:00 asm_pmon_+ASM2 oracle 20559 20478 0 10:07 pts/4 00:00:00 grep pmon oracle 26556 1 0 09:05 ? 00:00:00 ora_pmon_zona2 [oracle@rac2 ~]$ [oracle@rac2 ~]$ env | grep SID ORACLE_SID=zona2 [oracle@rac2 ~]$ [oracle@rac2 ~]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.5.0 - Production on Tue Jul 3 10:07:52 2018 Copyright (c) 1982, 2010, Oracle. All Rights Reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production With the Partitioning, Real Application Clusters, OLAP, Data Mining and Real Application Testing options SQL> select instance_name,status from v$instance; INSTANCE_NAME STATUS ---------------- ------------ zona2 OPEN SQL> exit Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production With the Partitioning, Real Application Clusters, OLAP, Data Mining and Real Application Testing options [oracle@rac2 ~]$ |
备库：
|
1 2 3 4 5 |
[oracle@standby-rac ~]$ sqlplus -V SQL*Plus: Release 10.2.0.5.0 - Production [oracle@standby-rac ~]$ |
一、基础配置检查：[……]
Adamhuan
今天，将一个10g的数据库（10201）（RAC）升级为10205之后，启动集群的数据库资源的时候遇到了如题所示的错误。
具体如下：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 |
[oracle@rac1 ~]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.5.0 - Production on Tue Jul 3 08:16:37 2018 Copyright (c) 1982, 2010, Oracle. All Rights Reserved. Connected to an idle instance. SQL> startup upgrade; ORACLE instance started. Total System Global Area 536870912 bytes Fixed Size 2097624 bytes Variable Size 150998568 bytes Database Buffers 377487360 bytes Redo Buffers 6287360 bytes Database mounted. ORA-01092: ORACLE instance terminated. Disconnection forced SQL> |
Alert日志：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
Tue Jul 03 08:16:58 CST 2018 Successfully onlined Undo Tablespace 1. Tue Jul 03 08:16:58 CST 2018 SMON: enabling tx recovery Tue Jul 03 08:16:58 CST 2018 Database Characterset is AL32UTF8 Updating 10.2.0.1.0 NLS parameters in sys.props$ -- adding 10.2.0.5.0 NLS parameters. Tue Jul 03 08:17:02 CST 2018 Errors in file /u01/app/oracle/admin/zona/udump/zona1_ora_30456.trc: ORA-39701: database must be mounted EXCLUSIVE for UPGRADE or DOWNGRADE Error 39701 happened during db open, shutting down database USER: terminating instance due to error 39701 Instance terminated by USER, pid = 30456 ORA-1092 signalled during: ALTER DATABASE OPEN MIGRATE... |
[……]
Adamhuan
在对RAC做升级的时候，如果你使用VNC开启图形窗口，那么你在runInstaller中可能会遇到这样的问题：
上面出问题的时候，系统日志如下：
日志：/var/log/secure
|
1 2 3 4 5 6 |
Jan 4 14:53:42 SHAdhv-066 sshd[2281]: Accepted publickey for vcdgrid from 10.157.1.69 port 39284 ssh2 Jan 4 14:53:42 SHAdhv-066 sshd[2281]: pam_unix(sshd:session): session opened for user vcdgrid by (uid=0) Jan 4 14:53:42 SHAdhv-066 sshd[2281]: pam_unix(sshd:session): session closed for user vcdgrid Jan 4 14:53:42 SHAdhv-066 sshd[2334]: Accepted publickey for vcdgrid from 10.157.1.70 port 47361 ssh2 Jan 4 14:53:42 SHAdhv-066 sshd[2334]: pam_unix(sshd:session): session opened for user vcdgrid by (uid=0) Jan 4 14:53:42 SHAdhv-066 sshd[2334]: pam_unix(sshd:session): session closed for user vcdgrid |
如果用debug模式【-de[……]
Adamhuan
今天，查看自己的测试环境的运行状态的时候，发现前几天搭建的RAC出现问题了：
登陆系统后，发现确实有问题，并遇到了如题所示的错误：
|
1 2 3 4 5 6 7 8 9 10 |
[root@oracle12c1 ~]# /u01/app/12/grid/bin/crs_stat -t -v CRS-0184: Cannot communicate with the CRS daemon. [root@oracle12c1 ~]# [root@oracle12c1 ~]# /u01/app/12/grid/bin/crsctl check crs CRS-4638: Oracle High Availability Services is online CRS-4535: Cannot communicate with Cluster Ready Services CRS-4530: Communications failure contacting Cluster Synchronization Services daemon CRS-4534: Cannot communicate with Event Manager [root@oracle12c1 ~]# |
查看ORACLE ASM的情况：
[crayon-6096405b3977c11[……]
Adamhuan