Oracle Networking ( How to connect to Oracle Database through Different Machine)

ORACLE NETWORKING

This article will tell you how to connect to an Oracle database through Different server Or Different Machine

For this Scenario I used VMWare Work Station ACE Edition.

1) First Install Linux and then ORACLE 10g R2 on VMware Machine.
  (clickhere  to know How to Install Linux on VMWare)
  (clickhere to know how to Install Oracle10g on Linux)


Note:  While Installing Oracle Software. You will find option like Install Software only. Click On it.  We will create Database later.


2)  In this case I created Linux server called Primary




Note: IP Address of Primary Machine is 192.168.2.151 and in active mode And host name is Primary.dbasagar.com, use same IP address and hostname at the time of  installing linux , only if you are using Bridged network

3)Now goto VMware storage location on your host (C:\Users\Administrator\Documents\Virtual Machine)
You will find folder called Primary ( Since my machine name is Primary)
Create a folder called Standby


4) Copy all files on Primary folder and paste those into Standby
5) Open standby folder and open vmware configuration file as shown in fugure
     find line name DisplayName, Chang primary to Standby


6) Now Go to VMware press ALT+F and the click on open. Go to Standby local open vmdk file as shown      
     in figure



Now you have a two virtual machines called Primary and standby. Then Power on Standby Machine and leave Primary Power off. we need to change certain parameters
And log in as root user



7) Go to Applications --> system settings --> Network




a) Double click on eth0
     A new window will open - change IP address 192.168.2.151 to 192.168.2.152 ( Since we just copied
     whole content of Primary to standby)


b)  on same window you have tab called Hardware Device as show in figure, click on in and click Probe for
     once to change MAC address finally click OK


c) Now click on DNS tab on Main window as show in figure and change Host name from 
    Primary.dbasagar.com to Standby.dbasagar.com 




d) Now click on Devices tab and finally click on activate and then YES and  click on OK






Your eth0 device is now active mode. Close Net configuration window and log off and log in again as root user


8) Open Terminal and issue following commands


     # hostname
     #vi /etc/hosts
make entries as show in figure




9) Now power on Primary Machine and log in as root user and  Open Terminal and issue following 
    commands
     # hostname
     #vi /etc/hosts
     make entries as show in figure




10) Now  log out of Root user and log in as oracle on both Machines
        Create database called PROD using DBCA tools (on Primary Machine)
       (Clickhere to know how to create database using DBCA)

11) Connect to database as sysdba (on Primary Machine)



12) Open another Terminal
      Is below command as shown in figure
       $ netca

 Listener Configuration --> Add --> Listener Name [ PROD ] --> TCP --> PORT 1521 --> Next --> Finish




13) Now Issues netmgr command to make entries on tnsname.ora
   
     $netmgr
     click on listeners --> PROD --> Database services -->
     add database make entires PROD and PROD --> again click on add database --> Save and EXIT






14)  Again issue netca

Local Net service configuration --> add --> Name --> PROD --> TCP -->  Host Name and  PORT 1521 --> YES, Perform test --> test successful--> NEXT --> Finish







15) Now Ping TNS using below command

      $tnsping PROD



 16)  Go to Directory $ORACLE_HOME/network/admin
       edit tnsnames.ora as show in figure



copy selected content and past it into Standby machine tnsnames.ora file and save it





17) Now Ping TNS using below command

      $tnsping PROD



We are all set. Now testing

18) Go to Primary machine

 log In as as sysdba

create a user called sagar and grant roles as shown in figure



19)  Now go to Standby and log In sagar user

$ sqlplus sagar/sagar@PROD


Yes... Now you are connected to Database PROD which is located at Primary Machine through Standby Machine

20) create a table called test and insert some records in it and issue commit;



21) Now go to Primary Machine. check that records are stored are not as a sys user or Sagar user



In this way we can connect to database as remotely. In this way only developers will connect to database

Thanks
Sagar



















Oracle 10g R2 silent Installation on linux

Today I got a task from my manager, he asked me to install Oracle 10g R2 on silent mode. I did that in 10 min. He appreciated me a lot. When i googled i found below response file  ( you will find that at end of this post)

