RMAN: Specifying the Backup User

RMAN: Specifying the Backup User

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 ... 55 views Андрей Волков Mon, 06 Jan 2020, 10:30:24
Running the RMAN Client Remote...
Running the RMAN Client Remote... 75 views Андрей Волков Mon, 06 Jan 2020, 09:56:51
Creating password-authenticate...
Creating password-authenticate... 1476 views Aida Mon, 26 Nov 2018, 12:20:58
Troubleshooting and Tuning LOB...
Troubleshooting and Tuning LOB... 6247 views Aaz24 Wed, 18 Sep 2019, 11:09:34

Comments on RMAN: Specifying the Backup User

Be the first to comment
Please login to comment