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-
最后修改时间:2021-11-02 09:44:18
「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。