we can create this file manually, we will get this file if we record during oracle installation using OUI (ORACLE UNIVERSAL INSTALLER. By using below syntax we can create a basic response file 



[oracle@locahost database]$ ./runInstaller -record -destinationFile /home/oracle/oracle10g.rsp

once you are done with installation using above command, you will get response file under directory /home/oracle

Now uninstall previous installed oracle software. Just execute below command or If you install oracle 10g on another linux server make a copy of response file on flash Drive and create Oracle environment ( creating users, groups, setting kernal parameters, required RPM's) 

After that Log in as a ORACLE user then past response file under the directory /home/oracle
And finally execute below command

 [oracle@locahost database]$ ./runInstaller -silent -responseFile /home/oracle/script.rsp

[oracle@oracle10g ~]$ cd /home/oracle/database/

[oracle@oracle10g database]$ ./runInstaller -record -destinationFile 

/home/oracle/script.rsp


Starting Oracle Universal Installer...

Checking installer requirements...

Checking 

operating system version: must be redhat-3, SuSE-9, redhat-4, UnitedLinux-1.0, 

asianux-1 or asianux-2
                                      Passed




All installer requirements met.


Preparing to launch Oracle Universal Installer from /tmp/OraInstall2012-07-15_10

-38-59PM. Please wait ...[oracle@oracle10g database]$ Oracle Universal Installer, 

Version 10.2.0.1.0 Production
Copyright (C) 1999, 2005, Oracle. All rights 

reserved.


[oracle@oracle10g database]$ ./runInstaller -silent -responseFile 

/home/oracle/script.rsp
Starting Oracle Universal Installer...

Checking installer 

requirements...

Checking operating system version: must be redhat-3, SuSE-9, 

redhat-4, UnitedLinux-1.0, asianux-1 or asianux-2
                                 

     Passed


All installer requirements met.

Preparing to launch Oracle Universal 

Installer from /tmp/OraInstall2012-07-15_10-39-59PM. Please wait ...

[oracle@oracle10g database]$ Oracle Universal Installer, Version 10.2.0.1.0 

Production
Copyright (C) 1999, 2005, Oracle. All rights reserved.

You can find a 

log of this install session at:
 

/u01/app/oracle/oraInventory/logs/installActions2012-07-15_10-39-59PM.log
.................................................................................

................... 100% Done.




Loading Product Information
.................................................................................

.................................. 100% Done.


Analyzing dependencies
.........................................................................
Starting 

execution of Prerequisites...
Total No of checks: 11



Performing check for CertifiedVersions

Checking operating system requirements ...
Expected result: One of redhat-

3,redhat-4,SuSE-9,asianux-1,asianux-2
Actual Result: redhat-4
Check complete. The 

overall result of this check is: Passed


Check complete: Passed
=======================================================================


Performing check for Packages
Checking operating system package requirements ...
Checking for make-3.79; found make-1:3.80-6.EL4.        Passed
Checking for 

binutils-2.14; found binutils-2.15.92.0.2-21.      Passed
Checking for gcc-3.2; 

found gcc-3.4.6-3.1.      Passed
Checking for libaio-0.3.96; found Not found.    

Failed <<<<
Check complete. The overall result of this check is: Failed <<<<


Check 

complete: Failed <<<<
Problem: Some packages required for the Oracle Database 10g 

to function properly are missing (see above).
Recommendation: Install the required 

packages before continuing with the installation.

=======================================================================


Performing check for Kernel
Checking kernel parameters
Checking for semmsl=250; 

found semmsl=250.      Passed
Checking for semmns=32000; found semmns=32000.  

Passed
Checking for semopm=100; found semopm=100.      Passed
Checking for 

semmni=128; found semmni=128.      Passed
Checking for shmmax=536870912; found 

shmmax=2147483648. Passed
Checking for shmmni=4096; found shmmni=4096.    Passed
Checking for shmall=2097152; found shmall=2097152.      Passed
Checking for file-

max=65536; found file-max=65536.      Passed
Checking for VERSION=2.6.9; found 

VERSION=2.6.9-42.0.0.0.1.ELsmp.       Passed
Checking for ip_local_port_range=1024 

- 65000; found ip_local_port_range=1024 - 65000.  Passed
Checking for 

rmem_default=262144; found rmem_default=262144.    Passed
Checking for 

rmem_max=262144; found rmem_max=262144.    Passed
Checking for 

wmem_default=262144; found wmem_default=262144.    Passed
Checking for 

wmem_max=262144; found wmem_max=262144.    Passed
Check complete. The overall 

result of this check is: Passed


Check complete: Passed
=======================================================================


Performing check for GLIBC
Checking Recommended glibc version
Expected result: 

ATLEAST=2.3.2-95.27
Actual Result: 2.3.4-2.25
Check complete. The overall result of 

this check is: Passed


Check complete: Passed
=======================================================================


Performing check for TotalMemory
Checking physical memory requirements ...
Expected 

result: 922MB
Actual Result: 1008MB
Check complete. The overall result of this 

check is: Passed


Check complete: Passed
=======================================================================


Performing check for SwapSpace
Checking available swap space requirements ...
Expected result: 1512MB
Actual Result: 1983MB
Check complete. The overall result of 

this check is: Passed


Check complete: Passed
=======================================================================


Performing check for DetectIfDHCPAssignedIP
Checking Network Configuration 

requirements ...
Check complete. The overall result of this check is: Not executed 

<<<<


Check complete: Not executed <<<<
Recommendation: Oracle supports 

installations on systems with DHCP-assigned public IP addresses.  However, the 

primary network interface on the system should be configured with a static IP 

address in order for the Oracle Software to function properly.  See the 

Installation Guide for more details on installing the software on systems 

configured with DHCP.

=======================================================================


Performing check for OracleBase
Validating ORACLE_BASE location (if set) ...
Check 

complete. The overall result of this check is: Passed


Check complete: Passed
=======================================================================


Performing check for OracleHomeSpace
Checking Oracle Home path for spaces...
Check 

complete. The overall result of this check is: Passed


Check complete: Passed
=======================================================================


Performing check for DetectAnyInvalidASMHome
Checking for proper system clean-

up....
Check complete. The overall result of this check is: Passed


Check complete: 

Passed
======================================================================

Performing check for CompatibilityChecks
Checking for Oracle Home 

incompatibilities ....
Actual Result: NEW_HOME
Check complete. The overall result 

of this check is: Passed


Check complete: Passed
=======================================================================
PrereqChecks complete

.......................................... 100% Done.


-----------------------------------------------------------------------------


Summary
Global Settings
    Source: /home/oracle/database/stage/products.xml
    

Oracle Home: /u01/app/oracle/product/10.2.0/db_1 (OraDb10g_home1)
    Installation 

Type: Enterprise Edition
Product Languages
   English
Space Requirements
   / 

Required 2.03GB (includes 108MB temporary) : Available 22.15GB
New Installations 

(107 products)
   Oracle Database 10g 10.2.0.1.0
   Enterprise Edition Options 

10.2.0.1.0
   Oracle Partitioning 10.2.0.1.0
   Oracle Spatial 10.2.0.1.0
   Oracle 

OLAP 10.2.0.1.0
   Oracle Enterprise Manager Console DB 10.2.0.1.0
   Oracle Net 

Services 10.2.0.1.0
   Oracle Database 10g 10.2.0.1.0
   Oracle Net Listener 

10.2.0.1.0
   HAS Files for DB 10.2.0.1.0
   Oracle Internet Directory Client 

10.2.0.1.0
   Oracle Call Interface (OCI) 10.2.0.1.0
   Oracle Programmer 

10.2.0.1.0
   Oracle interMedia 10.2.0.1.0
   Enterprise Manager Agent Core 

10.2.0.1.0
   Oracle JVM 10.2.0.1.0
   Database Configuration and Upgrade 

Assistants 10.2.0.1.0
   Oracle interMedia Locator 10.2.0.1.0
   Oracle XML 

Development Kit 10.2.0.1.0
   Oracle Text 10.2.0.1.0
   Oracle Database Utilities 

10.2.0.1.0
   Generic Connectivity Common Files 10.2.0.1.0
   Oracle Advanced 

Security 10.2.0.1.0
   Enterprise Manager Repository Core 10.2.0.1.0
   PL/SQL 

10.2.0.1.0
   Oracle Net 10.2.0.1.0
   Assistant Common Files 10.2.0.1.0
   

Enterprise Manager plugin Common Files 10.2.0.1.0 Beta
   Buildtools Common Files 

10.2.0.1.0
   Installation Common Files 10.2.0.1.0
   Oracle LDAP administration 

10.2.0.1.0
   Oracle Java Client 10.2.0.1.0
   Precompiler Common Files 10.2.0.1.0
  

 Oracle Recovery Manager 10.2.0.1.0
   SQL*Plus 10.2.0.1.0
   iSQL*Plus 10.2.0.1.0
  

 Enterprise Manager plugin Common Files 10.2.0.1.0
   HAS Common Files 10.2.0.1.0
  

 Oracle Clusterware RDBMS Files 10.2.0.1.0
   Oracle Wallet Manager 10.2.0.1.0
   

Enterprise Manager Minimal Integration 10.2.0.1.0
   Oracle Database User 

Interface 2.2.13.0.0
   Secure Socket Layer 10.2.0.1.0
   Oracle ODBC Driver 

10.2.0.1.0
   Required Support Files 10.2.0.1.0
   Database SQL Scripts 10.2.0.1.0
  

 OLAP SQL Scripts 10.2.0.1.0
   PL/SQL Embedded Gateway 10.2.0.1.0
   Oracle 

Globalization Support 10.2.0.1.0
   Character Set Migration Utility 10.2.0.1.0
   

LDAP Required Support Files 10.2.0.1.0
   Oracle Help for the  Web 1.1.10.0.0
   

Oracle JDBC Thin Driver for JDK 1.4 10.2.0.1.0
   Oracle JDBC Thin Driver for JDK 

1.2 10.2.0.1.0
   Oracle interMedia Client Option 10.2.0.1.0
   Oracle Notification 

Service 10.1.0.3.0
   Oracle Code Editor 1.2.1.0.0I
   Perl Interpreter 5.8.3.0.2
   

JDBC Common Files 10.2.0.1.0
   Oracle Locale Builder 10.2.0.1.0
   Oracle 

Containers for Java 10.2.0.1.0
   Database Workspace Manager 10.2.0.1.0
   Oracle 

Core Required Support Files 10.2.0.1.0
   Platform Required Support Files 

10.2.0.1.0
   Oracle interMedia Locator RDBMS Files 10.2.0.1.0
   Oracle JDBC/OCI 

Instant Client 10.2.0.1.0
   Oracle interMedia Annotator 10.2.0.1.0
   SQLJ Runtime 

10.2.0.1.0
   Oracle interMedia Java Advanced Imaging 10.2.0.1.0
   Oracle Database 

10g interMedia Files 10.2.0.1.0
   Oracle Data Mining RDBMS Files 10.2.0.1.0
   

Enterprise Manager Baseline 10.2.0.1.0
   Oracle Help For Java 4.2.6.1.0
   Oracle 

UIX 2.1.22.0.0
   XML Parser for Java 10.2.0.1.0
   Precompiler Required Support 

Files 10.2.0.1.0
   XML Parser for Oracle JVM 10.2.0.1.0
   Oracle Message Gateway 

Common Files 10.2.0.1.0
   Oracle Starter Database 10.2.0.1.0
   Sample Schema Data 

10.2.0.1.0
   Parser Generator Required Support Files 10.2.0.1.0
   Agent Required 

Support Files 10.2.0.1.0
   Oracle RAC Required Support Files-HAS 10.2.0.1.0
   

RDBMS Required Support Files 10.2.0.1.0
   RDBMS Required Support Files for 

Instant Client 10.2.0.1.0
   XDK Required Support Files 10.2.0.1.0
   Oracle OLAP 

API 10.2.0.1.0
   Oracle OLAP RDBMS Files 10.2.0.1.0
   DBJAVA Required Support 

Files 10.2.0.1.0
   SQL*Plus Required Support Files 10.2.0.1.0
   Oracle JFC 

Extended Windowing Toolkit 4.2.33.0.0
   Oracle Ice Browser 5.2.3.6.0
   Oracle 

Display Fonts 9.0.2.0.0
   Oracle Extended Windowing Toolkit 3.4.38.0.0
   

Enterprise Manager Common Files 10.2.0.1.0
   Enterprise Manager Agent DB 

10.2.0.1.0
   Oracle Net Required Support Files 10.2.0.1.0
   Enterprise Manager 

Repository DB 10.2.0.1.0
   SSL Required Support Files for InstantClient 

10.2.0.1.0
   regexp 2.1.9.0.0
   Bali Share 1.1.18.0.0
   Oracle Universal 

Installer 10.2.0.1.0
   Oracle One-Off Patch Installer 10.2.0.1.0
   Installer SDK 

Component 10.2.0.1.0
   Java Runtime Environment 1.4.2.8.0
   Sun JDK 1.4.2.0.8
   

Sun JDK extensions 10.1.2.0.0
-----------------------------------------------------------------------------


Installation in progress (Sun Jul 15 22:40:13 IST 2012)
...............................................................  11% Done.
...............................................................  23% Done.
...............................................................  35% Done.
...............................................................  47% Done.
...........................................                      55% Done.
Install 

successful

Linking in progress (Sun Jul 15 22:42:12 IST 2012)
.                     

                                           55% Done.
Link successful

Setup in 

progress (Sun Jul 15 22:43:23 IST 2012)
....................                       

                     100% Done.
Setup successful

End of install phases.(Sun Jul 15 

22:43:29 IST 2012)
Starting to execute configuration assistants
Configuration 

assistant "Oracle Net Configuration Assistant" succeeded
Configuration assistant 

"Oracle Database Configuration Assistant" succeeded
Configuration assistant 

"iSQL*Plus Configuration Assistant" succeeded
WARNING:A new inventory has been 

created in this session. However, it has not yet been registered as the central 

inventory of this system.
To register the new inventory please run the script 

'/u01/app/oracle/oraInventory/orainstRoot.sh' with root privileges.
If you do not 

register the inventory, you may not be able to update or patch the products you 

installed.

The following configuration scripts
/u01/app/oracle/product/10.2.0/db_1/root.sh
need to be executed as root for 

configuring the system. If you skip the execution of the configuration tools, the 

configuration will not be complete and the product wont function properly. In 

order to get the product to function properly, you will be required to execute 

the scripts and the configuration tools after exiting the OUI.

The installation of 

Oracle Database 10g was successful.
Please check 

'/u01/app/oracle/oraInventory/logs/silentInstall2012-07-15_10-39-59PM.log' for 

more details.

*******************************************************************************

Run the scripts as root user

/u01/app/oracle/product/10.2.0/db_1/root.sh
/u01/app/oracle/oraInventory/orainstRoot.sh
Response file 

copy below matter paste it in notepad save it as oracle10g.rsp
_______________________________________________________________________________


####################################################################
## Copyright (c) 1999, 2004 Oracle. All rights reserved.          ##
##                                                                ##
## Specify values for the variables listed below to customize     ##
## your installation.                                             ##
##                                                                ##
## Each variable is associated with a comment. The comment        ##
## identifies the variable type.                                  ##
##                                                                ##
## Please specify the values in the following format:             ##
##                                                                ##
##         Type         Example                                   ##
##         String       "Sample Value"                            ##
##         Boolean      True or False                             ##
##         Number       1000                                      ##
##         StringList   {"String value 1","String Value 2"}       ##
##                                                                ##
## The values that are given as <value required=""> need to be    ##
## specified for a silent installation to be successful.          ##
##                                                                ##
##                                                                ##
## This response file is generated by Oracle Software             ##
## Packager.                                                      ##
####################################################################


RESPONSEFILE_VERSION=2.2.1.0.0

#-------------------------------------------------------------------------------
#Name       : UNIX_GROUP_NAME
#Datatype   : String
#Description: Unix group to be set for the inventory directory. Valid only in Unix platforms.
#Example: UNIX_GROUP_NAME = "install"
#-------------------------------------------------------------------------------
UNIX_GROUP_NAME="oinstall"

#-------------------------------------------------------------------------------
#Name       : FROM_LOCATION
#Datatype   : String
#Description: Complete path to the products.xml.
#Example: FROM_LOCATION = "../stage/products.xml"
#-------------------------------------------------------------------------------
FROM_LOCATION="/home/oracle/database/stage/products.xml"

#-------------------------------------------------------------------------------
#Name       : FROM_LOCATION_CD_LABEL
#Datatype   : String
#Description: This variable should only be used in multi-CD installations. It includes the label of the compact disk where the file "products.xml" exists. The label can be found in the file "disk.label" in the same directory as products.xml.
#Example: FROM_LOCATION_CD_LABEL = "CD Label"
#-------------------------------------------------------------------------------
FROM_LOCATION_CD_LABEL=<value unspecified="">

#-------------------------------------------------------------------------------
#Name       : ORACLE_HOME
#Datatype   : String
#Description: Complete path of the Oracle Home.
#Example: ORACLE_HOME = "C:\OHOME1"
#-------------------------------------------------------------------------------
ORACLE_HOME="/u01/app/oracle/product/10.2.0/db_1"

#-------------------------------------------------------------------------------
#Name       : ORACLE_HOME_NAME
#Datatype   : String
#Description: Oracle Home Name. Used in creating folders and services.
#Example: ORACLE_HOME_NAME = "OHOME1"
#-------------------------------------------------------------------------------
ORACLE_HOME_NAME="OraDb10g_home1"

#-------------------------------------------------------------------------------
#Name       : SHOW_WELCOME_PAGE
#Datatype   : Boolean
#Description: Set to true if the Welcome page in OUI needs to be shown.
#Example: SHOW_WELCOME_PAGE = false
#-------------------------------------------------------------------------------
SHOW_WELCOME_PAGE=true

#-------------------------------------------------------------------------------
#Name       : SHOW_CUSTOM_TREE_PAGE
#Datatype   : Boolean
#Description: Set to true if the custom tree page in OUI needs to be shown.
#Use this page to select or de-select dependencies. This page appears only in a custom install type.
#Example: SHOW_CUSTOM_TREE_PAGE = false
#-------------------------------------------------------------------------------
SHOW_CUSTOM_TREE_PAGE=true

#-------------------------------------------------------------------------------
#Name       : SHOW_COMPONENT_LOCATIONS_PAGE
#Datatype   : Boolean
#Description: Set to true if the component locations page in OUI needs to be shown.
#This page only appears if there are products whose installed directory can be changed.
#If you set this to false you will prevent the user from being able to specify alternate directories.
#Example: SHOW_COMPONENT_LOCATIONS_PAGE = false
#-------------------------------------------------------------------------------
SHOW_COMPONENT_LOCATIONS_PAGE=true

#-------------------------------------------------------------------------------
#Name       : SHOW_SUMMARY_PAGE
#Datatype   : Boolean
#Description: Set to true if the summary page in OUI needs to be shown.
#The summary page shows the list of components that will be installed in this session.
#Example: SHOW_SUMMARY_PAGE = true
#-------------------------------------------------------------------------------
SHOW_SUMMARY_PAGE=true

#-------------------------------------------------------------------------------
#Name       : SHOW_INSTALL_PROGRESS_PAGE
#Datatype   : Boolean
#Description: Set to true if the install progress page in OUI needs to be shown.
#This page shows the current status in the installation. The current status includes the product being installed and the file being copied.
#Example: SHOW_INSTALL_PROGRESS_PAGE = true
#-------------------------------------------------------------------------------
SHOW_INSTALL_PROGRESS_PAGE=true

#-------------------------------------------------------------------------------
#Name       : SHOW_REQUIRED_CONFIG_TOOL_PAGE
#Datatype   : Boolean
#Description: Set to true if the required config assistants page in OUI needs to be shown.
#This page shows the list of required configuration assistants that are part of this installation.
#It shows the status of each assistant, including any failures with detailed information on why it failed.
#Example: SHOW_REQUIRED_CONFIG_TOOL_PAGE = true
#-------------------------------------------------------------------------------
SHOW_REQUIRED_CONFIG_TOOL_PAGE=true

#-------------------------------------------------------------------------------
#Name       : SHOW_CONFIG_TOOL_PAGE
#Datatype   : Boolean
#Description: Set to true if the config assistants page in OUI needs to be shown.
#This page shows the list of configuration assistants that are part of this installation and are configured to launch automatically.
#It shows the status of each assistant, including any failures with detailed information on why it failed.
#Example: SHOW_CONFIG_TOOL_PAGE = true
#-------------------------------------------------------------------------------
SHOW_CONFIG_TOOL_PAGE=true

#-------------------------------------------------------------------------------
#Name       : SHOW_RELEASE_NOTES
#Datatype   : Boolean
#Description: Set to true if the release notes of this installation need to be shown at the end of installation.
#This dialog is launchable from the End of Installation page and shows the list of release notes available for the products just installed.
# This also requires the variable SHOW_END_SESSION_PAGE variable to be set to true.
#Example: SHOW_RELEASE_NOTES = true
#-------------------------------------------------------------------------------
SHOW_RELEASE_NOTES=true

#-------------------------------------------------------------------------------
#Name       : SHOW_ROOTSH_CONFIRMATION
#Datatype   : Boolean
#Description: Set to true if the Confirmation dialog asking to run the root.sh script in OUI needs to be shown.
#Valid only for Unix platforms.
#Example: SHOW_ROOTSH_CONFIRMATION = true
#-------------------------------------------------------------------------------
SHOW_ROOTSH_CONFIRMATION=true

#-------------------------------------------------------------------------------
#Name       : SHOW_END_SESSION_PAGE
#Datatype   : Boolean
#Description: Set to true if the end of session page in OUI needs to be shown.
#This page shows if the installation is successful or not.
#Example: SHOW_END_SESSION_PAGE = true
#-------------------------------------------------------------------------------
SHOW_END_SESSION_PAGE=true

#-------------------------------------------------------------------------------
#Name       : SHOW_EXIT_CONFIRMATION
#Datatype   : Boolean
#Description: Set to true if the confirmation when exiting OUI needs to be shown.
#Example: SHOW_EXIT_CONFIRMATION = true
#-------------------------------------------------------------------------------
SHOW_EXIT_CONFIRMATION=true

#-------------------------------------------------------------------------------
#Name       : NEXT_SESSION
#Datatype   : Boolean
#Description: Set to true to allow users to go back to the File Locations page for another installation. This flag also needs to be set to true in order to process another response file (see NEXT_SESSION_RESPONSE).
#Example: NEXT_SESSION = true
#-------------------------------------------------------------------------------
NEXT_SESSION=false

#-------------------------------------------------------------------------------
#Name       : NEXT_SESSION_ON_FAIL
#Datatype   : Boolean
#Description: Set to true to allow users to invoke another session even if current install session has failed. This flag is only relevant if NEXT_SESSION is set to true.
#Example: NEXT_SESSION_ON_FAIL = true
#-------------------------------------------------------------------------------
NEXT_SESSION_ON_FAIL=true

#-------------------------------------------------------------------------------
#Name       : NEXT_SESSION_RESPONSE
#Datatype   : String
#Description: Set to true to allow users to go back to the File Locations page for another installation. This flag also needs to be set to true in order to process another response file (see NEXT_SESSION_RESPONSE).
#Example: NEXT_SESSION_RESPONSE = "nextinstall.rsp"
#-------------------------------------------------------------------------------
NEXT_SESSION_RESPONSE=<value unspecified="">

#-------------------------------------------------------------------------------
#Name       : DEINSTALL_LIST
#Datatype   : StringList
#Description: List of components to be deinstalled during a deinstall session.
#Example: DEINSTALL_LIST = {"oracle.server","10.2.0.1.0"}
#-------------------------------------------------------------------------------
DEINSTALL_LIST={"oracle.server","10.2.0.1.0"}

#-------------------------------------------------------------------------------
#Name       : SHOW_DEINSTALL_CONFIRMATION
#Datatype   : Boolean
#Description: Set to true if deinstall confimation is needed during a deinstall session.
#Example: SHOW_DEINSTALL_CONFIRMATION = true
#-------------------------------------------------------------------------------
SHOW_DEINSTALL_CONFIRMATION=true

#-------------------------------------------------------------------------------
#Name       : SHOW_DEINSTALL_PROGRESS
#Datatype   : Boolean
#Description: Set to true if deinstall progress is needed during a deinstall session.
#Example: SHOW_DEINSTALL_PROGRESS = true
#-------------------------------------------------------------------------------
SHOW_DEINSTALL_PROGRESS=true

#-------------------------------------------------------------------------------
#Name       : CLUSTER_NODES
#Datatype   : StringList
#Description: This variable represents the cluster node names selected by the user for installation.
#Example: CLUSTER_NODES = {"node1","node2"}
#-------------------------------------------------------------------------------
CLUSTER_NODES={}

#-------------------------------------------------------------------------------
#Name       : ACCEPT_LICENSE_AGREEMENT
#Datatype   : Boolean
#Description: By setting this variable to true, you are accepting the license agreement. This variable is used only for silent installations.
#Example: ACCEPT_LICENSE_AGREEMENT = true
#-------------------------------------------------------------------------------
ACCEPT_LICENSE_AGREEMENT=false

#-------------------------------------------------------------------------------
#Name       : TOPLEVEL_COMPONENT
#Datatype   : StringList
#Description: The top level component to be installed in the current session.
#Example: TOPLEVEL_COMPONENT = {"oracle.server","10.2.0.1.0"}
#-------------------------------------------------------------------------------
TOPLEVEL_COMPONENT={"oracle.server","10.2.0.1.0"}

#-------------------------------------------------------------------------------
#Name       : SHOW_SPLASH_SCREEN
#Datatype   : Boolean
#Description: Set to true if the initial splash screen in OUI needs to be shown.
#Example: SHOW_SPLASH_SCREEN = true
#-------------------------------------------------------------------------------
SHOW_SPLASH_SCREEN=true

#-------------------------------------------------------------------------------
#Name       : SELECTED_LANGUAGES
#Datatype   : StringList
#Description: Languages in which the components will be installed.
#Component  : oracle.server
#-------------------------------------------------------------------------------

SELECTED_LANGUAGES={"en"}

#-------------------------------------------------------------------------------
#Name       : COMPONENT_LANGUAGES
#Datatype   : StringList
#Description: Languages supported by this component.List of supported languages : {"en","fr","ar","bn","pt_BR","bg","fr_CA","ca","hr","cs","da","nl","ar_EG","en_GB","et","fi","de","el","iw","hu","is","in","it","ja","ko","es","lv","lt","ms","es_MX","no","pl","pt","ro","ru","zh_CN","sk","sl","es_ES","sv","th","zh_TW","tr","uk","vi"}
#Component  : oracle.server
#-------------------------------------------------------------------------------

COMPONENT_LANGUAGES={"en"}

#-------------------------------------------------------------------------------
#Name       : INSTALL_TYPE
#Datatype   : String
#Description: Installation type of the component.
#Component  : oracle.server
#-------------------------------------------------------------------------------

INSTALL_TYPE="Enterprise Edition"

#-------------------------------------------------------------------------------
#Name       : sl_superAdminPasswds
#Datatype   : StringList
#Description: List of passwords
#Component  : oracle.server
#-------------------------------------------------------------------------------

sl_superAdminPasswds=<value unspecified="">

#-------------------------------------------------------------------------------
#Name       : sl_dlgASMCfgSelectableDisks
#Datatype   : StringList
#Description: Disk Groups that can be selected
#Component  : oracle.server
#-------------------------------------------------------------------------------

sl_dlgASMCfgSelectableDisks={}

#-------------------------------------------------------------------------------
#Name       : s_superAdminSamePasswd
#Datatype   : String
#Description: Same Password Field
#Component  : oracle.server
#-------------------------------------------------------------------------------

s_superAdminSamePasswd=<value unspecified="">

#-------------------------------------------------------------------------------
#Name       : s_globalDBName
#Datatype   : String
#Description: Global Database Name
#Component  : oracle.server
#-------------------------------------------------------------------------------

s_globalDBName="orcl"

#-------------------------------------------------------------------------------
#Name       : s_dlgASMCfgRedundancyValue
#Datatype   : String
#Description: Redundancy Value
#Component  : oracle.server
#-------------------------------------------------------------------------------

s_dlgASMCfgRedundancyValue="2 (Norm)"

#-------------------------------------------------------------------------------
#Name       : s_dlgASMCfgNewDisksSize
#Datatype   : String
#Description: New Disks Size
#Component  : oracle.server
#-------------------------------------------------------------------------------

s_dlgASMCfgNewDisksSize="0"

#-------------------------------------------------------------------------------
#Name       : s_dlgASMCfgExistingFreeSpace
#Datatype   : String
#Description: Existing Freee Space
#Component  : oracle.server
#-------------------------------------------------------------------------------

s_dlgASMCfgExistingFreeSpace="0"

#-------------------------------------------------------------------------------
#Name       : s_dlgASMCfgDiskGroupName
#Datatype   : String
#Description: Disk Group Name
#Component  : oracle.server
#-------------------------------------------------------------------------------

s_dlgASMCfgDiskGroupName="DATA"

#-------------------------------------------------------------------------------
#Name       : s_dlgASMCfgDiskDiscoveryString
#Datatype   : String
#Description: Disk Discovery STring
#Component  : oracle.server
#-------------------------------------------------------------------------------

s_dlgASMCfgDiskDiscoveryString=""

#-------------------------------------------------------------------------------
#Name       : s_dlgASMCfgAdditionalSpaceNeeded
#Datatype   : String
#Description: Additional Space Needed
#Component  : oracle.server
#-------------------------------------------------------------------------------

s_dlgASMCfgAdditionalSpaceNeeded=" MB"

#-------------------------------------------------------------------------------
#Name       : s_dbSelectedUsesASM
#Datatype   : String
#Description: SID selected for upgrade
#Component  : oracle.server
#-------------------------------------------------------------------------------

s_dbSelectedUsesASM=""

#-------------------------------------------------------------------------------
#Name       : s_dbSIDSelectedForUpgrade
#Datatype   : String
#Description: SID selected for upgrade
#Component  : oracle.server
#-------------------------------------------------------------------------------

s_dbSIDSelectedForUpgrade=""

#-------------------------------------------------------------------------------
#Name       : s_dbRetChar
#Datatype   : String
#Description: Return value for database character set.
#Component  : oracle.server
#-------------------------------------------------------------------------------

s_dbRetChar="Responsefile entry West European WE8ISO8859P1"

#-------------------------------------------------------------------------------
#Name       : s_dbOHSelectedForUpgrade
#Datatype   : String
#Description: OH selected for upgrade
#Component  : oracle.server
#-------------------------------------------------------------------------------

s_dbOHSelectedForUpgrade=""

#-------------------------------------------------------------------------------
#Name       : s_ASMSYSPassword
#Datatype   : String
#Description: ASM SYS Password
#Component  : oracle.server
#-------------------------------------------------------------------------------

s_ASMSYSPassword=<value unspecified="">

#-------------------------------------------------------------------------------
#Name       : n_performUpgrade
#Datatype   : Number
#Description: 1 if user selects to perform upgrade
#Component  : oracle.server
#-------------------------------------------------------------------------------

n_performUpgrade=0

#-------------------------------------------------------------------------------
#Name       : n_dlgASMCfgRedundancySelected
#Datatype   : Number
#Description: Redundancy value selected
#Component  : oracle.server
#-------------------------------------------------------------------------------

n_dlgASMCfgRedundancySelected=2

#-------------------------------------------------------------------------------
#Name       : n_dbType
#Datatype   : Number
#Description: This variable contains the dbType i.e. GP, TP, DW or Advanced
#Component  : oracle.server
#-------------------------------------------------------------------------------

n_dbType=1

#-------------------------------------------------------------------------------
#Name       : n_dbSelection
#Datatype   : Number
#Description: row selected in the spread table of upgradable DB instances
#Component  : oracle.server
#-------------------------------------------------------------------------------

n_dbSelection=0

#-------------------------------------------------------------------------------
#Name       : b_useSamePassword
#Datatype   : Boolean
#Description: Usable only when SHOW_SCHEMA_PASSWORDS_PAGE is set to false.
Set this to true if same password across all the schemas is desired, else false to enter distinguish passwords for each schema.
If set to true, values from s_superAdminSamePasswd and s_superAdminSamePasswdAgain are picked up, else stringlists sl_superAdminPasswds and sl_superAdminPasswdsAgain are used.
#Component  : oracle.server
#-------------------------------------------------------------------------------

b_useSamePassword=true

#-------------------------------------------------------------------------------
#Name       : b_useFileSystemForRecovery
#Datatype   : Boolean
#Description: Usable only when SHOW_BACKUP_RECOVERY_OPTION_PAGE is set to false and b_enableAutoBackup is set to true.
Set this to true (default) if recovery into file system is desired, else to false for ASM recovery .
#Component  : oracle.server
#-------------------------------------------------------------------------------

b_useFileSystemForRecovery=true

#-------------------------------------------------------------------------------
#Name       : b_receiveEmailNotification
#Datatype   : Boolean
#Description: Usable only when SHOW_DATABASE_MANAGEMENT_PAGE is set to false and b_useDBControl is set to true.
Set this to true if email update is desired, false is the default .
#Component  : oracle.server
#-------------------------------------------------------------------------------

b_receiveEmailNotification=false

#-------------------------------------------------------------------------------
#Name       : b_loadExampleSchemas
#Datatype   : Boolean
#Description: Usable only when SHOW_DATABASE_OPTIONS_PAGE is set to false.
Set this to true if loading example schemas is desired, else false so database won't be created with example schemas. The default is false.
#Component  : oracle.server
#-------------------------------------------------------------------------------

b_loadExampleSchemas=false

#-------------------------------------------------------------------------------
#Name       : b_enableAutoBackup
#Datatype   : Boolean
#Description: Usable only when SHOW_BACKUP_RECOVERY_OPTION_PAGE is set to false.
Set this to true if automatic backup of the database is desired, else false to disable backup.
#Component  : oracle.server
#-------------------------------------------------------------------------------

b_enableAutoBackup=false

#-------------------------------------------------------------------------------
#Name       : b_dlgASMShowCandidateDisks
#Datatype   : Boolean
#Description: set to true if Candidate Disks is selected in ASM dialog
#Component  : oracle.server
#-------------------------------------------------------------------------------

b_dlgASMShowCandidateDisks=true

#-------------------------------------------------------------------------------
#Name       : b_centrallyManageASMInstance
#Datatype   : Boolean
#Description: true if ASM instance needs to be managed by grid control
#Component  : oracle.server
#-------------------------------------------------------------------------------

b_centrallyManageASMInstance=true

#-------------------------------------------------------------------------------
#Name       : sl_dlgASMDskGrpSelectedGroup
#Datatype   : StringList
#Description: Disk Groups that is selected
#Component  : oracle.server
#-------------------------------------------------------------------------------

sl_dlgASMDskGrpSelectedGroup={" "," "," "," "}

#-------------------------------------------------------------------------------
#Name       : s_dlgRBOUsername
#Datatype   : String
#Description: Username
#Component  : oracle.server
#-------------------------------------------------------------------------------

s_dlgRBOUsername=""

#-------------------------------------------------------------------------------
#Name       : s_dlgEMCentralAgentSelected
#Datatype   : String
#Description: Strores the central agent selected
#Component  : oracle.server
#-------------------------------------------------------------------------------

s_dlgEMCentralAgentSelected="No Agents Found"

#-------------------------------------------------------------------------------
#Name       : b_useDBControl
#Datatype   : Boolean
#Description: Usable only when SHOW_DATABASE_MANAGEMENT_PAGE is set to false.
Set this to true if using database control to manage the database is desired, else false so database can be managed by grid control.
#Component  : oracle.server
#-------------------------------------------------------------------------------

b_useDBControl=true

#-------------------------------------------------------------------------------
#Name       : s_superAdminSamePasswdAgain
#Datatype   : String
#Description: Confirmation of password.
#Component  : oracle.server
#-------------------------------------------------------------------------------

s_superAdminSamePasswdAgain=<value unspecified="">

#-------------------------------------------------------------------------------
#Name       : s_dlgEMSMTPServer
#Datatype   : String
#Description: Stores SMTP Server name
#Component  : oracle.server
#-------------------------------------------------------------------------------

s_dlgEMSMTPServer=""

#-------------------------------------------------------------------------------
#Name       : s_dlgEMEmailAddress
#Datatype   : String
#Description: stores the email address
#Component  : oracle.server
#-------------------------------------------------------------------------------

s_dlgEMEmailAddress=""

#-------------------------------------------------------------------------------
#Name       : s_dlgRBORecoveryLocation
#Datatype   : String
#Description: Recovery area location
#Component  : oracle.server
#-------------------------------------------------------------------------------

s_dlgRBORecoveryLocation="/u01/app/oracle/flash_recovery_area/"

#-------------------------------------------------------------------------------
#Name       : n_upgradeDB
#Datatype   : Number
#Description: 1 if user selects to upgrade DB
#Component  : oracle.server
#-------------------------------------------------------------------------------

n_upgradeDB=1

#-------------------------------------------------------------------------------
#Name       : n_configurationOption
#Datatype   : Number
#Description: This variable contains the configuration option i.e. createDB or configureASM or SoftwareOnly
#Component  : oracle.server
#-------------------------------------------------------------------------------

n_configurationOption=1

#-------------------------------------------------------------------------------
#Name       : sl_upgradableSIDBInstances
#Datatype   : StringList
#Description: This is list of SIDs, OH and whether SID uses ASM or not. contains DB instance details that are displayed in dialog's spread table.
#Component  : oracle.server
#-------------------------------------------------------------------------------

sl_upgradableSIDBInstances={}

#-------------------------------------------------------------------------------
#Name       : n_upgradeASM
#Datatype   : Number
#Description: 1 is user selects to upgrade DB
#Component  : oracle.server
#-------------------------------------------------------------------------------

n_upgradeASM=0

#-------------------------------------------------------------------------------
#Name       : sl_dlgASMCfgDiskSelections
#Datatype   : StringList
#Description: List of Selected Member Disks
#Component  : oracle.server
#-------------------------------------------------------------------------------

sl_dlgASMCfgDiskSelections={}

#-------------------------------------------------------------------------------
#Name       : s_ASMSYSPasswordAgain
#Datatype   : String
#Description: ASM Sys password confirmation
#Component  : oracle.server
#-------------------------------------------------------------------------------

s_ASMSYSPasswordAgain=<value unspecified="">

#-------------------------------------------------------------------------------
#Name       : n_dbStorageType
#Datatype   : Number
#Description: Usable only when SHOW_DATABASE_FILE_STORAGE_OPTION_PAGE is set to false.
Set this to the following numbers for corresponding database storage type desired:
1 - File System (default)
2 - ASM
3 - Raw Devices
#Component  : oracle.server
#-------------------------------------------------------------------------------

n_dbStorageType=1

#-------------------------------------------------------------------------------
#Name       : s_rawDeviceMapFileLocation
#Datatype   : String
#Description: Text2
#Component  : oracle.server
#-------------------------------------------------------------------------------

s_rawDeviceMapFileLocation=""

#-------------------------------------------------------------------------------
#Name       : sl_upgradableRACDBInstances
#Datatype   : StringList
#Description: contains DB instance details that are displayed in dialog's sprea table.
#Component  : oracle.server
#-------------------------------------------------------------------------------

sl_upgradableRACDBInstances={}

#-------------------------------------------------------------------------------
#Name       : s_dlgRBOPassword
#Datatype   : String
#Description: Password
#Component  : oracle.server
#-------------------------------------------------------------------------------

s_dlgRBOPassword=<value unspecified="">

#-------------------------------------------------------------------------------
#Name       : b_stateOfUpgradeDBCheckbox
#Datatype   : Boolean
#Description: stores the state of checkbox in UI
#Component  : oracle.server
#-------------------------------------------------------------------------------

b_stateOfUpgradeDBCheckbox=false

#-------------------------------------------------------------------------------
#Name       : s_dbSid
#Datatype   : String
#Description: Value that $ORACLE_SID will be set to.
#Component  : oracle.server
#-------------------------------------------------------------------------------

s_dbSid="orcl"

#-------------------------------------------------------------------------------
#Name       : b_dbSelectedUsesASM
#Datatype   : Boolean
#Description: stores the state of checkbox in UI
#Component  : oracle.server
#-------------------------------------------------------------------------------

b_dbSelectedUsesASM=false

#-------------------------------------------------------------------------------
#Name       : sl_superAdminPasswdsAgain
#Datatype   : StringList
#Description: Confirm Password list.
#Component  : oracle.server
#-------------------------------------------------------------------------------

sl_superAdminPasswdsAgain=<value unspecified="">

#-------------------------------------------------------------------------------
#Name       : s_mountPoint
#Datatype   : String
#Description: Database file location:  directory for datafiles, control files, redo logs.
#Component  : oracle.server
#-------------------------------------------------------------------------------

s_mountPoint="/u01/app/oracle/oradata/"

#-------------------------------------------------------------------------------
#Name       : b_stateOfUpgradeASMCheckbox
#Datatype   : Boolean
#Description: stores the state of checkbox in UI
#Component  : oracle.server
#-------------------------------------------------------------------------------

b_stateOfUpgradeASMCheckbox=false

#-------------------------------------------------------------------------------
#Name       : OPTIONAL_CONFIG_TOOLS
#Datatype   : String
#Description: #The following choices are available. The value should contain only one of these choices.
#The choices are of the form Internal Name : External name. Please use the internal name while specifying the value.List of optional config assistants that need to be launched.
#    localconfig,   : Cluster Synchronization Service Configuration
#    dbma,   : Database Upgrade Assistant
#Example: OPTIONAL_CONFIG_TOOLS = {"localconfig"}
#Component  : oracle.assistants.server
#-------------------------------------------------------------------------------

oracle.assistants.server:OPTIONAL_CONFIG_TOOLS="{}"

#-------------------------------------------------------------------------------
#Name       : OPTIONAL_CONFIG_TOOLS
#Datatype   : String
#Description: #The following choices are available. The value should contain only one of these choices.
#The choices are of the form Internal Name : External name. Please use the internal name while specifying the value.List of optional config assistants that need to be launched.
#    LocalConfig,   : Deinstall Oracle Cluster Synchronization Service
#Example: OPTIONAL_CONFIG_TOOLS = {"LocalConfig"}
#Component  : oracle.has.common
#-------------------------------------------------------------------------------

oracle.has.common:OPTIONAL_CONFIG_TOOLS="{}"

#-------------------------------------------------------------------------------
#Name       : OPTIONAL_CONFIG_TOOLS
#Datatype   : String
#Description: #The following choices are available. The value should contain only one of these choices.
#The choices are of the form Internal Name : External name. Please use the internal name while specifying the value.List of optional config assistants that need to be launched.
#    netca_deinst,   : Oracle Net Configuration Assistant - Deinstall Script
#Example: OPTIONAL_CONFIG_TOOLS = {"netca_deinst"}
#Component  : oracle.network.client
#-------------------------------------------------------------------------------

oracle.network.client:OPTIONAL_CONFIG_TOOLS="{}"

#-------------------------------------------------------------------------------
#Name       : OPTIONAL_CONFIG_TOOLS
#Datatype   : String
#Description: #The following choices are available. The value should contain only one of these choices.
#The choices are of the form Internal Name : External name. Please use the internal name while specifying the value.List of optional config assistants that need to be launched.
#    isqlplus,   : iSQL*Plus Configuration Assistant
#    removeisqlplusSrvc,   : Remove iSQL*Plus Service
#Example: OPTIONAL_CONFIG_TOOLS = {"isqlplus"}
#Component  : oracle.sqlplus.isqlplus
#-------------------------------------------------------------------------------

oracle.sqlplus.isqlplus:OPTIONAL_CONFIG_TOOLS="{}"

#-------------------------------------------------------------------------------
#Name       : OPTIONAL_CONFIG_TOOLS
#Datatype   : String
#Description: #The following choices are available. The value should contain only one of these choices.
#The choices are of the form Internal Name : External name. Please use the internal name while specifying the value.List of optional config assistants that need to be launched.
#    launchBrowser,   : Launch browser
#Example: OPTIONAL_CONFIG_TOOLS = {"launchBrowser"}
#Component  : oracle.sysman.console.db
#-------------------------------------------------------------------------------

oracle.sysman.console.db:OPTIONAL_CONFIG_TOOLS="{}"

#-------------------------------------------------------------------------------
#Name       : varSelect
#Datatype   : Number
#Description: Return index selected from dialog
#Component  : oracle.assistants.server
#-------------------------------------------------------------------------------

varSelect=1

#-------------------------------------------------------------------------------
#Name       : s_nameForOPERGrp
#Datatype   : String
#Description: oper group
#Component  : oracle.rdbms
#-------------------------------------------------------------------------------

s_nameForOPERGrp="dba"

#-------------------------------------------------------------------------------
#Name       : s_nameForDBAGrp
#Datatype   : String
#Description: dba group
#Component  : oracle.rdbms
#-------------------------------------------------------------------------------

s_nameForDBAGrp="dba"

</value></value></value></value></value></value></value></value></value></value>

________________________________________________________________________________


Thanks
sagar

RMAN basic BACKUP and RECOVERY (no catalog)


Oracle Recovery Manager (RMAN)

RMAN was introduced in Oracle8. Recovery Manager(RMAN) is an Oracle provided (free) utility for backing-up, restoring and recovering Oracle databases. RMAN ships with the Oracle database and doesn't require a separate installation. The RMAN executable is located in $ORACLE_HOME/bin directory.

Prerequisites:-  

1) Target database has to run in Archive log mode for this scenario
2) create a user
3) create a table on user, which we created just
4) Insert values

