Unregister database in 9i

One of my databases has backup issue.

when trying to backup the database manually(before backing up database I want to find the configuration out), I get following error

RMAN> show all;

RMAN configuration parameters are:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of show command at 05/17/2009 22:56:19
RMAN-06004: orACLE error from recovery catalog database: RMAN-20011: target data
base incarnation is not current in recovery catalog


I find some useful solution in the network, unregister the target database in the catalog DB and register it again. but I get another error when registering database in catalog

RMAN> unregister database;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found “identifier”: expecting one of: “allocate, alter
, backup, beginline, blockrecover, catalog, change, connect, copy, create, cross
check, configure, duplicate, debug, delete, drop, exit, endinline, host, {, libr
ary, list, mount, open, print, quit, recover, register, release, replace, report
, renormalize, reset, restore, resync, rman, run, rpctest, set, setlimit, sql, s
pool, startup, shutdown, send, show, test, upgrade, validate”
RMAN-01008: the bad identifier was: unregister
RMAN-01007: at line 1 column 1 file: standard input

it seems the command ‘UNREGISTER DATABASE’ is not recognized in this database, why????

Here is the reason, the target database is older then the catalog database.
the catalog database is,
the target database is

So I need to find how to unregister database in 9i, here is the detailed steps,

–step 1, connect to the catalog database, and get necessary informatiion:
CONNECT rman/xxxxxx@rmn01d

Select db_key, db_id
FROM   db
Where  db_id = 708061412;

    DB_KEY      DB_ID
———- ———-
   5428962  708061412

you can get the DBID from the target database by :

–step 2, unregister database using store procedure in catalog database.
EXECUTE dbms_rcvcat.unregisterdatabase(5428962, 708061412);

–step 3, connect to target database using catalog, and register database again,
rman TARGET AODRMAN/xxxxxx@ess03a CATALOG rman/xxxxxx@rmn01d


–step 4, Manually backup database , succeed.


0 条评论。


注意 - 你可以用以下 HTML tags and attributes:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>