https://www.linkedin.com/pulse/restoring-oracle-database-new-server-sajjad-razmi?forceNoSplash=true
http://www.thegeekstuff.com/2014/11/oracle-rman-restore/
http://damir-vadas.blogspot.com/2010/02/how-to-find-correct-scn.html
Upgrade GI and RDBMS
https://asanga-pradeep.blogspot.com/2017/09/upgrading-rac-from-11204-to-12201-grid.html
Incrementally updated image copy backups with RMAN
SQL Plan Management
https://blogs.oracle.com/optimizer/upgrade-to-oracle-database-12c-and-avoid-query-regression
https://www.oracle.com/technetwork/database/bi-datawarehousing/twp-sql-plan-mgmt-19c-5324207.pdf
https://blogs.oracle.com/optimizer/how-to-use-sql-plan-management
http://www.oracle-wiki.net/startdocshowtomanagetheevolutionofbaselines
https://oracle-base.com/articles/11g/sql-plan-management-11gr1
http://www.oracle.com/technetwork/database/bi-datawarehousing/twp-sql-plan-mgmt-12c-1963237.pdf
https://blogs.oracle.com/optimizer/sql-plan-management-part-1-of-4-creating-sql-plan-baselines
https://blogs.oracle.com/optimizer/sql-plan-management-part-2-of-4-spm-aware-optimizer
https://blogs.oracle.com/optimizer/sql-plan-management-part-3-of-4:-evolving-sql-plan-baselines
https://blogs.oracle.com/optimizer/sql-plan-management-part-4-of-4:-user-interfaces-and-other-features
Cluster Health Monitor
http://facedba.blogspot.com/2013/09/troubleshooting-oracle-clusterware.html
https://www.linkedin.com/pulse/move-recreate-oracle-12c-cluster-health-monitor-chm-repository-v-k/
http://surachartopun.com/2011/08/what-is-oracrf-in-11202-rac.html
OCR and Voting disks
https://www.linkedin.com/pulse/voting-disks-oracle-11gr2-rac-ankit-ashok-aggarwal/
https://www.thegeekdiary.com/how-to-move-ocr-vote-disk-file-asm-spile-to-new-diskgroup/
Drop a Database
http://dbaworkshop.blogspot.com/2010/09/how-to-drop-database-from-sqlplus.html
https://dbaclass.com/article/drop-database-in-oracle-rac/
Keep RMAN Backupsets
http://www.online-database.eu/index.php/recovery-manager-rman/85-keep-rman-backupsets
https://learnwithme11g.wordpress.com/2011/06/20/rman-backups-with-no-expire-option/
https://gavinsoorma.com/2010/04/rman-keep-forever-keep-until-time-and-force-commands/
Cataloging RMAN Backupsets
https://jhdba.wordpress.com/2010/04/15/cataloging-rman-backups/
https://adityanathoracledba.com/2015/08/06/rman-restore-database-fails-with-ora-19693-backup-piece-xxx-already-included/
RMAN Archived Redo Logs
http://www.dba-oracle.com/t_rman_32_backup_redo_log_files.htm
RMAN Commands for (Parallel) Backup and Deletion
http://oradbatips.blogspot.com/2006/12/tip-13-idea-rman-format-for-backup.html
http://www.thegeekstuff.com/2015/01/delete-oracle-rman-backup/
http://www.morganslibrary.org/reference/rman.html
https://oraclehandson.wordpress.com/2008/01/10/parallel-backup-using-rman-in-rac-environment/
http://www.oraclenext.com/2014/05/rman-backup-performance.html
About FRA
http://satya-dba.blogspot.com/2009/02/flash-recovery-area.html
NID Utility in Oracle
http://satya-dba.blogspot.com/2009/01/nid-utility.html
Virtualbox Scripts to duplicate Database
https://blog.dbi-services.com/scripts-to-duplicate-an-oracle-database-virtual-mach-step-oneine/
Oracle RAC Installation
https://balaoracledba.com/2013/12/23/step-by-step-install-of-oracle-rac-11gr2-on-oel-6-5-on-oracle-vm-virtual-box/
http://shannura.com/archives/2226261108_rac12c_04.html
Database Duplication
http://oracleinaction.com/duplicate-db-no-db-conn/
http://oracleinaction.com/duplicate-db-conn-db/
http://nelsonjaviermartinezacosta.blogspot.com/2009/09/rman-duplicating-databases-and.html
https://shivanandarao-oracle.com/2012/04/28/duplicating-database-without-connecting-to-target-database-or-catalog-database-in-oracle-11g/
http://linuxtechres.blogspot.com/2012/05/how-to-use-rman-backup-to-duplicate.html
http://emrebaransel.blogspot.com/2008/11/recover-database-until.html
http://oracletechdba.blogspot.com/2015/05/rman-04006-error-from-auxiliary.html
http://oracledbabhuvan.blogspot.com/2011/12/resetunset-oracle-parameters.html
ASMCMD & ASM
http://satya-dba.blogspot.com/2010/02/asmcmd-10g-11g.html
https://bdrouvot.wordpress.com/2013/02/15/asm-io-statistics-utility/
https://bdrouvot.wordpress.com/2013/10/04/asm-metrics-are-a-gold-mine-welcome-to-asm_metrics-pl-a-new-utility-to-extract-and-to-manipulate-them-in-real-time/
http://orababy.blogspot.com/2013/09/asm-io-queries.html
Database Block Corruption and Database Verfiication
https://www.thegeekdiary.com/oracle-sql-script-to-report-the-list-of-files-stored-in-asm-and-currently-not-opened/
http://rasolano.blogspot.com/2015/09/script-to-generate-dbverify-for-all.html
https://blog.toadworld.com/data-block-recovering-process-using-normal-redundancy
https://blog.toadworld.com/2017/12/01/block-corruption-in-an-oracle-database
https://stefanpanek.wordpress.com/2016/07/07/asm-corrupted-metadata-block-check-via-amdu-kfed-part-1/
What is GPnP Profile or ASM Spfile discovery
http://oracleinaction.com/gpnp-profile/
https://airydba.wordpress.com/2016/11/29/gpnp-grid-plug-n-play-profile-in-oracle-11g-r212c-rac/
Controlfile Backup and Multiplex
https://www.perftuning.com/blog/how-to-multiplex-the-oracle-controlfile-in-asm/
https://juniororacledba.wordpress.com/tag/rman-controlfile-backup/
http://www.dba-oracle.com/t_rman_29_backup_control_file.htm
http://www.orafaq.com/maillist/oracle-l/2005/02/03/0236.htm
https://www.perftuning.com/blog/how-to-multiplex-the-oracle-controlfile-in-asm/
http://www.dba-oracle.com/t_11g_new_asm_disk_repair.htm
Standby Database
https://www.red-gate.com/simple-talk/sql/oracle/rolling-forward-a-physical-standby-database-using-the-recover-command/
**** https://taliphakanozturken.wordpress.com/tag/data-guard-protection-modes/ ****
http://neeraj-dba.blogspot.com/2012/05/difference-between-lgwr-sync-and-async.html
https://docs.oracle.com/cd/E19421-01/820-5016/fnrfv/index.html
http://onlineappsdba.com/index.php/2009/08/19/standby-redo-logs-srl-in-standby-database/
http://dbaora.com/configure-physical-standby-database-oracle-database-11g-release-2-11-2/
http://www.oracledistilled.com/oracle-database/high-availability/data-guard/creating-a-physical-standby-using-rman-duplicate-from-active-database/
https://www.pythian.com/blog/creating-a-physical-standby/
https://avdeo.com/2011/05/09/creating-standby-database-using-active-duplication-oracle-database-11g/
https://oracleinstall.wordpress.com/2012/04/15/step-by-step-guide-on-creating-physical-standby-using-rmanasm/
http://www.oracle-ckpt.com/unnamed-file-in-standby-after-adding-new-file-to-primary-ora-01111-ora-01110-ora-01157/
https://imbibhuti.wordpress.com/2013/10/15/fal_client-and-fal_server-parameters/
https://farhatdba.wordpress.com/2014/09/15/spfile-in-rac-asm-created-or-restored-under-db_unknown-directory/
https://gemsofprogramming.wordpress.com/2014/03/13/building-a-single-instance-physical-standby-for-a-rac-primary-or-active-dataguard-save-my-daily-data/
http://ioracle-dba.blogspot.com/2017/09/12c-copy-password-file-from-primary-asm.html
https://jameshuangsj.wordpress.com/2017/03/01/no-standby-redo-logfiles-available-for-t-1/
'DB_UNKNOWN' directory was created when using asmcmd pwcopy (Doc ID 2329386.1)
https://blogs.oracle.com/optimizer/how-to-use-sql-plan-management
http://www.oracle-wiki.net/startdocshowtomanagetheevolutionofbaselines
https://oracle-base.com/articles/11g/sql-plan-management-11gr1
http://www.oracle.com/technetwork/database/bi-datawarehousing/twp-sql-plan-mgmt-12c-1963237.pdf
https://blogs.oracle.com/optimizer/sql-plan-management-part-1-of-4-creating-sql-plan-baselines
https://blogs.oracle.com/optimizer/sql-plan-management-part-2-of-4-spm-aware-optimizer
https://blogs.oracle.com/optimizer/sql-plan-management-part-3-of-4:-evolving-sql-plan-baselines
https://blogs.oracle.com/optimizer/sql-plan-management-part-4-of-4:-user-interfaces-and-other-features
Cluster Health Monitor
http://facedba.blogspot.com/2013/09/troubleshooting-oracle-clusterware.html
https://www.linkedin.com/pulse/move-recreate-oracle-12c-cluster-health-monitor-chm-repository-v-k/
http://surachartopun.com/2011/08/what-is-oracrf-in-11202-rac.html
OCR and Voting disks
https://www.linkedin.com/pulse/voting-disks-oracle-11gr2-rac-ankit-ashok-aggarwal/
https://www.thegeekdiary.com/how-to-move-ocr-vote-disk-file-asm-spile-to-new-diskgroup/
Drop a Database
http://dbaworkshop.blogspot.com/2010/09/how-to-drop-database-from-sqlplus.html
https://dbaclass.com/article/drop-database-in-oracle-rac/
Keep RMAN Backupsets
http://www.online-database.eu/index.php/recovery-manager-rman/85-keep-rman-backupsets
https://learnwithme11g.wordpress.com/2011/06/20/rman-backups-with-no-expire-option/
https://gavinsoorma.com/2010/04/rman-keep-forever-keep-until-time-and-force-commands/
Cataloging RMAN Backupsets
https://jhdba.wordpress.com/2010/04/15/cataloging-rman-backups/
https://adityanathoracledba.com/2015/08/06/rman-restore-database-fails-with-ora-19693-backup-piece-xxx-already-included/
RMAN Archived Redo Logs
http://www.dba-oracle.com/t_rman_32_backup_redo_log_files.htm
RMAN Commands for (Parallel) Backup and Deletion
http://oradbatips.blogspot.com/2006/12/tip-13-idea-rman-format-for-backup.html
http://www.thegeekstuff.com/2015/01/delete-oracle-rman-backup/
http://www.morganslibrary.org/reference/rman.html
https://oraclehandson.wordpress.com/2008/01/10/parallel-backup-using-rman-in-rac-environment/
http://www.oraclenext.com/2014/05/rman-backup-performance.html
About FRA
http://satya-dba.blogspot.com/2009/02/flash-recovery-area.html
NID Utility in Oracle
http://satya-dba.blogspot.com/2009/01/nid-utility.html
Virtualbox Scripts to duplicate Database
https://blog.dbi-services.com/scripts-to-duplicate-an-oracle-database-virtual-mach-step-oneine/
Oracle RAC Installation
https://balaoracledba.com/2013/12/23/step-by-step-install-of-oracle-rac-11gr2-on-oel-6-5-on-oracle-vm-virtual-box/
http://shannura.com/archives/2226261108_rac12c_04.html
Database Duplication
http://oracleinaction.com/duplicate-db-no-db-conn/
http://oracleinaction.com/duplicate-db-conn-db/
http://nelsonjaviermartinezacosta.blogspot.com/2009/09/rman-duplicating-databases-and.html
https://shivanandarao-oracle.com/2012/04/28/duplicating-database-without-connecting-to-target-database-or-catalog-database-in-oracle-11g/
http://linuxtechres.blogspot.com/2012/05/how-to-use-rman-backup-to-duplicate.html
http://emrebaransel.blogspot.com/2008/11/recover-database-until.html
http://oracletechdba.blogspot.com/2015/05/rman-04006-error-from-auxiliary.html
http://oracledbabhuvan.blogspot.com/2011/12/resetunset-oracle-parameters.html
ASMCMD & ASM
http://satya-dba.blogspot.com/2010/02/asmcmd-10g-11g.html
https://bdrouvot.wordpress.com/2013/02/15/asm-io-statistics-utility/
https://bdrouvot.wordpress.com/2013/10/04/asm-metrics-are-a-gold-mine-welcome-to-asm_metrics-pl-a-new-utility-to-extract-and-to-manipulate-them-in-real-time/
http://orababy.blogspot.com/2013/09/asm-io-queries.html
Database Block Corruption and Database Verfiication
https://www.thegeekdiary.com/oracle-sql-script-to-report-the-list-of-files-stored-in-asm-and-currently-not-opened/
http://rasolano.blogspot.com/2015/09/script-to-generate-dbverify-for-all.html
https://blog.toadworld.com/data-block-recovering-process-using-normal-redundancy
https://blog.toadworld.com/2017/12/01/block-corruption-in-an-oracle-database
https://stefanpanek.wordpress.com/2016/07/07/asm-corrupted-metadata-block-check-via-amdu-kfed-part-1/
What is GPnP Profile or ASM Spfile discovery
http://oracleinaction.com/gpnp-profile/
https://airydba.wordpress.com/2016/11/29/gpnp-grid-plug-n-play-profile-in-oracle-11g-r212c-rac/
Controlfile Backup and Multiplex
https://www.perftuning.com/blog/how-to-multiplex-the-oracle-controlfile-in-asm/
https://juniororacledba.wordpress.com/tag/rman-controlfile-backup/
http://www.dba-oracle.com/t_rman_29_backup_control_file.htm
http://www.orafaq.com/maillist/oracle-l/2005/02/03/0236.htm
https://www.perftuning.com/blog/how-to-multiplex-the-oracle-controlfile-in-asm/
http://www.dba-oracle.com/t_11g_new_asm_disk_repair.htm
Standby Database
https://www.red-gate.com/simple-talk/sql/oracle/rolling-forward-a-physical-standby-database-using-the-recover-command/
**** https://taliphakanozturken.wordpress.com/tag/data-guard-protection-modes/ ****
http://neeraj-dba.blogspot.com/2012/05/difference-between-lgwr-sync-and-async.html
https://docs.oracle.com/cd/E19421-01/820-5016/fnrfv/index.html
http://onlineappsdba.com/index.php/2009/08/19/standby-redo-logs-srl-in-standby-database/
http://dbaora.com/configure-physical-standby-database-oracle-database-11g-release-2-11-2/
http://www.oracledistilled.com/oracle-database/high-availability/data-guard/creating-a-physical-standby-using-rman-duplicate-from-active-database/
https://www.pythian.com/blog/creating-a-physical-standby/
https://avdeo.com/2011/05/09/creating-standby-database-using-active-duplication-oracle-database-11g/
https://oracleinstall.wordpress.com/2012/04/15/step-by-step-guide-on-creating-physical-standby-using-rmanasm/
http://www.oracle-ckpt.com/unnamed-file-in-standby-after-adding-new-file-to-primary-ora-01111-ora-01110-ora-01157/
https://imbibhuti.wordpress.com/2013/10/15/fal_client-and-fal_server-parameters/
https://farhatdba.wordpress.com/2014/09/15/spfile-in-rac-asm-created-or-restored-under-db_unknown-directory/
https://gemsofprogramming.wordpress.com/2014/03/13/building-a-single-instance-physical-standby-for-a-rac-primary-or-active-dataguard-save-my-daily-data/
http://ioracle-dba.blogspot.com/2017/09/12c-copy-password-file-from-primary-asm.html
https://jameshuangsj.wordpress.com/2017/03/01/no-standby-redo-logfiles-available-for-t-1/
'DB_UNKNOWN' directory was created when using asmcmd pwcopy (Doc ID 2329386.1)
Oracle 19c Active Data Guard-DML Redirection
How to Speed up and Troubleshooting MRP (Log Apply Rate of a Standby Database) Stuck Issues
1. Increase
Database Management Types
http://www.ludovicocaldara.net/dba/oracle-rac-and-policy-managed-databases/
http://en.community.dell.com/techcenter/enterprise-solutions/w/oracle_solutions/1418.how-to-convert-admin-managed-database-to-policy-managed-database-in-oracle-11g-r2
SCAN and Local Listeners
http://www.oracle.com/technetwork/database/clustering/overview/scan-129069.pdf
http://www.dbas-oracle.com/2013/08/SCAN-NAME-SCAN-VIP-SCAN-Listener-Node-VIP-Local-Listener-Remote-Listener-RAC.html
http://www.dbas-oracle.com/2013/03/how-virtual-ip-vip-works-in-rac.html
https://stackoverflow.com/questions/30219464/oracle-rac-vip-and-scan-ips
http://dnccfg.blogspot.com/2012/09/single-client-access-name-scan-in.html
https://www.orskl.com/how-does-scan-listener-works-in-oracle-rac-11gr2/
http://ermanarslan.blogspot.com/2014/02/rac-listener-configuration-in-oracle.html
http://blog.yannickjaquier.com/oracle/oracle-restart-and-listener-configuration.html
http://www.dba-oracle.com/t_sample_listener_ora_files.htm
http://oracleappsdbaexpert.blogspot.com/2016/08/how-to-start-and-stop-local-listener.html
https://community.oracle.com/thread/4049977
How Shutdown and Start Oracle RAC Database
http://www.dbas-oracle.com/2013/07/Shutdown-and-Start-Oracle-Real-Application-Clusters-RAC-Database.html
Switch logfile vs Archive log current
http://www.dba-oracle.com/t_alter_system_switch_logfile_vs_alter_system_archivelog_current.htm
Purging SYSAUX tablespace
http://www.techpaste.com/2017/03/cleaning-oracle-sysaux-tablespace-usage/
http://www.oracle-scn.com/purging-statistics-from-the-sysaux-tablespace/
https://www.testwo.com/blog/3643
http://oracle-mssql-dba.blogspot.com/2014/08/oracle-11gsysaux-tablespace-purging.html
https://grepora.com/2017/11/08/orphan-awr-data-consuming-sysaux-space/
https://community.oracle.com/thread/379026
https://mikedietrichde.com/2017/07/19/first-ru-oracle-12-2-0-1-available/?fb_action_ids=1478713115520046&fb_action_types=news.publisheshttp://www.dbas-oracle.com/2013/08/SCAN-NAME-SCAN-VIP-SCAN-Listener-Node-VIP-Local-Listener-Remote-Listener-RAC.html
http://www.dbas-oracle.com/2013/03/how-virtual-ip-vip-works-in-rac.html
https://stackoverflow.com/questions/30219464/oracle-rac-vip-and-scan-ips
http://dnccfg.blogspot.com/2012/09/single-client-access-name-scan-in.html
https://www.orskl.com/how-does-scan-listener-works-in-oracle-rac-11gr2/
http://ermanarslan.blogspot.com/2014/02/rac-listener-configuration-in-oracle.html
http://blog.yannickjaquier.com/oracle/oracle-restart-and-listener-configuration.html
http://www.dba-oracle.com/t_sample_listener_ora_files.htm
http://oracleappsdbaexpert.blogspot.com/2016/08/how-to-start-and-stop-local-listener.html
https://community.oracle.com/thread/4049977
How Shutdown and Start Oracle RAC Database
http://www.dbas-oracle.com/2013/07/Shutdown-and-Start-Oracle-Real-Application-Clusters-RAC-Database.html
Switch logfile vs Archive log current
http://www.dba-oracle.com/t_alter_system_switch_logfile_vs_alter_system_archivelog_current.htm
Purging SYSAUX tablespace
http://www.techpaste.com/2017/03/cleaning-oracle-sysaux-tablespace-usage/
http://www.oracle-scn.com/purging-statistics-from-the-sysaux-tablespace/
https://www.testwo.com/blog/3643
http://oracle-mssql-dba.blogspot.com/2014/08/oracle-11gsysaux-tablespace-purging.html
https://grepora.com/2017/11/08/orphan-awr-data-consuming-sysaux-space/
https://community.oracle.com/thread/379026
Oracle Enterprise Manager Cloud Control
https://oracle-base.com/articles/13c/cloud-control-13cr1-installation-on-oracle-linux-6-and-7
https://oracle-base.com/articles/12c/enterprise-manager-database-express-12cr1
https://gokhanatil.com/2016/08/installing-em13c-agents-on-microsoft-windows-target-hosts.html
http://emdeepaksharma.com/2017/06/oem13c-the-page-has-expired-click-ok-to-continue/
http://jcraju.blogspot.com/2019/04/13c-oem-javasqlsqlexception-connection.html
http://emdeepaksharma.com/2017/06/oem13c-the-page-has-expired-click-ok-to-continue/
http://jcraju.blogspot.com/2019/04/13c-oem-javasqlsqlexception-connection.html
Materilaized Views
https://technology.amis.nl/2014/08/15/materialized-views-fast-refresh-complete-refresh-recreate/
https://technology.amis.nl/2014/08/11/oracle-restart-to-autostart-your-oracle-database-listener-and-services-on-linux/
https://mikedietrichde.com/2017/10/11/utlrp-sql-drecease-resource-consumption/
https://uhesse.com/2009/05/04/incremental-backups-with-block-change-tracking-recover-copy/
https://mikedietrichde.com/page/21/
http://dbaworkshop.blogspot.com/2010/04/11gr2-how-to-remove-file-from-asm.html
http://www.dba-oracle.com/t_monitor_rman_script.htm
http://dulalhasandba.blogspot.com/2010/04/resolve-problem-ora-00031-session.html
http://momendba.blogspot.com/2007/07/closer-look-at-sysdba-and-dba.html
http://www.oraclenext.com/2014/11/ora-12514-during-switchover-to-standby.html
http://oracleinaction.com/add-instance-manual/
http://www.dba-oracle.com/t_dbms_qopatch.htm
https://blog.dbi-services.com/oracle-system-schemas-vs-created-users/
http://arup.blogspot.com/2008/09/magic-of-block-change-tracking.html
https://navneetupnejadba.wordpress.com/2010/09/10/recoverable/
https://pavandba.com/2011/07/12/how-to-deleteremove-non-executing-datapump-jobs/
http://neeraj-dba.blogspot.com/2011/04/differences-between-table-view-synonym.html
http://blog.ronnyegner-consulting.de/2011/04/11/ora-27154-postwait-create-failed-ora-27301-os-failure-message-no-space-left-on-device-when-starting-asm-or-database-instance/
https://oracle-base.com/articles/11g/database-replay-11gr1#capture_using_api
https://www.linuxidc.com/Linux/2016-03/129103.htm (Oracle snapshot standby scheduler jobs)
http://oracle-help.com/oracle-19c/installing-oracle-database-19c-with-github-repos/
http://dirknachbar.blogspot.com/2016/03/alter-user-rename-half-official-option.html
http://www.snapdba.com/2013/03/incrementally-updated-image-copy-backups-with-rman/#.XaVzxUYzaUn
https://oracle-base.com/articles/misc/incrementally-updated-image-copy-backups
https://grepora.com/2017/07/19/sqlnet-ora-parameter-sqlnet-expire_time/
https://prashantatridba.wordpress.com/tag/sqlnet-expire_time/
https://sqljana.wordpress.com/2018/04/25/oracle-find-the-total-size-of-all-of-your-clob-blob-columns-in-all-tables/
https://oracle-base.com/articles/8i/dropping-columns
https://oracle-base.com/articles/misc/reclaiming-unused-space
https://oracle-base.com/articles/misc/alter-table-shrink-space-online
https://oracle-base.com/articles/misc/autonomous-health-framework-ahf
https://oracle-patches.com/en/databases/oracle/3254-troubleshooting-and-tuning-lob-segment-performance-in-oracle
https://satyasmart23.wordpress.com/2015/10/29/how-to-check-the-progress-of-expdpimpdp/
http://dbtricks.com/?p=198
https://dbaclass.com/article/ora-02020-many-database-links-use/
https://getsomeoracle.wordpress.com/2015/11/25/prerequisite-check-checkactivefilesandexecutables-failed/
https://mikedietrichde.com/2016/04/20/data-pump-exclude-stats-differently-for-tts-and-ftex/
Fix ROOT.SH problem in GRID installation 11gR2
https://fatdba.com/2016/01/06/oracle-gi-11-2-installation-on-rhel-7-error-ohasd-failed-to-start-failed-to-start-the-clusterware-last-20-lines-of-the-alert-log-follow-ohasd-failed-to-start-at-u01app11-2-0gridcrsinstallr/
http://oracledatabasegrid.blogspot.com/2015/05/rootsh-script-failed-on-first-node.html
https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=192936547457117&id=1360798.1&_afrWindowMode=0&_adf.ctrl-state=1c9kkojxmp_45
OS Kernel Parameters for Oracle DB
http://www.dba-oracle.com/oracle10g_tuning/t_ios_kernel_parameters.htm
https://www.orskl.com/why-are-kernel-parameters-critical-for-oracle-database/
https://oradbps.wordpress.com/2016/02/09/kernel-parameters-for-oracle-db/
https://www.orskl.com/why-should-we-configure-limits-conf-for-oracle-database/
Oracle RAC Highly Available IP (HAIP) for the Cluster Interconnect
http://www.dba-oracle.com/t_rac_tuning_haip.htm
http://oracleinaction.com/haip/
Dedicated vs Shared Servers
http://www.dba-oracle.com/t_mts_multithreaded_servers_shared.htm
http://guyharrison.squarespace.com/blog/2009/9/18/mts-amm-bulk-collect-trouble.html
https://gerardnico.com/db/oracle/dispatcher
Shared Pool
http://oracleinaction.com/shared-pool-arch/
https://www.orskl.com/can-you-really-flush-oracle-shared_pool/
Services
http://oracleinaction.com/services/
https://jarneil.wordpress.com/2010/11/05/11gr2-database-services-and-instance-shutdown/
http://db.geeksinsight.com/tools-scripts/srvctl-command-for-service/
http://ilmarkerm.blogspot.com/2012/05/scipt-to-automatically-move-rac-11gr2.html
http://oracledbabhuvan.blogspot.com/2011/11/relocate-service-in-rac.html
https://easyoradba.com/2012/01/29/transparent-application-failover-taf-service-in-oracle-rac-11gr2/
https://www.thegeekdiary.com/how-to-failover-a-service-during-instance-shutdown-using-srvctl/
http://db.geeksinsight.com/tools-scripts/srvctl-command-for-service/
OCP Upgrade to 12c OCP
http://www.bobbydurrettdba.com/2014/08/05/passed-ocp-12c-test/
https://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=5001&get_params=p_exam_id:1Z0-060
https://blogs.oracle.com/certification/upgrade-your-dba-ocp-certification-to-oracle-database-12c-with-one-exam
https://www.amazon.com/Upgrade-Oracle-Database-Guide-1Z0-060/dp/0071819975/ref=sr_1_1?ie=UTF8&qid=1407273046&sr=8-1&keywords=Alapati+12c+upgrade
https://www.amazon.com/Upgrade-Oracle-Database-Guide-1Z0-060/dp/0071819975
https://www.amazon.com/Study-Guide-1Z0-060-Database-Certification/dp/1941404022
ERRORS and WARNINGS
Fix for ORA-03113
https://emarcel.com/fix-ora-03113-end-of-file-on-communication-channel/
Fix for CRS-5017 ORA-01017
https://easyoradba.com/2015/08/21/oracle-crs-fails-with-crs-5017-ora-01017-what-to-do-when-even-in-init-mode-you-cannot-bring-up-crs/
Fix for CRS-5017 ORA-01017
https://easyoradba.com/2015/08/21/oracle-crs-fails-with-crs-5017-ora-01017-what-to-do-when-even-in-init-mode-you-cannot-bring-up-crs/
Archivelogs Deletion Policy and RMAN-08591: WARNING
http://www.vitalsofttech.com/archivelog-deletion-policy-archivelog-failover-in-11g/
http://www.acehints.com/2015/06/rman-08591-warning-invalid-archived-log.html
https://martincarstenbach.wordpress.com/2009/10/08/archivelog-retention-policy-changes-in-rman-11g/
http://oraclesivaram.blogspot.com/2016/06/rman-08591-warning-invalid-archived-log.html
ORA-19809: limit exceeded for recovery files – db_recovery_file_dest_size and archiver error
https://jhdba.wordpress.com/2008/07/16/25/
I was facing the exact same issue. I tried the options mentioned above as well, to no avail.
Finally, as suggested by a friend, disabling the db_recovery_file_dest solved the issue for me.
SQL> alter system set db_recovery_file_dest='' scope=both;
ORA-17628, ORA-19505 during RMAN DUPLICATE FROM ACTIVE
http://www.vitalsofttech.com/archivelog-deletion-policy-archivelog-failover-in-11g/
http://www.acehints.com/2015/06/rman-08591-warning-invalid-archived-log.html
https://martincarstenbach.wordpress.com/2009/10/08/archivelog-retention-policy-changes-in-rman-11g/
http://oraclesivaram.blogspot.com/2016/06/rman-08591-warning-invalid-archived-log.html
ORA-19809: limit exceeded for recovery files – db_recovery_file_dest_size and archiver error
https://jhdba.wordpress.com/2008/07/16/25/
I was facing the exact same issue. I tried the options mentioned above as well, to no avail.
Finally, as suggested by a friend, disabling the db_recovery_file_dest solved the issue for me.
SQL> alter system set db_recovery_file_dest='' scope=both;
ORA-17628, ORA-19505 during RMAN DUPLICATE FROM ACTIVE
http://m.blog.itpub.net/205377/viewspace-2072988/
https://thepacifieddba.wordpress.com/2017/09/17/ora-12012ora-20001-and-ora-06512-from-oraat_os_opt_sy_xxx/
https://thepacifieddba.wordpress.com/2017/09/17/ora-12012ora-20001-and-ora-06512-from-oraat_os_opt_sy_xxx/
OPatch failed with error code 41
http://dbaclass.com/article/prerequisite-check-checkactivefilesandexecutables-failed/
GUI Display Error
http://blog.mclaughlinsoftware.com/2016/06/01/cant-display-256-colors/
GUI Display Error
http://blog.mclaughlinsoftware.com/2016/06/01/cant-display-256-colors/
Target database memory exceed available shared memory
http://rashiddba.blogspot.com/2013/12/target-database-memory-exceed-available.htmlConfiguring the core file name pattern in Linux
Flex ASM feature in oracle 12c
https://www.oracle.com/technetwork/articles/database/asm-odb12c-enhancements-2206102.html
https://www.oracle.com/technetwork/articles/database/flexasm-flexcluster-benefits-odb12c-2177371.html
https://shivanandarao-oracle.com/2017/09/09/flex-asm-configuration-in-oracle-12c/
https://emilianofusaglia.net/tag/flex-asm/
https://docs.oracle.com/en/database/oracle/oracle-database/18/ostmg/asmcmd-filterdriver-commands.html#GUID-C23690C6-0DE6-42A7-B9C7-4FB1FF13ED64
MAX_STRING_SIZE Parameter In Oracle 12c
http://dbaclass.com/article/max_string_size-parameter-oracle-12c/
https://oracle-base.com/articles/12c/extended-data-types-12cR1
https://docs.oracle.com/database/121/REFRN/GUID-D424D23B-0933-425F-BC69-9C0E6724693C.htm#REFRN10321
Multitenant Database 12c
https://blog.dbi-services.com/can-you-open-pdbseed-read-write/
http://oracleinaction.com/12c-connect-pdbs-with-same-name/
https://www.dbarj.com.br/en/2018/10/the-best-upcoming-features-in-oracle-database-19c/
Management of a tablespace from MANUAL to AUTO
Data Guard Broker
https://martincarstenbach.wordpress.com/2012/06/29/how-to-set-up-data-guard-broker-for-rac/
https://uhesse.com/2016/05/18/another-reason-why-you-should-use-the-data-guard-broker-for-your-oracle-standby/
https://uhesse.com/2014/10/14/let-the-data-guard-broker-control-log_archive_-parameters/
https://dbaclass.com/article/setup-dataguard-broker-configuration-dg-broker/
http://nnawaz.blogspot.com/2016/01/12c-dataguard-broker-setup-error-ora.html
Database Design
https://www.codeproject.com/Articles/359654/11-important-database-designing-rules-which-I-fo-2
https://www.red-gate.com/simple-talk/sql/database-administration/ten-common-database-design-mistakes/
Metalinks
- Drop Tablespace Failed with ORA-02429: cannot drop index used for enforcement of unique/primary key (Doc ID 1918060.1)
- RECO Process Fails With ORA-603 ORA-3106 In Oracle 12.2 In A Distributed Environment (Doc ID 2368500.1)
- Bug 27544973 - Reco Process Fails with ORA-603 ORA-3106 in oracle 12.2 (Doc ID 27544973.8)
DataPump Export (EXPDP) Fails With Errors ORA-39126 ORA-06512 ORA-1950 (Doc ID 1531789.1)
Datapump Export Fails with ORA-1950: "no privileges on tablespace" (Doc ID 1633698.1)
ORAchk Upgrade Readiness Assessment (Doc ID 1457357.1)
Patches to apply before upgrading Oracle GI and DB to 12.2.0.1 (Doc ID 2180188.1)
Patch conflict resolution (Doc ID 1299688.1)
How to Use the My Oracle Support Conflict Checker Tool for Patches Installed with OPatch [Video] (Doc ID 1091294.1)
TNS-12518, TNS-12540, TNS-12582 and TNS-12615 Errors Reported in 11g Listener Log Under Heavy Load (Doc ID 1399677.1)
Can Redo Generation Be Disabled During Materialized View Refresh (Doc ID 334878.1)
Complete Materialized View Refresh Generates Lots Of Archive Logs and Rollback/Undo Activity (Doc ID 413188.1)
Cluster Health Monitor (CHM) FAQ (Doc ID 1328466.1)
HugePages on Linux: What It Is... and What It Is Not... (Doc ID 361323.1)
Oracle Linux: Shell Script to Calculate Values Recommended Linux HugePages / HugeTLB Configuration (Doc ID 401749.1)
Best Practices for Corruption Detection, Prevention, and Automatic Repair - in a Data Guard Configuration (Doc ID 1302539.1)
Complete Checklist for Upgrading to Oracle Database 12c Release 2 (12.2) using DBUA (Doc ID 2189854.1)
12.2.0.1 Base Release - Availability and Known Issues (Doc ID 2239820.1)
Script to Collect DB Upgrade/Migrate Diagnostic Information (dbupgdiag.sql) (Doc ID 556610.1)
How to Handle Materialized Views When You Upgrade or Clone a Database (Doc ID 1406586.1)
Supplemental Readme - Grid Infrastructure Release Update 12.2.0.1.x (Doc ID 2246888.1)
How do you apply a Patchset,PSU or CPU in a Data Guard Physical Standby configuration (Doc ID 278641.1)
Oracle Recommended Patches -- "Oracle JavaVM Component Database PSU and Update" (OJVM PSU and OJVM Update) Patches (Doc ID 1929745
Datapatch: Database 12c Post Patch SQL Automation (Doc ID 1585822.1)
EM 12c: Agent Deployment hangs at Remote Pre-requisite Check step Or Fails With "PROV-16011: Session.connect: java.net.SocketException" (Doc ID 1634871.1)
ORA-12012 ORA-04063 ORA-06508 For JOB WWV_FLOW_MAIL (Doc ID 2332475.1)
How To Verify If APEX Is Being Used in an 11.x Database Installation When APEX Shows as INVALID in DBA_REGISTRY (Doc ID 1518046.1)
EM 12c: Agent Deployment hangs at Remote Pre-requisite Check step Or Fails With "PROV-16011: Session.connect: java.net.SocketException" (Doc ID 1634871.1)
ORA-12012 ORA-04063 ORA-06508 For JOB WWV_FLOW_MAIL (Doc ID 2332475.1)
How To Verify If APEX Is Being Used in an 11.x Database Installation When APEX Shows as INVALID in DBA_REGISTRY (Doc ID 1518046.1)
I like to read your blog. You shared a wonderful information.
ReplyDeleteOracle dba Training