技术文章列表
120 篇RMAN Database Restore from ASM to File System
On Source Server 1. Backup database 2. Create pfile from spfile 3. Push backup files/pfile to target server On Target Se...
RMAN-06054: media recovery requesting unknown archived log
Resolving error RMAN-06054: media recovery requesting unknown archived log (Doc ID 1900053.1)
Goal Solution References _This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) proce...
Recreate OUI Central Inventory in Real Applications Clusters after Ins-42012 error
Get the Oracle home names and locations of your Oracle homes by looking in the central inventory’s ContentsXML folder at...
Queries to Monitor Datapump Jobs
This post is to cover the queries that could be used to monitor the running Datapump Jobs.Without wasting anytime just p...
Performing Disaster Recovery using RMAN
# Performing Disaster Recovery using RMAN Here I will be explaining how to perform disaster recovery of a database serve...
PDF – www.oracle.com
5-database-tuning-backup-recovery2-133634-zhs.pdf
Password File Failing with: ORA-19505, and ORA-27037
Symptoms Cause Solution References Applies to: Oracle Database – Enterprise Edition – Version 11.2.0.1 and l...
Out of Space Error while still Have Space
Recently I worked on a large database on a X-4 full rack Exadata for a few months. I am using sqlplus command every day ...
Oracle高水位查找方法
1. 高水位的介绍 数据库运行了一段时间，经过一些列的删除、插入、更改操作有些表的高水位线就有可能和实际的表存储数据的情况相差特别多，为了提高检索该表的效率，建议对这些表进行收缩； 1. 查找高水位线的表 1. 表的存储结构; —...
Oracle数据库文件系统迁移到ASM磁盘
1、登陆+ASM实例查看ASM磁盘是否正 [Oracle@rhel5 ~]$ export ORACLE_SID=+ASM [oracle@rhel5 ~]$ sqlplus / as sysdba SQL> select name,...
oracle 数据备份之exp优化
exp/imp简单方便，适用于跨db版本、跨os平台、异地备份等情况，是大家最常用的一种备份方式。 expdp/impdp是10g以后推出的备份方式，其特点就是效率的大幅改善，据eygle报告，impdp相比与传统imp有20倍速度提升,其...
Oracle 快照控制文件(snapshot control file)
听说过Oracle 控制文件，还有快照控制文件这个说法呢？没错，尽管快照控制文件很少被提及，但确实是存在，只不过在使用RMAN时这个快照控制文件被使用。回顾一下 Oracle 控制文件，我们知道控制文件是oracle体系结构中的重要组成部分...
oracle备份恢复之recover database的四条语句区别
1 recover database using backup controlfile2 recover database until cancel3 recover database using backup controlfile un...
Oracle从windows迁移至linux 使用RMAN
实验环境：windows 2008 R2 & RHEL 6.5Oracle版本：11.2.0.4参考文档: 将windows数据库shutdown immediate，然后启动到mount模式下2. 生成pfile文件create ...
Oracle中打开10046 Trace的各种方法
nny71510046是一个Oracle的内部事件(event)，通过设置这个事件可以得到Oracle内部执行系统解析、调用、等待、绑定变量等详细的trace信息，对于分析系统的性能有着非常重要的作用。 设置10046事件的不同级别能得到不...
Oracle SQL Loader: high speed data loading tool
Three things needed in most cases for loading data using sql loader – a) Control file: summary.ctl b) Data file: s...
Oracle slow SQL query against dba_segments solved | DaDBm
July 18, 2014 by Kirill Loifman 3 Comments []()[Tweet]()[]()[[]()6](http://www.dadbm.com/oracle-slow-sql-query-against-d...
Oracle RMAN的格式化串 %t %d %U
比如 backup incremental level 0 database format='LEV0_%d_%t_%U_%s＿%p' %c 备份片的拷贝数 %d 数据库名称 %D 位于该月中的第几天 (DD) %M 位...