rman的連接
1 本地連接
[oracle@pc6 ~]$ rman target /
Recovery Manager: Release 11.2.0.1.0 - Production on Sat Mar 24 21:23:15 2018
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: HYYK (DBID=2117284640)
2.遠(yuǎn)處連接
首先在遠(yuǎn)程創(chuàng)建tnsnames
[oracle@ogg-80 admin]$ vim tnsnames.ora
HYYK =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.51)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = hyyk)
)
)
其次在遠(yuǎn)程鏈接
[oracle@ogg-80 ~]$ rman target sys/oracle@hyyk
Recovery Manager: Release 11.2.0.4.0 - Production on Sat Mar 24 21:38:51 2018
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
PL/SQL package SYS.DBMS_BACKUP_RESTORE version 11.02.00.01 in TARGET database is not current
PL/SQL package SYS.DBMS_RCVMAN version 11.02.00.01 in TARGET database is not current
connected to target database: HYYK (DBID=2117284640)
這里說(shuō)明一下rman和數(shù)據(jù)庫(kù)的權(quán)限RMAN 需要訪問(wèn)目標(biāo)數(shù)據(jù)庫(kù)上sys用戶存在的各種數(shù)據(jù)包，還需要具有啟動(dòng)和關(guān)閉目標(biāo)數(shù)據(jù)庫(kù)的權(quán)限。因此RMAN 通常以sysdba 用戶身份連接到目標(biāo)數(shù)據(jù)庫(kù)。 如果以不具有sysdba 權(quán)限的用戶連接到目標(biāo)數(shù)據(jù)庫(kù)，RMAN 會(huì)報(bào)ORA-01031: insufficient privileges 錯(cuò)誤。
做以下實(shí)驗(yàn)
創(chuàng)建一個(gè)用戶
SYS@hyyk> create user rman identified by rman;
授予權(quán)限
SYS@hyyk> grant connect,resource to rman;
測(cè)試連接
[oracle@pc6 ~]$ rman target rman/rman
Recovery Manager: Release 11.2.0.1.0 - Production on Sat Mar 24 21:43:04 2018
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: HYYK (DBID=2117284640)
如果在遠(yuǎn)程用rman用戶連接
[oracle@ogg-80 ~]$ rman target rman/rman@hyyk
Recovery Manager: Release 11.2.0.4.0 - Production on Sat Mar 24 21:45:03 2018
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-01031: insufficient privileges
這里在本機(jī)授予rman用戶sysdba權(quán)限
SYS@hyyk> grant sysdba to rman;
Grant succeeded.
在次從遠(yuǎn)程連連接，顯示連接成功
[oracle@ogg-80 ~]$ rman target rman/rman@hyyk
Recovery Manager: Release 11.2.0.4.0 - Production on Sat Mar 24 21:59:32 2018
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
PL/SQL package SYS.DBMS_BACKUP_RESTORE version 11.02.00.01 in TARGET database is not current
PL/SQL package SYS.DBMS_RCVMAN version 11.02.00.01 in TARGET database is not current
connected to target database: HYYK (DBID=2117284640)
當(dāng)前題目：rman的連接
當(dāng)前URL：http://jinyejixie.com/article42/ggciec.html
成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供企業(yè)網(wǎng)站制作、關(guān)鍵詞優(yōu)化、搜索引擎優(yōu)化、電子商務(wù)、品牌網(wǎng)站設(shè)計(jì)、微信公眾號(hào)
聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請(qǐng)盡快告知，我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng)，如需處理請(qǐng)聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時(shí)需注明來(lái)源： 創(chuàng)新互聯(lián)
- 小程序來(lái)了，如何運(yùn)營(yíng)推廣？ 2016-08-30
- APP開(kāi)發(fā)與小程序開(kāi)發(fā)你更加適合哪個(gè)？ 2023-01-21
- 選擇微信小程序開(kāi)發(fā)定制公司的注意事項(xiàng) 2022-07-18
- 微信小程序應(yīng)該怎樣的進(jìn)行吸粉以及引流呢？ 2016-08-13
- 呵呵~百度小程序也叫智能了 2014-09-28
- 成都小程序開(kāi)發(fā)哪家好 2014-04-12
- 江西小程序開(kāi)發(fā)一定要注意哪些事情？ 2020-12-13
- 成都干洗店小程序開(kāi)發(fā) 2022-06-08
- 小程序開(kāi)發(fā)對(duì)企業(yè)的發(fā)展有多重要？ 2014-04-25
- 復(fù)刻小程序流程 2017-03-28
- 成都代駕服務(wù)小程序開(kāi)發(fā)，成都代駕服務(wù)小程序制作 2022-06-04
- 微信小程序開(kāi)發(fā)的意義是什么 2021-02-16