Testing

A) Click on start => type CMD => right click on CMD icon => click on Run as Administrator 

C:\Windows\system32>set ORACLE_SID=PROD

C:\Windows\system32>sqlplus / as sysdba

SQL*Plus: Release 10.2.0.3.0 - Production on Fri Jul 13 18:25:25 2012

Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> create user sagar identified by sagar default tablespace users;

User created.

SQL> grant connect, resource to sagar;

Grant succeeded.

SQL> conn sagar/sagar
Connected.
SQL> create table rman_test (n number(1));

Table created.

SQL> insert into rman_test values (1);

1 row created.

SQL> /

1 row created.

SQL> /

1 row created.

SQL> /

1 row created.

SQL> /

1 row created.

SQL> commit;

Commit complete.

SQL> select count(*) from rman_test;

  COUNT(*)
----------
         5

SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options

b) Connect to RMAN client 

C:\Windows\system32>rman target /

Recovery Manager: Release 10.2.0.3.0 - Production on Fri Jul 13 18:28:20 2012

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

connected to target database: PROD (DBID=200218226)

RMAN> backup database;

Starting backup at 13-JUL-12
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\PROD\SYSTEM01.DBF
input datafile fno=00003 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\PROD\SYSAUX01.DBF
input datafile fno=00002 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\PROD\UNDOTBS01.DBF
input datafile fno=00004 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\PROD\USERS01.DBF
channel ORA_DISK_1: starting piece 1 at 13-JUL-12
channel ORA_DISK_1: finished piece 1 at 13-JUL-12
piece handle=C:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\PROD\BACKUPSET\2012_07_13\O1_MF_NNNDF_TAG2
0120713T183036_8006ZNYX_.BKP tag=TAG20120713T183036 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:55
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
including current SPFILE in backupset
channel ORA_DISK_1: starting piece 1 at 13-JUL-12
channel ORA_DISK_1: finished piece 1 at 13-JUL-12
piece handle=C:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\PROD\BACKUPSET\2012_07_13\O1_MF_NCSNF_TAG2
0120713T183036_80071FQN_.BKP tag=TAG20120713T183036 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 13-JUL-12


