REFERENCE WEBSITES

REFERENCE WEBSITES



ASM
===
http://rohitguptaoracletips.blogspot.in/2008/07/basics-of-asm-automatic-storage.html


DATAGUARD
=========
Architecture
http://www.datadisk.co.uk/html_docs/oracle_dg/architecture.htm


Oracle Data Guard Overview
http://andrewfraserdba.com/2011/08/09/oracle-data-guard-overview/


Introduction to Oracle Data Guard
http://www.stanford.edu/dept/itss/docs/oracle/10g/server.101/b10823/concepts.htm
============================================================================================================
Oracle® Data Guard Broker
10g Release 1 (10.1)
Part Number B10822-01


5 Data Guard Scenarios - Using Oracle Enterprise Manager


http://docs.oracle.com/cd/B14117_01/server.101/b10822/gui.htm
============================================================================================================
Oracle® Data Guard Concepts and Administration
10g Release 2 (10.2)
Part Number B14239-05


http://docs.oracle.com/cd/B19306_01/server.102/b14239/scenarios.htm
============================================================================================================
Oracle® Data Guard Concepts and Administration
11g Release 1 (11.1)
Part Number B28294-03


http://docs.oracle.com/cd/B28359_01/server.111/b28294/rman.htm#i1024051
============================================================================================================
13 Data Guard Scenarios


Oracle® Data Guard Concepts and Administration
11g Release 2 (11.2)
Part Number E25608-03
Steps for creating Physical standby database


http://docs.oracle.com/cd/E11882_01/server.112/e25608/scenarios.htm#i1008082
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
Steps for creating Physical standby database
http://anandrathinam.blogspot.in/2008/06/steps-for-creating-physical-standby.html
============================================================================================================
Create single instance standby database for RAC Database
http://oracleinstance.blogspot.in/2012/01/create-single-instance-standby-database.html
============================================================================================================
Physical Data Guard scenario in 10G on Linux
http://webgeek-tutorials.blogspot.in/2011/02/physical-data-guard-scenario-in-10g-on.html
============================================================================================================
Recover Dataguard With Lost Archivelogs
http://emrebaransel.blogspot.in/2008/12/recover-dataguard-from-lost-archivelog.html
============================================================================================================
Data Guard Redo Apply and Media Recovery Best Practices 10g
http://tonguc.wordpress.com/2008/05/05/data-guard-redo-apply-and-media-recovery-best-practices-10g/
============================================================================================================
11gR2 RAC-Dataguard Sync issue Between Primary & Standby
http://www.oracledbasupport.co.uk/11gr2-rac-dataguard-sync-issue-between-primary-standby/
============================================================================================================
How to recover Standby database from a missing archivelog
http://dbaregistry.blogspot.in/2010/01/how-to-recover-standby-database-from.html
============================================================================================================
Resolving missing archive log gap at Standby Database
http://shrikantrao.wordpress.com/2011/04/28/resolving-missing-archive-log-gap-at-standby-database/
============================================================================================================
RMAN Incremental Backups to Roll Forward a Physical Standby DatabaseFebruary 14th, 2012 | Posted by Nassyam Basha in Data Guard
http://www.oracle-ckpt.com/rman-incremental-backups-to-roll-forward-a-physical-standby-database-2/
============================================================================================================
Resolving Gaps in Data Guard Apply Using Incremental RMAN BAckup
http://arup.blogspot.in/2009/12/resolving-gaps-in-data-guard-apply.html
============================================================================================================
http://rohitguptastandbydbtips.blogspot.in/
============================================================================================================
Steps to recover the primary database's datafile using a copy of a standby database's datafile
Steps to recover the standby database's datafile using a copy of a primary database's datafile.
http://dbaregistry.blogspot.in/2010/01/steps-to-recover-primary-databases.html
============================================================================================================


DATA PUMP
=========
Data Pump in Oracle Database 10g
http://webgeek-tutorials.blogspot.in/2012/02/data-pump-in-oracle-database-10g.html


How to change the table name during import?
http://dbaregistry.blogspot.in/2010/02/how-to-change-table-name-during-import.html


