Oracle Notes

ASM

ASM Commands and Queries

How to edit files with names starting with +

Auditing

Unified Audit Trail Queries

Developing a Unified Audit Policy

Standard Audit Trail Queries

Fine-Grained Audit Trail Example

Purging the Audit Trail

Database Copy / Clone / Restore

RMAN Duplicate Active Database

Duplicate Database Using DBCA

RMAN Restore db to New Server

Data Guard

Create Standby Database Example

Create Standby Database Using DBCA

Monitoring Redo Apply

Checking Standby Synchronization

Open Standby Database with Delay to Point in Time

Resolving Gaps

Roll Forward Standby Using Recover From Service

Switchover / Switchback Example

DG Broker – Fix ORA-16792 Inconsistent Properties

Data Pump

Data Pump Syntax

Filtering Objects and Data

Data Pump Examples

Interactive Command Line Mode

Failed Job Cleanup

Network Import

Export from Standby Database

Maintenance Tasks

Backing Up OraInventory

Managing Redo Log Files in a Data Guard Configuration

Moving Spfile to a Different Disk Group

Recreating Default Temp Tablespace

Relocating Control Files

Multitenant

Maintaining Multitenant Databases

Performance

Sql Performance Monitoring

Monitoring SGA and PGA Usage

Resource Manager Queries

Monitoring Autotask Jobs

Exporting Extended Statistics

RMAN

Basic RMAN Commands

RMAN Multitenant Examples

Cold Backup Example

Hot Backup Example

RMAN Restore db to New Server

Monitoring RMAN Activity

Securing Databases

Creating and Using Wallets

SQL

Database Links

DBMS_METADATA Examples

Flashback Database Example

Flashback Query

Sql Examples

SQL Loader

SQL Loader Examples

Sqlplus

Common Sqlplus Tasks

Identify object in a corrupt block

Monitoring Archivelog and Undo Usage

Monitoring Database Activity

List Client Version for Sessions

Running sqlplus from a Batch File

Unix

How to edit files with names starting with +

Common Unix Tasks

Nohup, fg, bg, and disown

Unix Command History Recall

Dos2Unix file conversion