Learning RMAN On Windows PDF
Learning RMAN On Windows PDF
Learning RMAN On Windows PDF
Introduction................................................................................................................................................... 2
Server Configuration ..................................................................................................................................... 2
Shutdown Instance and Service "DB114"...................................................................................................... 2
Installing Oracle database Instance "EUDB114": .......................................................................................... 2
Shut down Oracle Instance and Windows Service "EUDB114" ..................................................................... 2
Installing Oracle database Instance "USDB114" ........................................................................................... 2
Setting Oracle Environment Variables .......................................................................................................... 3
Setting Oracle SID .......................................................................................................................................... 3
RMAN Practice............................................................................................................................................... 3
Tablespace for RMAN .................................................................................................................................... 3
RMAN User .................................................................................................................................................... 3
Create Catalog ............................................................................................................................................... 3
Connect Target Database and Catalog .......................................................................................................... 4
Change RMAN Configuration Parameters ..................................................................................................... 4
Run the Configuration File............................................................................................................................. 4
Backup Database and Archives ..................................................................................................................... 4
Instance and Service "EUDB114" Startup...................................................................................................... 5
Useful Links.................................................................................................................................................... 5
Introduction
The idea is to practice installing multiple Oracle Instances on a Single Windows Server and also
learning RMAN.
Creating and managing two or more Oracle Instances on a single Windows Server.
Using RMAN connecting these Instances and getting backup.
The links at the bottom would help more to learn or test if you are new to Oracle on Windows
like I am with it :-).
ORADIM is one of the tool to manage Oracle on Windows .
The Oracle Instances created and named as :
"EUDB114" (EUDB-> Europe Database->) and "USDB114" (USDB-> USA Database).
Server Configuration
On "orasys1" Host we already created a database Instance. It is found here.
http://de.scribd.com/doc/225333424/Primary-and-Standby-on-Windows
RMAN Practice
Created a Directory called "Scripts" in "F" Drive.
To change to Drive "F".
C:\> f:
F:\> cd scripts
F:\scripts> set oracle_sid=usdb114
F:\scripts> sqlplus sys as sysdba
Press just "Enter" Key as the password is automatically read if Password file is present in the directory "
%ORACLE_HOME%\database ".
RMAN User
SQL> create user rman identified by rman default tablespace rmantbs quota unlimited on
rmantbs;
SQL> grant resource, recovery_catalog_owner to rman;
Create Catalog
F:\scritps\> rman catalog rman/rman
RMAN> create catalog;
output : recovery catalog created
RMAN> exit
Lastly I shut down this instance so that I connect to another database Instance.
RMAN> exit
F:\scripts> oradim -shutdown -sid usdb114 -shuttype srvc, inst
Useful Links
http://satya-dba.blogspot.de/2010/04/rman-commands.html
https://community.oracle.com/thread/1128974
http://www.dba-oracle.com/t_rman_recovery_window_retention.htm
http://pavandba.com/2011/07/11/how-to-define-rman-retention-policy-time/