ORACLE
BACKUP & RECOVERY(10)
RECOVER MANAGED STANDBY DATABASE INSTANCES ALL is not working on 19.5- Ready RMAN Backup Script To Schedule from Crontab
- Re-execution of Duplicate command on 19c DB fails with RMAN-06054: media recovery requesting unknown archived log
- Datafile Rename with minimal Downtime using RMAN
- RMAN-05502: the target database must be mounted when issuing a DUPLICATE command
- RMAN Backup Shell Script for Oracle
- Managed Recovery Stopped Applying Archives on Standby Database After Enabling Apply Delay on The Primary Archive Process
- Recover Data from Damaged/Corrupted/Inconsistent/Offline/Truncated/Dropped Table While the Database is Offline
- Switch Database to RMAN Image Copy Backup and Switch It Back
- Synchronize | Refresh Standby Database From The Primary Database Using RMAN Incremental Backup
DATAGUARD(10)
- Standby RAC Database Creation Steps 19c
- Duplicate of a standby DB fails with ORA-39511: Start of CRS resource for instance ‘223’ failed with error
- Setup AWR on Standby DB
- Duplicate of a Standby DB fails with ORA-19845
- Script to delete applied archivelogs on a STANDBY database
- Managed Recovery Stopped Applying Archives on Standby Database After Enabling Apply Delay on The Primary Archive Process
- Recover Data from Damaged/Corrupted/Inconsistent/Offline/Truncated/Dropped Table While the Database is Offline
- Switch Database to RMAN Image Copy Backup and Switch It Back
- Synchronize | Refresh Standby Database From The Primary Database Using RMAN Incremental Backup
- Standby Database Switchover | Failover
PERFORMANCE TUNING(15)
- Which is better for gathering statistics? DBMS_STATS or ANALYZE command
- The Pursuit of Ultimate Performance On Non Production Oracle Databases
- SQL Tuning Script
- New Sections in 19c AWR In Comparison With 11g’s AWR
- Speed Up The Data Pump Import In Oracle 19c
- Oracle Resource Manager | Decoding The Enegma Machine
- “virtual circuit wait” Wait Event in AWR on a Dedicated Architecture Server
- Using RULE Based Optimizer When Querying GV$ Views
- dbalarm Script for Monitoring Oracle DB Server is Now Packed With New Features
- Script To Automatic Kill of Long Running Sessions Connecting From Specific Program | Oracle On Linux
ORACLE RAC(16)
- Introduction To a Great Tool: RAC Configuration Audit Tool (RAC & DB Health Check & MAA Check)
- RAC MOST USED COMMANDS
- DBA Diary
- Cleanup Logs on Oracle RAC 12c+
- 18c Remarkable New Features
- 19c Grid Infrastructure Installation when running root.sh with PRKH-1010 : Unable to communicate with CRS services.
- CRS-6706: Oracle Clusterware Release patch level (‘3291738383’) does not match Software patch level (‘724960844’)
- 19c Clusterware fail to Startup due to CRS-41053: checking Oracle Grid Infrastructure for file permission issues CRS-4000
- Maximum Availability Architecture For New Databases
- 12c Remarkable New Features [12.1 & 12.2]
DATABASE SECURITY(6)
- Unable to obtain current patch information due to error: 16000
- Unable to obtain current patch information due to error: 20013 When Starting up a DB Instance
- Auditing Using LogMiner
- The difference between granting direct privileges to a user and granting same privileges within a role
- Hiding table Data from unauthorized Users
- About Default And Password Protected Roles
TROUBLESHOOTING(17)
- ORA-04088: error during execution of trigger ‘SYS.XDB_PI_TRIG’ PLS-00302: component ‘IS_VPD_ENABLED’ must be declared
- ORADEBUG How To
- Upgrade TIMEZONE Version On Oracle 19.5 from 32 to 33 to Fix ORA-39405 During Import
- Sharing the Same Read Only Tablespace between Multiple Databases
- Duplicate of a Database Fails With Error: ORA-17502: ksfdcre:4 Failed to create file
- ora_lms Consuming Lots of Memory and May Lead to Memory Starvation in RAC 19c
- CRS-2974: unable to act on resource
- Major Update to Rebuild Table Script
- ORA-13831: SQL profile or patch name specified is invalid [On 19c]
- “ORA-14451: unsupported feature with temporary table” Error When Creating a PRIVATE TEMPORARY TABLE in 19c
DATABASE UPGRADE(11)
- 19c Remarkable New Features
- ORA-28040: No matching authentication protocol
- Upgrade from 11.2.0.3 to 19c Using GoldenGate [Cookbook]
- Drop Oracle Database
- Upgrade RAC 11.2.0.1 to 11.2.0.3 (Part IV RAC Database Upgrade from 11.2.0.1 to 11.2.03)
- Upgrade from RAC 11.2.0.1 to 11.2.0.3 (Part III Create Standby database being synchronized from the 11.2.0.1 primary DB)
- Upgrade from RAC 11.2.0.1 to 11.2.0.3 (Part II OS preparation, Grid Infrastructure and Database software installation)
- Upgrade RAC 11.2.0.1 to 11.2.0.3 (Part I Software Installation)
- Upgrade from 11.2.0.1 to 11.2.0.3 (Part II Database Upgrade)
- Upgrade from 11.2.0.1 to 11.2.0.3 (Part I Software Installation)