+++++++++Migrating from ASMLIB to ASMFD+++++++++++

https://blog.dbi-services.com/migrating-from-asmlib-to-asmfd/

 

 

++++++++Flex ASM+++++++++

https://www.hhutzler.de/blog/flex-asm-new-12c-feature/

 

++++++++++Dataguard & Goldengate+++++++++

Configure data guard environment to reduce overheads of fast incremental backups on the primary database:

http://www.ocmguide.com/configure-data-guard-environment-to-reduce-overheads-of-fast-incremental-backups-on-the-primary-database/

 

oracle dataguard n dataguard broker:

https://omarnarman.wordpress.com/2017/11/26/__trashed/

 

Oracle Active Data Guard and Oracle GoldenGate:

http://www.oracle.com/technetwork/database/availability/dataguardgoldengate-096557.htmlThanks

http://www.oracle.com/technetwork/database/enterprise-edition/overview/active-data-guard-11g-datasheet-1-134534.pdf

 

Monitor Goldengate From OEM 12c Cloud Control:

http://oracle-help.com/goldengate/monitor-goldengate-oem-12c-cloud-control/?utm_content=buffer8171b&utm_medium=social&utm_source=linkedin.com&utm_campaign=buffer&lipi=urn%3Ali%3Apage%3Ad_flagship3_feed%3B1nC%2FMxJuTaKk7RBpnGb%2FbA%3D%3D

 

1.2.2 Overview of Data Pumps:

https://docs.oracle.com/goldengate/1212/gg-winux/GWUAD/wu_about_gg.htm#GWUAD119

 

Configuring Integrated Extract and Integrated Replicat Using Oracle GoldenGate 12c on Linux (slides):

http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/goldengate/12c/OGG12c_Integrated_Replicat/index.html

 

Oracle GoldenGate 12c:Real-Time Access to Real-Time Information (white paper):

http://www.oracle.com/us/products/middleware/data-integration/oracle-goldengate-realtime-access-2031152.pdf

 

Installing and Configuring Oracle GoldenGate for Oracle Database (12.1.2):

https://docs.oracle.com/goldengate/1212/gg-winux/GIORA.pdf

 

Oracle GoldenGate Performance Best Practices:

http://www.oracle.com/technetwork/database/availability/maa-gg-performance-1969630.pdf

 

Oracle GoldenGate Best practices: GoldenGate parameter files

http://www.ateam-oracle.com/oracle-goldengate-best-practice-goldengate-parameter-files/

 

Oracle GoldenGate 12c (12.2.0.1):Get Started:

https://docs.oracle.com/goldengate/c1221/gg-winux/index.html

 

New Features in 12c (12.2.0.1):

https://docs.oracle.com/goldengate/c1221/gg-winux/GRLWU/toc.htm#GRLWU101

 

Oracle GoldenGate 12c:Real-Time Access to Real-Time Information

http://www.oracle.com/us/products/middleware/data-integration/oracle-goldengate-realtime-access-2031152.pdf

 

Goldengate introduction:

https://www.red-gate.com/simple-talk/sql/oracle/goldengate-an-introduction/

 

https://docs.oracle.com/cd/E35209_01/doc.1121/e29399.pdf

https://docs.oracle.com/goldengate/c1221/gg-winux/GWURF/GWURF.pdf

http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/goldengate/12c/OGG12c_Integrated_Replicat/index.html

https://www.wysheid.com/courses/uni-directional-replication-goldengate/lessons/how-to-dowload-the-correct-version-of-goldengate-video-tutorial/

http://www.dba-oracle.com/t_goldengate_ha_overview.htm

 

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Move tables (online / offline) in Oracle (9i-12cR2):

http://loredata.com.br/2017/06/16/move-tables-online-offline-oracle/

 

Moving Datafiles in Oracle Database:

http://loredata.com.br/2016/07/06/movimentacao-de-datafiles-no-oracle-database/

 

+++++++++++++AWR Report++++++++++++

Graphical awr report:

https://github.com/flashdba/scripts/blob/master/awr-parser.sh

 

Sample AWR report:

http://www.dba-oracle.com/t_sample_awr_report.htm

 

AWR report analysis:

