ORA-01950 對(duì)表空間無(wú)權(quán)限
數(shù)據(jù)庫(kù):oracle 19.3
系統(tǒng):Windows 11
問(wèn)題描述:在創(chuàng)建恢復(fù)目錄時(shí),報(bào)ORA-01950告警,如下所示:
C:\Users\Administrator>rman target / catalog rman_reuser/oracle
恢復(fù)管理器: Release 19.0.0.0.0 - Production on 星期五 5月 27 13:24:57 2022
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
已連接到目標(biāo)數(shù)據(jù)庫(kù): ORCL (DBID=1624841057)
連接到恢復(fù)目錄數(shù)據(jù)庫(kù)
未安裝恢復(fù)目錄
RMAN> create catalog tablespace rman_ts;
創(chuàng)建 config_update 時(shí)出錯(cuò)
恢復(fù)目錄數(shù)據(jù)庫(kù)發(fā)生 Oracle 錯(cuò)誤: ORA-01950: 對(duì)表空間 'RMAN_TS' 無(wú)權(quán)限
恢復(fù)目錄數(shù)據(jù)庫(kù)發(fā)生 Oracle 錯(cuò)誤: ORA-00942: 表或視圖不存在
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-06433: 安裝恢復(fù)目錄時(shí)出錯(cuò)
提示對(duì)表空間'RMAN_TS'無(wú)權(quán)限,那么授予權(quán)限即可.
執(zhí)行過(guò)程:
C:\Users\Administrator>rman target / catalog rman_reuser/oracle
恢復(fù)管理器: Release 19.0.0.0.0 - Production on 星期五 5月 27 13:24:57 2022
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
已連接到目標(biāo)數(shù)據(jù)庫(kù): ORCL (DBID=1624841057)
連接到恢復(fù)目錄數(shù)據(jù)庫(kù)
未安裝恢復(fù)目錄
SQL> grant unlimited tablespace to rman_reuser;
授權(quán)成功.
C:\Users\Administrator>rman target / catalog rman_reuser/oracle
恢復(fù)管理器: Release 19.0.0.0.0 - Production on 星期五 5月 27 13:36:02 2022
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
已連接到目標(biāo)數(shù)據(jù)庫(kù): ORCL (DBID=1624841057)
連接到恢復(fù)目錄數(shù)據(jù)庫(kù)
RMAN> create catalog tablespace rman_ts;
恢復(fù)目錄已創(chuàng)建
