RMAN -- Set DBID

Issues -- target database name is ambiguous
=============================================

tx2qdfsdb1> /oracle/admin/GENQA/rman/shell [GENQA] rman target / catalog
rman/xxx@cataprd6

Recovery Manager: Release 8.1.7.4.0 - Production

RMAN-06006: connected to target database: GENQA (not mounted)
RMAN-06008: connected to recovery catalog database

RMAN> list backup;

RMAN-03022: compiling command: list
RMAN-03026: error recovery releasing channel resources
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure during compilation of command
RMAN-03013: command type: list
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20005:
target database name is ambiguous

Solution -- Set DBID -- Must be done when database is down
===========================================================
rman@CATAPRD6> select * from rc_database where name='GENQA';

DB_KEY DBINC_KEY DBID NAME RESETLOGS_CHANGE#
RESETLOGS_TIME
---------- ---------- ---------- -------- -----------------
--------------------
4829855 4829856 525219448 GENQA 3.6278E+10 21-MAY-2007
13:24:35
4766609 4766610 515653788 GENQA 3.6123E+10 27-MAR-2007
23:17:18

==

RMAN> set dbid=525219448;

RMAN-03022: compiling command: CSET
RMAN-03026: error recovery releasing channel resources
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure during compilation of command
RMAN-03013: command type: CSET
RMAN-06188: cannot use command when connected to target database

RMAN> shutdown;

RMAN-06402: Oracle instance shut down

RMAN> set dbid=525219448;

RMAN-03022: compiling command: CSET

RMAN> startup nomount;

RMAN-06193: connected to target database (not started)
RMAN-06196: Oracle instance started

Total System Global Area 2064646304 bytes

Fixed Size 73888 bytes
Variable Size 1005494272 bytes
Database Buffers 1048576000 bytes
Redo Buffers 10502144 bytes