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

RMAN>
————————————————————————————————–

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 10.2.0.4,
the target database is 9.2.0.8

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 :
Select DBID FROM V$DATABASE;

–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

REGISTER DATABASE;

–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>