RMAN Commands List Oracle 11g

RMAN Commands List (Oracle 11g)

This article presents more useful  commands list Of RMAN Oracle 11g.

During my experience i used all of these commands for many reasons and i decided to share with you.

SHOW Commands :

1.shows all the current configuration settings

RMAN>show all;

2.shows the current retention policy.

RMAN> show retention policy;

3.shows the default device type configured for backups.

RMAN>show default device type;

4.shows the number of backup copies available in the target database.

RMAN> show datafile backup copies;

Configuration..

1.To how many days the backup copies need to be retained. 

RMAN>CONFIGURE RETENTION POLICY TO REDUNDANCY2;

2.Retention policy to the default value of 1 day

RMAN> CONFIGURE RETENTION POLICY CLEAR;

3.Optimization option to the default value.

RMAN>CONFIGURE BACKUP OPTIMIZATION CLEAR;

4.identical files are NOT backed up to the device specified.

RMAN>CONFIGURE BACKUP OPTIMIZATION ON;

BACKUP COMMAND

1.backs up the database (target).

RMAN> backup database;

2.backs up the target database and the current control file and archive log files.

RMAN> backup database include current controlfile plus archive log;

1.reports which backups can be deleted.

RMAN> report obsolete;

1.deletes all the backups that are older based on the retention policy setup.

RMAN> delete obsolete;

LIST COMMAND

1. First of all we may LIST our Rman backup sets by following command. 

RMAN> list backup;

   2.If we want to list backup of individul database we use

RMAN> list backup of database;

 

  3.List only backup set proxy copies

RMAN> list backupset;

 

4.List image copies and archivelog

RMAN>list copy;

 5.lists out all the files that are in the backup that belong to the tablespace ‘system’.

RMAN> list backup of tablespace system;

6.If backup deleted/moved by OS we can use

RMAN>list expired backup;

7.to list by file or some specific(control) file

RMAN>list backup by file;

RMAN>list backup of control file;

8.We can list summary of copies, proxy and sets

RMAN>list backup summary;

9.To list incarnation backup

RMAN>list incarnation;

10.Also to list all database

RMAN>list backup of database;

ODI11g: Creating and Connecting to ODI Work Repository

This Article present Creating ODI11G: Work repository, At previous post i mention Master Repository So lets Create Work Repository On it.

         Work Repository: Organization and project Repository. Keeping information about working on server or clients. Also Data project and models keeping here.

Step by step Creating Work Repository 

First create ODIW user and give password (for example: "veysi")

SQL> create user ODIW identified by veysi;

Grant dba privile to user

SQL> grant dba to ODIW;

NOTE:  Now remember ODIM user for Master, ETL for System And ODIW user for Work user.

Open the ODI

Log in with Master Repository

Click New(+) and write requisites informations.

Log in Name: Whatever you want

SUPERVISOR:Supervısor and password did you give

USER:Master User(ODIM)

Drive list: Oracle jdbc Drive 

Drive Name: oracle.jdbc.OracleDriver (Connect Oracle  Host JDBC)

URL: Would you like to connect Database jdbc:oracle:thin:@ 

You can Test Your Connection and Click Ok 

Click Ok

Now its ready for doing Any job. Click Work Repository

You will see the Master Repository connection information. Click Next

Write ID between 1-998 and write name(whatever you want)  Choose Work repository Development and Click Finish

ODI is creating your work

Click Yes

Choose created work click Ok

 It Now Ready you can test it and click ok

Now have a nice work :)

ODI11g: Creating and Connecting to ODI Master Repository

Today I'll preset ODI Creating Master Repository, During My practice at OraTech i used to ODI

So what does it mean Repository? Repository is data center of ODI that keep all of works. We need a Master repository and "n" Work Repository before we have started.

Master Repository: Keep information of installation and Sources, Targets,Security and version. On every project should be at less one Master repository or sometime more than one.

        ETL: E-LT(Extract-Load & Transform ) Data  transformation and integration . Etl takes  data's from source system to Data warehouse. 

Step by Step creating Master Repository

1. Create prerequisite users..

Create “ETL” user and password. (for example”veysi”)

SQL> create user ETL identified by veysi;

Give ETL user DBA privilege.

SQL> grant dba to ETL;

Create “ODIM” user and password. (for example:”veysi”)

SQL> create user ODIM identified by veysi;

Give ODIM user DBA privilege

SQL> grant dba to ODIM;

So,Lets start. first keep going on path and run ./odi.sh

Its Opening

Click File>New

Choose Master Repository Creation and click OK

Technology: Default Oracle  (Master Repositori host)

JDBC Driver: oracle.jdbc.OracleDriver (Oracle connect to Host JDBC)

JDBC URL: jdbc:oracle:thin:@ (Connection to Oracle  database  Host,post and Sid information)

Note: Host and  sid could known by using V$instance parameter.

USER: ODIM (Master Repository  user)

Password: veysi (ODIM user password)

DBA USER: ETL (system user)

Password: veysi (ETL password)

NOTE: ID should be different with others  Master Repository ID

Click Test Connection and test your connection

So, Mine was successfully :)

Give Supervisor Password and click next

Choose Internal Password Storage and Click finish

Master Repository is creating, wait for a while :)

So that was Successful

Now You can login and create Any work Repository for projects.

Next Post is Work Repository just keep following ;)

Installing Oracle Data Integrator

I have started an professional internship program. 
i installed Oracle Data integrator, Created ODI Work Repository  and ODI Master Repository. 

Now I'm going to present How to install Oracle Data Integrator 11.1.1.6.0 on windows 32 bit system.

First make sure your database already installed.

Go to Oracle site and download ODI Here   

Then Unzip your downloaded folders.

Note: Download Oracle JDK package and install it in order to During installation if you don't want to get error of Oracle Java JDK package.

1. Open Disk1 folder at unzipped file.

run setup.exe as administrator 

So, i got this Error. Install JDK and run again.

Now its Starting 

The Welcome page Click Next.

If you would like to Get Oracle support for Upgrade write your E-mail address but now i don't need it choose Skip .. and Click Next

For Now choose Developer and Standalone Installation for targets and sources.. Click Next

The ODI checking for Prerequisite. Click Next

Choose your Oracle Home directory and Click Next

I wanted to create my self Repositories (Master and Work) that's why i Skip it. Click Next

Write Agent Name and Port but Agent Port must be 0 - 65535, So, i wrote AgentODI and 20910 Click Next

Windows asking for firewall just Click Allow access and click Next

Again asking for Oracle Security Support for Now i don't need any support, Click Next

Click Yes

Now You can save the summary what have you done. Then Click Install

ODI is going to installing.

So it was successfully installed and Configured Automatically Click Next

Installation Completed Again you can save summary and Click Finish...

Now start it by following command

$ cd /u01/app/oracle/product/11.2.0/ODIAgent/oracledi/agent/bin/




$ ./odiparams.sh




$ ./agent_Agent001.sh