rman客戶端是用于執(zhí)行backup,restore和recover命令的rman程序。本文介紹幾種連接rman客戶端的辦法,sysbackup是12c開始引入的新的角色,目地在于分離權(quán)限,使數(shù)據(jù)庫的權(quán)限管理更 加精準化,同時結(jié)合新的權(quán)限和角色,在日常運維中我們也可以將rman備份用戶進行分離,不再像之前版本大多操作通過sys 用戶完成。 1、本地連接方式 分別使用sysbakcup角色和操作系統(tǒng)認證方式 [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> 通過創(chuàng)建一個用戶授予sysbackup角色進行連接 創(chuàng)建備份用戶,這里我們創(chuàng)建一個公共用戶 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的別名是已經(jīng)配置好的,這里也可以使用easy connect連接 使用我們創(chuàng)建的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
「喜歡這篇文章,您的關(guān)注和贊賞是給作者最好的鼓勵」
關(guān)注作者
【版權(quán)聲明】本文為墨天輪用戶原創(chuàng)內(nèi)容,轉(zhuǎn)載時必須標注文章的來源(墨天輪),文章鏈接,文章作者等基本信息,否則作者和墨天輪有權(quán)追究責任。如果您發(fā)現(xiàn)墨天輪中有涉嫌抄襲或者侵權(quán)的內(nèi)容,歡迎發(fā)送郵件至:contact@modb.pro進行舉報,并提供相關(guān)證據(jù),一經(jīng)查實,墨天輪將立刻刪除相關(guān)內(nèi)容。




