RMAN: Specifying the Backup User

RMAN: Specifying the Backup User
Andrey Volkov

Andrey Volkov

System, network administration + DBA. And a little programmer!)) See Author profile.

As discussed previously, RMAN requires that you use a database user with SYSDBA privileges. Whether I’m running RMAN from the command line or invoking RMAN in a script, in most scenarios, I connect directly as SYS to the target database. For example, here is how I connect to RMAN from the command line:

$ rman target /

Some DBAs don’t use this approach; they opt to set up a user separate from SYS and cite security concerns as a rationale for doing this.

I prefer to use the SYS account directly, because when connecting to RMAN locally on the server, there is no need to specify a username and password. This means that you never have to hard-code usernames and passwords into any backup scripts or specify a username and password on the command line that can be viewed by rogue developers or managers looking over your shoulder.

Вас заинтересует / Intresting for you:

RMAN: Using Online or Offline ...
RMAN: Using Online or Offline ... 819 views Андрей Волков Sat, 29 Feb 2020, 10:01:33
RMAN: Checking for Corruption ...
RMAN: Checking for Corruption ... 161 views Андрей Волков Thu, 30 Sep 2021, 11:57:27
RMAN: Backing UP Oracle Databa...
RMAN: Backing UP Oracle Databa... 110 views Андрей Волков Wed, 29 Sep 2021, 18:27:51
RMAN: Backing Up the spfile
RMAN: Backing Up the spfile 82 views Андрей Волков Wed, 29 Sep 2021, 18:13:31
Log in to comment