unregister::=
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.Execute only at the RMAN prompt.
RMAN must be connected to the recovery catalog in which the target database is registered.
You can identify the database to unregister in one of three ways:
Connect RMAN to the target database
Provide the database_name argument to identify the database to unregister, if the database name is unique;
Use SET DBID
to identify the database if RMAN is not connected to the target database and the database_name is not unique in the recovery catalog.
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. |
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; }