Tuesday, December 6, 2016

Oracle Links

Restoring an Oracle Database on a New Server
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)


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

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



Materilaized Views

https://technology.amis.nl/2014/08/15/materialized-views-fast-refresh-complete-refresh-recreate/


https://mikedietrichde.com/2017/07/19/first-ru-oracle-12-2-0-1-available/?fb_action_ids=1478713115520046&fb_action_types=news.publishes
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

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


OPatch failed with error code 41


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)

1 comment: