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

Thread: RMAN

  1. #1
    Join Date
    Jun 2001
    Posts
    88

    Question

    Hi gurus
    I have created user rman in tablespace rcvcat.
    I have granted all the necessary rights to rman
    Now i am trying to run the catrman.sql script to create the necessary tables for the recovery catalog.
    But i am getting following error.

    SP2-0310: unable to open file "\Oracle\Ora81\RDBMS\ADMIN\catrman.sql"

    I am using Release 8.1.6.0.0 personal edition Win98
    Any idea???
    Thanks
    Akash

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    There is no catrman script in 8.1.x. Use CREATE CATALOG instead.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Jun 2001
    Posts
    88
    Can u tell me how to use create catalog?


    Thanks
    Akash

  4. #4
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by akash
    Can u tell me how to use create catalog?

    Thanks
    I assume you have a user called RMAN with default tablespace RCVCAT.

    As sys:

    1. GRANT recovery_catalog_owner TO rman;

    2. GRANT connect, resource TO rman;

    Open Command Prompt and write (assuming you have a primary DB called primary and the recovery catalog is in DB called catalog):

    3. rman catalog rman/password@catalog

    Now (being in RMAN) write:

    4. CREATE CATALOG tablespace "RCVCAT";
    EXIT;

    Important: the tablespace in capitals! Beats me why Oracle wants it like that. Also: the quotes!

    5. rman target sys/password@primary rcvcat rman/password@catalog

    Now (being again in RMAN) write:

    6. REGISTER DATABASE;

    That's it.

  5. #5
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530
    Hi,
    At the command prompt enter the following command :

    c:\>rman target="sys/sys@prod" rcvcat="rman/rman@grman"

    RMAN>create catalog ---catalog created

    RMAN>register database ---information about the target
    database is stored in the recovery
    catalog from the controlfile of the
    target database;

    RMAN>list incarnation of database --- check whether the
    target database is
    registered

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


    Regards,
    ROhit Nirkhe,Oracle DBA,OCP 8i
    rohitsn@altavista.com

  6. #6
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by rohitsn
    Hi,
    At the command prompt enter the following command :

    c:\>rman target="sys/sys@prod" rcvcat="rman/rman@grman"

    RMAN>create catalog ---catalog created

    RMAN>register database ---information about the target
    database is stored in the recovery
    catalog from the controlfile of the
    target database;

    RMAN>list incarnation of database --- check whether the
    target database is
    registered

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


    Regards,
    ROhit Nirkhe,Oracle DBA,OCP 8i
    rohitsn@altavista.com
    For Oracle version 8.1.7 the following

    RMAN>create catalog ---catalog created

    is not good.

    You should use:

    CREATE CATALOG TABLESPACE "TABLESPACE_NAME"

    And "tablespace_name" or just TABLESPACE_NAME does not work.

    Bad experience :-)


  7. #7
    Join Date
    Jun 2001
    Posts
    88
    So I need to have two databases..... Right?
    My first database name is ORCL now I will create another.

    Just tell me how these two database will interact (link)?

    Thanks





    Akash

  8. #8
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by akash
    So I need to have two databases..... Right?
    My first database name is ORCL now I will create another.

    Just tell me how these two database will interact (link)?

    Thanks

    Two DBs is not a must. However, you want you Catalog outside the Target DB. What happens if for some reason you loose your Primary DB. You loose the Catalog.

    It is also a good idea to have a Backup strategy for the Catalog.

    How they interact:

    rman target sys/password@primary rcvcat rman/password@catalog

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