Rman Catalog Problem
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Rman Catalog Problem

Hybrid View

  1. #1
    Join Date
    Nov 2001
    Location
    Delhi
    Posts
    31

    Exclamation

    Hello Friends!
    I want to use rman, for this it is must to create recovery catlog to run catrman.sql which resides in /../rdbms/admin/catrman.sql .But I am not getting this script in admin directory. My Oracle (8.1.7.0) is installed on Win 2000.
    Please suggest me to how to get this script to use rman utilities.
    Thanks.

  2. #2
    Join Date
    Oct 2000
    Posts
    467
    its dbmsrman.sql
    This is run automatically when u run catproc.sql
    Vinit

  3. #3
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530
    Hi,
    From Oracle 8.1.5 onwards there is no catrman.sql script to create the recovery catalog.Instead of that u have to use create catalog command at the rman prompt to create the RMAN catalog.
    The following is the procedure to do it:

    STEP 1:
    connect to rman
    rman target="sys/sys@orc1" rcvcat="rman/rman"

    STEP 2:
    Create the RMAN catalog
    RMAN> create catalog;

    STEP 3:
    Register the target database in RMAN of which u have to
    take the backup.
    RMAN> register database ;


    In case of any help please be free to ask me at rohitsn@altavista.com

    Regards,
    Rohit Nirkhe,Oracle DBA,OCP 8i

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