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 {}…
Browsing: DBA
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)
Direct Read Path
https://weidongzhou.wordpress.com/2016/04/06/direct-path-read-vs-buffer-cache-read/ For direct path read, SGA is bypassed and the blocks are read directly into…
Performance – sql tuning advisor
https://dbaclass.com/article/how-to-run-sql-tuning-advisor-for-a-sql_id/