find orphaned ASM filesfind orphaned ASM files
SET VERIFY OFF SET LINESIZE 200 SET SERVEROUTPUT ON SET […]
分类： Oracle
分享Oracle数据库相关教程，文章，知识以及技巧
How to Migrate to different Endian Platform Using Transportable Tablespaces With RMAN (Doc ID 371556.1)How to Migrate to different Endian Platform Using Transportable Tablespaces With RMAN (Doc ID 371556.1)
Goal Starting with Oracle Database 10g, you can transpo […]
Export DataPump and Import DataPump FAQ (Doc ID 556636.1)Export DataPump and Import DataPump FAQ (Doc ID 556636.1)
1.Purpose This Frequently Asked Questions (FAQ) provide […]
Oracle数据库跨操作系统迁移Oracle数据库跨操作系统迁移
Goal To migrate an existing Oracle database (NOT BINARI […]
Data Guard Broker control LOG_ARCHIVE_* parametersData Guard Broker control LOG_ARCHIVE_* parameters
转：Let the Data Guard Broker control LOG_ARCHIVE_* param […]
Renaming or Moving Oracle FilesRenaming or Moving Oracle Files
1.Controlfiles The current location of the controlfiles […]
Merge Into和UpdateMerge Into和Update
一、摘要 merge方法是最简洁，效率最高的方式，在大数据量更新时应该优先使用这种方式。 1. 基本语法 me […]
Performing FRA BackupsPerforming FRA Backups
Oracle Flash Recovery Area (FRA) is a directory that co […]
DataGuard not sync troubleshootingDataGuard not sync troubleshooting
1)Check RECOVERY_FILE_DEST col name for a15 SELECT name […]
How to Check DataGuard is in Sync or Not and resolved gap ?How to Check DataGuard is in Sync or Not and resolved gap ?
Step by Step Process to Resolve gap on the Standby data […]