RMAN> list backup of controlfile ;


List of Backup Sets
===================

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
14      Full    6.80M      DISK        00:00:00     12-JUL-12
        BP Key: 14   Status: AVAILABLE  Compressed: NO  Tag: TAG20120712T204245
        Piece Name: C:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\PROD\BACKUPSET\2012_07_12\O1_MF_NCS
NF_TAG20120712T204245_7ZXTDWLT_.BKP
  Control File Included: Ckp SCN: 644200       Ckp time: 12-JUL-12

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
16      Incr 1  6.80M      DISK        00:00:02     12-JUL-12
        BP Key: 16   Status: AVAILABLE  Compressed: NO  Tag: TAG20120712T211612
        Piece Name: C:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\PROD\BACKUPSET\2012_07_12\O1_MF_NCS
N1_TAG20120712T211612_7ZXWCXFS_.BKP
  Control File Included: Ckp SCN: 649612       Ckp time: 12-JUL-12

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
18      Full    6.80M      DISK        00:00:03     13-JUL-12
        BP Key: 18   Status: AVAILABLE  Compressed: NO  Tag: TAG20120713T183036
        Piece Name: C:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\PROD\BACKUPSET\2012_07_13\O1_MF_NCS
NF_TAG20120713T183036_80071FQN_.BKP
  Control File Included: Ckp SCN: 692265       Ckp time: 13-JUL-12

