Alok Giri Oracle

In this Doc I am appliyimg a patch which is provided by Oracle Support through opatch utility. $ unzip -d . p10319478_10205_HPUX-IA64*.zip -----this is a example of patch Archive:   p10319478_10205_HPUX-IA64[1].zip ----Unzip the pacth    creating: ./10319478/    creating: ./10319478/files/    creating: ./10319478/files/lib/    creating: ./10319478/files/lib/libserver10.a/   inflating: ./10319478/files/lib/libserver10.a/kzul.o   inflating: ./10319478/files/lib/libserver10.a/kss.o   inflating: ./10319478/files/lib/libserver10.a/kstt.o    creating: ./10319478/etc/    creating: ./10319478/etc/config/   inflating: ./10319478/etc/config/inventory.xml   inflating: ./10319478/etc/config/actions.xml   inflating: ./10319478/etc/config/deploy.xml    creating: ./10319478/etc/xml/   inflating: ./10319478/etc/xml/GenericActions.xml   inflating: ./10319478/etc/xml/ShiphomeDirectoryStructure.xml   inflating: ./10319478/README.txt $ pwd    --- To see the path of patch /u01/home/oracle/product/

Use the following procedure to restore OCR on UNIX-based systems: Identify the OCR backups by using the ocrconfig -showbackup command. You can execute this command from any node as user oracle. The output tells you on which node and which path to retrieve automatically generated backups. Review the contents of the backup by using ocrdump -backupfile file_name , where file_name is the name of the backup file. Stop Oracle Clusterware on all the nodes of your cluster by executing the crsctl stop crs command on all the nodes as the root user. Perform the restore by applying an OCR backup file that you identified in step one using the following command as the root user, where file_name is the name of the OCR file that you want to restore. Make sure that the OCR devices that you specify in the OCR configuration file (/etc/oracle/ocr.loc) exist and that these OCR devices are valid before

In this Document Purpose Scope and Application Steps to Re-Create ASM Diskgroups Step 1: Ensure that you have a prior RMAN backup of all databases using ASM Step 2: Shutdown your ASM instance(s) Step3: Use DD to clear the metadata from ASM disks Step 4: Re-create your ASM disk group(s) Step 5: Restore database References Applies to: Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 11.1.0.7 - Release: 10.1 to 11.1 Information in this document applies to any platform. Purpose To provide a method of re-creating ASM diskgroups. Scope and Application This document is intended for DBAs and Support Engineers who need to re-create ASM diskgroups. Steps to Re-Create ASM Diskgroups In the event you cannot mount your ASM disk groups, you will be unable to start any databases using those disk groups. Here is a possible error reported when mounting ASM disk groups: SQL> startup mount ORA-15032: not all alterations performed ORA-15063: diskgroup "<

               Stop Oracle Clusterware or Cluster Ready Services Processes If you are modifying an Oracle Clusterware or Oracle Cluster Ready Services (CRS) installation, then shut down the following Oracle Database 10g services. Step to Stop RAC System. 1.        Shut down any processes in the Oracle home on each node that might be accessing a database; for example, shut down Oracle Enterprise Manager Database Control. 2.        Shut down all Oracle RAC instances on all nodes. To shut down all Oracle RAC instances for a database, enter the following command, where db_name is the name of the database: ORACLE_HOME \BIN\srvctl stop database -d <Database Name> 3.        Shut down all ASM instances on all nodes. To shut down an ASM instance, enter the following command, where node is the name of the node where the ASM instance is running: ORCALE_HOME \bin\srvctl stop asm -n node 4.        Stop all node applications on all nodes. To stop node applications running on a node, enter

