script to get query for reclaim space from auto extensible datafile
set linesize 1000 pagesize 0 feedback off trimspool on with hwm as ( -- get highest block id from each…
7 years ago
Implementing the Golden Gate plug-in monitor for Oracle Cloud Control 13cR2(13.2.0.0.0)
This note describes the procedure of implementing the GoldenGate plug-in for Oracle Cloud Control 13cR2. These versions are required for…
7 years ago
Upgrade of Oracle 11g RAC database to Oracle 12c RAC DBUA
This document will help you providing guideline to upgrade Oracle 11g RAC to Oracle 12c RAC clusterware and Database .…
7 years ago
ORA-01111: name for data file is unknown – rename to correct file
Error in dataguard alert log/start managed recovery process:- SYS@XXX>alter database recover managed standby database; alter database recover managed standby database…
7 years ago
Active RMAN duplicate clone 12c using section size and compress backupset
Overview of New PULL method The original “push” process is based on image copies.With Oracle Database 12c, a “pull” (or…
7 years ago
rman command reference
##Connecting RMAN############## rman TARGET SYS/target_pwd@target_str # connects in NOCATALOG mode rman TARGET / CATALOG rman/rman@rcat rman TARGET / CATALOG rman/rman@rcat…
7 years ago
Database backup and restore after manual catalog RMAN backup
Database backup and restore after manual catalog RMAN backup 1.Please take backup of primary database ORCL rman target / nocatalog…
7 years ago
ORACLE OPTIMIZER COST CALCULATIONS BASIC OVERVIEW
Cost Calculation for Full table Scan How FTS cost depends on system statistics Gather statistics manually on load: The following…
7 years ago
Undo Advisor help to estimate the undo tablespace size and undo retention to avoid ORA-1555
Prepare by: Nurullah Sharif Scope: Undo Advisor Undo Advisor help to estimate the undo tablespace size and also advise…
7 years ago
How to check and implement best practice for Oracle Database 11g onwards
Author: Saibal Ghosh About author: I am an Oracle professional with twenty plus years of experience and have deep knowledge…
7 years ago