ORA-01950 對表空間無權(quán)限
數(shù)據(jù)庫:oracle 19.3
系統(tǒng):Windows 11
問題描述:在創(chuàng)建恢復(fù)目錄時,報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ù)庫: ORCL (DBID=1624841057)
連接到恢復(fù)目錄數(shù)據(jù)庫
未安裝恢復(fù)目錄
RMAN> create catalog tablespace rman_ts;
創(chuàng)建 config_update 時出錯
恢復(fù)目錄數(shù)據(jù)庫發(fā)生 Oracle 錯誤: ORA-01950: 對表空間 'RMAN_TS' 無權(quán)限
恢復(fù)目錄數(shù)據(jù)庫發(fā)生 Oracle 錯誤: ORA-00942: 表或視圖不存在
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-06433: 安裝恢復(fù)目錄時出錯
提示對表空間'RMAN_TS'無權(quán)限,那么授予權(quán)限即可.
執(zhí)行過程:
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ù)庫: ORCL (DBID=1624841057)
連接到恢復(fù)目錄數(shù)據(jù)庫
未安裝恢復(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ù)庫: ORCL (DBID=1624841057)
連接到恢復(fù)目錄數(shù)據(jù)庫
RMAN> create catalog tablespace rman_ts;
恢復(fù)目錄已創(chuàng)建