C) Make a note of path and name of Controlfile

Now get out of RMAN

RMAN > EXIT

Recovery Manager Complete

D) Now shutdown the database. Remove all files under oradata location

SQL*Plus: Release 10.2.0.3.0 - Production on Fri Jul 13 18:35:42 2012

Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> 


NOTE: (This is just understanding purpose. You must not do this step at customer site)

E ) Delete all files under this directory C:\ORACLE\PRODUCT\10.2.0\oradata\PROD\

Now go to RMAN client  Connect to target database

C:\Windows\system32>rman target /

Recovery Manager: Release 10.2.0.3.0 - Production on Fri Jul 13 18:45:01 2012

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

connected to target database (not started)



Note :Since database is in down mode, RMAN does not show the Database name and status of Database


RMAN> startup nomount;

Oracle instance started

Total System Global Area    1199570944 bytes

Fixed Size                     1291988 bytes
Variable Size                293603628 bytes
Database Buffers             897581056 bytes
Redo Buffers                   7094272 bytes

RMAN> restore controlfile from 'C:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\PROD\BACKUPSET\2012_07_
13\O1_MF_NCSNF_TAG20120713T183036_80071FQN_.BKP';

Starting restore at 13-JUL-12
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=157 devtype=DISK

channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:05
output filename=C:\ORACLE\PRODUCT\10.2.0\ORADATA\PROD\CONTROL01.CTL
output filename=C:\ORACLE\PRODUCT\10.2.0\ORADATA\PROD\CONTROL02.CTL
output filename=C:\ORACLE\PRODUCT\10.2.0\ORADATA\PROD\CONTROL03.CTL
Finished restore at 13-JUL-12

