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-
Oracle 19c中连接RMAN客户端的连接方法
来源:这里教程网
时间:2026-03-03 17:06:02
作者:
编辑推荐:
- Oracle 19c中连接RMAN客户端的连接方法03-03
- “人老了要明白:养老与孩子无关,自己有钱,才是王道”你怎么看?03-03
- 【PASSWORD】Oracle12c 如何检查数据库用户使用的是默认密码03-03
- 【PDB】Oracle数据库如何检查和设置pdb最大存储大小03-03
- ORACLE 12.1.0.2 for linux7.6 应用PSU补丁31550110中的巨坑03-03
- 回归声音纯粹,山进WR-12BT PLUS穿越复古潮流,不止唤醒电台记忆03-03
- [20211022]ORA-00904 REF invalid identifier 19c dba_obj_audit_opts(补充).txt03-03
- 【SQL】Oracle SQL写法与优化器缺陷一例03-03
下一篇:
相关推荐
-
雷神推出 MIX PRO II 迷你主机:基于 Ultra 200H,玻璃上盖 + ARGB 灯效
2 月 9 日消息,雷神 (THUNDEROBOT) 现已宣布推出基于英
-
制造商 Musnap 推出彩色墨水屏电纸书 Ocean C:支持手写笔、第三方安卓应用
2 月 10 日消息,制造商 Musnap 现已在海外推出一款 Oce
热文推荐
- ORACLE 12.1.0.2 for linux7.6 应用PSU补丁31550110中的巨坑
- 回归声音纯粹,山进WR-12BT PLUS穿越复古潮流,不止唤醒电台记忆
回归声音纯粹,山进WR-12BT PLUS穿越复古潮流,不止唤醒电台记忆
26-03-03 - 【SQL】Oracle SQL写法与优化器缺陷一例
【SQL】Oracle SQL写法与优化器缺陷一例
26-03-03 - 体验科技、感受未来!“百辆级「自动驾驶」车队”火爆来袭!
体验科技、感受未来!“百辆级「自动驾驶」车队”火爆来袭!
26-03-03 - Oracle 12c RAC构筑之二:共享磁盘配置
Oracle 12c RAC构筑之二:共享磁盘配置
26-03-03 - 直播回顾 | 云和恩墨范计杰:Oracle DBA的SQL编写技能提升宝典(含SQL资源)
- C盘系统文件提示损坏怎么办?系统文件损坏怎么修复
C盘系统文件提示损坏怎么办?系统文件损坏怎么修复
26-03-03 - Win10自动更新后桌面文件不见了怎么办?
Win10自动更新后桌面文件不见了怎么办?
26-03-03 - B端,钉钉也许并非得心应手
B端,钉钉也许并非得心应手
26-03-03 - 电脑没声音了如何恢复?电脑没有声音在哪里设置
电脑没声音了如何恢复?电脑没有声音在哪里设置
26-03-03
