Skip Headers

Oracle® Database Recovery Manager Reference
10g Release 1 (10.1)

Part Number B10770-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to current chapter
Up
Go to next page
Next
View PDF

UNREGISTER DATABASE

Syntax

unregister::=

Text description of unregister.gif follows


Text description of unregister

Purpose

To unregister a database from the recovery catalog.

See Also:

"DROP DATABASE" to learn how to delete a database and unregister it with one command.

Restrictions and Usage Notes

Keywords and Parameters

Syntax Element Description

database_name

Specifies the name of the target database that you are unregistering. You do not have to specify db_name if RMAN is connected to the target database.

NOPROMPT

Specifies that RMAN should not prompt for confirmation before unregistering the database.

Example

Unregistering a Database: Example

In this example, you connect to the target database test1 and then unregister it:

rman TARGET SYS/oracle@test1 CATALOG rman/rman@catdb

RMAN> UNREGISTER DATABASE NOPROMPT;
Unregistering a Database That is Not Unique in Catalog: Example

The following UNIX shell script unregisters database testdb from the recovery catalog. Because multiple databases called testdb are registered in the recovery catalog, and because RMAN is not connected to the target database (which has already been deleted from the file system), you must run SET DBID:

rman CATALOG rman/rman@catdb
RMAN> RUN
{  
  SET DBID 1334531173;   # specifies test database by DBID
  UNREGISTER DATABASE testdb NOPROMPT;
}