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

Thread: rman

  1. #1
    Join Date
    Jan 2003
    Posts
    40

    rman

    Anybody knows how to create a recovery database using rman, I never have made it.
    I want to know all steps than I must to do.
    Thanks.

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092

  3. #3
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  4. #4
    Join Date
    Jan 2003
    Posts
    40
    But First I must create a db call rmandb for example and later register my database??
    How rman knows what database I want to register??

  5. #5
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    C:\>rman target sys/password@tsh1 rcvcat rman/rman@dba1 msglog 'C:\Oracle\Backup\TSH1\TSH1_Daily_Backup.log'

    Recovery Manager: Release 8.1.7.0.0 - Production

    RMAN-06005: connected to target database: TSH1 (DBID=955315395)
    RMAN-06008: connected to recovery catalog database

    RMAN> register database;

    while connected to the target database through recovery catalog you should explicity register the database in the recover catalog..

    http://www.oracle-base.com/Articles/8i/RecoveryManager(RMAN)8i.asp

    The article is by one of our members Tim Hall refer to his site..

    regards
    Hrishy

  6. #6
    Join Date
    May 2002
    Posts
    36
    Its as simple as
    1. create a RMAN database sat RMANDB
    2. create a user for the RMANDB say RMANUSR
    3. grant connect,rescourse to RMANUSR
    4. grant recovery_catalog_owner to RMANUSR
    5. rman connect target sys/password
    6. rman> register database.

    Better still go through the Oracle Backup and Recovery Guide.

    Sam

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