LINUX
=====
http://www.freeos.com/guides/lsst/index.html
http://blog.contractoracle.com/2008/08/tar-and-gzip-via-unix-pipe-to-save.html


METALINK NOTES
==============
Note 839182 - Installing patches using OPatch
http://www.stechno.net/sap-notes.html?view=sapnote&id=839182


Note 871735 - Current patch set for Oracle 10.2.0
http://www.stechno.net/sap-notes.html?view=sapnote&id=871735


Note 912620 - FAQ: Oracle indexes
http://www.stechno.net/sap-notes.html?view=sapnote&id=912620


Note 771929 - FAQ: Index fragmentation
http://www.stechno.net/sap-notes.html?view=sapnote&id=771929


Note 910389 - FAQ: Oracle Segment Shrinking
http://www.stechno.net/sap-notes.html?view=sapnote&id=910389


Note 659946 - FAQ: Temporary tablespaces
http://www.stechno.net/sap-notes.html?view=sapnote&id=659946


Note 619188 - FAQ: Oracle wait events
http://www.stechno.net/sap-notes.html?view=sapnote&id=659946


Note 712624 - High CPU consumption by Oracle
http://www.stechno.net/sap-notes.html?view=sapnote&id=712624


ORA-ERRORS
==========
http://searchoracle.techtarget.com/answer/Resolving-the-ORA-1630-error
http://searchoracle.techtarget.com/answer/ORA-01654-even-though-maxextents-defined-as-unlimited
http://searchoracle.techtarget.com/tip/Creating-an-INDEX-on-primary-key-columns-before-creating-a-primary-key
http://searchoracle.techtarget.com/answer/Temp-segment-not-created-in-temp-tablespace
http://searchoracle.techtarget.com/tutorial/Solving-common-Oracle-errors-guide


http://www-wnt.gsi.de/oragsi/problems.html


http://www.arikaplan.com/oracle.html


while importing a full database I am getting these errors. I wonder how this happens and how to handle them.
http://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=4513


To fix the ORA-1630 error, you'll need to change the STORAGE limits on the index. You can do this by issuing the following command:


ALTER INDEX index_name STORAGE (MAXEXTENTS 500);
Now the index can allocate up to 500 extents (more than the 249).


PERFORMANCE TUNING
==================
Oracle Wait Events
http://dbaregistry.blogspot.in/2010/01/oracle-wait-events.html


http://blog.contractoracle.com/2010/05/diagnosing-rac-cluster-waits.html


Latches and Latch Contention
http://dbaregistry.blogspot.in/2010/01/latches-and-latch-contention.html


DBA Interview questions
http://dbaregistry.blogspot.in/2010/01/dba-interview-questions.html


Direct-Path INSERT
http://dbaregistry.blogspot.in/2010/03/direct-path-insert.html


http://oraclespin.wordpress.com/2012/05/27/how-to-see-current-utilization-of-processessessions-and-max-utilization/


http://nadvi.blogspot.in/2012/02/10053-trace-with-dbmssqldiagdumptrace.html


http://www.oracledbasupport.co.uk/virtual-memory-statistics-vmstat/


http://www.oracledbasupport.co.uk/awr-how-to-run-reports/


Auditing in Oracle
http://satya-dba.blogspot.in/2009/05/auditing-in-oracle.html


RAC
===
Oracle RAC Interview questions and answers
http://dbaregistry.blogspot.in/2010/02/oracle-rac-interview-questions.html


RAC Load Balancing, TAF , FAN
http://dbaregistry.blogspot.in/2010/02/rac-load-balancing-taf-fan.html


Oracle Real Application Clusters (RAC)
http://www.datadisk.co.uk/html_docs/rac/rac.htm


RAC Architecture
http://www.datadisk.co.uk/html_docs/rac/architecture.htm


RAC Troubleshooting
http://www.datadisk.co.uk/html_docs/rac/troubleshooting.htm#performance_issues


RAC Performance
http://www.datadisk.co.uk/html_docs/rac/performance.htm


How to move OCR and Voting disk to new storage device?
http://dbaregistry.blogspot.in/2010/01/how-to-move-ocr-and-voting-disk-to-new.html


