RMAN on 8.1.7
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: RMAN on 8.1.7

  1. #1
    Join Date
    Sep 2004
    Posts
    1

    RMAN on 8.1.7

    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.

  2. #2
    Join Date
    Dec 2001
    Location
    Slovenia, Kranj
    Posts
    82
    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?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width