Create Duplicate Database Using RMAN
Source Database Name is PRODDB Target (duplicate) Database name is MYDB Source Host Name :…
Read moreOracle
Migrate Non-ASM to ASM instance in 12c
Check the status of ASM instance . Check the database version and its status. Check…
Read moreProtected: 2 node RAC with Dataguard Configuration (DGMGRL)
There is no excerpt because this is a protected post.
Read moreHow To Run SQL Tuning Advisor For A Sql_id
When we run SQL tuning advisor against a SQL statement or sql_id, it provides tuning…
Read moreProtected: Fixing Corrupted Grid Home
There is no excerpt because this is a protected post.
Read moreProtected: srvctl related configurations
There is no excerpt because this is a protected post.
Read moreMonitor Standby Database with Lag Time Report
vi /home/oracle/scripts/lag_time_report_and_diskgroup_space.ksh To save the script and change its permissions, follow these steps:1. Save the…
Read moreConfigure MRP in Standby
Add the Target Database TNS entry to the Source's tnsnames.ora file(s) (all of them if…
Read moreDe-configure MRP in Standby
On Source, as Oracle user: On Target, as Oracle user: Hope it helped !! 🙂
Read moreRollForward Standby Database using rman service
Overview: As we are already aware that the rolling forward an physical standby database via…
Read moreProtected: Performance Tuning Scripts.
There is no excerpt because this is a protected post.
Read moreRecover Block Corruption
What is a data block corruption? Data block corruptions occur whenever data is not in…
Read moreResync Standby Database Using RMAN Incremental Backups
Normally in DR setup, the archives from primary shipped to standby and applied there. Suppose…
Read moreRMAN Recovery Catalog in Oracle
RMAN recovery catalog is separate DB/ Server and which will save only the details of…
Read moreROWNUM Pseudocolumn
The ROW_NUMBER built-in SQL function provides superior support for ordering the results of a query.…
Read moreHow to fix ‘ORA-01000 maximum open cursors exceeded’ issue in Oracle database
OPEN_CURSORS specifies the maximum number of open cursors (handles to private SQL areas) a session…
Read moreRMAN Basic Commands
Oracle Recovery Manager (RMAN) satisfies the most pressing demands of performance, manageable backup and recovery,…
Read moreRAC Basic Commands
Check the status of the cluster Check the status of the services on the cluster…
Read moreOracle Dataguard Scripts
1) Information of database (Primary & Standby). 2) To display current status for Physical Standby…
Read moreBuffer & Dictionary Hit Ratio
The Data Buffer Hit Ratio Oracle metric is a measure of the effectiveness of the…
Read moreRelocating enabl database for oracle 19c
Relocating enabl database for oracle 19c 1:- After the upgrade add this hosting members as…
Read moreOratop Utility
Oratop is a text based user interface tool similar to top command for monitoring basic…
Read moreStandby : Unnamed file issue
Sun Jan 1 22:02:11 2022 Errors in file /u01/app/oracle/diag/rdbms/proddb/proddb1/trace/proddb1_pr00_117080.trc: ORA-01111: name for data file 185…
Read moreProtected: CRS-41053: Checking Oracle Grid Infrastructure for file permission issues CRS-4000
There is no excerpt because this is a protected post.
Read moreProtected: Improve Performance of Data Pump Import In Oracle 19c
There is no excerpt because this is a protected post.
Read more