Oracle 19c中連線RMAN客戶端的連線方法
rman客戶端是用於執行backup,restore和recover命令的rman程式。本文介紹幾種連線rman客戶端的辦法,sysbackup是12c開始引入的新的角色,目地在於分離許可權,使資料庫的許可權管理更 加精準化,同時結合新的許可權和角色,在日常運維中我們也可以將rman備份使用者進行分離,不再像之前版本大多操作透過sys 使用者完成。 1、本地連線方式 分別使用sysbakcup角色和作業系統認證方式 [oracle@db19do01 ~]$ export ORACLE_SID=cdb19c [oracle@db19do01 ~]$ rman target '"/as sysbackup"' Recovery Manager: Release 19.0.0.0.0 - Production on Sat Aug 21 11:46:29 2021 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. connected to target database: CDB19C (DBID=509743990) [oracle@db19do01 ~]$ rman target / Recovery Manager: Release 19.0.0.0.0 - Production on Sat Aug 21 11:48:42 2021 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. connected to target database: CDB19C (DBID=509743990) RMAN> 透過建立一個使用者授予sysbackup角色進行連線 建立備份使用者,這裡我們建立一個公共使用者 c##backupuser SYS@cdb19c >create user c##backupuser identified by Oracle_123; User created. SYS@cdb19c >grant sysbackup to c##backupuser; Grant succeeded. SYS@cdb19c > [oracle@db19do01 ~]$ rman target c##backupuser/Oracle_123 Recovery Manager: Release 19.0.0.0.0 - Production on Sat Aug 21 11:51:30 2021 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. connected to target database: CDB19C (DBID=509743990) [oracle@db19do01 ~]$ rman Recovery Manager: Release 19.0.0.0.0 - Production on Sat Aug 21 11:53:30 2021 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. RMAN> connect target c##backupuser/Oracle_123 connected to target database: CDB19C (DBID=509743990) RMAN> exit Recovery Manager complete. [oracle@db19do01 ~]$ rman Recovery Manager: Release 19.0.0.0.0 - Production on Sat Aug 21 11:53:54 2021 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. RMAN> connect target / connected to target database: CDB19C (DBID=509743990) RMAN> exit [oracle@db19do01 ~]$ rman Recovery Manager: Release 19.0.0.0.0 - Production on Sat Aug 21 11:55:28 2021 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. RMAN> connect target '"/ as sybackup"' target database Password: connected to target database: CDB19C (DBID=509743990) RMAN> 2、遠端連線 透過配置tnsnames.ora檔案連線rman客戶端,cdb19c的別名是已經配置好的,這裡也可以使用easy connect連線 使用我們建立的c##backupuser備份使用者連線 [oracle@db19do01 ~]$ rman target '"c##backupuser/Oracle_123@cdb19c as sysbackup"' Recovery Manager: Release 19.0.0.0.0 - Production on Sat Aug 21 12:53:06 2021 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. connected to target database: CDB19C (DBID=509743990) RMAN> 透過sys使用者連線到CDB [oracle@db19do01 ~]$ rman target sys/Oracle_123@cdb19c Recovery Manager: Release 19.0.0.0.0 - Production on Sat Aug 21 12:53:49 2021 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. connected to target database: CDB19C (DBID=509743990) RMAN> 透過sys使用者連線到PDB [oracle@db19do01 ~]$ rman target sys/Oracle_123@hrpdb Recovery Manager: Release 19.0.0.0.0 - Production on Sat Aug 21 12:54:07 2021 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. connected to target database: CDB19C:HRPDB (DBID=3868540829) RMAN> -the end-
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/28373936/viewspace-2840102/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- impala客戶端連線客戶端
- Redis客戶端連線Redis客戶端
- 客戶端連線資料庫的方法客戶端資料庫
- Oracle客戶端連線伺服器教程Oracle客戶端伺服器
- 不安裝Oracle客戶連線Oracle 8的方法(轉)Oracle
- mysql、redis 客戶端連線池MySqlRedis客戶端
- vncserver建立與客戶端連線VNCServer客戶端
- 配置ORACLE 客戶端連線到資料庫Oracle客戶端資料庫
- ESP作為單連線中的TCP客戶端TCP客戶端
- Redis客戶端連線數DevOpsRedis客戶端dev
- 從客戶端連線ASM例項客戶端ASM
- 獲取SQL Server中連線的客戶端IP地址SQLServer客戶端
- oracle客戶端連線server 端, tnsnames的三種設定方式Oracle客戶端Server
- RMAN連線與oracle連線模式的關係Oracle模式
- 顯示連線Oracle資料庫的客戶端IP地址Oracle資料庫客戶端
- MySQL client客戶端的四種連線方式MySqlclient客戶端
- Java 客戶端 Jedis和JedisPool 連線池Java客戶端
- 客戶端連線故障檢查流程手段客戶端
- python中socket建立客戶連線Python
- Qt TCP通訊客戶端斷開連線有哪些方法QTTCP客戶端
- 使用 WebSocket 客戶端連線 MQTT 伺服器Web客戶端MQQT伺服器
- 客戶端怎麼連線到伺服器?客戶端伺服器
- linux之客戶端連線數統計Linux客戶端
- Sqlcl 連線Oracle DataBase 19cSQLOracleDatabase
- 如何配置oracle客戶端連線10g rac 資料庫Oracle客戶端資料庫
- Oracle的表連線方法(三)雜湊連線Oracle
- Oracle RMAN 連線資料庫認證方法Oracle資料庫
- mysql客戶端連線的幾個常見錯誤MySql客戶端
- 某客戶系統tomcat連線池連線異常Tomcat
- HTTP客戶端連線,選擇HttpClient還是OkHttp?HTTP客戶端client
- 配置TimesTen客戶端連線[TimesTen運維]客戶端運維
- 客戶端連線RAC報ora-12545客戶端
- 8i客戶端不能連線9i?客戶端
- oracle中的連線Oracle
- 客戶端段建立到伺服器端的連線過程客戶端伺服器
- 不安裝oracle client客戶端通過plsql developer連線oracle10.2.0.4Oracleclient客戶端SQLDeveloper
- PL/SQL developer 遠端連線資料庫 客戶端配置SQLDeveloper資料庫客戶端
- PHP5.3連線Oracle的客戶端及PDO_OCI模組安裝PHPOracle客戶端