SQL SCRIPTS
===========
Useful SQL Scripts for day-to-day DBA tasks.
http://dbaregistry.blogspot.in/2010/02/useful-sql-scripts.html


Oracle DBA Script : Keep tablespace usage less than 80%
http://webgeek-tutorials.blogspot.in/2012/06/oracle-dba-script-keep-tablespace-usage.html


Health Check script for RAC DB
http://www.reachdba.com/showthread.php?284-Health-Check-script-for-RAC-DB


http://myoraclediaryforme.blogspot.in/2011_12_01_archive.html


http://myoracleguide.com/s/metadata_object_types.htm


http://oracleandunix.blogspot.in/2009/07/dbmsmetadatagetddl.html


http://mnsinger.wordpress.com/2012/02/01/useful-sql-queries-and-oracle-code/


http://www.optimaldba.com/scripts/


http://vamshiappsdba.blogspot.in/2011_09_01_archive.html


http://shailapps.blogspot.in/2008_05_01_archive.html


http://oraclespin.wordpress.com/category/general-dba/dataguard-general-dba/
http://blog.contractoracle.com/2008/08/dataguard-diagnostics-select-statements.html
http://blog.contractoracle.com/2009/11/maa-for-active-dataguard.html
http://blog.contractoracle.com/2010/03/create-dataguard-broker-configuration.html
http://blog.contractoracle.com/2008/08/setup-dataguard-broker.html
http://blog.contractoracle.com/2009/11/enable-active-standby-on-database-with.html
http://blog.contractoracle.com/2008/08/manual-dataguard-switchover.html
http://blog.contractoracle.com/2008/08/test-impact-of-nologging-on-oracle.html
http://blog.contractoracle.com/2009/09/recover-standby-database-using.html
http://blog.contractoracle.com/2010/03/duplicate-database-from-active.html


http://blog.contractoracle.com/2008/09/moving-indexes-index-partitions-index.html
http://blog.contractoracle.com/2010/05/rebuilding-unusable-indexes-index.html
http://blog.contractoracle.com/2009/09/index-monitoring-to-identify-unused.html
http://blog.contractoracle.com/2009/10/identifying-low-cardinality-indexes.html


http://blog.contractoracle.com/2009/12/using-flashback-archive-to-avoid-ora.html
http://blog.contractoracle.com/2008/09/if-db-recovery-file-dest-fills-up.html


http://newgendba.blogspot.in/2009/04/rman-set-newname-command-using-sql.html
http://blog.contractoracle.com/2008/08/rman-examples.html


http://blog.contractoracle.com/2010/01/asm-diagnostics-report.html
http://blog.contractoracle.com/2008/08/asm-diagnostics-statements.html
http://blog.contractoracle.com/2008/09/asm-rebalance-power.html
http://blog.contractoracle.com/2008/08/copy-archivelog-file-from-asm-to-disk.html


http://blog.contractoracle.com/2008/08/undo-tablespace-usage.html
http://blog.contractoracle.com/2008/08/temp-tablespace-usage.html


http://blog.contractoracle.com/2008/08/rollback-patch-with-opatch.html


http://yaping123.wordpress.com/2008/09/02/db-link/
http://oraclespin.wordpress.com/2008/03/28/how-to-extract-the-db-links-ddl-with-the-password/


http://rohitguptaoracletips.blogspot.in/


UPGRADE
=======
Performing a Manual Upgrade
http://anandrathinam.blogspot.in/2008/05/performing-manual-upgrade.html


BOOKS PDFS DL
=============
http://freedownload.is/ppt/powerpoint-presentation-8492037.html
http://freedownload.is/ppt/oracle-10g-database-administrator-implementation-and-administration-8378076.html
http://www.ebook3000.com/OCA--Oracle-10g-Administration-I-Study-Guide--1Z0-042-_106621.html
http://www.ebook3000.com/Oracle-Database-11g-R2-Performance-Tuning-Cookbook_154865.html
http://www.free-download-ebooks.com/Expert-Oracle-Database-10g-Administration_284588.html



"Hope for the best, Prepare for the worst"

-Dharmendra