RMAN-在恢复目录中注册和取消数据库

创建恢复目录
1、在目录数据库中创建恢复目录所用表空间
SQL> create tablespace rman_ts datafile ‘c:oracleoradataccrmants.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@pingRecovery Manager: Release 10.2.0.1.0 – Production on Wed Jan 7 09:52:13 2009Copyright (c) 1982, 2005, Oracle. All rights reserved.connected to recovery catalog databaseRMAN> create catalog tablespace rman_ts;recovery catalog created4、注册目标数据库到恢复目录
目标数据库:racdb
恢复目录：ping[oracle@node1 ~]$ rman target sys/1@racdbRecovery Manager: Release 10.2.0.1.0 – Production on Wed Jan 7 10:05:50 2009Copyright (c) 1982, 2005, Oracle. All rights reserved.connected to target database: RACDB (DBID=672464192)RMAN> connect catalog rman/rman@pingconnected to recovery catalog databaseRMAN> register database;database registered in recovery catalog
starting full resync of recovery catalog
full resync complete二、取消数据库的注册
1．在SQLPLUS使用RMAN用户登录恢复目录[oracle@node1 ~]$ sqlplus /nologSQL*Plus: Release 10.2.0.1.0 – Production on Wed Jan 7 10:50:06 2009Copyright (c) 1982, 2005, Oracle. All rights reserved.SQL> conn rman/rman@ping
Connected.2．查找表DB 中的注册记录
[oracle@node1 ~]$ rman target sys/1@racdbRecovery Manager: Release 10.2.0.1.0 – Production on Wed Jan 7 10:49:03 2009Copyright (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 672464192DBID=DB.DB_ID
## 切记一定要使用RMAN的用户登陆，不然将出现如下错误提示SQL> conn sys/sys@ping as sys开发云主机域名dba
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 ~]$ rmanRecovery Manager: Release 10.2.0.1.0 – Production on Wed Jan 7 11:02:16 2009Copyright (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 databaseRMAN>

相关推荐: Mesa 18.2.8发布啦

Mesa 18.2.8向后推出了新的Vega M PCI ID以及我们最近几周发现的用于AMD/Radeon Linux 图形驱动程序堆栈的其他新Vega 10和Vega 20 PCI ID，用于当前未公布的产品。通过建立现有的Vega（以及Polaris，…