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客戶端連線客戶端
- Oracle RMAN 連線資料庫認證方法Oracle資料庫
- Redis客戶端連線數DevOpsRedis客戶端dev
- mysql、redis 客戶端連線池MySqlRedis客戶端
- ESP作為單連線中的TCP客戶端TCP客戶端
- python中socket建立客戶連線Python
- Sqlcl 連線Oracle DataBase 19cSQLOracleDatabase
- Java 客戶端 Jedis和JedisPool 連線池Java客戶端
- Qt TCP通訊客戶端斷開連線有哪些方法QTTCP客戶端
- 使用 WebSocket 客戶端連線 MQTT 伺服器Web客戶端MQQT伺服器
- 客戶端怎麼連線到伺服器?客戶端伺服器
- [Oracle-> MySQL] Oracle通過dblink連線MySQL--Oracle 19c連線到MySQL 5.7OracleMySql
- 4.2.14.3 為Oracle呼叫介面客戶端啟用快速連線故障轉移Oracle客戶端
- 某客戶系統tomcat連線池連線異常Tomcat
- Linux系統中KafKa安裝和使用方法 java客戶端連線kafkaLinuxKafkaJava客戶端
- 【LISTENER】Oracle分析連線監聽情況,判斷客戶端IP分佈Oracle客戶端
- Presto學習筆記——Go客戶端連線PrestoREST筆記Go客戶端
- 使用 Java 客戶端透過 HTTPS 連線到 EasysearchJava客戶端HTTP
- HTTP客戶端連線,選擇HttpClient還是OkHttp?HTTP客戶端client
- 4.2.14 啟用客戶端快速連線故障轉移客戶端
- gRPC學習記錄(六)--客戶端連線池RPC客戶端
- 使用11g客戶端或pl/sql developer連線高版本Oracle 19c ORA-28040 ORA-01017客戶端SQLDeveloperOracle
- vnc遠端連線linux,vnc遠端連線linux的具體方法。VNCLinux
- ORA-21561 OID generation failed [Ubuntu 16.04下Oracle客戶端連線伺服器]AIUbuntuOracle客戶端伺服器
- 掌握遠端連線,暢享Mac SSH客戶端Termius的便利之道Mac客戶端
- TCP協議服務端和客戶端的連線與通訊TCP協議服務端客戶端
- 0039-如何使用PythonImpyla客戶端連線Hive和ImpalaPython客戶端Hive
- 微服務整合Spring Cloud Alibaba Seata (二) 客戶端連線微服務SpringCloud客戶端
- 如何使用Redshift客戶端工具SQL Workbench來連線Redshift客戶端SQL
- OceanBase學習之路7|透過 MySQL 客戶端連線 OceanBase 租戶MySql客戶端
- MQTT 客戶端自動重連實踐|構建可靠 IoT 裝置連線MQQT客戶端
- 第三方客戶端連線網易郵箱客戶端
- 4.2.14.1 關於啟用客戶端快速連線故障轉移客戶端
- Android客戶端網路預連線優化機制探究Android客戶端優化
- Oracle 19c透過SCAN連線ORA-12520Oracle
- netty服務端監聽客戶端連線加入和斷開事件Netty服務端客戶端事件
- rdp遠端桌面連線方法
- Rd遠端桌面連線方法