- 博客(64)
- 收藏
- 关注
RSS订阅原创 12c之后增量修复gap
适用场景：备库产生GAP且主库归档已经删除，如何快速恢复（oracle12c新特性）参考：Rolling Forward a Physical Standby Using Recover From Service Command in 12c (Doc ID 1987763.1)备注：此方案适用于数据量大的库，如果数据量不大可以考虑直接重新初始化在12c之前，利用基于SCN的增量备份恢复备库的过程较为复杂。大致过程如下：1，确定备库的最大SCN2，在主数据库上进行基于备库SCN＃的增量备份
2022-04-21 21:55:45
608
原创 12c dbca静默建库
dbca -silent -createDatabase \-templateName General_Purpose.dbc \-gdbname rac -responseFile NO_VALUE \-sid rac \-databaseConfigType RAC \-characterSet ZHS16GBK \-sysPassword Oracle_123 \-systemPassword Oracle_123 \-createAsContainerDatabase...
2021-06-24 23:42:25
298
原创 静默安装Oracle 11.2.0.4 RAC
静默安装gi/etc/hosts##Public Network - (eth0)192.168.56.113 rac1192.168.56.114 rac2##Private Interconnect - (eth1)10.0.0.11 rac1-priv10.0.0.22 rac2-priv##Public Virtual IP (VIP) addresses - (eth0)192.168.56.115 rac1-vip192.168.56.116 rac2-vip...
2020-10-13 15:48:10
656
原创 parted分区
parted[root@tlyb-db-net ~]# parted /dev/vdbGNU Parted 2.1Using /dev/vdbWelcome to GNU Parted! Type 'help' to view a list of commands.(parted) mklabel gptWarning: The existing disk label on /dev/vdb will be destroyed and all data on this disk wi
2020-10-09 10:29:02
150
原创 19c pdb导出报错 ORA-39126: KUPW$WORKER.FETCH_XML_OBJECTS [ORA-00942: table or view does not exist
19c pdb导出报错[oracle@rac19c1 ~]$ expdp system/oracle@pdb11g dumpfile=exp.dmp cluster=n directory=exp full=y;Export: Release 19.0.0.0.0 - Production on Fri Jun 5 22:57:39 2020Version 19.3.0.0.0Copyright (c) 1982, 2019, Oracle and/or its affiliates. A.
2020-06-06 00:31:31
1894
原创 测试重建pdb的xml文件
查看pdbSQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED---------- ------------------------------ ---------- ---------- 2 PDB$SEED REA...
2020-04-14 21:36:16
468
原创 oradebug挂起进程测试
1、使用方法选择进程SQL> oradebug setospid spid或者oradebug setorapid pid挂起进程SQL> oradebug suspend重新开始进程SQL> oradebug resume2、测试查询进程pid和spidSQL> select ADDR,PID,SPID,PNAME,USERN...
2020-04-06 22:48:27
450
原创 hanganalyz和ssd测试记录
第一个窗口查询sidSQL> select distinct sid from v$mystat; SID---------- 34手动创造latchSQL> select name,addr,gets from v$latch_children where name like '%row cache%' and gets >...
2020-04-06 22:33:28
220
原创 truncate表恢复测试
SQL> conn t1/t1Connected.SQL> create table t4 as select * from user_objects;Table created.SQL> truncate table t1.t4;Table truncated.停止业务对表空间的操作，可以将表空间readonly，收集表的元数据，索引等信息略。查看...
2020-03-17 15:31:32
172
原创 Oracle Linux5.5 10.2.0.1带库升级到10.2.0.5
1、升级crs不停集群，解压升级补丁[oracle@rac1 soft]$ unzip p8202632_10205_Linux-x86-64.zip[oracle@rac1 soft]$ cd Disk1/执行安装[oracle@rac1 Disk1]$ ./runInstaller在1节点执行提示脚本停机群[root...
2020-03-16 11:55:21
245
原创 redhat7一些操作
修改主机名hostnamectl set-hostname <hostname>配置yumcd /etc/yum.repos.d/vi rhel-source.repo[oel7_local]name = oracle Enterprise Linux 7baseurl=file:///mnt/gpgcheck=0enabled=1安装、...
2020-03-13 15:19:10
447
原创 19c创建pdb
CREATE PLUGGABLE DATABASE { { pdb_name [ AS APPLICATION CONTAINER ] | using_snapshot_clause} | { AS SEED } } { create_pdb_from_seed | create_pdb_clone | create_pdb_from_xml | create_pdb_from_mirr...
2020-03-09 17:05:55
5016
原创 LOB导致临时表空间不释放
数据库版本11204执行占用temp表空间sql，发现执行sql后temp表空间不释放SQL> select TABLESPACE_NAME,TABLESPACE_SIZE/1024/1024 ,FREE_SPACE/1024/1024 from dba_temp_free_space;TABLESPACE_NAME TABLESPACE_SIZE...
2020-02-12 18:11:17
936
原创 用x$ktsso查实际占用temp的sql
执行占用temp表空间sqlSQL> select TABLESPACE_NAME,TABLESPACE_SIZE/1024/1024 ,FREE_SPACE/1024/1024 from dba_temp_free_space;TABLESPACE_NAME TABLESPACE_SIZE/1024/1024 FREE_SPACE/1024/1024...
2020-02-12 16:50:26
644
原创 ORA-600 4194
Step by step to resolve ORA-600 4194 4193 4197 on database crash (文档 ID 1428786.1)Basic Steps to be Followed While Solving ORA-00600 [4194]/[4193] Errors Without Using Unsupported parameter (Doc ID ...
2020-02-10 15:42:04
157
原创 Oracle ASM存储限制
What is the Max LUN size in ASM 12c (not using Flex ASM).Before ASM 12c there was an limitation of 2 Tb LUNs.12cR1The following information was taken from theOracle® Automatic Storage Managem...
2020-01-20 19:15:20
252
原创 duplicate报ORA-17502、ORA-15001、ORA-15040
在duplicate过程中报错Starting backup at 11-JAN-20using channel ORA_DISK_1RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ...
2020-01-11 17:31:33
1371
原创 搭建rac+racdg
主库# rac1192.168.56.33 rac1192.168.56.111 rac1-vip10.10.10.1 rac1-priv# rac2192.168.56.44 rac2192.168.56.112 rac2-vip10.10.10.2 r...
2020-01-08 23:48:00
1833
原创 Gaussdb----Instance Startup Failed
cat/opt/gaussdb/log/run/zengine.rlogUTC-5 2020-01-03 14:38:16.787|ZENGINE|00000|77309421615|INFO>[LOG] file '/opt/gaussdb/data/log/zenith_alarm.log' is added [srv_param.c:488]UTC-5 2020-01-03 ...
2020-01-03 19:49:48
722
原创 HADOOP+ZOOKEEPER+HBASE测试搭建
三个节点环境变量export PATHexport JAVA_HOME=/usr/local/jdk1.8.0_191export JRE_HOME=$JAVA_HOME/jreexport CLASSPATH=.:$JAVA_HOME/jre/lib/rt.jar:$JAVA_HOME/lib/dt.jar:$JAVA_HOME/lib/tools.jarexport PATH=...
2019-11-30 20:36:29
120
原创 ORA-00600 kcratr_nab_less_than_odr
重建控制文件解决。Alter database open fails with ORA-00600 kcratr_nab_less_than_odr(文档 ID 1296264.1)
2019-11-19 18:37:20
123
原创 11g异机恢复19c，插入cdb
不太严谨的测试将11.2.0.4 RAC异机恢复到19c数据库切换到upgradeSQL> startup upgradeORACLE instance started.Total System Global Area 843052528 bytesFixed Size 8902128 bytesVariable Size ...
2019-11-18 16:04:04
1366
原创 数据分布不均匀导致查询不走索引。
测试表SQL> desc testName Null? Type----------------------------------------- -------- ----------------------------ID ...
2019-10-20 11:42:04
839
原创 11201启动时报CRS-4124 CRS-4000
服务器异常断电，重启后集群无法自动启动，执行crsctl start crs时显示/u01/app/11.2.0/grid/bin/crsctl start crsCRS-4124:OracleHighAvailabilityServicesstartupfailed.CRS-4000:CommandStartfailed,orcompletedwitherr...
2019-09-10 23:19:54
1867
原创 监听
SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = orcl) (ORACLE_HOME = D:\app\Administrator\product\11.2.0\dbhome_1) ) (SID_DESC = (SID_NAME = CLRExtProc) (...
2019-09-03 13:18:11
580
原创 ORA-16018
SQL> alter system set db_recovery_file_dest='+datadg';alter system set db_recovery_file_dest='+datadg'*ERROR at line 1:ORA-02097: parameter cannot be modified because specified value is inv...
2019-08-21 12:39:08
245
原创 ASH不收集数据
Oracle数据库版本12.2.0.1ASH不收集数据，V$ACTIVE_SESSION_HISTORY没有任何数据。查看当前通过隐含参数_ash_size设置为500M。去掉隐含参数，一切正常，ASH正常收集数据。怀疑_ash_size参数过大导致。Before 12.1.0.1 the max setting for "_ash_size" is 254Mb, i.e. 1...
2019-08-17 23:04:31
411
原创 通过dblink连接10.2.0.1（未打补丁）scn同步
A库11204B库10201A库创建dblink连接B库A库scnSQL> select current_scnfrom v$database;CURRENT_SCN----------------------------------------1901084B库scnSQL> select current_scn from v$databa...
2019-08-14 23:50:05
304
原创 将数据库由单实例变为双节点rac
将数据库由单实例变为双节点rac1、将数据库变为mount状态，将文件copy进asmrman target /backup as copy datafile 1 format '+DATADG';backup as copy datafile 2 format '+DATADG';backup as copy datafile 3 format '+DATADG';backu...
2019-08-08 14:44:48
1093
原创 ERROR OGG-00446 .
RLYSI_B进程 ABENDINGview report 报ERROR OGG-00446 .GGSCI (juece2) 2> view report RLYSI_B*********************************************************************** Oracle Golden...
2019-08-08 14:29:11
642
原创 在线11204迁移OCR磁盘组
第一种方法：add/drop disk参考文档：零宕机时间迁移 ASM 磁盘组到另一个 SAN/磁盘阵列/DAS 的准确步骤 (文档 ID 1946664.1)SQL> select name from v$asm_diskgroup;NAME------------------------------DATADGOCRDGSQL> alter diskgrou...
2019-08-07 01:24:43
236
原创 CRS-6706 patch level 不一致
19.3.0.0RAC的2节点打补丁失败，导致2节点集群无法启动报错：[root@rac19c2 soft]# /u01/app/11.2.0/grid/bin/crsctl start crsCRS-6706: Oracle Clusterware Release patch level ('4203896349') does not match Software patch level...
2019-07-28 16:13:23
2202
原创 Oracle 10g RAC 修改Public IP、VIP
一、修改公网 IP或者VIP， 但是不修改网卡、子网或网络掩码信息，或者只是修改MAC地址，而不需要修改其他信息如果只需要修改公网 IP 地址或者VIP，而且新的地址仍然在相同的子网和相同的网络接口上，或者只是修改公网IP的MAC地址，IP/interface/subnet/netmask仍旧保持不变，集群层面不需要做任何修改，所有需要的修改是在 OS 层面反映 IP 地址的变化。1. 关闭...
2019-07-06 23:46:59
920
原创 expdp Fails With ORA-600 [unable to load XDB library]
AIX平台，Oracle数据库版本10.2.0.2，使用expdp导出时失败，报错：ORA-39014: One or more workers have prematurely exited.ORA-39029: worker 1 with process name "DW01" prematurely terminatedORA-31671: Worker process DW0...
2019-07-05 23:25:20
169
原创 未提交事务屏蔽回滚段
1、插入数据SQL> select count(*) from t1; COUNT(*)---------- 9156SQL> insert into t1 select * from t1;9156 rows created.SQL> select count(*) from t1; COUNT(*)---------- 1...
2019-04-23 18:07:43
228
原创 AIX11203srvctl启动数据库hang死
srvctl start|stop database -d racdg 时hang死集群数据库资源状态一直在starting或者stoping状态。只能通过startup单独启动各实例查看集群日志显示：[/grid/11.2.0/grid/bin/oraagent.bin(19005610)]CRS-5818:Aborted command 'clean' for resourc...
2019-04-11 17:11:51
251
原创 amdu抽取数据文件
一、amdu恢复数据[grid@rac1 ~]$ amduamdu_2019_03_14_13_57_27/[grid@rac1 ~]$[grid@rac1 ~]$[grid@rac1 ~]$ cd amdu_2019_03_14_13_57_27/[grid@rac1 amdu_2019_03_14_13_57_27]$ lsreport.txt1、查看盘信息[gr...
2019-03-15 16:06:56
489
1
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人