Step to Install - Oracle 10G Silent Installation Step :- Pre-requisites Kernel Paramters settings and Creation of Oracle user and groups. Step :- Mount CD or allocate Oracle software as per requirment. Step :- To create a response file, start the OUI with the following command and perform an installation as normal. ./runInstaller -record -destinationFile /tmp/10gR2.rsp Description :- The "-record" parameter tells the installer to write to the response file and the "-destinationFile" parameter defines the name and location of the response file.The response files are quite large, containing a large number of parameters and comments. The 10gR2.rsp file is an example of a response file from an Oracle Database 10g installation generated by the previous command. Step :- A silent installation is initiated using the following command. ./runInstaller -silent -responseFile /tmp/10gR2.rsp Description :- The "-silent" parameter indicates that this is a silent in

Steps below. 1) Backup the database. 2) Shut down and startup the database in nomount mode. $ sqlplus SQL*Plus: Release 10.2.0.4.0 - Production on Fri Jan 1 12:52:44 2010 Copyright (c) 1982, 2008, Oracle. All rights reserved. Enter user-name: /as sysdba Connected to an idle instance. SQL> startup nomount ORACLE instance started. Total System Global Area 1.6034E+10 bytes Fixed Size 2127408 bytes Variable Size 1610615248 bytes Database Buffers 1.4361E+10 bytes Redo Buffers 60174336 bytes SQL> exit Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, Real Application Clusters, OLAP, Data Mining and Real Application Testing options $ 3) Copy the non-asm files to asm diskgroup. [oracle]$ rman nocatalog Recovery Manager: Release 10.2.0.4.0 - Production on Fri Jan 1 12:57:14 2010 Copyright (c) 1982, 2007, Oracle. All rights reserved. RMAN> connect target RMAN> sql 'alter database mount

Solution To Flashback primary database execute following steps : 1. Shutdown primary database . SQL> SHUTDOWN IMMEDIATE 2. Start primary database in mount stage SQL> STARTUP MOUNT 3. Flashback primary database to specified scn SQL> FLASHBACK DATABASE TO SCN <scn_number>; 4. Open primary database with reset logs. SQL> ALTER DATABASE OPEN RESETLOGS; 5. Cancel media recovery on the standby database. SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL; 6. Check current_scn on the standby database, If flashback scn is greater then current_scn then skip next step (step 7). SQL> SELECT CURRENT_SCN FROM V$DATABASE; 7. Flashback Standby database SQL> FLASHBACK STANDBY DATABASE TO SCN <scn_number -2>; (on standby database) 8. Start managed recovery on the standby database . SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

There are performance issues associated with incremental backups as the whole of each datafile must be scanned to identify changed blocks. In Oracle 10g it is possible to track changed blocks using a change tracking file. Enabling change tracking does produce a small overhead, but it greatly improves the performance of incremental backups. The current change tracking status can be displayed using the following query. SELECT status FROM v$block_change_tracking; Change tracking is enabled using the   ALTER DATABASE   command. ALTER DATABASE ENABLE BLOCK CHANGE TRACKING; By default the change tracking file is created as an Oracle Managed File (OMF) in the location pointed to by the   DB_CREATE_FILE_DEST   parameter. An alternate location can be specified using the following command. ALTER DATABASE ENABLE BLOCK CHANGE TRACKING    USING FILE '/u01/oradata/MYSID/rman_change_track.f' REUSE; The tracking file is created with a minumum size of 10M and grows in 10M increments. It'

General RAC Is rcp and/or rsh required for normal Oracle RAC operation ? What is Cache Fusion and how does this affect applications? Is it difficult to transition (migrate) from Single Instance to Oracle RAC? What are the dependencies between OCFS and ASM in Oracle Database 10g ? Do we have to have Oracle Database on all nodes? What software is necessary for Oracle RAC? Does it have a separate installation CD to order? What Application Design considerations should I be aware of when moving to Oracle RAC? What kind of HW components do you recommend for the interconnect? How can a NAS storage vendor certify their storage solution for Oracle RAC ? My customer has an XA Application with a Oracle RAC Database, can I do Load Balancing across the Oracle RAC instances? Should the SCSI-3 reservation bit be set for our Oracle Clusterware only installation? How do I determine which node in the cl