oracle12c
文章平均质量分 70
好记忆不如烂笔头abc
Oracle GoldenGate认证,超15年电信、金融、医疗、政府、教育等数据库运维经验,擅长oracle数据库高可用技术RAC/ADG以及跨平台跨版本数据库各种方法最短时间大数据量迁移升级:
oracle各版本之间:从9i->10g->11g->12c,19c,21c
sqlserver各版本之间:从2000->2008->2012->2014->2016->2017->2019
db2->oracle,oracle->postgresql等
展开
-
oracle标准版转换到企业版
Oracle 数据库标准版转换为企业版转载 2024-03-25 15:07:17 · 98 阅读 · 0 评论 -
How to Troubleshoot and Resolve an ORA-1110 Error (Doc ID 434013.1)
AFNand&BLspool off。转载 2023-11-09 12:30:36 · 172 阅读 · 0 评论 -
ORA-02354 ORA-01555 ORA-22924
oracle clob转载 2023-10-23 16:06:11 · 171 阅读 · 0 评论 -
Open Database failed - DATAFILE NEEDS MORE RECOVERY TO BE CONSISTENT ORA-1194 ORA-1547 ORA-1110
Open Database failed - DATAFILE NEEDS MORE RECOVERY TO BE CONSISTENT ORA-1194 ORA-1547 ORA-1110 (Doc ID 1528788.1)转载 2023-10-20 16:58:18 · 151 阅读 · 0 评论 -
oracle自动列表分区
oracle自动列表分区转载 2023-07-14 11:21:13 · 233 阅读 · 0 评论 -
Oracle统计信息(二)—— 直方图 Histogram
Oracle统计信息(二)—— 直方图 Histogram转载 2023-07-06 15:40:45 · 1501 阅读 · 0 评论 -
表进行加密(redact)实验
表进行加密(redact)实验转载 2022-10-28 20:08:10 · 274 阅读 · 0 评论 -
oracle补丁psu20221018
oracle补丁psu20221018原创 2022-10-20 16:19:14 · 606 阅读 · 0 评论 -
Oracle数据库中的数据加密 / Oracle数据库DES解密
Oracle数据库中的数据加密 / Oracle数据库DES解密转载 2022-10-10 16:54:13 · 2584 阅读 · 0 评论 -
ALERT - Corruption ORA-00600 [4506] ORA-00600 [ktubko_1] on CDB with Different SGA Sizes across RAC
ALERT - Corruption ORA-00600 [4506] ORA-00600 [ktubko_1] on CDB with Different SGA Sizes across RAC转载 2022-10-09 09:27:13 · 194 阅读 · 0 评论 -
purgeLogs: Cleanup traces, logs in one command (Doc ID 2081655.1)
一键清理oracle/grid相关日志转载 2022-09-28 14:01:09 · 679 阅读 · 0 评论 -
The ASM Priority Rebalance feature - An Example (Doc ID 1968607.1)
The ASM Priority Rebalance feature - An Example (Doc ID 1968607.1)转载 2022-09-27 16:45:17 · 227 阅读 · 0 评论 -
Recover from diskgroup failure using the 12.1.0.2 “mount restricted force for recovery” feature - An
Recover from diskgroup failure using the 12.1.0.2 “mount restricted force for recovery” feature - An Example (Doc ID 1968642.1)转载 2022-09-27 16:40:04 · 738 阅读 · 0 评论 -
使用UltraEdit修改oracle二进制文件
使用UltraEdit修改oracle二进制文件转载 2022-09-23 14:37:29 · 662 阅读 · 0 评论 -
oracle 12c rac asm使用nfs注意的问题
oracle 12c rac配置nfs注意的问题原创 2022-09-20 13:43:08 · 593 阅读 · 0 评论 -
grid起图形安装rac,跨网段
grid起图形安装rac,跨网段原创 2022-09-15 14:49:07 · 474 阅读 · 0 评论 -
Oracle RAC目录权限丢失故障恢复
oracle rac目录权限丢失恢复转载 2022-09-15 09:01:35 · 954 阅读 · 0 评论 -
oracle rac打补丁备份home目录
oracle rac打补丁备份home目录原创 2022-09-13 19:02:16 · 306 阅读 · 0 评论 -
Oracle 12c系列(四)|资源隔离之IO、内存、CPU
可以使用DBA_HIST_RSRC_PDB_METRIC来计算一个PDB合理的IO限制。当计算IO限制值时,可以参考以下列:IOPS、IOMBPS、IOPS_THROTTLE_EXEMPT和IOMBPS_THROTTLE_EXEMPT。转载 2022-06-10 10:29:09 · 782 阅读 · 0 评论 -
不同步某个pdb的做法参考
不同步某个pdb的做法参考:关闭并禁用pdb恢复即可select name, recovery_status from v$pdbs;或show pdbs;alter database recover managed standby database cancel;alter session set container=XXXPDB;alter pluggable database close;alter pluggable database disable recovery;show pd转载 2022-02-17 12:56:40 · 155 阅读 · 1 评论 -
OGG整合模式抽取(downstream模式)
Configuring a Downstream Mining DatabaseOGG整合模式抽取(downstream模式)参考文档:B Configuring a Downstream Mining DatabaseC Example Downstream Mining ConfigurationOGG Integrated模式分为:1.Local deployment:The source database and the mining database are th转载 2022-02-16 16:46:32 · 1028 阅读 · 0 评论 -
adg备库生成awr
How to Generate AWRs in Active Data Guard Standby Databases (Doc ID 2409808.1)Oracle Database - Enterprise Edition - Version 12.2.0.1 and laterGen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and laterOracle Cloud .转载 2021-08-24 10:00:33 · 841 阅读 · 0 评论 -
Requirements for Configuring RAC Extended Clusters on Exadata (Doc ID 2234289.1)
Oracle Exadata Storage Server Software - Version 12.2.1.1.0 and laterOracle Database - Enterprise Edition - Version 12.2 BETA1 and laterOracle Database Cloud Schema Service - Version N/A and laterOracle Database Exadata Cloud Machine - Version N/A and l转载 2021-08-06 13:36:12 · 163 阅读 · 0 评论 -
清理太多审计文件和监听日志
[root@racd2 trace]# su - grid[grid@racd2 ~]$ cd /oracle/app/grid/diag/tnslsnr/racd2/asmnet1lsnr_asm/trace[grid@racd2 trace]$ lltotal 4839932-rw-r----- 1 grid oinstall 4955315994 Jul 29 12:33 asmnet1lsnr_asm.log[grid@racd2 trace]$ du -sh *4.7G asmn..原创 2021-07-29 12:48:46 · 614 阅读 · 0 评论 -
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.FIXUP_MASTER_TABLE_EXPORT
[oracle@ dmp]$ expdp \'/ as sysdba\' directory=dmp schemas=xczhh version=11.2 dumpfile=xczhh-`date "+%Y%m%d_%H%M%S"`.dmp logfile=xczhh-`date "+%Y%m%d_%H%M%S"`.log EXCLUDE=TABLE:\"IN \(\'EE_SCENE_ORDER_LOG\'\)\" exclude=TABLE:\"LIKE\'%20%\'\" exclude=TAB...原创 2021-05-28 13:21:01 · 4216 阅读 · 0 评论 -
OGG-02913 Metadata format of the definitions file for table <schema>.<Table> does not match trail f
Ogg replicat - ERROR OGG-02913 Metadata format of the definitions file for table <schema>.<Table> does not match trail format. (Doc ID 2603896.1)Oracle GoldenGate Application Adapters - Version 12.3 and laterInformation in this document appl转载 2021-05-18 13:06:55 · 1011 阅读 · 0 评论 -
自Oracle 12.2始,Active Dataguard也开始支持AWR功能了
自Oracle 12.2始,Active Dataguard也开始支持AWR功能了https://blogs.oracle.com/database4cn/%e4%bb%8e%e7%8e%b0%e6%9c%89adg%e5%a4%87%e5%ba%93%e5%88%9b%e5%bb%ba%e6%96%b0%e5%a4%87%e5%ba%93%e7%9a%84%e5%8f%af%e8%a1%8c%e6%80%a7%e6%b5%8b%e8%af%95在之前的版本里,Active Dataguard不支持转载 2021-05-11 09:36:26 · 522 阅读 · 0 评论 -
ORA 700 [kfnRConnect2] (Doc ID 2424902.1)
ORA 700 [kfnRConnect2] (Doc ID 2424902.1)racle Database Cloud Schema Service - Version N/A and laterOracle Database Exadata Cloud Machine - Version N/A and laterOracle Database Backup Service - Version N/A and laterOracle Database Cloud Service - ...原创 2021-04-01 12:13:00 · 397 阅读 · 0 评论 -
Step by step to resolve ORA-600 4194 4193 4197 on database crash (Doc ID 1428786.1)
Step by step to resolve ORA-600 4194 4193 4197 on database crash (Doc ID 1428786.1)Oracle Database - Enterprise Edition - Version 9.2.0.1 to 12.2.0.1 [Release 9.2 to 12.2]Information in this document applies to any platform.***Checked for relevance on转载 2021-03-31 09:27:54 · 192 阅读 · 0 评论 -
rman备份指定备份集对应文件
例如备份user表空间,指定备份集对应文件$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on 9 10:32:05 2021Copyright (c) 1982, 2013, Oracle. All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionW.原创 2021-03-19 10:35:36 · 505 阅读 · 0 评论 -
How to estimate RMAN incremental backup size using block change tracking file (Doc ID 1938079.1)
How to estimate RMAN incremental backup size using block change tracking file (Doc ID 1938079.1)Oracle Database - Enterprise Edition - Version 10.1.0.2 and laterZero Data Loss Recovery Appliance Software - Version 12.1.0.1.0 and laterOracle Database.转载 2021-03-17 16:46:57 · 319 阅读 · 0 评论 -
TNS-12537: TNS:connection closed SQLNET.EXPIRE_TIME
[oracle@rac1 admin]$ cat sqlnet.oraSQLNET.EXPIRE_TIME = 10SQLNET.ALLOWED_LOGON_VERSION_SERVER=8SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8https://blog.csdn.net/qq_34556414/article/details/81330604原创 2021-01-27 16:56:16 · 212 阅读 · 0 评论 -
db_recovery_file_dest恢复区的空间保留问题
恢复区保留问题:Files being deleted in the flash recovery area, messages in the alert log Deleted Oracle managed file filename (Doc ID 1369341.1)SQL> archive log list;Database log mode Archive ModeAutomatic archival EnabledArchive dest...原创 2021-01-21 14:36:46 · 1153 阅读 · 1 评论 -
oracle cluster+database 最新补丁查找
Master Note for Database Proactive Patch Program (Doc ID 888.1)Assistant: Download Reference for Oracle Database/GI Update, Revision, PSU, SPU(CPU), Bundle Patches, Patchsets and Base Releases (文档 ID 2118136.2)4.1 Database 19This table only contai.原创 2021-01-21 10:15:10 · 442 阅读 · 0 评论 -
ASM Diskgroup on NFS: ORA-15080 ORA-17500: ODM err: (Doc ID 2203220.1)
Oracle Database - Enterprise Edition - Version 12.1.0.2 and laterOracle Database Cloud Schema Service - Version N/A and laterOracle Database Exadata Cloud Machine - Version N/A and laterOracle Database Exadata Express Cloud Service - Version N/A and lat转载 2021-01-20 12:38:16 · 667 阅读 · 0 评论 -
oracle查看索引碎片并重建
SQL> analyze index CIS.IDX_XXX validate structure online;--加上online无法显示index_stats结果(Doc ID 283974.1) Index analyzed.SQL> select name,del_lf_rows_len,lf_rows_len,(del_lf_rows_len/lf_rows_len)*100 from index_stats;no rows selectedSQL> ...原创 2020-12-21 11:16:18 · 413 阅读 · 0 评论 -
12c以上在线移动数据文件,临时文件,日志文件
[root@rac1 ~]# su - gridLast login: Thu Dec 17 13:43:55 CST 2020[grid@rac1 ~]$ asmcmd lsdgState Type Rebal Sector Logical_Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files NameMOUNTED NORM...原创 2020-12-17 14:06:20 · 663 阅读 · 0 评论 -
12.2 RMAN Cross-Platform Transport of PDB into Destination CDB (Doc ID 2308210.1)
GOALNOTE: In the images and/or the document content below, the user information and environment data used represents fictitious data from the Oracle sample schema(s), Public Documentation delivered with an Oracle database product or other training materi转载 2020-12-16 13:22:04 · 193 阅读 · 0 评论 -
How To Perform a Full Export And Exclude Certain Schemas Using The Data Pump API? (Doc ID 1340781.1)
How To Perform a Full Export And Exclude Certain Schemas Using The Data Pump API? (Doc ID 1340781.1)You want to perform a full export and exclude certain schema(s) using the Data Pump API (dbms_datapump).The next example demonstrates how to perform thi.转载 2020-12-15 20:52:47 · 259 阅读 · 0 评论 -
Dataguard中pdb的迁移和故障切换
在12c多租户环境中,每一个CDB当中都会有多个pdb在运行,在某些情况下会涉及到CDB之间进行pdb的迁移。当然也就会碰到类似的情况,比如只有其中某一个pdb出现了问题,而其他的pdb都运行正常,这个时候如果对CDB做failover代价太大,这时为了最大程度减少停机时间和缩小影响,我们可以只对这个单独的pdb进行failover或者迁移到同服务器的其他primary cdb。这就需要用到dg broker所带来的新功能,从12.1版本开始,通过dg broker中migrate pluggable da转载 2020-12-15 15:54:45 · 825 阅读 · 0 评论