christiansestu.wordpress.com
Oracle 10g … 11gR2 Clusterware Interconnect Healthy ? | Christian Sestu @ Oracle => Blog
https://christiansestu.wordpress.com/2010/07/10/oracle-11gr2-clusterware-survival-guide-part1-is-interconnect-healthy
Christian Sestu @ Oracle = Blog. Yet Another Oracle Weblog. Oracle 10g … 11gR2 Clusterware Interconnect Healthy? Working with lots of RAC issues lately due to bad Interconnect setups. Issues that lead to : Instance Eviction, Server Crashes, Performance Issues ). I decided to start with this posting about Interconnect issues debugging to collect some information on how/what ti check for likely issues. To set MTU Frame :. To determine if you are going to experience UDP socket buffer overflow and packet los...
bash-dba.com
BASH-DBA: Scripts
http://www.bash-dba.com/p/scripts.html
Oracle database real life problems and recommended solutions! BASH-DBA: How to Start/Stop Oracle Clusterware. Find Oracle database performance. Identify large pl/sql anonymous blocks. BASH-DBA: ORACLE: ADDM, AWR and ASH Utilities. BASH-DBA: Keeping PL/SQL in Oracle Memory. BASH-DBA: Running the Linux script. Even after logging out. BASH-DBA: Finding Tablespace Fragmentation. BASH-DBA: Truncating multiple tables using PL/SQL block. BASH-DBA: Finding Problematic SQL and Top waits from past using . Pythian ...
bash-dba.com
BASH-DBA: Oracle Support Master Notes
http://www.bash-dba.com/p/white-paperslinks.html
Oracle database real life problems and recommended solutions! Oracle Support Master Notes. Oracle Support Master Note For Oracle Recovery Manager (RMAN) (Doc ID 1116484.1). Master Note for 11g Diagnosability - ADR and Packaging [ID 1283137.1]. Master Note for Data Pump [ID 1264715.1]. Master Note: Database Performance Overview [ID 402983.1]. Master Note for Handling Oracle Database Corruption Issues [ID 1088018.1]. Master Note For PL/SQL Dynamic SQL [ID 1136382.1]. August 7, 2012 at 1:59 AM. ORACLE-BASE ...
bash-dba.com
BASH-DBA: RMAN Incremental Backups to Roll Forward a Physical Standby Database (Lags far behind the primary database)
http://www.bash-dba.com/2013/07/rman-incremental-backups-to-roll_12.html
Oracle database real life problems and recommended solutions! Friday, July 12, 2013. RMAN Incremental Backups to Roll Forward a Physical Standby Database (Lags far behind the primary database). MAN incremental backups can be used to sync a physical standby database with the primary database. We can use the. BACKUP INCREMENTAL FROM SCN. Command to create a backup on the primary database that starts at the current SCN of the standby, which can then be used to roll the standby database forward in time.
bash-dba.com
BASH-DBA: RMAN: Concept and Usage of Recovery Catalog
http://www.bash-dba.com/2014/04/rman-concept-and-usage-of-recovery.html
Oracle database real life problems and recommended solutions! Wednesday, April 23, 2014. RMAN: Concept and Usage of Recovery Catalog. Recovery catalog is an optional database schema consisting of database objects like tables and views. RMAN uses these objects to store its repository data. The control file of each target database always serves as the primary store for the repository, however, catalog can act as a secondary storage and provides repository redundancy. RMAN-stored scripts that you create.
bash-dba.com
BASH-DBA: RAC/Clusterware
http://www.bash-dba.com/p/rac.html
Oracle database real life problems and recommended solutions! BASH-DBA: Finding details of Oracle 11g RAC. BASH-DBA: Oracle 11g Clusterware Installation Requirements. BASH-DBA: Oracle 11g R1 Clusterware installation. BASH-DBA: Oracle 11g R1 Clusterware. BASH-DBA: Oracle 11g R2 Clusterware installation. BASH-DBA: How to Start/Stop Oracle Clusterware. Subscribe to: Posts (Atom). Oracle Support Master Notes. Communities.oracle.com/portal/server.pt/community/support/219. OraChat - Oracle DBAs.
bash-dba.com
BASH-DBA: RMAN
http://www.bash-dba.com/p/rman.html
Oracle database real life problems and recommended solutions! How to Configure Recovery Catalog. Configuring the RMAN environment. Basic RMAN Back-up Scenarios. RMAN 6 Recovery Steps in Theory. Restoring Control File Scenarios. Tablespace and Datafile Recovery Scenarios. Recover using a backup of a previous incarnation. Restoring from an Older Backup. Find out if the Data-files backed up in last 24 hours. To find out if Archlog Files backed up in last 24 Hours. Difference b/w Oracle Restore and Recovery.
bash-dba.com
BASH-DBA: Managing a Physical Standby Database
http://www.bash-dba.com/2013/07/managing-physical-standby-database.html
Oracle database real life problems and recommended solutions! Tuesday, July 2, 2013. Managing a Physical Standby Database. Below steps are related to day-to-day operations of the Oracle Data Guard environment. These operations include starting the standby database, enabling managed recovery, opening the standby in read-only, as well as general maintenance tasks. Starting a Physical Standby. SQL startup nomount;. SQL alter database mount standby database;. SQL startup mount;. This above command will appea...
bash-dba.com
BASH-DBA: April 2014
http://www.bash-dba.com/2014_04_01_archive.html
Oracle database real life problems and recommended solutions! Wednesday, April 23, 2014. RMAN: Concept and Usage of Recovery Catalog. Recovery catalog is an optional database schema consisting of database objects like tables and views. RMAN uses these objects to store its repository data. The control file of each target database always serves as the primary store for the repository, however, catalog can act as a secondary storage and provides repository redundancy. RMAN-stored scripts that you create.
bash-dba.com
BASH-DBA: Snapshot standby database
http://www.bash-dba.com/2013/04/snapshot-standby-database.html
Oracle database real life problems and recommended solutions! Wednesday, April 17, 2013. Oracle 11g has a feature in this area called : Snapshot standby database. A Snapshot Standby Database is a fully update-able standby database that is created by converting a physical standby database into a snapshot standby database for read and write operation for a short period of time thus making it possible to process transactions independently of the primary database. These steps applies to. 6 Snapshot standby d...
SOCIAL ENGAGEMENT