RMAN catalog failure
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: RMAN catalog failure

Hybrid View

  1. #1
    Join Date
    Feb 2003
    Location
    Tehran/Iran
    Posts
    94

    RMAN catalog failure

    Hi
    I've configured RCAT database including the previously installed production database. I cant create catalog and tried some other commands that dose not functioning well. The following steps has been done so far:
    1. created rcat database
    2. created rcvcat tablespace
    3. create user rman user
    4. grant the permissions to rman user
    5. connecting rman for
    creating rman catalog results in the following:

    RMAN> create catalog tablespace rcvcat

    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-00558: error encountered while parsing input commands
    RMAN-01005: syntax error: found "rcvcat": expecting one of: "double-quoted-string, identifier, single-quoted-string"
    RMAN-01007: at line 1 column 27 file: standard input


    RMAN> create catalog tablespace rcvcat
    --------------------------------------

    6.Testing another commands like:

    RMAN> run {host "ls -l";}

    RMAN-03022: compiling command: host
    RMAN-06428: recovery catalog is not installed
    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: host
    RMAN-06429: RCVCAT database is not compatible with this version of RMAN

    -------------------------------
    7. Testing another commands like:

    RMAN> run { sql "select * from v$datafile"; }

    RMAN-03022: compiling command: sql
    RMAN-06428: recovery catalog is not installed
    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: sql
    RMAN-06429: RCVCAT database is not compatible with this version of RMAN

    Do you have any idea what is wrong.

    //Hamhey

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Create a tablespace and make it default tablesapce for rman user.
    Login as rman and simply type
    Code:
    CREATE CATALOG;
    Register your target database and you are ready to go.

    HTH
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  3. #3
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Oh just noticed that you are missing quotes. Try this.
    Code:
    CREATE CATALOG TABLESPACE 'RCVCAT';
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  4. #4
    Join Date
    Feb 2003
    Location
    Tehran/Iran
    Posts
    94
    Hi,
    Thanks alot, it worked.
    But registet the database failed:
    I used the following:
    $ rman target / catalog rman/rman@rcat

    Recovery Manager: Release 8.1.5.0.0 - Production

    RMAN-06005: connected to target database: RCAT (DBID=268301244)
    RMAN-06008: connected to recovery catalog database

    RMAN> shutdown immediate;

    RMAN-06405: database closed
    RMAN-06404: database dismounted
    RMAN-06402: Oracle instance shut down

    RMAN> startup mount;

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

    Total System Global Area 34897296 bytes

    Fixed Size 64912 bytes
    Variable Size 17883136 bytes
    Database Buffers 16777216 bytes
    Redo Buffers 172032 bytes

    RMAN> register database;

    RMAN-03022: compiling command: register
    RMAN-03023: executing command: register
    RMAN-03026: error recovery releasing channel resources
    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-03006: non-retryable error occurred during execution of command: register
    RMAN-07004: unhandled exception during command execution on channel default
    RMAN-10015: error compiling PL/SQL program
    RMAN-10033: error during compilation of job step 1: ORA-01041: internal error. hostdef extension doesn't exist

    Any idea what is wrong again.

    //Hamhey

  5. #5
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Any trace file generated ? Any further info in alert.log ??
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  6. #6
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Originally posted by hamhey

    $ rman target / catalog rman/rman@rcat

    Recovery Manager: Release 8.1.5.0.0 - Production

    RMAN-06005: connected to target database: RCAT (DBID=268301244)
    RMAN-06008: connected to recovery catalog database
    It is clear that you are connecting to the Catalog database as your target database. I think i told you to keep the target and the catalog database seperate.

    Use $ rman target sys/password@target catalog rman/rman@rcat

    after connection do

    RMAN> register database;

    Clearly mention the target username/password and the connect_string.
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  7. #7
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Originally posted by hamhey

    RMAN> startup mount;

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

    Total System Global Area 34897296 bytes

    Fixed Size 64912 bytes
    Variable Size 17883136 bytes
    Database Buffers 16777216 bytes
    Redo Buffers 172032 bytes

    RMAN> register database;

    RMAN-03022: compiling command: register
    RMAN-03023: executing command: register
    RMAN-03026: error recovery releasing channel resources
    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-03006: non-retryable error occurred during execution of command: register
    RMAN-07004: unhandled exception during command execution on channel default
    RMAN-10015: error compiling PL/SQL program
    RMAN-10033: error during compilation of job step 1: ORA-01041: internal error. hostdef extension doesn't exist

    Any idea what is wrong again.

    //Hamhey
    And morever since you are connected to Catalog database which is your target database also and it is not open, its only mounted (see above) how will you register. Keep them seperate.
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  8. #8
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    If you are using / (without connect string) make sure that your oracle_sid is set to target db. It is set to catalog db so your target and catalog db is same. And when catalog database is not opened you can't create catalog.
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

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