Your Doorstep to the Temple of Oracle

Oracle EBS

Creating an RMAN Database User on the Target Database for Backups

Posted by appsdba11i on April 9, 2011


By default, when RMAN logs into the target database, it does so as the SYS account (as SYSDBA) without any configuration required. This is commonly not what you would want to do in a production system. It is recommended that you create specific database accounts to be used just for RMAN backup purposes. Before going in to the details of how to do this, lets first look at how to log in using the default SYS account:

Login as oracle user

Oracle@rhel5 : rman target /

The above command will login to the target database (TARGDB) using the SYS account (as SYSDBA).

Now, let’s go ahead and create the database user that will be used for all RMAN backups:

% sqlplus “/ as sysdba”

SQL> CREATE USER Rman_user IDENTIFIED BY Rman_user
2 DEFAULT TABLESPACE users TEMPORARY TABLESPACE temp;

SQL> GRANT sysdba TO Rman_user;

After creating the RMAN backup user, you can now login to the target database using the following:

% rman target Rman_user/Rman_user

Notice that the above command will login to the target database (in this case, whatever database is set by the ORACLE_SID environment variable) using SYSDBA privileges. We do not have to specify the “as sysdba” clause when logging into RMAN; it is assumed and RMAN will always use SYSDBA privileges.

Note : now RMAN is in no catalog mode and Control file will be used for the resgistering backup.

Thanks
L N REDDY

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s