Posts

RMAN Backup Performance Tuning

  RMAN Backup Performance Tuning Common Reason for RMAN Backup Slowness: ·        Single backup channel ·        Large datafiles ·        Slow storage ·        No incremental backup strategy ·        Compression overhead ·        High I/O usage ·        Archive log accumulation ·        Poor backup destination   Step 1: Check Current RMAN Configuration RMAN> show all; This gives you information about: Parallelism Backup type Compression Retention policy Backup optimization   Step 2: Check RMAN Backup History SET LINESIZE 200 SET PAGESIZE 100 COLUMN START_TIME           FORMAT A20 COLUMN END_TIME             FORM...
Post a Comment
Read more

Oracle Exadata Patching

  Oracle Exadata Patching (Oracle Homes) Task#1: patch the Grid Infrastructure (GI) and Oracle RDBMS homes Target Patches GI & RDBMS Home Patch: p37641958_190000_Linux-x86-64.zip OJVM Patch (if required): p37499406_190000_Linux-x86-64.zip Recommended DB Patches: p34774667_1927000DBRU_Linux-x86-64.zip p34672698_1927000DBRU_Linux-x86-64.zip Step 1: Configure SSH Equivalence from node1. ## dcli -g /u01/stage/target_Nodes -l root -k -s '-o StrictHostKeyChecking=no' ## dcli -g /u01/stage/target_Nodes -l root hostname Step 2: Prepare and Copy Patches ## dcli -g /u01/stage/target_Nodes -l root mkdir -p /u01/stage/GI_DB_OJVM_19c/ dcli -g /u01/stage/target_Nodes -l root -f /u01/stage/GI_DB_OJVM_19c/p37641958_190000_Linux-x86-64.zip -d /u01/stage/GI_DB_OJVM_19c/ ## dcli -g /u01/stage/target_Nodes -l root -f /u01/stage/GI_DB_OJVM_19c/p37499406_190000_Linux-x86-64.zip -d /u01/stage/GI_DB_OJVM_19c/ ## dcli -g /u01/stage/target_Nod...
Post a Comment
Read more

Recover Lost TDE Encryption Wallet Password

  Recover Lost TDE Encryption Wallet Password   We can recover lost TDE Encryption wallet password if the auto-login wallet (cwallet.sso) is available and function. ·        ewallet.p12 – Oracle TDE password protected wallet/keystore file ·        cwallet.sso – Auto login wallet file   Steps for Recovery Step#1: Take backup of current DB wallet files ·        cd $TNS_ADMIN/db_wallet ·        cp ewallet.p12 ewallet.p12_bak ·        cp cwallet.sso cwallet.sso_bak   Step#2: Create a new TDE wallet/keystore ·        Sql> administer key management create keystore '/u01/app/oracle/db_temp_wallet' identified by "<new_password>";   Step#3: Merge existing keys into new wallet. ·        Sql> administer key management mer...
Post a Comment
Read more

Migration to Cloud

  Migration to Cloud (OCI / Hybrid)   ·       Lift-and-Shift RMAN backup to Object Storage and restore on OCI DBCS Oracle Zero Downtime Migration (ZDM) Data Guard setup to OCI followed by switchover   ·       Modernization Migration     Oracle Zero Downtime Migration (ZDM)   ·        Install ZDM on a ZDM host (separate from source and target) unzip zdm21.x.zip cd zdm21.x ./zdminstall.sh service ORAHOME=/u01/zdmhome ORABASE=/u01/zdmbase PORT=8895   ·        Initialize ZDM /u01/zdmhome/bin/zdmservice start   ·        Run pre-migration checks zdmcli migrate database -sourcenode    source-server -sourcedb       ORCL -srcauth        zdmauth -srcarg1        user:oracle ...
Post a Comment
Read more