https://www.slideshare.net/pachot/reading-awr-or-statspack-report-straight-to-the-goal?qid=1ad16a1b-adf1-4c78-ba6d-18c995039e63&v=&b=&from_search=1

 

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Recovering Oracle datafile from rm -rf:

http://dbaall.blogspot.in/2018/01/recovering-oracle-datafile-from-rm-rf.html

 

Transporting Tablespaces Between Databases:

https://docs.oracle.com/cd/B28359_01/server.111/b28310/tspaces013.htm#ADMIN11394

 

Oracle Database 11gR2 (11.2.0.4) installation on Oracle Linux 6.4:

http://www.snapdba.com/2014/01/oracle-database-11gr2-11-2-0-4-installation-on-oracle-linux-6-4/#.WqjodK6WbIX

 

++++++++++RAC links+++++++++++

Steps for Create RAC Database Manually:

http://oracle-help.com/oracle-rac/steps-create-rac-database-manually/?lipi=urn%3Ali%3Apage%3Ad_flagship3_feed%3BSAKpI1dCTLeC9Y1TlXMH3Q%3D%3D&licu=urn%3Ali%3Acontrol%3Ad_flagship3_feed-original_share_object

 

How to Configure the DNS Server for SCAN VIP on Linux for 11gR2 GI installation (Doc ID 1107295.1)

 

How to Start Oracle RAC Database:

http://www.dbainsights.com/2017/12/how-to-start-oracle-rac-database.html?spref=fb&m=1

 

Oracle Database 12c Release 1 (12.1) RAC On Oracle Linux 6 Using VirtualBox:

http://www.dbainsights.com/2018/01/oracle-database-12c-release-1-121-rac.html?spref=fb&m=1

 

Using Oracle Real Application Clusters (RAC):

https://www.google.co.in/url?sa=t&rct=j&q=&esrc=s&source=web&cd=7&cad=rja&uact=8&ved=0ahUKEwjqxOazx6nYAhVGD8AKHelBB0cQFghKMAY&url=https%3A%2F%2Fd117h1jjiq768j.cloudfront.net%2Fdocs%2Fdefault-source%2Fdefault-document-library%2Fdatadirect%2Fdocuments%2Fodbc%2Ftutorial%2Fodbc-oracle-rac.pdf%3Fsfvrsn%3Def2ce033_0%26download%3Dtrue&usg=AOvVaw12eKnKicsr94Nl3ZP31To7

 

Oracle Database 11g Release 2 RAC On Oracle Linux 5.8 Using VirtualBox

https://oracle-base.com/articles/11g/oracle-db-11gr2-rac-installation-on-oel5-using-virtualbox

 

Step By Step: Install and setup Oracle 11g R2 RAC on Oracle Enterprise Linux 5.5 (32 bit) Platform:

http://www.oracledba.org/11gR2/Pre_Install_11gR2.htm

 

Configuring Kernel Parameters and Resource Limits:

https://docs.oracle.com/cd/E11882_01/install.112/e24326/toc.htm#BHCCADGD

 

https://docs.oracle.com/cd/E11882_01/install.112/e41962/racinstl.htm#RILIN1006 (rac setup)

 

https://docs.oracle.com/cd/E11882_01/install.112/e41961/storage.htm#CWLIN257 (grid setup)

 

https://docs.oracle.com/cd/E11882_01/install.112/e41961/typinstl.htm#CWLIN152 (RAC setup IP characteristics)

 

https://access.redhat.com/sites/default/files/attachments/deploying-oracle-11gr2-rac-on-rhel6_1.1.pdf (kernel,shell parameters storage n rac setup)

 

https://access.redhat.com/documentation/en-us/red_hat_enterprise_linux/5/html/configuration_example_-_oracle_ha_on_cluster_suite/sample_2_node

 

scan listener:

https://www.orskl.com/how-does-scan-listener-works-in-oracle-rac-11gr2/

http://www.oracle.com/technetwork/products/clustering/overview/scan-129069.pdf

https://www.linkedin.com/pulse/difference-between-scan-vips-oracle-11gr2-gi-adnan-shafiq/

http://www.dba-oracle.com/grid_tnsnames_ora_file.htm

