Oracle 12C rman

標籤：log   release   1.3   nec   rman   created   min   對象   操作   

1.1. RMAN串連資料庫
RMAN可通過作業系統認證和密碼檔案兩種方式串連到一個目標資料庫，使用RMAN備份恢複工具的使用者需要具有SYSDBA或SYSBACKUP系統許可權，如果使用者需要串連到恢複目錄，需要被授予RECOVERY_CATALOG_OWNER對象許可權。
D:\instantclient_12_2>sqlplus sys/密碼@clonepdb_plug as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Mon Jan 29 10:50:45 2018

Copyright (c) 1982, 2016, 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

復原管理員: Release 12.2.0.1.0 - Production on 星期一 1月 29 10:51:10 2018

Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.

RMAN> connect target "cndba/[email protected]_plug as sysbackup"

已串連到目標資料庫: NEWTEST:CLONEPDB_PLUG (DBID=50957894)
C:\Users\Administrator>rman

復原管理員: Release 12.2.0.1.0 - Production on 星期一 1月 29 10:55:35 2018

Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.

RMAN> connect target "cndba/[email protected] as sysbackup"

已串連到目標資料庫: NEWTEST (DBID=1779551310)
D:\instantclient_12_2>sqlplus sys/密碼@newtest as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Mon Jan 29 10:55:16 2018

Copyright (c) 1982, 2016, 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

復原管理員: Release 12.2.0.1.0 - Production on 星期一 1月 29 10:52:59 2018

Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.

RMAN> connect target "c##cndba/[email protected]_plug as sysbackup"

已串連到目標資料庫: NEWTEST:CLONEPDB_PLUG (DBID=50957894)
C:\Users\Administrator>rman

復原管理員: Release 12.2.0.1.0 - Production on 星期一 1月 29 10:53:54 2018

Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.

RMAN> connect target "c##cndba/[email protected] as sysbackup"

已串連到目標資料庫: NEWTEST (DBID=1779551310)
說明sysbackup使用者沒有公用和本機使用者區別

Oracle 12C rman