zero downtime
https://dohdatabase.com/2021/09/09/zero-downtime-migration-logical-offline-migration-how-to-minimize-downtime/
Browsing: DBA
Installation of Oracle 19c DBA on Oracle Linux 7.x
Here are the steps for Installation of Oracle 19c DBA on Oracle Linux 7.x https://appsdba.info/wp-content/uploads/2025/07/Install_19c_using_OracleVM_on_OEL7.6.pdf
Best Backup script
cat > run.sh !/bin/sh . /home/oradev/DEVCDB_erpr12.envDATE=date +%m%d%y%H%M find /ub1002/PROD/Backups/PROD_bu_* -mtime +0 -exec rm -f {}…
19.3 to 19.23 upgrade
https://www.mirsayeedhassan.com/patching-oracle-database-19c-release-update-on-april-2024-19-23-p36233263-on-single-instance-database/
How to update remote listener port
alter system set remote_listener=’scanname:1591′ scope=spfile sid=’*’;alter system register srvctl modify scan_listener -p 1591,1521srvctl config scan_listenersrvctl…
DR Sync query
select name,db_unique_name,open_mode,database_role from v$database; sho pdbs; SELECT al.thrd “Thread”,almax “Last Seq Received”,lhmax “Last Seq Applied”,(almax…
Exadata – RMAN incremental backup
https://blog.zeddba.com/2019/05/29/rman-incremental-with-block-change-tracking-demo/ To optimize the performance of incremental backups, the database can offload block filtering to Oracle…
Backup Script
cat > /home/oracle/scripts/rman.sh !/bin/sh DATE=date +%m%d%y%H%M$ORACLE_HOME/bin/rman target / log=/home/oracle/scripts/log/backup_PROD_$DATE.log @/home/oracle/scripts/db.rman cat > /home/oracle/scripts/db.rmanrun {allocate channel…
Restore using timestamp
Find the sequence from v$archived_log and get the timestamp and then restore using RMAN col…
Transportable Tablespace
https://mikedietrichde.com/database-upgrade-hands-on-lab-oracle-18c-and-19c/hands-on-labs-for-upgrade-migration-and-patching/ How to Move a Database Using Transportable Tablespaces (Doc ID 1493809.1)