RMAN> alter database mount;

database mounted
released channel: ORA_DISK_1

RMAN> restore database;

Starting restore at 13-JUL-12
Starting implicit crosscheck backup at 13-JUL-12
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=157 devtype=DISK
Crosschecked 5 objects
Finished implicit crosscheck backup at 13-JUL-12

Starting implicit crosscheck copy at 13-JUL-12
using channel ORA_DISK_1
Finished implicit crosscheck copy at 13-JUL-12

searching for all files in the recovery area
cataloging files...
cataloging done

List of Cataloged Files
=======================
File Name: C:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\PROD\BACKUPSET\2012_07_13\O1_MF_NCSNF_TAG201
20713T183036_80071FQN_.BKP

using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to C:\ORACLE\PRODUCT\10.2.0\ORADATA\PROD\SYSTEM01.DBF
restoring datafile 00002 to C:\ORACLE\PRODUCT\10.2.0\ORADATA\PROD\UNDOTBS01.DBF
restoring datafile 00003 to C:\ORACLE\PRODUCT\10.2.0\ORADATA\PROD\SYSAUX01.DBF
restoring datafile 00004 to C:\ORACLE\PRODUCT\10.2.0\ORADATA\PROD\USERS01.DBF
channel ORA_DISK_1: reading from backup piece C:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\PROD\BACK
UPSET\2012_07_13\O1_MF_NNNDF_TAG20120713T183036_8006ZNYX_.BKP
channel ORA_DISK_1: restored backup piece 1
piece handle=C:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\PROD\BACKUPSET\2012_07_13\O1_MF_NNNDF_TAG2
0120713T183036_8006ZNYX_.BKP tag=TAG20120713T183036
channel ORA_DISK_1: restore complete, elapsed time: 00:00:46
Finished restore at 13-JUL-12

RMAN> recover database;

Starting recover at 13-JUL-12
using channel ORA_DISK_1

starting media recovery

unable to find archive log
archive log thread=1 sequence=2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 07/13/2012 18:55:30
RMAN-06054: media recovery requesting unknown log: thread 1 seq 2 lowscn 692242


RMAN> alter database open resetlogs;

database opened

RMAN> exit

Recover Manager Complete.


F) Since we started our database and opened through RMAN.

Just connect as sagar user

C:\Windows\system32>set ORACLE_SID=PROD

C:\Windows\system32>sqlplus sagar/sagar

SQL*Plus: Release 10.2.0.3.0 - Production on Fri Jul 13 19:09:59 2012

Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> select count(*) from rman_test;

  COUNT(*)
----------
         5

SQL> select * from rman_test;

         N
----------
         1
         1
         1
         1
         1

SQL>


We successfully done with  backups and recovery using RMAN