Skip Headers
Oracle® Database Backup and Recovery Reference
10g Release 2 (10.2)

Part Number B14194-03
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
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

UNREGISTER DATABASE

Syntax

unregister::=

Description of unregister.gif follows
Description of the illustration unregister.gif

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;
}