1.1. Rman Connection Database
Rman can connect to a target database through operating system authentication and password file two ways, users who use the Rman Backup Recovery tool need to have SYSDBA or sysbackup system permissions, if the user needs to connect to the recovery directory, need to be granted Recovery_catalog_ Owner object permissions.
D:\instantclient_12_2>sqlplus sys/password @clonepdb_plug as Sysdba
Sql*plus:release 12.2.0.1.0 Production on Mon Jan 29 10:50:45 2018
Copyright (c) 1982, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0-64bit Production
[Email protected]_plugpdb> Create user cndba identified by CNDBA
2/
User created.
elapsed:00:00:01.30
[Email protected]_plugpdb> grant Sysbackup to CNDBA;
Grant succeeded.
elapsed:00:00:00.42
C:\users\administrator>rman
Recovery manager: Release 12.2.0.1.0-production on Monday January 29 10:51:10 2018
Copyright (c) 1982, Oracle and/or its affiliates. All rights reserved.
Rman> Connect Target "Cndba/[email Protected]_plug as Sysbackup"
Connected to target database: Newtest:clonepdb_plug (dbid=50957894)
C:\users\administrator>rman
Recovery manager: Release 12.2.0.1.0-production on Monday January 29 10:55:35 2018
Copyright (c) 1982, Oracle and/or its affiliates. All rights reserved.
Rman> Connect Target "Cndba/[email protected] as Sysbackup"
Connected to target database: Newtest (dbid=1779551310)
D:\instantclient_12_2>sqlplus sys/password @newtest as Sysdba
Sql*plus:release 12.2.0.1.0 Production on Mon Jan 29 10:55:16 2018
Copyright (c) 1982, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0-64bit Production
[Email protected] cdb> Create User C # #cndba identified by C # #cndba
2/
User created.
elapsed:00:00:00.21
[Email protected] Cdb> Grant Sysbackup to C # #cndba;
Grant succeeded.
elapsed:00:00:00.07
C:\users\administrator>rman
Recovery manager: Release 12.2.0.1.0-production on Monday January 29 10:52:59 2018
Copyright (c) 1982, Oracle and/or its affiliates. All rights reserved.
Rman> Connect Target "C # #cndba/[email Protected]_plug as Sysbackup"
Connected to target database: Newtest:clonepdb_plug (dbid=50957894)
C:\users\administrator>rman
Recovery manager: Release 12.2.0.1.0-production on Monday January 29 10:53:54 2018
Copyright (c) 1982, Oracle and/or its affiliates. All rights reserved.
Rman> Connect Target "C # #cndba/[email protected] as Sysbackup"
Connected to target database: Newtest (dbid=1779551310)
Description Sysbackup user does not have public and local user differences
Oracle 12C Rman