• Arun Kumar

Connecting Oracle RMAN

In this article we will understand about Oracle RMAN utlity and how to connect RMAN to target database.

  • RMAN utility comes with Oracle Binaries

  • No special installation or license required for using RMAN

  • At command prompt, you can just type rman and the utility will start

  • By default, it connects to database environmental variables defined

  • RMAN is used only when your DB is in at least Mount stage

  • RMAN is used while the DB is up and running and have a very little performance impact if backup is running

Connecting RMAN

If you want to connect to the RMAN utility, you can simply type “rman target /” and it will connect to the default database variables that are exported in your environment.

Let us check the environmental variables in our database

The variables are set to proddb. Now if we type rman target / , it will connect to the proddb database

Let us say that you don’t want to connect to proddb but to any other database instance which is running on this server

You can connect to any database on the same server by following the steps:

# rman

RMAN> connect target sys@testdb

target database password:

But in real time, DBAs don’t use the above method. They will export the environmental variables and then connect to the correct database.


Recent Posts

See All

Perform Manual Switchover on Physical Standby

Connect to proddb database via client: Take a new putty session and connect to proddb database via client machine. Keep querying below sqlplus sys/sys@proddb as sysdba SQL> select name, open_mode, db

How to check database backups

Checking Database backups are one of the main focus areas of a DBA. Time to time, DBA needs to check database backup status and see if its completed, failed, running etc. Also, DBA must be able to get

Automate RMAN Backup using Shell Script

In a real environment, off course you will not manually trigger all the Oracle database backups. You need an automated mechanism to trigger RMAN backups. In this article we will look at RMAN backup au

  • Facebook
  • Twitter
  • YouTube
  • Instagram

© 2020 by DBA Genesis