Oracle Database Audit FGA using SYSLOG to capture
Oracle Database Audit using SYSLOG to capture Oracle Database can be configured to log events into a database table, XML […]
security
Technology
Technology
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
oracle 12c
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 .
Dataguard, Troubleshooting
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
Backup and Recovery, Cloning, oracle 12c
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
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