DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: RMAN Recovery Catalog

  1. #1
    Join Date
    Feb 2001
    Location
    Scotland
    Posts
    200

    RMAN Recovery Catalog

    Hi there,

    I am trying to create a recovery catalog on a 9i database on a Linux box.
    When I invoke the rman command from the prompt it just freezes and nothing happens (like the application is running in the background)

    If I try the command rman catalog rman_user/rman@portals I get the error
    portals@cream:~$ rman catalog rman_user/rman@portals
    rman: can't open catalog

    Similarly

    portals@cream:~$ rman nocatalog
    rman: can't open nocatalog

    However
    portals@cream:~$ sqlplus /nolog
    SQL*Plus: Release 9.2.0.1.0 - Production on Wed Dec 11 14:04:01 2002
    Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
    SQL> connect rman_user/rman@portals
    Connected.
    SQL>
    Works, so the connectivity and the user is correct

    I can't work out why I can't get the executable to run.
    I have followed the procedure many times before on my NT machine with no problems.
    Any help would be greatly appreciated.

    Allie
    What's the sound of one hand clapping - "CL"

  2. #2
    Join Date
    Apr 2006
    Posts
    1
    I'm having the same problem. Oracle9i on Fedora Core 4. If I find a solution, I will let you know!

  3. #3
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    dude, that post was over 3 and half years ago! i bet they still aint checking this forum for an answer

  4. #4
    Join Date
    Jul 2006
    Posts
    1
    I have problem with Oracle 10g r1 database in DR site. That is Oracle 10g database and running in "mount" mode. I have setup rman job to apply archive logs and recover the database.

    We have added data file to the production system and when particular archive apply to the DR site database, there wasn't enough space to create the datafile.

    Now we have increase the space and there are enough space to create the particular fle.

    How do we continue the recovery?


    Starting recover at 17-JUL-06
    using target database controlfile instead of recovery catalog
    allocated channel: ORA_DISK_1
    channel ORA_DISK_1: sid=161 devtype=DISK

    starting media recovery

    archive log filename=/archive1/isw1/1_10896_571279999.arc thread=1 sequence=1089
    6
    creating datafile fno=30 name=/oradata/isw/isw_cust_data25_raw_2000m
    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-03002: failure of recover command at 07/17/2006 12:31:00
    ORA-19502: write error on file "/oradata/isw/isw_cust_data25_raw_2000m", blockno
    64768 (blocksize=8192)
    ORA-27063: number of bytes read/written is incorrect
    SVR4 Error: 28: No space left on device
    Additional information: -1
    Additional information: 1048576
    ORA-19502: write error on file "/oradata/isw/isw_cust_data25_raw_2000m", blockno
    64896 (blocksize=8192)
    ORA-27063: number of bytes read/written is incorrect
    Additional information: 311296
    Additional information: 1048576

    RMAN>

    Recovery Manager complete.

    Recovery Manager: Release 10.1.0.3.0 - 64bit Production

    Copyright (c) 1995, 2004, Oracle. All rights reserved.

    RMAN>
    connected to target database: ISW (DBID=1237080350)

    RMAN>
    Starting recover at 17-JUL-06
    using target database controlfile instead of recovery catalog
    allocated channel: ORA_DISK_1
    channel ORA_DISK_1: sid=157 devtype=DISK
    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-03002: failure of recover command at 07/17/2006 13:01:05
    RMAN-06094: datafile 30 must be restored

    Thank you
    Colin

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