https://www.orskl.com/how-to-add-a-new-scan-listener-in-oracle-11gr2-rac-setup/#more-71

 

tnsnames.ora entry:

http://practical-tech.blogspot.in/2012/09/oracle-rac-11gr2-client-side-taf.html

https://learnwithme11g.wordpress.com/2010/09/02/scan-in-11gr2-grid-infrastructure/

 

ASMLib n ASM storage:

https://blogs.oracle.com/wim/asmlib

https://access.redhat.com/sites/default/files/attachments/oracle_on_rhel_with_or_without_asm_asmlib_0.pdf

http://www.dba-oracle.com/real_application_clusters_rac_grid/limitations_asm.htm

http://oracleflash.com/11/how-to-configure-asm-disks-using-asmlib-or-raw-disks.html

https://learnwithme11g.wordpress.com/2010/03/18/11gr2-rac-shared-storage-preparationasm-part1/

https://docs.oracle.com/cd/B28359_01/server.111/b31107/asmprepare.htm#OSTMG11000

https://oracle-base.com/articles/linux/udev-scsi-rules-configuration-in-oracle-linux

https://oracle-base.com/articles/10g/asm-using-asmlib-and-raw-devices

orababy.blogspot.in/2014/06/which-file-system-or-raw-device-vs-asm.html

http://www.orafaq.com/node/66

http://www.nyoug.org/Presentations/2008/Sep/Zito_RAC.pdf

 

RAID:

http://www.dba-oracle.com/t_raw_vs_cooked_files.htm

 

Convert Single Instance Database to Oracle RAC:

Convert Single Instance Database to Oracle RAC - ORACLE-HELP

 

+++++++++++Database upgradation++++++++++++

Oracle Database Upgrades:

http://www.oracle.com/technetwork/database/upgrade/overview/index.html

 

upgrading-a-database-using-recovery-manager-rman-duplicate-command-in-oracle-12c:

https://www.red-gate.com/simple-talk/sql/oracle/upgrading-a-database-using-recovery-manager-rman-duplicate-command-in-oracle-12c/

 

+++++++12c installation+++++++

Oracle Multitenant:

http://www.oracle.com/technetwork/database/multitenant/overview/index.html

 

Multitenant : Overview of Container Databases (CDB) and Pluggable Databases (PDB)

https://oracle-base.com/articles/12c/multitenant-overview-container-database-cdb-12cr1#multitenant-articles

 

Installation of 12c Grid Infrastructure on linux - configure ASM on 12c GridInfrastructure on Linux-64bit:

https://www.toadworld.com/platforms/oracle/b/weblog/archive/2013/06/29/installation-of-12c-grid-infrastructure-on-linux-configure-asm-on-12c-gridinfrastructure-on-linux-64bit

https://blog.dbi-services.com/oracle-grid-infrastructure-12c-prerequisites-for-installation/

 

Grid Infrastructure Installation Guide => Configuring Networks for Oracle Grid Infrastructure and Oracle RAC:

https://docs.oracle.com/database/121/CWLIN/networks.htm#CWLIN473

 

Database High Availability Best Practices => Configuring Oracle Database with Oracle Clusterware:

https://docs.oracle.com/database/121/HABPT/config_cw.htm#HABPT4855

https://www.oracle.com/database/roles/database-administrator.html

http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/12c/r1/poster/OUTPUT_poster/poster.html#tab_1

 

http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=641&sc=WWOUDB12cPRESSREL

 

http://www.oracle.com/technetwork/database/enterprise-edition/overview/index.html

 

http://www.oracle.com/technetwork/dbadev/index.html

 

Sharding Database Infrastructure Horizontally - Sharding in Oracle 12.2 – Part 1

Communication Center : Blogs : Sharding Database Infrastructure Horizontally - Sharding in Oracle 12.2 – Part 1

 

+++++++Recovery++++++++

How to recover database without knowing DBID or DB Name:

http://oracle-help.com/backup-and-recovery/recover-database-without-know-dbid-db-name/

 

Convert Non ASM database to ASM Database using Duplicate Database command:

Convert Non ASM database to ASM Database using Duplicate Database command - ORACLE-HELP

 

 

Thanks & Regards,

Mukesh Kumar Jha