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 […]
Backup and Recovery, Cloning, oracle 12c
Oracle DBA
Backup and Recovery
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
Backup and Recovery, Cloning
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
General Performance tuning
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
General DBA, Troubleshooting
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
General DBA
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
Backup and Recovery, Cloning
Duplicate database until Point in Time recover, using backup location from RAC to single instance
Prepare by: Nurullah Sharif Scope: Point in Time Recovery Duplicate database until Point in Time recover, using backup location.
oracle 12c
CDB and PDB concepts in Oracle 12c
Oracle introduced PDB from 12c to minimize following drawbacks in 11g In 11g,sometimes we need to create numerous databases
cloud control 13c
Step by step Upgrade cloud control from 13cR1 to 13cR2 (13.2.0.0.0)
Prerequisites for Upgrading to Enterprise Manager Cloud Control 13c Release 2 1.First latest PSU patch needs to be applied in
Troubleshooting
Oracle time stamp showing wrong timezone connecting TNS remote
Time stamp problem:- sqlplus system/****@ORCL SQL>alter session set nls_date_format=’dd-mm-yyyy hh:mi:ss’; SQL>select instance_name from v$instance; SQL>select sysdate, current_timestamp,