RMAN on 8.1.7

[ads2004]

Hello,

I am trying to setup RMAN on an 8.1.7 running on RHL 8. I run the following three steps, which work fine in 9i, but cause an error on the 8i system.

Step 1 - Create tablespace + user / Set the archive log for current log and open db. This all works fine.

[oracle@localhost oracle]$ svrmgrl

SVRMGR> connect / as sysdba;
svrmgrl> create tablespace rman_ts datafile '/usr/oracle/oradata/rmants.dbf'
size 50m
default storage(
initial 100k
next 100k
pctincrease 0
) ;

svrmgrl> CREATE USER rman1 IDENTIFIED BY rman
TEMPORARY TABLESPACE temp
DEFAULT TABLESPACE rman_ts
QUOTA UNLIMITED ON rman_ts;

svrmgrl> GRANT connect, resource, recovery_catalog_owner TO rman1;
svrmgrl> shutdown
svrmgrl> startup mount
svrmgrl> alter database archivelog
svrmgrl> alter database open

---

Step 2: Connect the RMAN & register DB & Resync catalog

[oracle@localhost oracle]$ rman
RMAN>connect catalog rman1/rman
RMAN>create catalog tablespace rman_ts

At this point it just hangs until I issue a CTRL-C. Then I restart the server and do the step 1 and step 2 again, I get the following error on step 2:

[oracle@localhost oracle]$ rman

Recovery Manager: Release 8.1.7.0.1 - Production

RMAN> connect catalog rman1/rman

RMAN-06008: connected to recovery catalog database
RMAN-06428: recovery catalog is not installed

RMAN> create catalog tablespace rman_ts

RMAN-06099: error occurred in source file: krmk.pc, line: 6600
RMAN-06097: text of failing SQL statement: CREATE TABLE db
(
db_key NUMBER NOT NULL, -- sequence generated primary key
db_id NUMBER NOT NULL, -- kccfhdbi from controlfile
-- updatable columns
curr_dbinc_key NUMBER, -- current incarnation
CONSTRAINT db_p PRIMARY KEY (db_key),
CONSTRAINT db_u1 UNIQUE(db_id) -- ensure that db_id is unique
)
tablespace rman_ts

RMAN-06004: ORACLE error from recovery catalog database: ORA-00955: name is alre
ady used by an existing object

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-06433: error installing recovery catalog

---

Thanks in advance for any insight you may have on this.

[Aljaz]

Hello.

About errors :
RMAN-06099: error occurred in source file: krmk.pc, line: 6600
RMAN-06097: text of failing SQL statement: CREATE TABLE db
RMAN-06004: ORACLE error from recovery catalog database:
ORA-00955: name is already used by an existing object

The first time you said "create catalog", same objects were generated in schema rman1, but then you terminated the process of creating catalog.

So the next time you said "create catalog" rman once againg tries to create the same objects. If you go into sqlplus as rman1/rman you will see those objects.

So before createing catalog again, you should drop user rman1 and recreate it.

When you terminated rman with CRTL-C, was the session on database active?