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

Thread: rman start

  1. #1
    Join Date
    Sep 2001
    Posts
    120
    hi,
    i want to setup rman on 8i and 9i for performing backup and recovery.

    can someone how to start with and what dows the following term means:

    CONNECT CATALOG rman/cat_pwd@cat_str

    when i issue this command it give no user is there and when i change it to

    CONNECT CATALOG sys/password@cat_str it gives connect but no recovery catalague installed.

    how should i do it.

    please help

    thanks


    Saurabh Garg
    OCP 9i

  2. #2
    Join Date
    Aug 2001
    Location
    Waterloo, On
    Posts
    547
    You have to create a recovery catalog first.
    Create a new database or pickup an existing database.
    Create a tablespace for RMAN objects, about 50 MB size.
    Create a user 'rman' and set his default tablespace as that created above.
    Grant RECOVERY_CATALOG_OWNER to rman.
    Grant DBA, Connect & Resource roles to rman.
    Now connect to recovery catalog as user rman to create recovery catalog objects.

    Raminder Singh

    Oracle Certified DBA: Oracle 8i, 9i


    Mail me at raminderahluwalia@rediffmail.com.

  3. #3
    Join Date
    Jan 2000
    Posts
    387
    You can also refer to this thread

    http://www.dbasupport.com/forums/sho...threadid=16939

    It shows how to create the catalog and register the database.

  4. #4
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    As much as possible create your rman in another database or much better if in another machine. Otherwise, your rman will defeat its intention if something goes wrong with the database that you intend to apply with rman.

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