91超碰碰碰碰久久久久久综合_超碰av人澡人澡人澡人澡人掠_国产黄大片在线观看画质优化_txt小说免费全本

溫馨提示×

溫馨提示×

您好,登錄后才能下訂單哦!

密碼登錄×
登錄注冊×
其他方式登錄
點擊 登錄注冊 即表示同意《億速云用戶服務條款》

RMAN-在恢復目錄中注冊和取消數據庫

發布時間:2020-08-09 22:18:07 來源:ITPUB博客 閱讀:225 作者:達芬奇的夢 欄目:建站服務器

創建恢復目錄
1、在目錄數據庫中創建恢復目錄所用表空間
SQL> create tablespace rman_ts datafile 'c:\oracle\oradata\cc\rmants.ora' size 20M ;
表空間已創建。

2、在目錄數據庫中創建RMAN 用戶并授權
SQL> create user rman identified by rman default tablespace rman_ts temporary tablespace temp
quota unlimited on rmants;
用戶已創建

SQL> grant recovery_catalog_owner,resource to rman;

Grant succeeded.

3、在目錄數據庫中創建恢復目錄
[oracle@node1 ~]$ rman catalog  rman/rman@ping

Recovery Manager: Release 10.2.0.1.0 - Production on Wed Jan 7 09:52:13 2009

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

connected to recovery catalog database

RMAN> create catalog tablespace rman_ts;

recovery catalog created

4、注冊目標數據庫到恢復目錄
目標數據庫:racdb
恢復目錄:ping

[oracle@node1 ~]$ rman target  sys/1@racdb

Recovery Manager: Release 10.2.0.1.0 - Production on Wed Jan 7 10:05:50 2009

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

connected to target database: RACDB (DBID=672464192)

RMAN> connect catalog  rman/rman@ping

connected to recovery catalog database

RMAN> register database;

database registered in recovery catalog
starting full resync of recovery catalog
full resync complete

二、取消數據庫的注冊
1.在SQLPLUS使用RMAN用戶登錄恢復目錄

[oracle@node1 ~]$ sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Jan 7 10:50:06 2009

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL> conn  rman/rman@ping 
Connected.

2.查找表DB 中的注冊記錄
[oracle@node1 ~]$ rman target  sys/1@racdb

Recovery Manager: Release 10.2.0.1.0 - Production on Wed Jan 7 10:49:03 2009

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

connected to target database: RACDB (DBID=672464192)

RMAN>

SQL> select db_key,db_id from db;

    DB_KEY      DB_ID
---------- ----------
         1  672464192

DBID=DB.DB_ID
## 切記一定要使用RMAN的用戶登陸,不然將出現如下錯誤提示

SQL> conn  sys/sys@ping as sysdba
Connected.
SQL> select db_key,db_id from db;
select db_key,db_id from db
                         *
ERROR at line 1:
ORA-00942: table or view does not exist


3.注銷數據庫
SQL> execute dbms_rcvcat.unregisterdatabase(1,672464192);

PL/SQL procedure successfully completed.

4.驗證注銷動作
[oracle@node1 ~]$ rman

Recovery Manager: Release 10.2.0.1.0 - Production on Wed Jan 7 11:02:16 2009

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

RMAN> list backup;

using target database control file instead of recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of list command at 01/07/2009 11:02:21
RMAN-06171: not connected to target database

RMAN>

向AI問一下細節

免責聲明:本站發布的內容(圖片、視頻和文字)以原創、轉載和分享為主,文章觀點不代表本網站立場,如果涉及侵權請聯系站長郵箱:is@yisu.com進行舉報,并提供相關證據,一經查實,將立刻刪除涉嫌侵權內容。

AI

迁西县| 娱乐| 贺州市| 三穗县| 江源县| 长顺县| 黄浦区| 仁化县| 金秀| 依兰县| 南宁市| 和顺县| 安庆市| 松滋市| 罗甸县| 乐至县| 陇南市| 香河县| 博客| 台中县| 文昌市| 绥江县| 茂名市| 岱山县| 乌拉特中旗| 丰宁| 揭西县| 垫江县| 南涧| 双流县| 崇仁县| 新源县| 望城县| 额尔古纳市| 囊谦县| 宁阳县| 文山县| 卢龙县| 新沂市| 淮滨县| 汉寿县|