ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Unregister a Database From RMAN[9i]

Unregister a Database From RMAN[9i]

原创 Linux操作系统 作者:jlandzpa 时间:2019-07-19 12:57:01 0 删除 编辑
First we start up RMAN with a connection to the catalog and the target, making a note of the DBID in the banner:
First we start up RMAN with a connection to the catalog and the target, making a note of the DBID in the banner:
C:>rman catalog=rman/rman@dba1 target=sys/password@w2k1

Recovery Manager: Release 9.2.0.1.0 - Production

Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.

connected to target database: W2K1 (DBID=1487421514)
connected to recovery catalog database

RMAN>
Next we list and delete any backupsets recorded in the repository:
RMAN> LIST BACKUP SUMMARY;
RMAN> DELETE BACKUP DEVICE TYPE SBT;
RMAN> DELETE BACKUP DEVICE TYPE DISK;
Next we connect to the RMAN catalog owner using SQL*Plus and issue the following statement:
SQL> CONNECT rman/rman@dba1
Connected.
SQL> SELECT db_key, db_id 
  2  FROM   db 
  3  WHERE  db_id = 1487421514;

    DB_KEY      DB_ID
---------- ----------
         1 1487421514

1 row selected.

SQL>
The resulting key and id can then be used to unregister the database:
SQL> EXECUTE dbms_rcvcat.unregisterdatabase(1, 1487421514);

PL/SQL procedure successfully completed.

SQL>

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/936/viewspace-60514/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2001-10-12

  • 博文量
    240
  • 访问量
    172939